Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Modules / DAO / VBA / February 2006

Tip: Looking for answers? Try searching our database.

Weird problems with VBA in Access

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
tfitzhugh - 30 Jan 2006 20:56 GMT
Hi,

I am having some strange difficulties with some VBA code written in Access.  
The code was originally written in Access 97, where it works fine.  Since
then I have been using the same code in Access 2000 and 2002, but for large
datasets the code will inexplicably just stop.  There is no error message or
anything, it just stops processing after it reaches a certain number of
records.  I can identify where in the dataset the code stopped from the
output, but when I run the code using the debugger to that point, there is no
identifiable error.  That is, I can step through the point where code stopped
with no problems and keep on going, as long as I am in the debugger.  It only
kicks out of the routine when I am runnning it outside the debugger.

Any ideas?  I'm hoping someone else has had a similar problem when
transferring VBA code written in Access 97 to later versions.

Thanks!

Tom
Margaret Bartley - 03 Feb 2006 00:23 GMT
This sounds like it might be a corruption issue.  I've had invisible
corruption issues before.

You should rebuild the table with the offending data.  Do an Append Query to
move every record to the new table, rather than copy the table from one DB
to another.

One way to decide if it's a corruption issue is to resort the input data,
and see if it stops with the same record, or at the same recordcount.

> Hi,
>
[quoted text clipped - 15 lines]
>
> Tom
George Nicholson - 07 Feb 2006 02:18 GMT
You might consider adding a "Do Events". (maybe have it excecute every 10th
time through the loop). Depending on the program, what you're asking it to
do and the hardware it's running on a "Do Events" can help to let all the
pieces get back on the same page.

Not a particularly elegant suggestion, but I've had it work too many times
when nothing else seemed to.

HTH,
Signature

George Nicholson

Remove 'Junk' from return address.

> Hi,
>
[quoted text clipped - 21 lines]
>
> Tom
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.