Replies

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
DoEvents ' Yield to other processes.
Loop

End Function

TRY THIS

sql = “SELECT [2K1-JobBook-Query].[JOBNUMBER], [2K1-JobBook-Query].[2K1-JobBook_CUSTOMERID], [2K1-JobBook-Query].[DATE_IN], [2K1-JobBook-Query].[SUBDIVISION], [2K1-JobBook-Query].[2K1-JobBook_CITY], [2K1-JobBook-Query].[2K1-JobBook_STATE], [2K1-JobBook-Query].[PLAN#], [2K1-JobBook-Query].[LOT], [2K1-JobBook-Query].[BLOCK], [2K1-JobBook-Query].[2K1-JobBook_ADDRESS], [2K1-JobBook-Query].[STATUS-OUTBOUND], [2K1-JobBook-Query].[STATUS-DATE-SCANNED-OUTBOUND] FROM [2K1-JobBook-Query] WHERE ((([2K1-JobBook-Query].[2K1-JobBook_CUSTOMERID])=’DAVID’) And (([2K1-JobBook-Query].[DATE_IN])>Date()-9) And (([2K1-JobBook-Query].[STATUS-OUTBOUND])=Yes))

I think the problem was the “”DAVID”” which should be ‘DAVID’

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 the object source during runtime to display the file’s contents.

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 server. MSDE comes on the office cd.

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 of the temp.mdb. If it is over a size you feel comfortable with, just copy the ‘TEMPLATE’ version of the temp.mdb over the ‘PRODUCTION’ version. Then connect yout table links and proceed as usual.
I actually use a variation of this technique with my distributed front-ends which can become bloated over time. My variation also checks for a NEWER version depending on whether I have added/modified/fixed anything to the front-end ‘TEMPLATE’

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())