Search results

I need to get the MAX id from two tables for use in vb.net. For example: Table1 Table2 id, customer id, customerHow do I write a query that will return the last or MAX id from both tables based on a customer criteria. As a new user to access and vb.net any guidance...

I have a table in access 2010 that has a primary key in the 'Request no' field, that has no duplicates and no zero length., which is updated etc from vb.net. My question is how do I allow for multiple clients having the same number. For example, client 1 has a number of 011697 but client 2...

I keep getting the above error in access 2010 and for the life of me cannot see where the error is. I have checked that datatypes are the same. It keeps referring to type conversion failure and didn't add (1) record due to a key violation. The problem is that it doesn't tell you where the...

Hi I am using vb.Net to connect to an access db. In access 2010 this query works fine, but in vb.Net, it errors with 'JOIN expression not supported'. Now I am a new user to access and vb.Net so could do with some help to straighten this query out and show me my error. Many thanks sql = "SELECT...

Hi I have been struggling for 2 days trying to find a solution to my query problem. I am using vb.Net with access as a back-end and keep running into errors with a query I am trying run which fetches records {0} at a time so instead loading 28000 records I can load so many at a time. Now I must...