Can anyone help me with a form (and database)?

I want to create a -form- in access that will be used for documenting
material that has been recieved in through my department. It will need
fields such as PO#, Part#, QTY, Supplier, Date, Inspected By, and
Comments.
This for will also have a field labeled LTN that has to automatically
number itself one increment at a time each time the form is used. And
all forms must be save into a searchable database.
I have started tooling around some with access and have had some luck
developing tables and such with the correct fields but when it comes to
having access give me a form that has ONLY one (numbered) report per
page I have had no luck. The form will be printed and placed into the
supplier file, I cannot have 3 or 4 reports on one form, I need it to
print one per page.
I am very new to access any help would be appreciated.

Thanks

G.


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

Hi -

Forms are generally speaking not designed for printing - they are for
data entry, updating or on-screen viewing. If you want to print the
data on a form, I suggest you design a Report which has one record per
page, and then print that report, perhaps using a command button, from
the form, after the data has been saved.

Also remember that multiple copies of forms are not saved in the
database - only the data is, in your tables. This means that the form
field LTN that you describe must also be in your table(s) somewhere,
otherwise there is no point in using it. What do you mean by "...each
time the form is used."? Each time a form is opened, it can be used to
create any number of records in a table, or any number of reports. If
you don't care what values LTN has, other that they are unique, you
could use an autonumber field in your table and bind a form (and report)
control to it. If you do care what values LTN has, then you will need
some VBA code to look after that, though uniqueness of LTN can be
enforced by putting a unique index on it in the table.

You can e-mail me if you need more information (remove the NO_ _SPAM)

Hope this helps get you started

John



BigG wrote:

I want to create a -form- in access that will be used for documenting
material that has been recieved in through my department. It will need
fields such as PO#, Part#, QTY, Supplier, Date, Inspected By, and
Comments.
This for will also have a field labeled LTN that has to automatically
number itself one increment at a time each time the form is used. And
all forms must be save into a searchable database.
I have started tooling around some with access and have had some luck
developing tables and such with the correct fields but when it comes to
having access give me a form that has ONLY one (numbered) report per
page I have had no luck. The form will be printed and placed into the
supplier file, I cannot have 3 or 4 reports on one form, I need it to
print one per page.
I am very new to access any help would be appreciated.

Thanks

G.


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

I guess it can't be done, I thought that might be the case.


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

You didn't include your email (or at least I cant find it)

G.


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

It should have been in the headers of the message; in any event, here it is:

; but remove the NO_ _SPAM.

Cheers.

John


BigG wrote:

You didn't include your email (or at least I cant find it)

G.


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/