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 Rhinorhino 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: *

  • Users: gaRed
  • Content: Threads
  • Order by date
  1. gaRed

    Converting a Combo Box to a Text Box

    I have a form that deals with production data that has two combo boxes, one for the starting date and one for the finish date, as well as several radio buttons that give users the option to go back in week, month or quarter increments instead of going back to a specific start date. Things were...
  2. gaRed

    Errors with Compacting Function

    I have several buttons on a form that compact different parts of a database. When clicking on them, the program starts making constant error noises and the message bar at the bottom of the browser blinks different errors so fast that you cannot read them. Upon hitting control, alt, delete, I...
  3. gaRed

    Part of DB is Still in Previous Version of Access

    The programmer that was in charge of my database before me converted it from Access 97 to 2000. I believe part of the db is still in 97 format. Clicking on one of the buttons gives an error saying that the program cannot run visual basic code from within. This is a 97 problem. How do I find...
  4. gaRed

    Problem with Snapshot Naming

    I have a form that generates production reports from an access db. The form gives the user the option to generate reports in Microsoft Snapshot format, via the click of a button. When the user clicks this button, a Snapshot file is created and stored in a folder on the user's c: drive. I...
  5. gaRed

    Compacting Problem

    I am working on a database another programmer created. At some point the DB was converted from Access 97 to Access 2000. My boss has always felt that a few parts of the DB (mostly tables I think) did not get converted and are still in 97 format. I am having some trouble with a compacting...
  6. gaRed

    Want Query to Open an Excel Spreadsheet

    What is the best way to have the results of a query automatically open up in an excel spreadsheet? Thanx.
  7. gaRed

    Need an Excel Spreadsheet to Automatically Update a Table

    Normally, I'm not an excel user so my quesion may seem a bit easy. I have an excel spreadsheet that the user enters production information into. There are many ranges. The user wants the Totals to automatically populate a table, instead of her having to type in all the spreadsheet data, and...
  8. gaRed

    Commenting in Access

    Does anyone know how to comment out SQL code when using an Access database? I know that you can use '/*' or '--' to comment out SQL on other types of databases, but not with Access.
  9. gaRed

    Subform won't display Query results

    I am having trouble getting the results of a select query to populate a text box in a subform. I can't figure out what I'm going wrong. The query deals with down production hours and is measured in military time. Part of the IIf statement in the select portion of the code is as follows...

Part and Inventory Search

Back
Top