Sorry, I mean like there where I've passed the SelectObject function a report not a form but used acForm instead of acReport.. I would expect that to produce an error/fall on its backside in C but VB is happy to ignore it. Better for stability but annoying when you make stupid mistakes and typos!
You're a superstar... thank you very much for pointing out the very stupid typo! Fully working now! :D
A by-product of this is why are there no variable controls for VB?! ;)
Hi, Im trying to call the same report several times in VB using a global variable to control the initial query results and I can't seem to get it working - to be honest I'm a C coder not a VBA coder and am a bit of a n00b when it comes to Access and VB so I get a bit frustrated at the minute!
I...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.