Recent content by CJ UK

Hi Fizzio I have put the SQL you suggested in the criteria box under [ClientID] in my query. I am getting message: 'The syntax of the subquery in this expression is incorrect' not sure how to remedy this? Did you notice in my previous post that I am having to select the appointment query...

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

Nearly there! Hi all. I have implemented the code as suggested by Fizzio. I have got it up and running but I'm having a few minor problems. When I hit my "Create Letter" button, word is starting, opening up my merge doc but it is bringing up this list of data sources for me to choose from...

Hi Fizzio, Thanks for the reply. I have created the module and altered the query reference to match my query (qryapptletter). Still not sure what I need to do to my query to not accumulate results. Also not sure, now that I have got the mailmerge module, how to run the code through the...

Hi Fizzio Thanks for the code. Me being a newbie, I'm having a little trouble on how to implement the code. Lots of reference to .ActiveDocument, does this mean that the document I want to merge to needs to be open? What do I click on, select, run etc to implement the code, no reference to a...

Thanks for your reply. I have considered using a Report but have encountered a few problems with the layout. I am sure that these could be overcome with a little patience. The main reason that I wanted to automate the process was so that the letter would print automatically (x2) as soon as...

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

Search for a specific record Hi Dave. Thanks for the example. I am sure I will be able to modify this suit my needs - excellent! It also seems a very user friendly way of going about it and I can see that it will be more efficient too. If you get a chance, would you mind looking at my other...

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 again. I'm afraid I'm no further along. I will give more detail in the hope that someone will be able to help. I work in a team of 10 advisers. Each adviser has 5. 6 or 7 appointments per day, at 30 minute or 1 hour intervals. I have created a database for the clients records and have...

Hi Rich. Thank you for your reply. I have a copy of the PIM, found on the net. I have been fiddling about with it and learning a lot as I have gone along. However, what it does not do is allow you to book an appointment for someone through their record and have it appear in the diary. Also some...

Hey, I'm replying to my own question. I've had some thoughts about the design for this problem. We never work with people for any more than a year, therefore the diary does only needs to run from the record creation date to plus 1 year. How about having one of these diaries on each persons...

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

Hi Kacy. I am new to this forum and relatively new to Access. (I can't even find how to create a new thread!) You are the only person as far as I can see that has mentioned and appointment scheduler recently, so I thought you'd be the person to ask. I have created a database for my clients and...