Search results

Hi that creates an error of which I have attached screenshot. Thanks

@Galaxiom Thank you for reply. However, it is only returning the value from the first table. Where have i gone wrong. Thanks SELECT Max([Request no]) AS MaxID FROM (SELECT [Request no] FROM Requests UNION ALL SELECT [Request no] FROM [Request Boxes]) AS A WHERE Customer = "DEMO";

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

How would I know what the dupe is? It certainly isn't the primary key which set to number not auto. I have checked required in fields and they are no and allow zero length. Where do I go from here. Thanks

Hi Now I am getting error like in the screenshot. What do I do now. I have checked for dupes and there are none. Thanks

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

Thanks very much JHB.

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

Thanks for reply. How hard can this be? All I am trying to do is pull the first 100 records based on a paramatised query using vb.net as front end and then click a button for the next 100 records. You get the idea. I have declared my vars like the code below. It is just a pagination example...

Pat. This is the query I am using to pull the first 100 records from the db. Is there a way to pull the next 100 and son on. Thanks SELECT TOP 100 Postings.[Ref no], Postings.[Customer], Postings.[Dept], Postings.[Dept name], Postings.[Date], Postings.[Net] FROM Postings WHERE...

The link the spike gave me is the original link where I found the query. However, I cannot get it to work. I posted my statement that I was using and it is not correct and I do not know how to correct it. 1) Do I need to incorporate COUNT within the select statement or it it declared on its...

Pat, Being as I am a new user to access, how would you code a query to perform this task. Thanks

spikepl, That link is where I got the code from in thr first place that everybody says dosen't work. I went to the last entry and that poster had a blog with the code I am using to get the result I posted, where people say the sql dosen't make sense. Thanks

Any further help with this please. Thanks

Here is the sql that gives me say the first 10 records for a parametrised customer. What I need to do is create a next and previous option to load the next 10 records or the previous 10 records. A pagination. I have posted my simple sql statement and I shall find a way to post then table. Thanks

@Plog Thanks for reply. As I am a novice to access, how do post a table here. Is there a way to output table in query form from access? Thanks

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