Recent content by cright99

Yes I did and the problem is when the WHERE statement changes to SELECT CustomerID, Name, Min(ApplicationNo) As MinAppNo FROM ClientSearch WHERE ApplicationNo LIKE "5001*" GROUP BY CustomerID, Name I get all the records in the table. But I only want the records that is LIKE "5001*" Im...

I think I found a solution but can't get it to work with Access because it doesn't allow select statements inside a select statement. It goes like this SELECT * FROM ClientSearch AS CS JOIN (SELECT CustomerID, [ApplicationNo] = MIN([ApplicationNo]) FROM ClientSearch GROUP BY CustomerID) AS CO...

Thanks for your help but Its still doesnt do what i want :(. this is really doing my head in :(. The problem is that the WHERE conditions are variables in VBA. So the user can change what the values are and what fields to look in in the search engines interface. For example the user could do...

Sorry I should of elaborated on the conditions of this sql Statement. It is based off the search example here http://www.access-programmers.co.uk/forums/showthread.php?t=99353 So the sql statement in code can switch around to look like this: SELECT * FROM ClientSearch WHERE ApplicationNo LIKE...

I have a table (Well actually a query called ClientSearch) which is for example holds this data: CUSTOMERID NAME APPLICATIONNO 1001 Bob 5001 1001 Bob 5002 1002 Jane 5003 1003 Fred 5004 1003 Fred 5005 1004...

Thank you soo much. Perfecty done :D Quite sad as I've just completed a course on databases. But I've never been told how to use the join keyword before :(

I have about 4 attributes of a table called Customer which has a primary key CustomerId then FirstName, lastname, phonenumber Then it has a relationship with another table called Application with a primary key of ApplicationId then Type, ExpiryDate, CustomerID CUSTOMER(CustomerID, FirstName...

Whats the deal with Mde's? I can compile my mde fine. But it wont run any of my vba code that ive written for my database. I know that the source code isnt displayed. But I didnt think the vba code just wouldnt run as well. What is the point of a mde if you cant run vba code?? I must be doing...

I keep on getting the error run-time error '3033'. I cant access the master front end mdb file. Im getting a head acke from trying to get this to work. So I give up :(

Our business is using Access 2007 for its database. It users the workgroup way (Not sure what its called) to connect multiusers to the database. Our database is a immigration company that records information on customers names, address's, what visa/permit they are on, invoicing and recept...

Im using it as my main os. Id say its better than vista. Cleaner and a little easy to use. But mainly it feels more comfortable. I guess the reason why i like it a lot is because its got a lot of improvements to the user interface which just makes me happy as it shows they care about me ;)...

Yea good point. Im not sure how it works, ill have to ask the business. An application can be lodged at a branch. And also a Case officer can be located at a branch which is assign to an application. Annnyway... the question has been asked. So thank you!

Thanks a lot for that! I learnt so much from it :) Ive just been working on the erd for the database for the last few hours. I came up with this... I dont expect anyone to help or suggest any improvements to it. As I realise people have lives and there is quite alot to the erd. But thought...

Im new to Normalization and working on updating my database which has about 1500 clients in it for my parents immigration company. I want to reduce the size of the database. I have for example two tables that are CLIENTS(ClientID, FirstName, Lastname, PermitType*, PermitLocation*)...

Thanks for that. Im trying to figure it out (im not to good at sql) But still havent got any where yet :(