I have a database that handles bookings etc for after-school care. I set it up so that the user could just tick boxes to indicate days each child books.
This gave a total of 65 tick boxes. I then set up a combo box that showed "monday week 4" or whatever but kept a value from 1 to 65 for the appropriate day.
Lastly, I set up a set of if statements basically saying
if combo=1 make a table where day1 is ticked
if combo=2 make a table where day2 is ticked
etc
My problem is that when I run the module I get an hourglass for a second or two and then back to the pointer but the pointer appears 2 or 3 seconds before access has finished making the table.
The object is to print the roll but I can't put the print command in the module or macro because I get an error "table doesn't exist" and even with a seperate print button the user gets an error unless they wait the few seconds.
Is there some way to introduce a pause or wait in the process?
This gave a total of 65 tick boxes. I then set up a combo box that showed "monday week 4" or whatever but kept a value from 1 to 65 for the appropriate day.
Lastly, I set up a set of if statements basically saying
if combo=1 make a table where day1 is ticked
if combo=2 make a table where day2 is ticked
etc
My problem is that when I run the module I get an hourglass for a second or two and then back to the pointer but the pointer appears 2 or 3 seconds before access has finished making the table.
The object is to print the roll but I can't put the print command in the module or macro because I get an error "table doesn't exist" and even with a seperate print button the user gets an error unless they wait the few seconds.
Is there some way to introduce a pause or wait in the process?
