Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. BruceBell

    Acces Notes Tables via OBDC

    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...
  2. BruceBell

    msgbox if query has no results

    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...
  3. BruceBell

    DCount in text box with SQL backend

    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]")...
  4. BruceBell

    Acces Notes Tables via OBDC

    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...
  5. BruceBell

    Can I suppress the new page command?

    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...
  6. BruceBell

    run automatically a macro with the access compiler

    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...

Part and Inventory Search

Back
Top