Create a Temp Table via VBA

[prakashwadhwani]

I have an app with a Front End and a Back-End. My date field is
INV_DATE

I would like to copy all data with year(inv_date) 2005 to a temp
table in both, the front end & the back end.

How can I do this via VBA ?

Rgds,
Prakash.

[Sjakies Pretpaleis]

On Jul 31, 6:32 am, [e-mail] wrote:

I have an app with a Front End and a Back-End. My date field is
INV_DATE

I would like to copy all data with year(inv_date) 2005 to a temp
table in both, the front end & the back end.

How can I do this via VBA ?

Rgds,
Prakash.

Are your FrontEnd and BackEnd linked to each other? Otherwise you have
to use a reference (filename and location) to one.

Dim dbsCurrent As Database, dbsContacts As Database
Set dbsCurrent = CurrentDb
Set dbsContacts = DBEngine.Workspaces(0).OpenDatabase("C:
\Contacts.mdb")

>From here you may do as you please.

[Larry Linson]

<pr*************@gmail.comwrote in message
news:11**********************@o61g2000hsh.googlegr oups.com...

>I have an app with a Front End and a Back-End. My date field is
INV_DATE

I would like to copy all data with year(inv_date) 2005 to a temp
table in both, the front end & the back end.

How can I do this via VBA ?

You might take a look at MVP Tony Toews' site,
http://www.granite.ab.ca/accsmstr.htm for a method which creates a
temporary database in which to create the temporary table. When you are
done with it, you can unlink, and delete it -- and not have to worry over
time about it bloating and having to be compacted and repaired.

I'm wondering why you might need a temporary table in the back end _and_ the
front end. Perhaps if you'd tell us what you are trying to accomplish,
instead of the way you think you might accomplish it, someone could offer
useful suggestions.

If you use Tony's technique, you'll link both the table in the "temporary
back end database" and the table in the "temporary front end database."

Larry Linson
Microsoft Access MVP