vba access something like sleep ... but not quite.
i'm building a database in access 2003 of a group of music (with the names of the people who belong it, instruments, gigs etc...)
I'm working on a form connected to the people in the database, wich also have their pictures.(the pictures are not ole objects, they are external files)
the thing is... each time i change record of a person in the db form, access has a moment of 1/2 second to load the picture(between each record). If i click to change the record while access is still loading the picture, this produces an error not easy to clean from the screen.
1st i thought in the sleep function, wich should give me some time to finish the load of the picture before i could be able to click the mouse again. But this sleeps also the load of the picture :(
i was thinking in getting a function that could block my clicking during a certain time, and use it in a current-event(or something), but i don't know where to start...
can anybody help me please
write to filipeocacheleu aat hotmail dot com
thanks a lot