Data Entry Form

[Dennis the Safety Nerd]

How do I create a custom form for data entry
It should have drop down boxes to select from and preferably have data on 3
work sheets.
It would also help if there were an auto number field like access uses. I
can't figue access out so I need to use excell.

[Ronin]

Dennis,

There are ways to use Excel's VBA Form as a FrontEnd Data Entry Form. By
using the reference DAO or ADO, you can have the Access as back end database.


Ronin

"Dennis the Safety Nerd" wrote:

> How do I create a custom form for data entry
> It should have drop down boxes to select from and preferably have data on 3
> work sheets.
> It would also help if there were an auto number field like access uses. I
> can't figue access out so I need to use excell.

[Dennis the Safety Nerd]

That sounds good. How do I learn to do that?

"Ronin" wrote:

> Dennis,
>
> There are ways to use Excel's VBA Form as a FrontEnd Data Entry Form. By
> using the reference DAO or ADO, you can have the Access as back end database.
>
>
> Ronin
>
> "Dennis the Safety Nerd" wrote:
>
> > How do I create a custom form for data entry
> > It should have drop down boxes to select from and preferably have data on 3
> > work sheets.
> > It would also help if there were an auto number field like access uses. I
> > can't figue access out so I need to use excell.

[Ronin]

In VBA,

1) click Tools

2) check either one
a) Microsoft ActiveX Data Objects 2.6 Library or below (AKA ADO)
b) Microsoft DAO 3.6 Object Library

3) search for help files in your computer for the corresponding help file
a) ADO210.CHM
b) DAO360.CHM

4) In the help file, look for/type in the search tab for (without the a)
or b))
a) Open Method (ADO Recordset)
b) OpenRecordset Method Example (DAO)

5) Click the "Example" link close to the heading or follow the instruction

Best of luck


Ronin


"Dennis the Safety Nerd" wrote:

> That sounds good. How do I learn to do that?
>
> "Ronin" wrote:
>
> > Dennis,
> >
> > There are ways to use Excel's VBA Form as a FrontEnd Data Entry Form. By
> > using the reference DAO or ADO, you can have the Access as back end database.
> >
> >
> > Ronin
> >
> > "Dennis the Safety Nerd" wrote:
> >
> > > How do I create a custom form for data entry
> > > It should have drop down boxes to select from and preferably have data on 3
> > > work sheets.
> > > It would also help if there were an auto number field like access uses. I
> > > can't figue access out so I need to use excell.

[Ronin]

Sorry, after 1), click References...


Best of luck again


Ronin

"Ronin" wrote:

> In VBA,
>
> 1) click Tools
>
> 2) check either one
> a) Microsoft ActiveX Data Objects 2.6 Library or below (AKA ADO)
> b) Microsoft DAO 3.6 Object Library
>
> 3) search for help files in your computer for the corresponding help file
> a) ADO210.CHM
> b) DAO360.CHM
>
> 4) In the help file, look for/type in the search tab for (without the a)
> or b))
> a) Open Method (ADO Recordset)
> b) OpenRecordset Method Example (DAO)
>
> 5) Click the "Example" link close to the heading or follow the instruction
>
> Best of luck
>
>
> Ronin
>
>
> "Dennis the Safety Nerd" wrote:
>
> > That sounds good. How do I learn to do that?
> >
> > "Ronin" wrote:
> >
> > > Dennis,
> > >
> > > There are ways to use Excel's VBA Form as a FrontEnd Data Entry Form. By
> > > using the reference DAO or ADO, you can have the Access as back end database.
> > >
> > >
> > > Ronin
> > >
> > > "Dennis the Safety Nerd" wrote:
> > >
> > > > How do I create a custom form for data entry
> > > > It should have drop down boxes to select from and preferably have data on 3
> > > > work sheets.
> > > > It would also help if there were an auto number field like access uses. I
> > > > can't figue access out so I need to use excell.