Recent content by mr_sd

Brilliant! Thanks.

Hi, I was wondering if it's possible to use one form to display the results of different queries. I have a form to make a booking, an identical form to display booking search results and another identical form to display today's bookings. When I update the database, I make identical changes to...

I have a duplicate finding query which returns all the bookings that are on the same date at the same time. It also returns the number of people. I would like it to only return results where the total number of people is greater than 20. (all duplicate records [nopeople] fields added together)...

Sorted Thank you.

I have a query which displays times of bookings for today. Booking times are formatted in 24hr clock without seconds eg "14:00" I need a criteria which will only display bookings up to 2 hours old so at 16:00 the 14:00 booking will no longer display. I have tried (in the booking time...

Just realised something really obvious Why don't I just make a report for the envelopes instead of a word mail merge?!? *Slaps Self* Sorry guys.

Anyone? :confused:

Hi, heres my problem: I have a database which prints letters. I have a word document which prints the envelopes via a mail merge from the database. I would like to know if there is any code I could use on a button which will automatically merge the 'envelopes' document to the printer rather...

My primary key is an autonumber althought there are some gaps between numbers

Where would I put this? In the criteria of [PartyID]? Kind Regards, Rich.

Hi, appologies if this has already been answered but I can't find it. I need a query to find the last/latest entry into a table by its primary key [PartyID] Kind regards, Rich.

Genius!! Never would have thought of that. Thanks very much! :D

I have a line of code in an afterupdate sub for my "surname" field: The code: Me.PartyName = StrConv(Me.PartyName, vbProperCase) The problem is when a double barreled surname is entered eg: Smith-Jones The code converts it to: Smith-jones. Is there a simple way to correct this? Thanks, Rich.

Cheers. Much appreciated.

Hi, I am modifying a database which was written by someone else. The database it used to take bookings from customers. The booking form saves to the table tbl_(dump)Partybookings The contents of this table are then moved to tbl_Partybookings and the dump table entry deleted. It uses this VB...