PC Review


Reply
Thread Tools Rate Thread

Cannot Do Record Searches While Module Running

 
 
Chaplain Doug
Guest
Posts: n/a
 
      9th Sep 2003
I have a "background" subroutine running which kicks off a
daily data download at 6:00 AM. I had to do this because
the Windows 2000 scheduler was not working due to the
security setup on my workstation. Anyhow, whenever this
subroutine is running I am able to move about in my
various switchboards. However, when I try to search for a
record, the search dialog comes up and I am able to enter
the search criteria, but when I click "find" I just get
a "ding" and no search takes place. Anyone know why? I
am including the code that is running in the background
(by the way if the code is dorky and there is a better
way, please say so). Thanks and God bless.

While 1 = 1
DoEvents
If Time = "6:00:00 AM" Then
TStart = Timer
TEnd = TStart
'Wait one second so duplicate CHAPFILEs not
kicked off
While TEnd = TStart
TEnd = Timer
Wend
Update_Executive ("Download")
End If
Wend

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Opening a new record form but allowing searches Fallout Microsoft Access Form Coding 2 7th Mar 2010 01:40 AM
running a Sub in a class module from a functionin a general module Paul Microsoft Access Form Coding 2 9th Feb 2010 02:25 AM
find/replace only searches selected record Howard Microsoft Access 0 29th Jan 2004 07:24 PM
Long running searches David Kleyman Microsoft ASP .NET 4 6th Jan 2004 09:29 PM
Reports and Record Searches - Basic Question Andree Microsoft Access Reports 0 14th Aug 2003 06:12 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:27 AM.