Search results for query: *

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.

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...

Got it. Thanks so much for the advice.

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?

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...

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.

This worked perfectly. Thanks for the help.

Any advice on how to set it up properly? Thanks

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

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...