Re: Help to automate field entry

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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" <Mifty@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:D076C7FE-C491-4562-B198-BDF8EE36271F@xxxxxxxxxxxxxxxx
> 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" <Mifty@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > news:4A4BD915-574C-4203-B186-2298B9471956@xxxxxxxxxxxxxxxx
> > > 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
> >
> >
> >


.

Relevant Pages

  • Re: WHY
    ... only seem to knwo a pure Microsoft environment. ... > database people in the country use VB or VBA or VB.net. ... >> And if there were people employed as *developers* who only knew ... >> Spreadsheet use isn't the core of of the jobs done by people who use ...
    (microsoft.public.excel)
  • Re: WHY
    ... I've been working a lot longer than that LoL ... re-creating the same spreadsheet, ... > I'm sure the database admins do all the work at, say, Boeing and Airbus, ... > Or perhaps you meant implicitly to restrict your remarks to developers. ...
    (microsoft.public.excel)
  • Re: Create Non Access DB with VB??
    ... reproduce or use any of the files that make up the Microsoft Access database ... a general-purpose word-processing, spreadsheet, or database management ... general purpose word processing, ...
    (microsoft.public.vb.database)
  • Re: Can Access use Fuzzy Logic
    ... uniqueness. ... Well, since the source data is a spreadsheet, there *aren't* any ... database *does* have the ability to define what constitutes ... I meant the length of a common tail. ...
    (comp.databases.ms-access)
  • RE: Integrating "Blocks" of Constants
    ... Access is a database, not a spreadsheet, so you really need to change your ... data structure to do what you want. ... (MonthField, BlockTimeStart, and ConstantValue). ... A spreadsheet containing a dozen "blocks" of constants data. ...
    (microsoft.public.access.tablesdbdesign)