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 Chriss Miller 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 mjd1947

  1. mjd1947

    Number Format with MySQL Linked Table

    Could you provide some direction on how this could be accomplished? The form is bound to a query which updates the record as soon as it is edited. Any way that I am aware of to 'display Value/100' would make the field based on an expression and therefore not able to be edited.
  2. mjd1947

    Number Format with MySQL Linked Table

    Hello.....I have a linked table through ODBC with a MySQL database. Any of the number fields are returned without the decimal place. For example 1,000.01 is stored in MySQL as 100001. My question is what is the best approach to work with these values in Access Forms? If I do any conversion of...
  3. mjd1947

    Update N number of Records

    Got it. Thanks so much for the advice.
  4. mjd1947

    Update N number of Records

    It can be the first 15 records. Basically the 10,000 records would be a pool of open Product IDs and I want to select the first X amount to update. Does that make sense?
  5. mjd1947

    Update N number of Records

    Hi, I want to have a command button that will prompt the user to update a specified number of records from the table. When clicked, a prompt will ask how many records and then update fields based on other controls. I have attempted this with the TOP function but cannot get the command to...
  6. mjd1947

    VBA Code to Hide Excel 2010 Rows

    I need a macro that will hide an entire row in Excel 2010 based on the value in one column. I have found other macros but they perform very slowly with 2010. The sheet has about 1300 rows. Thanks in advance.
  7. mjd1947

    Outer Join Four Tables

    This worked perfectly. Thanks for the help.
  8. mjd1947

    Outer Join Four Tables

    Any advice on how to set it up properly? Thanks
  9. mjd1947

    Outer Join Four Tables

    Ok This worked. Thanks, I just couldn't think of it. Now I have results with each UPC showing up multiple times depending on how many tables it is in. I would like a report with [UPC], [Price from ItemsA],[Price from ItemsB],[Price from ItemsC],[Price from ItemsD], etc. Any tips? Thanks
  10. mjd1947

    Outer Join Four Tables

    Hi, I need to make an Access query that will outer join four separate tables, for example: tblItemsA UPC Description Dept Aisle Price LastSold tblItemsB UPC Description Dept Aisle Price LastSold tblItemsC UPC Description Dept Aisle Price LastSold tblItemsD UPC Description Dept Aisle Price...
See more

Part and Inventory Search

Back
Top