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

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

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

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