If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Create Local Table
Hello,
I have a table with a fe for users and be that holds just my tables I have code that will create tables, but it creates them in the be and links them, not in the fe where I want them to be used as temp tables and deleted on opening and closing of the fe. I use the fExistTable function to check if the table exists. Then I run this sub from a class module: Sub sClean_Local_Client() On Error GoTo ErrorHandler gstrSubProcName = "sClean_Local_Client()" 'Check to see if Local Client temp table exists gblnTest = fExistTable("tblClient_Local_Temp") 'If table exists the clean information from table If gblnTest = True Then strSQL = "DELETE * FROM tblClient_Local_Temp;" DoCmd.SetWarnings False DoCmd.RunSQL strSQL DoCmd.SetWarnings True Else 'if table does not exist then create it DoCmd.CopyObject , "tblClient_Local_Temp", acTable, "tblUSys_Client_Local" End If .. . . End Sub How can I make this table in the always be created in the users local fe and not the be? -TFTH Bryan |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Autonumber | Ally H. | General Discussion | 7 | August 27th, 2004 04:51 PM |
Complicated Databse w/many relationships | Søren | Database Design | 7 | July 13th, 2004 05:41 AM |
Create Table Statement | nagesh | Running & Setting Up Queries | 1 | June 4th, 2004 04:12 PM |
How to extract data from multiple Access databases to create a Pivot table | Android | Worksheet Functions | 4 | February 6th, 2004 03:22 PM |