Search results for query: *

If you try to use a pop-up form to do this, you may have a record-locking problem, because both forms would simultaneously have the same record in focus, if open at the same time However, I think you could handle this in a single form: you could add your "problem-description" field to the main...

Setting the target to c:\db1.mdb /xautoexec1 may do the trick for you

One way you could get round this is by splitting your database into two: tables held in a back-end database; forms, queries and reports etc in the front-end database. This way the front-end can be small enough for it to be practical for users to have their own copy of it (either on their local...

Dunno...You may be right, but then again not sure, it may be I didn't explain my problem too well I would have no problem with using INSERT to create a table in the main SQL database, but actually only want to SELECT some records from it, and INSERT them into a local Access table. So the...

Thanks for your help It was a struggle but I got there in the end (Not sure if this is the best way, but seems to work) 'Define and open connection to SQL Dim conSQL As ADODB.Connection Set conSQL = New ADODB.Connection conSQL.Open "Driver=SQL Server; Server=xxxxxx; Database=xxxxxx...

I'm trying to get the results of a query on a SQL database to write into a table in my local Access database. In the past, I've got by with slightly kludgy macros using "send-keys" to rewrite pass-through queries on the fly, but this is proving less than robust in Citrix environments, forcing...