Help to automate field entry

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mifty - 30 Apr 2005 09:36 GMT

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

Signature

Mifty

Reply to this Message

Ed Warren - 30 Apr 2005 11:34 GMT

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.

> Hi,
> I would like to be able to autofill fields where data is nearly always the
[quoted text clipped - 14 lines]
> grateful
> if someone can help

Reply to this Message

Mifty - 30 Apr 2005 13:06 GMT

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

Signature

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
[quoted text clipped - 21 lines]
> > grateful
> > if someone can help

Reply to this Message

Dan Artuso - 30 Apr 2005 14:18 GMT

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

> Hi Ed,
> Thanks for your reply but I don't think I explained what I needed very well.
[quoted text clipped - 38 lines]
> > > --
> > > Mifty

Reply to this Message