Help I need somebody lol...

[June7]

Also, search the Access Help for topic 'Introduction to Programming in Access'.

[keels]

I use both but the designer helps get basic SQL constructed faster.

Am surprised you could be comfortable with the SQL editor and not know how to include the WHERE clause. You might find this tutorial site of interest http://www.w3schools.com/SQl/default.asp

Am not comfortable with the editor, I used the wizard in 2007 and I'm fumbling my way round, admittedly I have learned a fair bit of the basics in access and excel since becoming unemployed 2mths ago. But code of any kind baffles me, what's the saying about OLD DOG New Tricks that's me lol, sorry.

Akeel

P.S. thank you both for the help, if only the whole world where like this hmmmm

[keels]

This is the code that was created by the wizard, how would I add the extra code?

[RedWolf3x]

Keep us posted on how this works out for you.

[June7]

If I understand correctly, try:

In (SELECT [Passenger Name] FROM [Bookings] As Tmp GROUP BY [Passenger Name] HAVING Count(*)>1) AND Forms![My Form]![passenger name]

[keels]

Keep us posted on how this works out for you.

Will do, how would I upload my database so you could see what I mean and check the code, it's quite big like 44.9 MB?

Cheers

[keels]

Thanks June will try this.

[June7]

Copy file, remove confidential data, run Compact & Repair, zip if still large, attach to post. Attachment Manager is below Advanced post editor. 2mb size limit for zip. If still too big, try extracting objects relevant to the issue.

[RedWolf3x]

Go to Tools> Database Utilities> Compact and Repair Database That will shink the size.

[keels]

Nah didn't work. Hmmmm

[keels]

Ok thanks guy's going to try shrink it like I could really do with shrinking it oops sorry just had to get that one in lol

[keels]

Ok guy's here it is the troublesome little DB .
See what you can do please, btw the postcode search returns a void because I had to delete that table because it was to big to send.
if you use the Venus dispatch System form to fictitiously book a job you will see the results of the booking table duplicates, that is fine but I only want to return the names that correspond with the name you entered.

Cheers

P.S. can I select a record from the query and have it append the bookings table and show as a current outstanding job?

[RedWolf3x]

Unfortunately I'm unable to open the database you copied, however I believe if you change the code in the Zoom to

IN(SELECT [Passenger Name] From [Bookings] As Tmp WHERE Bookings.[Passenger Name] = Forms![Your Form Name]![Passenger Name Box on form] AND Count(*)>1 Group By [Passenger Name]


Update the bold sections with your form name and the name of the box on your form.

[keels]

Ok sorry try this I converted it to 2002 -2003 so you should be able to open it.

Will try to amend the code in the mean while.

Thanks Red your a diamond geeza