If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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/ |
#2
|
|||
|
|||
Can anyone help me with a form (and database)?
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/ |
#3
|
|||
|
|||
Can anyone help me with a form (and database)?
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/ |
#4
|
|||
|
|||
Can anyone help me with a form (and database)?
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/ |
#5
|
|||
|
|||
Can anyone help me with a form (and database)?
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/ |
Thread Tools | |
Display Modes | |
|
|