Hi,
I'm quite new to Ms-Access, so it's possible that I'm making a bit of
a school boy error, so please forgive me.
We are populating a table "tbltempacc" with about nine or ten lines of
results, and then trying to print a report based on this table. We
have had a problem for a while where occasionally one or two lines at
the bottom of the report do not print. Initially this seemed to be a
timer problem, so we added one. Now over time we have had to increase
this timer to ten seconds long and we still get problems sometimes.
Quite frustrating. The code we're using is shown below. Anyone got any
ideas?
'Code with calculations to populate table is up here within a loop.
Pausetime = 10
start = Timer
Do While Timer < start + Pausetime
DoEvents
Loop
'print report on data in tbltempacc.
DoCmd.OpenReport "rpttbltempacc"
Thanks in advance,
Laurence