Search results

  1. A

    Application vs DoCmd

    I have been reading some threads that Application is the new DoCmd... any opinions on the two? Any major limitations of one vs the other? I have my entire database written with DoCmds but if the majority agree that Application is more efficient, then I will update accordingly. Thanks for your...
  2. A

    Slow Opening Invoice

    I have built an Invoicing system for the company I work for. I have attached a example copy of the invoice I designed. The only major issue I am having with my system is that the report we use as an invoice is slow opening (around 20-40 secs) for one page. This report has multiple sub reports...
  3. A

    Link BE table to more than one FE

    Howdy, I am working on a project that includes a BE file, and two FE files. One FE is a control panel for the admins to adjust security settings, look at audit files, etc., while the other FE serves as the data entry point for lower level users. Right now, when a admin creates a new employee...
  4. A

    Universal Error Tracking Within Form?

    I have made a public function that logs runtime errors. Do I have to write a "On Error GoTo Err_SpecificProcedure" to call the function from EVERY procedure in EVERY form, or is there a way to write a "universal" function ONCE per form that will call my ErrorLog function from any procedure...
  5. A

    Report Previously Formatted for Printer X....

    Howdy, I have multiple FEs across our network, and every user has their own printer. When a report is printed from a computer other than mine, Access 2007 brings up a dialog box saying that the Report was previously formatted for another printer (my printer), and will confirm that they really...
  6. A

    Checking Multiple Text Boxes for Unique Values

    Howdy All, I am working on a form that can have UP TO ten unbound text boxes with unique values inputted by the worker. How can I make sure each entry is unique (within the group shown on the form), while disregarding Nulls, before ultimately writing them to a table? I thought there might be...
  7. A

    Tabbed Information in Memos?

    Is it possible to have tabbed information in a memo? If so, how?
  8. A

    I Don't Want to Select the Whole Field!

    Howdy All, I have two text boxes I am working with: txtStarting and txtEnding. On the AfterUpdate property of txtStarting, I have a command which sends the first three numbers to txtEnding. When you tab from txtStarting to txtEnding, the whole field of txtEnding is highlighted, and I would...
  9. A

    First-Last(or something like that) With a twist...

    SURELY the old saying "If there is a will, there is a way" will still hold true for this one! I have a database that keeps track of lab records. If I have a set of ten labs on a particular invoice, such as these: .Lab Number.|.TestWanted.|.Description..|.Price...
  10. A

    The Larger of the Two Table Making Evils?...

    Which would be the larger evil: (A) Having lots of blank cells within 1 table, or (B) having multiple small tables with no blank spaces, but having to have complex queries accompanying them to be able to combine the data to resemble the 1 table in (A)? Thoughts?
  11. A

    Joining Fields to form Master List

    Hello All! I have multiple tables containing lab information, invoice information, and customer information. I would like to have a "master list" containing all the data in a compact form. The Table/Fields are like this: Table:______|___Invoices_____| Field:______|___InvoiceID____|...
  12. A

    Table Setup for Future Multi-level Report

    I will eventually need a report that will look like the example below, so my question is: How would I structure my tables to get the information to be able to be displayed this way? :confused: (A little background: I work with lab numbers with a possibility of having multiple tests required...
Back
Top Bottom