We had this annoying problem: a simple query in Access to a linked table (using ODBC and MS SQL server) returned incorrect results, though the same query returned correct results in MS SQL server. By incorrect I mean the field values were different, so rather than returning AZ, the query returned BZ (some other value […]
Continue readingWell, I got this error message today while I was trying to import a text file: “The search key was not found in any record” After some research, I found that either it was a bug caused by Microsoft Jet 4.0 Service Pack or it was the size of the database (should be not greater […]
Continue readingI was trying to enable an add-in for Excel 2007, and I kept getting this error: Access to the VB project is not trusted You can turn this message off by going to Developer tab in the ribbon and then clicking on the Macro security button, and checking the check box for “Trust access to […]
Continue readingProblem: When I tried to export a table/query from Access 2007 to Excel 2007, I was getting this annoying error: You selected more records than can be copied onto the Clipboard at one time. Divide the records into two or more groups, and then copy and paste one group at a time. The maximum number […]
Continue readingPMT function has various uses; if you go to Excel help you?ll see its uses. I am using it to calculate monthly payment I have to do pay off credit card debt. If you also want to do that please follow these steps: 1. Type this A1=Card Name, B1=Balance, C1=Years, D1= Interest rate, E1=Monthly Payment, […]
Continue reading