Search:

try something like this:

select case Me![OptConnection] & "_" & Me![OptTables]
case "1_1"
case "1_2"
case "2_1"
case "2_2"
case else
end select

post the query string. that is where your error seems to be

try this. I use it in modules with no problems

Function fnMomentaryPause(timPause As Single)

Dim Start
Start = Timer ' Set start time.
Do While Timer < Start + timPause
...

TRY THIS

sql = "SELECT [2K1-JobBook-Query].[JOBNUMBER], [2K1-JobBook-Query].[2K1-JobBook_CUSTOMERID], [2K1-JobBook-Query].[DATE_IN], [2K1-JobBook-Query].[SUBDIVISION],...

since you say it is updated weekly, i would suggest pushing the db to them at a preset time every week. You say they are all on a lan so you can use your network o/s scheduling utility to do this.

look up 'Picture Property' in access help

This particular problem is well documented in all Access forums I know. Do not store files in your database. Store, instead the filepath to the file (whether it be a .bmp, .jpg, .doc, .txt) and set...

my recommendation would be to move your tables into MSDE and transform your queries into stored procs and views. The benefits of these are well known and the MSDE functions the same as an SQL...

without answering you questions, i have some of my own:

You are using A2K, but are you utilizing the MSDE, or JET?
Is the db split?
When you imported the data, did you compact before running?

you need to provide the back-end password in the connection (link) string for the back-end tables

What Legare means is to have a template temp.mdb which contains the table objects you wish to use. In your code, before linking to the temp tables, check the file size of your 'PRODUCTION' version...

sure. send it to jbulger@directhitdata.com

CurrentDb.Execute "UPDATE products set stock = [order details]+ stock WHERE orderid = " & TOrderID

What you will need to look into is: .OldValue

HTH

myDate<=DateAdd("d",-7,Date())

or he could pass the teacherid in the openargs parameter

I was trying to hold out on you, but....

FileCopy varOriginationMDB, varDestinationMDB

or

FileCopy varOriginationMDB, varDestinationLocation & "" & format("yyyy-dd-mm",Date()) & ".mdb"
...

Just because it is networked is no reason for concern. What is of concern is how everyone access it. Is the db split into front-end/back-end or is everyone using the SAME .mdb? Exactly what is...

The easiest would be, (in access) run a shell command such as the following:
Shell "c:program fileswinzipwinzip32.exe -min -a " & fullPathAndFilenameToCreate & " " & fullPathAndFilenameToZip
which...

Just a thought.

Just prior to the Application.Quit, (using code, of course) open up another .mdb file which would contain the copydb code. You can then fire the code in the open event of the...

This may work well as you say, but this code realy belongs behind the form and not in a separate module. The reasoning behind my statement is that you are explicitly saying that only the form...

since the report specified is held in a variable, try something like this:

.fields("PM")=reports(obj).PM

(although this will only work if every report passed has the same object (i.e. "PM") on...

All I would end up doing is giving away their code which is pretty unethical. their code is free to use as long as you purchase their book or find it published in one of their many articles in...

If you have the Acees Developers Handbook by Gilbert, Getz & Litwin, you would already have that. If you don't have the book, I would HIGHLY recommend purchasing it.

assuming you are using code to connet the table links, try using an if statement such as:

IF table.name like 'MDATAP*' then
'**place your connection code here
END IF