Delay

  • Thread starter Thread starter Kevin Rickey
  • Start date Start date
K

Kevin Rickey

I have a VB application that sends data to an Access database via a command
object.

My problem is this: The data does not seem to be finished being written
before I need it to be displayed. If I step throught he application, as
long as I wait a second or two before I jump to the display part of the code
it willl work fine. I would assume this problem to be greater once the data
no longer resides localy.

My question is this: Is there something / someway Access can send something
back to say it is finished? I send the data to it and it returns some kind
of result code or something?

Thanks
 
Kevin,

Check the Command object's State property:
adStateClosed
adStateOpen
adStateConnecting
adStateExecuting
adStateFetching

While cmd.State > adStateOpen
'Do nothing
Wend
'Display the data

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
 
Back
Top