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!

Register Log in
  • 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. FRIDL125

    removing security mdw file.

    You can create a new user group and call it [YourName].mdw and replace the existing file of the same name. HTH Lisa
  2. FRIDL125

    Creating a Temporary Recordset for Output

    This works like a charm! Thank you! One last question... I would like to automatically save this report to a specific folder so that someone else can automatically pick it up at a specified time. How would I do this in conjunction with the code you provided? The code I am using with a...
  3. FRIDL125

    Creating a Temporary Recordset for Output

    In my database, I have an existing query that I want to use with several different forms specifying date ranges. Using VBA, is there any way to do the following: 1) Reference the query 2) Run an SQL statement on the query to obtain a subset of records that match my date criteria 3) Create a...
  4. FRIDL125

    Restore & Maximize

    Is it possible to DoCmd.Restore on Form_Load for a specific form without affecting other forms that may be open? (i.e. a menu form) Or, do I need to close the form I want to remain maximized when I open the form I want to "restore" to a half-screen size (and then reopen the first form...
  5. FRIDL125

    Do... Loop Issues

    I am having difficulties extracting information from another application to load in my database. I have one table (tblAccounts) that stores account numbers and another table set up to receive the account number and the additional information I'm screen scraping from our system. I am using a...
  6. FRIDL125

    Do... Loop Nesting and Runtime Error '6' - Overflow

    NOTE: I am no longer receiving the Runtime Error
  7. FRIDL125

    Do... Loop Nesting and Runtime Error '6' - Overflow

    I have the following code and when I attempt to run it, it doesn't loop properly. The underlying table from which I am pulling data contains 1000 records. The field length is 20. The online help hasn't helped me at all and I'm wondering if anyone is seeing anything that stands out as being...
  8. FRIDL125

    Concatenation: Text and Numeric Values

    Bob: Thanks very much! This is exactly what I needed. I do have one follow up question... In some cases, especially with the percentages, if the percent is 4.75% (for example) in one record, it may be 14.75% in another. How can I prevent the 4.75% from displaying as 04.75%? TIA, Lisa
  9. FRIDL125

    Concatenation: Text and Numeric Values

    I'm wondering if the following is possible. I can't seem to find any supporting documentation on the Microsoft site. I have a control that I am using to "create" a project description that (via concatenation) pulls together several fields... some of which are % and currency. I have my...

Part and Inventory Search

Back
Top