A couple of years ago I found a download that corrected this problem. I had to reinstall MS Office XP Pro developers software. Now that I remembered the problem I don't seem to remember which patch corrects the problem.
Please Help me out,
Thanks,
Craig
Craig Martin
Last Activity: Jul 30 '06, 04:29 PM
Joined: Jun 10 '06
Location: Chicago
-
Craig Martin started a topic Access XP runtime package wizard will not install on Windows XP Professionalin AccessAccess XP runtime package wizard will not install on Windows XP Professional
-
Macro-Action Failed - Halt
Hi
I have 40 or so .csv files attached to my access xp.mdb. I am running a macro of about 40 append quires. If I pickup a damaged or partial file - that append query will fail. I do not get an option of continue or ignore. It halts the entire macro. Is there any way to disregard that query and allow the macro to continue. Set warnings in macro does not work. I have converted to code with DoCmd.OpenQuery and DoCmd.SetWarnin gs. I can't get that... -
action failed - halt
Hi
I have 40 or so .csv files attached to my access xp.mdb. I am running a macro of about 40 append quires. If I pickup a damaged or partial file - that append query will fail. I do not get an option of continue or ignore. It halts the entire macro. Is there any way to disregard that query and allow the macro to continue. Set warnings in macro does not work. I have converted to code with DoCmd.OpenQuery and DoCmd.SetWarnin gs. I can't get that...Last edited by Craig Martin; Jun 13 '06, 05:09 AM. -
Banfa,
Thanks For responding
Just got the answer. Tested it and works great.
Dim rstThis as RecordSet
Dim varField2 as Variant
Set rstThis = CurrentDB.OpenR ecordset("11-SWBACKORDS-test") ' or whatever it is called
With rstThis
.MoveLast
.MoveFirst
If .RecordCount Then
Do Until .EOF
... -
I use access XP on windows xp home. The file that comes to me is a .csv. I have it linked to my database and append to a table that requires the customer ID filled in - it's the index for the product ID.
Hope that is the info you were asking for.
Thanks,
Craig...Leave a comment:
-
Replace Null field with previous record value
I get a text file every day that has Customer ID and Product ID. The customer ID is only in the first record. I need to replicate the customer ID into each field relating to his products. Find and replace box works fine but I have hundreds to do each day. I need a to do it in the code area on "on open" or some other automatic way.
Please help me with my near vission.
Thanks,
Craig
No activity results to display
Leave a comment: