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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
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...- mjd1947
- Thread
- Replies: 3
- Forum: Microsoft: Access Other topics
-
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...- mjd1947
- Thread
- Replies: 7
- Forum: Microsoft: Access Modules (VBA Coding)
-
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.- mjd1947
- Thread
- Replies: 3
- Forum: Microsoft: Office
-
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...- mjd1947
- Thread
- Replies: 8
- Forum: Microsoft: Access Queries and JET SQL
