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
|
|||
|
|||
Help to automate field entry
Hi,
I would like to be able to autofill fields where data is nearly always the same. There are five fields containing data about product type, (product no, product presentation, size and type). It would make life so much easier for entry and subsequent searches if this could be autofilled. I have very little experience in Access, the database was set up by my predecessor, but in the dim and distant past I have used Lotus spreadsheets to write macros controlling @base databases. I need to know where the macro to do this would be written and how to be able to enter data directly to the field when the prooduct has a non standard presentation. I'm probably trying to run before I can walk, but I would be really grateful if someone can help -- Mifty |
#2
|
|||
|
|||
The 'easy' answer is to set the default value in the form field. Open
access, open the form in design view, right click on the field, select data tab, set default value, save form. Done. Ed Warren. "Mifty" wrote in message ... Hi, I would like to be able to autofill fields where data is nearly always the same. There are five fields containing data about product type, (product no, product presentation, size and type). It would make life so much easier for entry and subsequent searches if this could be autofilled. I have very little experience in Access, the database was set up by my predecessor, but in the dim and distant past I have used Lotus spreadsheets to write macros controlling @base databases. I need to know where the macro to do this would be written and how to be able to enter data directly to the field when the prooduct has a non standard presentation. I'm probably trying to run before I can walk, but I would be really grateful if someone can help -- Mifty |
#3
|
|||
|
|||
Hi Ed,
Thanks for your reply but I don't think I explained what I needed very well. There are a number of different product lines and what I want to do is to have something like a drop down list (used to link to a function key in Lotus) so that we can enter product code e.g. A100 and this would enter on the product code field then each of the fields for product type would autofill. We would also have to have an option for entering data manually. We use the spreadsheet view of the database for entering data. Don't know if this helps or if I'm making the water ever more muddy! thx -- Mifty "Ed Warren" wrote: The 'easy' answer is to set the default value in the form field. Open access, open the form in design view, right click on the field, select data tab, set default value, save form. Done. Ed Warren. "Mifty" wrote in message ... Hi, I would like to be able to autofill fields where data is nearly always the same. There are five fields containing data about product type, (product no, product presentation, size and type). It would make life so much easier for entry and subsequent searches if this could be autofilled. I have very little experience in Access, the database was set up by my predecessor, but in the dim and distant past I have used Lotus spreadsheets to write macros controlling @base databases. I need to know where the macro to do this would be written and how to be able to enter data directly to the field when the prooduct has a non standard presentation. I'm probably trying to run before I can walk, but I would be really grateful if someone can help -- Mifty |
#4
|
|||
|
|||
Hi,
Keep in mind that this is a database, not a spreadsheet. You should have a Products table with your product code amd the other relevant fields. The *only* thing you should be entering in other tables is the product code. You don't need to type in the other product details. You can have other product fields in your dropdown so that you can see them, but they should not be stored elsewhere. -- HTH Dan Artuso, Access MVP "Mifty" wrote in message news Hi Ed, Thanks for your reply but I don't think I explained what I needed very well. There are a number of different product lines and what I want to do is to have something like a drop down list (used to link to a function key in Lotus) so that we can enter product code e.g. A100 and this would enter on the product code field then each of the fields for product type would autofill. We would also have to have an option for entering data manually. We use the spreadsheet view of the database for entering data. Don't know if this helps or if I'm making the water ever more muddy! thx -- Mifty "Ed Warren" wrote: The 'easy' answer is to set the default value in the form field. Open access, open the form in design view, right click on the field, select data tab, set default value, save form. Done. Ed Warren. "Mifty" wrote in message ... Hi, I would like to be able to autofill fields where data is nearly always the same. There are five fields containing data about product type, (product no, product presentation, size and type). It would make life so much easier for entry and subsequent searches if this could be autofilled. I have very little experience in Access, the database was set up by my predecessor, but in the dim and distant past I have used Lotus spreadsheets to write macros controlling @base databases. I need to know where the macro to do this would be written and how to be able to enter data directly to the field when the prooduct has a non standard presentation. I'm probably trying to run before I can walk, but I would be really grateful if someone can help -- Mifty |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
comparing a single entry to field in other rows? | Kay Harvey via AccessMonster.com | Running & Setting Up Queries | 7 | March 6th, 2005 06:52 AM |
Syntax needed to get needed reports | Frank Lueder | New Users | 15 | January 6th, 2005 08:39 AM |
New Record Update | Michelle | Using Forms | 5 | October 28th, 2004 07:59 AM |
How do I add an entry to a task "requested by" field in Outlook? | nralphs | General Discussion | 0 | October 4th, 2004 08:13 AM |
Supress blank lines in DOCPROPERTY field | Mary | Formatting Long Documents | 10 | May 25th, 2004 07:27 PM |