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 derfloh 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: *

  • Users: SPL26
  • Order by date
  1. SPL26

    Run Time Error 3021

    What I've done under the ErrorHandler section, see below, is instead of using Resume Next I've just put the code for updating the record again with an exit function at the end. This solves the problem with the last record not being updated. I know this is probably not the best solution to the...
  2. SPL26

    Run Time Error 3021

    Thanks for you help I've manage to sort it now Regards
  3. SPL26

    Run Time Error 3021

    Its get hang up on the line that says Do While level3!ACP_NO = Activ!ACP_NO it doesn't get as far as the updating the last record
  4. SPL26

    Run Time Error 3021

    Thanks for replying so quickly ZmrAbdulla, i've put this into my code but for some reason the last record in the main table has not been updated. regards
  5. SPL26

    Run Time Error 3021

    Thanks for the response Alibaba2003, but what I trying to do is effectivly calculate a value from the many side and update the value in the table not add a record. Regards
  6. SPL26

    Run Time Error 3021

    Hi, Can anybody help me, I'm getting a error message with the following code. The error message is RUN-TIME ERROR '3021' NO CURRENT RECORD. What I'm trying to do is to update a value in one table from another table. The table I'm updating has a one-to-many relationship with the table which I'm...
  7. SPL26

    Searching for a Table using code

    Thanks for that, works just fine ! Regards
  8. SPL26

    Searching for a Table using code

    Hi, Can anybody help, I'm trying to find a table in a database, and if this table does not exist, then I will create it. The bit I'm having trouble with is how do I see if this table exists or not using code. I'm using Access 2000 by the way. Regards
  9. SPL26

    Locate / Capture Version of Msjet35.dll

    drctx, I've manage to solve my problem now with a bit of a work around with the data you provided I've go the result I was looking for. Basically, I don't need the "if .excute" statement as I know what file I'm looking for, So I've just replaced line "Text1 = GetFileVersion(Text0)" with "Text1 =...
  10. SPL26

    Locate / Capture Version of Msjet35.dll

    Thanks for that foolio12, just a couple of things, in your articule "Verify Appropriate Jet Service Pack is installed", I assume I make this a function, and when I run this as a fuction, I get an error message "Sub or function not defined" for "tt_ProdVerInfo".
  11. SPL26

    Locate / Capture Version of Msjet35.dll

    drctx, I've Managed to solve the problem with FS, Variable Not Defined"., however, I've now got another problem with the line "If .Execute(SortBy:=msosortbyfilename, SortOrder:=msosortorderascending) > 0 Then", it comes up with the message "Error 5, Invalid Procedure call or argument" any...
  12. SPL26

    Locate / Capture Version of Msjet35.dll

    Thanks for that drctx, but I have one problem, under "Private Sub Command2_Click()", FS comes up as "Variable Not Defined". any suggestions?
  13. SPL26

    Locate / Capture Version of Msjet35.dll

    Can anybody help. I have written an application in Access'97 and I'm trying to locate / capture the version of msjet35.dll that resides on a users machine so that the application can automatically install the latest version of 3.5. I'm looking for the full version ie. not 3.51, but 3.51.3328.0
  14. SPL26

    Locate / Capture Version of Msjet35.dll

    Can anybody help. I have written an application in Access'97 and I'm trying to locate / capture the version of msjet35.dll that resides on a users machine so that the application can automatically install the latest version of 3.5. I'm looking for the full version ie. not 3.51, but 3.51.3328.0

Part and Inventory Search

Back
Top