Search results

This might have something to do with it. When I am in the form, I open the toolbox, I click the command button, I click onto the body of the form to insert the command button onto the form I get an error message: Compile.error.in query expression...

OK, Not sure what is going on.....here is the code on the command button: Private Sub Command0_Click() Dim tdf As DAO.TableDef Dim db As DAO.Database Set db = CurrentDb() For Each tdf In db.TableDefs If Len(tdf.Connect) > 0 Then DoCmd.RunSQL "Select * " & _ "Into "...

Banana, Here is the full code form the command button--->Event---->On Click--->Event Procedure: Private Sub Command0_Click() Dim db As DAO.Database Set db = CurrentDb() For Each tdf In db.TableDefs If Len(tdf.Connect) > 0 Then DoCmd.RunSQL "Select * " & _ "Into " &...

I am still getting the same error message and the module is hanging on the "Set" command. Below is the entire code for the command button: Dim db As DAO.Database Set db = CurrentDb() For Each tdf In CurrentDb.TableDefs If Len(tdf.Connect) > 0 Then DoCmd.RunSQL "Select * " & _ "Into " &...

I got the following error: Compile Error: Invalid Outside Procedure The following line of code was highlighted: For Each tdf In CurrentDb.TableDefs I really appreciate the help

Do I create a module, copy the code, paste into the module, save the module and then run it? Please forgive my ignorant question :)

I will need to do it 5 or 6 times. If there are two approaches I'd much appreciate if you could explain both. Thx

I have an Access Db where I am pulling in (via ODBC/USQL) linked tables to an ERP system (C-ISAM). I would like to be able to convert the linked tables to regular tables. The only way I know how to do this is to run a make table query for each individual linked table. There are several...

Well, to do that I'd have to bust into Routing and Remote Access. It is already configured and I'd have to disable it first in order to set up incoming VPN on the server. Thier OS is Small Business Server. This is far outside my expertise. Im a BI guy that is doing a one off Access project...

Thaks Pbaldy....thats the issue I am having b/c the machine I connect to via RDP doesnt have MS Access installed, so there is no way for me to connect to the Db. Alsa, if the ERP was on SQL I could get to it but since it ISAM the only way I can connect is via Access. I thought there might be a...

Where do I put the DSN ont he clients machine? Access is not installed on the clients machine (they dont want to pay for the license)......sorry I should have been more clear......what I am trying to do is remote desktop into the client, run Access from my local machine and be able to get to the...

I am rather new to Access so please forgive if this question is simplistic. I have a new client for whom I am writing some queries for. The source Db is ISAM. I installed a USQL license, created a DSN, and pulled the data into Access via ODBC linked tables. I only have time to go out to the...