English Deutsch Français Italiano Español Português 繁體中文 Bahasa Indonesia Tiếng Việt ภาษาไทย
All categories

I have a small scale company that manufactures products. As a product is being built, I want the person building it to enter the part numbers and relevant information into a microsoft access database, but i want it to be quick and easy, i dont want them to have to go into the tables and change data around. Is there a way to have them maybe click a tab and from there they are promted to enter the relevant information, such as serial numbers and performance data taht goes right into the tables that are already established?

2007-06-28 01:20:17 · 2 answers · asked by jquigg09 2 in Computers & Internet Software

2 answers

For a small fee to a paypal account I could put together an application for you.

Much better than what you describe because at a minimum you need to enforce rules on what can or should be entered or not entered into your database.

If you have no choice but to do it yourself, just use the form wizard and select AutoForm: Datasheet. ( Don't forget to select your table)

The datasheet view just lists all the table fields on a form.

In Tools, Startup, select your table from the drop down (combo box) labeled "Display Form/Page: so your new form is automatically displayed upon opening Ms Access.

2007-06-30 15:48:41 · answer #1 · answered by Lorenzo H 3 · 0 0

Build a Data Entry Form that adds to the Table.
There is a wizard in the Forms view to walk you through the setup process.

2007-06-28 01:49:54 · answer #2 · answered by Capt Crasher 6 · 0 1

fedest.com, questions and answers