Sep 11 2006, 11:41 AM
Attached is an extremely simplified copy of a database I have been working on, for ordering & shipping and the like. Basically the person enters into a table the name of the prodcut, and the quantity ordered, and the database does the rest. The problem is that as time goes by you have to scroll farther and farther down to enter new orders.....
Is there a way to make a form, with all the product names on it, and also seperate buttons with quantities on them....such that when I hit a button for Product A a new record is made in the table with the date for that record being the current date, and that when they hit a button for a quantity, that number goes into the Quantity field for Product A?? Then if they hit the button for Product B a new record in the table is made in the table, for the current date...and so on and so forth?
The sample database I've posted may not look cumbersome, but the actual version is getting rather large and cumbersome.
Sep 11 2006, 12:11 PM
The file doesn't download. However, it sounds like you are entering data directly into tables which is not a good idea. I would suggest looking at the Northwinds sample database that comes with Access.
Sep 11 2006, 12:55 PM
it's not downloading? that's weird....yah I guess i'll have to poke around northwind again....although I did before and didn't see anything like what I wanted
Sep 11 2006, 12:58 PM
alright here it is again, maybe it'll work this time
Sep 11 2006, 01:50 PM
Ok this time it downloaded. First Date is a reserved word in Access and shouldn't be used as an object name. Second, you shoiuldn't be storing Product Name in the Quantity tablem insted you should be storing the Product ID as a foreign key. Its also a better idea to use a descriptive name for your PKs. I usually use the tablename and 'ID' so You would have ProductID and QuanityID. This makes it clear when used as a FK.
Northwinds is very much more detailed then what you have, but its still and order entry so should give you some ideas.
However, with as simple a strucutre as you have, you need 2 separate forms. One to enter Products and one to enter Quantity. I would NOT use a continuous form. Just a single form to enter the data. Use a combobox to select the product. If you want to show summaries, use a report for that.
Sep 11 2006, 03:24 PM
k, sounds good, thanks!
Sep 11 2006, 04:00 PM
glad to assist
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here