473,399 Members | 2,278 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

home > topics > general > questions > action failed - halt

Join Bytes to post your question to a community of 473,399 software developers and data experts.

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.SetWarnings. I can't get that to work either.

Thanks,

Craig
Jun 13 '06 #1
0 1072

Sign in to post your reply or Sign up for a free account.

Similar topics

2
Any ways to force the Program to halt?
by: kochs | last post by:
Hi, I have a problem here. Referring to the following programming structure, is there a way to cause the computer to overflow or stop by inputting wrong values of intTime and/or intDay? i.e. I...
Visual Basic 4 / 5 / 6
1
Once page is transferred the form action is wrong
by: willwork4dsl | last post by:
When implementing the Front Controller, you use Server.Transfer to halt execution on the "imaginary" page and transfer to the "actual" page. Thereby abstracting the url from the resource. The...
ASP.NET
1
Custom Action failed to launch under AD push Install
by: Eric | last post by:
Our .Net installation project includes a custom action that is launched post install. When the msi is run from a desktop, all is fine. We tested an install doing an Active Directory push to...
.NET Framework
6
AutoExec - Action Failed
by: darren via AccessMonster.com | last post by:
Hi I have multiple .mde FE's linked to an .mdb BE. The FE is distributed with an Auto FE updater and as such all users are on the same version of the FE. However, one user is getting "Action...
Microsoft Access / VBA
7
jinalpatel
Action Failed Error
by: jinalpatel | last post by:
I have a report which is based on a macro. Macro is serieas of open queries and a single open report query. When I run this report from my switchboard form it gives me the following series of errors....
Microsoft Access / VBA
0
Migrating Website to Cloud - Emmanuel Katto
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
General
0
BarryA
Navigating the Data Structures and Algorithms (DSA)
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
Algorithms / Advanced Math
1
Looking to do Android software development, any suggestions? Is flutter better?
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
General
1
Is that possible of reading the .csv file in column wise and the column have different lengths ?
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
C / C++
0
jinu1996
Maximizing Business Potential: The Nexus of Website Design and Digital Marketing
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
Online Marketing
0
The easy way to turn off automatic updates for Windows 10/11
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
Windows Server
0
tracyyun
Discussion: How does Zigbee compare with other wireless protocols in smart home applications?
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
General
0
agi2029
AI Job Threat for Devs
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
Career Advice
0
isladogs
Access Europe - Using VBA to create a class based on a table - Wed 1 May
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
Microsoft Access / VBA

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.

BYTES.COM © 2024
About Bytes
Terms Of Use
Privacy Policy
Sitemap
Advertise on Bytes:
Post a Job
Sponsored Posts
Platinum & Gold Sponsors
Hire Now!