Template that automatically populates the data into Access

[Stizzo]

Looking to establish a template of form that automatically inserts the data
into a table in Access. Is this possible? Example: End user opens template
and inserts action data for sales. Places the order number, credit card
number, product code, cost of units, date of sale, etc. This information is
placed into an access database, without having to import.

 

[Beth Melton]

Looking to establish a template of form that automatically inserts the
data
into a table in Access. Is this possible? Example: End user opens
template
and inserts action data for sales. Places the order number, credit card
number, product code, cost of units, date of sale, etc. This information
is
placed into an access database, without having to import.

What you want is possible but you'll likely need to find a consultant if you
want the front-end to be in an application other than Access. IOW, you can
do it using an Access form but if you want to use Word or Excel you'll need
someone with VBA and ADO/DAO knowledge.

--
~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP
https://mvp.support.microsoft.com/profile/Melton
What is a Microsoft MVP? http://mvp.support.microsoft.com/gp/mvpfaqs

Guides for the Office 2007 Interface:
http://office.microsoft.com/en-us/training/HA102295841033.aspx