Re: Create a Temp Table via VBA
- From: Sjakies Pretpaleis <sjakie.pretpaleis@xxxxxxxxx>
- Date: Tue, 31 Jul 2007 08:23:42 -0000
On Jul 31, 6:32 am, prakashwadhw...@xxxxxxxxx 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.
.
- References:
- Create a Temp Table via VBA
- From: prakashwadhwani
- Create a Temp Table via VBA
- Prev by Date: Crashing of Access 97
- Next by Date: convert 2003 to 97 file format, imports linked tables
- Previous by thread: Create a Temp Table via VBA
- Next by thread: Access DOES NOT closes when referencing a VB DLL
- Index(es):
Relevant Pages
|
