Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. DerFarm

    strange behavior in opening recordset

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

    strange behavior in opening recordset

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

    can't open a recordset based on a query

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

    can't open a recordset based on a query

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

    can't open a recordset based on a query

    just did a compact to make sure, same thing happened
  6. DerFarm

    can't open a recordset based on a query

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

    Setting Object variable to nothing

    ...to do it right, just have time to do it over. Been there, done that. You always get blamed and never get to do it right. Make sure that you have something in writing that says you shouldn't do a complete re-write. Otherwise, when the s*** hits the fan you're right in front of it. Good Luck
  8. DerFarm

    Releasing Locked records

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

    Releasing Locked records

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

    Releasing Locked records

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

    appending tables code blowing up

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

    appending tables code blowing up

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

    appending tables code blowing up

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

    Removing beginning characters in a string

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

    Should We Be Developing New Apps with VB6 ?

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

    Problems with Apostrophies in String Variables

    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)
  17. DerFarm

    msadox.dll giving me trouble ... I think

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

    Look For " "

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

    Expected end of statement error

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

    Tracking Shell process

    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?

Part and Inventory Search

Back
Top