Search results

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

Cheers! :D U'r a star!

Sorry - my vb knowledge is pretty basic Any chance of some example code and (how) would I call the module from the afterupdate of "booked-by"? Cheers, Rich.

Ok, i've tried the vb code in the after update of "booked-by": Me.Booked-by.Tag = Me.Booked-by I close the form, open it in design view and the tag is null. :( I havent quite got to playing with dlookup yet as I'm scared of messing up our customer database!! (as it's not me who originally...

I have a DB which requires staff to select their name from a list when taking a booking. Is there an easy way of the combo box remembering what was selected last when the form is opened, rather than the staff member have to select it every time they take a booking. I.E. Bob takes a booking and...

Thanks - my silly error. Still giving the same problem tho. It's as if the backcolor property doesn't exist for the CCissue field.