Search results

Hi peeps. I think it's a query I need!? I have a query that collects information for an appointment letter from two tables, tblclients & tblappointments. I have multiple locations, times, dates, clients and advisers. I need to do something that will dissallow a double-booking. i.e. client...

Access to Word Mail Merge Automation Hi all. I was wondering if anyone can help? I have been trying to automate a mailmerge from Access 2002 to Word 2002 (xp) but with no luck. I have a query that I wish to use as the datasource. I have found some code for the 97 version but can't get it to...

Hi. I have an appointment booking system that I have created with a lot of help from Fizzo in the form of an example. It has been the only example I have found that a newbie like me could understand (sort of).I have come across a problem though. (I have e-mailed Fizzio but thought I would...

Hi all. I have a search form on my database which consists of three text fields and three buttons. This is to enable you to search for record by surname or date of birth or record id. The code behind each button is: DoCmd.OpenForm "Records", acNormal, , "[Surname] Like '*" & Me.Text1 & "*'"...

Hi people. I'm totally new to this forum and quite new to Access. I'm learning as I go and finding a great deal of help in these forums.I have made a contact management-type database, including a search form to find specific records. The next step in my database is to create an appointment...