Search results

Thanks Paul. For some reason I thought I was simplifying the query. I was in mind simplifying the opposite of the query Not ( Not Like "*Payable*" And Not Like "*Receivable*"). I feel very stupid now. Alok

Hi Friends I was trying to simplify a condition for a field in a query: I replaced Not Like "*Payables*" And Not Like "*Receivables*" with Like "*Payables*" Or Like "*Receivables*" and got completely different results. Can someone explain why this is so? Thanks.

Thanks Bob. Yes I was referencing the correct library Microsoft Office Access Database Engine 12.0 Object Library but I was not able to get my code going. Then I saw that you have to do DBEngine.OpenDatabase. When I did that then the things starting working. I never tried this in the first place...

Hi Friends, I normally use Excel to connect to 2003 format Access database. Even when i use Microsoft Access 2007 I have been making it a point to save the database in Access 2003 format. I use DAO to connect to the Access databases and have had DAO Object Library 3.6 reference in the IDE. I...

Hi friends, I am Alok Joshi and have been coding in VB2 through VB6 and then Excel and Access VBA for the past 15-20 years. I enjoy playing Chess and Table Tennis and solving and reading about recreational math problems. I also like to read about World, and Medieval and European history. I...