Search results for query: *

strTemp0 = "Matched-Field1" 'Left$("Matched-" & DepVar, 60) Results_RC.Open TargetResults, Conn, adOpenKeyset, adLockPessimistic, adCmdTable Dep_RC.Open "Matched-Field1", Conn, adOpenKeyset, adLockPessimistic, adCmdTable in the above code snippet, Results_RC works fine. Dep_RC doesn't...

Conn.ConnectionString = BuildConnectionString(TargetDB) strTemp0 = ...code to build a select query... strTemp1 = CreateView(TargetDB, strTemp0, "CountMatches") CountMatches_RC.Open "CountMatches", Conn, adOpenForwardOnly, adLockReadOnly CountMatches_RC is properly declared...

I'm writing an application that requires a large number of updates. I'm getting the error message that I have exceeded the MaxLocksPerFile Registry entry. I really don't want to mess with registry entries in programs that will be used by people who have trouble turning on the machine in the...

Access ver 2003 sp2 the variables are properly typed, the DstDB is actually created just prior to execution I'm sure the code worked in prior versions, but I can't for the life of me figure out why the append is not working correctly. Can anyone see something stupendously stupid that I'm...

I'm trying to build an install for a program. I want the silly thing to work on win98 and 2000. Using PCDMLN I built the setup and everything was going fine, until msadox.dll wouldn't install. I clicked on ignore (after re-try a couple of times) and proceeded. The program will run to a certain...

I have a shell execute statement Shell("c:\,,,,,") and it returns a double, which is apparently the ID of the process. How do I track the ID until it closes? Alternatively, How can I determine that the process HAS closed?

[code] strTemp2 = CreateLinkedAccessTable(TargMDB, "PartA", TempMDB, "TempPartA") 'creates a linked table sqlTemp0 = BeneZip() 'Returns a SQL string For intTemp0 = 1 To 100 DoEvents Next 'Supposed to make sure everything...