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

[BigG]

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

Thanks

G

 

[J. Goddard]

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]

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

 

[BigG]

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

G

 

[J. Goddard]

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

jrgoddard@NO_cyberus_SPAM.ca ; but remove the NO_ _SPAM.

Cheers.

John