Yert33, I'd love to write an agent to automate the task, but I can't get a developer's access level for Lotus Notes, which I understand is necessary to write an agent. My company's IT department said a couple of years ago that they couldn't give me that access level because it cost too much...
thornmaster, would you say that putting a test like yours above into the "open" event is the best way to keep a report from running when there are no records for it to display? I run a long macro that tests to see if customers have ordered any of a series of catering menus and prints...
Well, I know more knowlegeable people than I will respond, but don't you need some kind of criterion in the last spot of that expression? I usually write these expressions like this
=DCount("[TagNo]","[Product]","[TagNo]=forms!frminputbox![TagNoinTextbox]")...
I certainly would also love to learn how to directly access a Notes table from my Access application. I have a catering database in Access that imports its main table from Notes. I first have to export from Notes to a Lotus 123 file, then import the 123 file to a table in Access. We do it...
How can I set a shorter page length for my reports? I print dozens of reports that use only half a page in portrait format. When a report has several records, they print two to a page, which is what I want. The problem comes when I print several reports, each of which has only one record...
Could you set a timer to run every 24 hours beginning with the time that you want the program to run? You wouldn't be setting an absolute time, eg, "2:00 am", but you would start at 2:00 am and use a timer control to open the program every 24 hours after that. You probably thought of...
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.