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 Mike Lewis 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. bonnief

    Pause execution opening a form until the form has calculated

    Form frm603 is the form I want to delay opening until all frm603 fields have been calculated. With my code, the fields are still not calculated when the form is opened. My code does delay for 10 seconds, but I think it is stopping everything so that my fields don't calculate until AFTER MY...
  2. bonnief

    Pause execution opening a form until the form has calculated

    I a have a form with multiple summed fields whose control source is "=DSUM..." or "=SUM...". When the form opens it shows "Calculating..." in the bottom left corner until all of the fields actually have their values calculated. I would like to display the...
  3. bonnief

    Text Import from Excel comes in as scientific notation

    I had the same problem with Access losing the leading zeroes on a batch number (ie. 0012345 would convert to Access as 12345). I insert a dummy record as the first record in the excel spreadsheet. I key in AAAAAAA (adjusted for field length) as each field value in that 1st record. Access then...
  4. bonnief

    Who has an excel spreadsheet open

    Is there a way to display through code the user who has a spreadsheet open? Thank you.
  5. bonnief

    Open recordsets to edit data entered in a form

    I use a technique several times in a user entry form. Multiple users are entering into this form at the same time. The entry gets slower and slower. Is my code shown below causing this slowdown? Thank you. 'Page 248 Access 97 Developer's Handbook: 'Define query parameters passed to query...

Part and Inventory Search

Back
Top