Search results for query: *

Bingo! I've been careful about that up to this point, but ... Thank you very much

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...

Alright, it's official. I'm an absolute idiot. You guys were right, I wasn't opening the connection. Thank you for seeing it. This is what comes of now programming for 6 months and then trying to get back into it.

I get exactly the same response. I had tried that in a previous incarnation and it hadn't worked. At the time I thought it might be because I was using a query within a query.

just did a compact to make sure, same thing happened

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...

My 2 cents worth ... I'm with the re-engineered crowd. Sounds to me like you've got "flakey" errors that you might or might not be able to localize ... especially if this thing is organic and called from multiple sources. Your being told that you don't have time to do it right, just have time...

hmmmmmmmmm....so if I use adOptimistic and call .BatchUpdate this will release the records? That doesn't sound right. I'm not saying it ISN'T right, just doesnt' feel like what MS likes to do. My experience is that the release comes when the table/query/recordset is released. I've run into...

The actions are updates to a single record in a recordset. I realize that the max number of locks is huge, but, IN THEORY, the lock max COULD be reached, or worse, changed by another application between iterations. I'm pretty much a purist when it comes to writing code (evidence of a mis-spent...

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...

ok, the final answer is that autoincrement is a property, but nullable appears to be an attribute ..... ???? replacing the .....properties("nullable")=adcolnullable with Thiscolumn.attributes=adcolnullable and the damn thing works fine. go figure

The thing works fine when I comment out the properties lines. Leaving the autoincrement line commented out I did the following: ThisTable.Columns.Item(ThisColumn.Name).Properties("Nullable") = adColNullable I changed "nullable" to 2 (the 0 based index of the nullable property) and...

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 have a set of string functions which would solve the problem outright, but they are idiosyncratic to me. If you'd like them, message me and I'll send the app and instructions on how to use them.

Until MS does something about Vista, I'm not exerting myself to utilizing ANYTHING new. Nothing works under this POS. You have to re-invent the ROCK, much less the wheel. My guess is that the current iteration of .Net will be totally obsolete when the dust settles on whatever Dell and Gateway...

you can massage the input by replacing the ' with `. Your users won't know the difference but the machine will. `=lowercase umlaut (upper left hand corner)

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...

yeah, you can use instr intTemp0=instr(strTemp0,chr(34)) intTemp1=instr(intTemp0+1,strTemp0,chr(34)) strTemp1=mid(strTemp0,intTemp0+1,intTemp1-intTemp0) ... Remember to make the appropriate checks for intTemp0 and intTemp1 being =0. That is, make sure some idiot didn't screw up...

Get rid of the "as string" In VBScript (at least as it pertains to ASP) you don't declare the function type. Essentially, it thinks you are trying to do something other than dim on that line. At least, that's what I've always done with ASP....

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?