Search results for query: *

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

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

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

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

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

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

Thanks for that, works just fine ! Regards

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

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

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

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

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

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

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