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

    after 97 to 2k conversion; working report has no number?

    I converted a working app from acc97 to acc2k. A working report is now not displaying any numbers. The data is there but if a date or any numeric value is suppose to be displayed, it is blank. Report example; In Acc97: Truck Date Amount CH-01 12-10-04 $100.99 In Acc2K: Truck...
  2. johnmc64

    microsoft access running on a dba

    Mark, I'd consider an HP H4150 400Mhz processor, 64 RAM, 32 ROM. Has features that can accept Access apps. Consider writing a new FE that creates temp tables and loads only data that is needed. Do you need the entire mdb? Can you create temp tables that "roll" according to your needs? For...
  3. johnmc64

    How do I have one database at more than one office

    I'm with dhaveedh, those two offices should have a link between each other. Without a doubt, a single shared source is the best route. If your company does have a link, its about time they consider this. Replication has its difficulties. What Neil Berryman wrote is true, you can open yourself...
  4. johnmc64

    Print n copies of a report

    Dear Pez, The Mn value is stored within the data table (Historic reasons). Also, each of these copies will become an invoice, so to speak. Its easier to invoice "12345-M16" than "12345-1, 12345-3, 12345-3..." I've tried the OnPrint and Onformat with a prompt. I can trap...
  5. johnmc64

    Print n copies of a report

    Hmmm...thanks Pezamystik. I've tried that option before but it won't work here. 1. When a dispatcher marks are report for printing, it may be 6 hours before he actually wants the report to print. With the PrintOut method, it implies that you are printing immediately. 2. Normally, the...
  6. johnmc64

    Print n copies of a report

    I have a dispatch system that sometimes requires multiple copies of a single Bill Of Lading (BOL). To print my BOL's, the dispatcher simply enters an optional code, ie. M16, (which is stored within the record) and a "Master" bol should be printed with n (16) copies. I am not sure...

Part and Inventory Search

Back
Top