DoCmd. statement in my script is bypassed

captnk

Registered User.
Local time
Today, 16:26
Joined
Dec 12, 2001
Messages
148
Can someone tell me what I am am doing wrong.
(as u will guess vb is not my strong point but it does work..up till now)
My script worked perfectly until I inserted:
DoCmd.Run Macro "imtempclwrtm"
Into the statement.
The script appears to ignore the Run macro command.
Heres the bit that doesnt work:

'move the file we have just imported out of the way(so we don't import it again)
Name "d:\price\" & filename As "d:\price\done\" & filename
DoEvents

'calculate the classfig and ratings
DoCMD.RunMacro "imtempclwrtm"

'make sure that operation is finished before continuing:

'loop back if there is another file:
Wend
 
Tks folks!
Dont worry I appear to have resolved the problem.
All best
 

Users who are viewing this thread

Back
Top Bottom