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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by stevehatpa

  1. stevehatpa

    Query Problem

    Thanks everyone for responding. GMMASTROS- I tried inserting your "Select Coalesce" code into a new column in Query Designer and received a "Invalid or Missing Expression" message. Any ideas as to why I would be receiving this? Thanks. Steve
  2. stevehatpa

    Query Problem

    I'm somewhat of a novice with SQL 2000, so please bear with me. I have created a large query in SQL Query Designer. Unfortunately I cannot use CASE statements in this. Essentially I need to all values in column TX_PA_HOMESTEAD.HOMESTEAD_12, that are less than 51 to become 50, and all other...
  3. stevehatpa

    Query not working

    I'm somewhat of a novice with SQL 2000, so please bear with me. I have created a large query in SQL Query Designer. Unfortunately I cannot use CASE statements in this. Essentially I need to all values in column TX_PA_HOMESTEAD.HOMESTEAD_12, that are less than 51 to become 50, and all other...
  4. stevehatpa

    Macro Combo Box?

    That's exactly what I needed! Very easy. -Steve
  5. stevehatpa

    Macro Combo Box?

    I am working with a client who uses Microsoft Access 2000 on an XP machine. We have made a Macro for the client that calls upon a detailed query and eventually exports the data to Excel form. How can I have a "combo box", or some other window, automatically open for the client at the beginning...
  6. stevehatpa

    Access ErrorExport Issue

    Hello. I have created a series of Macros in Microsoft Access 2000 that allows a technology-challegenged client to create exports from underlying SQL data. The final process in the macro creates an Excel spreadsheet toa specified folder on their desktop computer. Since I am using Access 2000...
  7. stevehatpa

    ExportErrors Issue

    Hi, I have created a series of Macros in Microsoft Access 2000 that allows a technology-challegenged client to create exports from underlying SQL data. The final process in the macro creates an Excel spreadsheet toa specified folder on their desktop computer. Since I am using Access 2000 and...
  8. stevehatpa

    Conditional populating of report

    Turkbear, I think that did the trick! Thanks for the help. -Stevehatpa
  9. stevehatpa

    Conditional populating of report

    I am only a Crystal Reports user, but am attempting to change a past coworkers report. We have a a report that grabs various information, such as name, address, account number, etc and puts it into a report for printing out. There are some of them that put the name and address of someone, even...
See more

Part and Inventory Search

Back
Top