Recent content by Justin

I have a parameter query set up to allow me to select records to use in a mail merge. I have the query and mail merge set up to run in a macro. What I want is to be able to automatically add the current date to a Date Run field in the table when the macro is run so that we can see which records...

Thanks for that but I can't seem to upload the database as its too big and I have tried compressing it too and its still 500k too big.....i have added a couple of JPEGS if thats any help. Notice that there are 3 donation entries for the person and 3 records have been returned even though they...

Thanks - sorry I should have said that I already have Donations displayed on the form as a subform and even though the number of entries are displayed in this subform, I still get the same number of records duplicated ???

I have searched the forum but cannot find an answer to this problem so I hope someone can help me. I have a multiple table database and I have set up a search form so that for example to search for an entry by name, you choose the name from a combo box (picked up from the INDIVIDUAL table) and...

thanks for your help with this !

Thanks Neil - just to claify this is the SQL statement for the query as it stands SELECT DISTINCTROW Individuals.IndividualID, Individuals.Name, Individuals.Address1, Individuals.Address2, Individuals.Address3, Individuals.Postcode, Individuals.Telephone, Individuals.Email, Individuals.[Company...

Thanks for this - I should have mentioned I have got to this stage already. What I now want to do is add a search facility so that my users can search by name, postcode, who is a donor etc BUT my query comes back blank even though there is data in the database. However I think this is because...

I have a database that records details of people who either fundraise, donate, hold events or volunteer for our charity. The Main table (containing personal data) is linked to the other four tables FUNDRAISING, DONATIONS, EVENTS and VOLUNTEERS. One person can do one or more of these things. My...

Thanks very much for your help woith this :)

Yes the record has been saved on further inspection I think it is because some related fileds in other tables are blank. How do I deal with blank fields so that my data is returned whether fields contain values or not? thanks

I have a database with multiple tables and I have designed forms to enter data. In form view i can view all data that is input but as soon as i try and use a select query to extract the data from the multiple fields, my queries are blank. Can anyone help me with why this would be?? many thanks...

Hi I have an address form that has 4textboxes for a work address and 4 text boxes for a home address. I also have a check box. I want to run a report (to print labels) based on a query that selects records that are ticked, but I then want the user to be able to specify whether to use the home...

thanks I will try those out !

Is there I way that I can setup a notification alarm in Access? I am doing a database for storing staff contracts and I have a field for "contract end date" and I want to set something up so that I am notified by a dialog box when the length of the agreement is 6 months from expiring. I have...

I need to be able to click a button on a form and it opens a word template, which you can then fill in and the database can link to that word file. Can anyone help please? thanks