Search results

In a mailmerge query that I'm using there is a field called 'subgroup'. Some of the recipients are in more than one subgroup and so they are getting a letter for each subgroup that they belong to. I would like to send them one letter but with all the subgroups that they belong to listed (in the...

Does anybody have a quick answer for this please: I want to select all records in a table apart from records identified in another query ... I'm sure it's easy but my brain has gone to fuzz this morning Thanks!

Hi, I was trying to run a query for selected records using their ContactsID number in the criteria field. There are about 300 but they have nothing that links them so I just keyed them in manually. It produced an error 'query too complex'. I'm sure there must be a more effective way of doing...

Hi, I have a pivot table that keeps a running total of contracts sent, places booked, revenue etc. The problem is that in the places booked field in the PT, it isn't bringing up the actual number that is in my access table. It just puts '1' wherever there is an entry instead of the '5' or '19'...

I have accidentally deleted some code somewhere in my db. Now it won't work at all. Fortunately I have a back up copy that I saved yesterday but it doesn't have any records in it. How do I import just the records, not the tables themselves? I only have an hour before I go & it must be fixed...

I've looked at the other threads & still don't get it. I assigned a macro to a command button to print current form details. It prints the details across 6 pages. So I've designed a report based on a query to fit it to the page. So how do I get the button to print the report for just the current...

Hi, I think I've completely messed this up -I went into security wizard and set up a new workgroup, it secured the database then at the end it said the workgroup couldn't be saved as I was logged in as Admin and I would have to log in as a different admin user. I am the only admin user so I...

Hi, I would like users to be able to fill in a form for if they have made a sales appointment and e-mail it to the relevant person. I have the form and I have started by having mailto hyperlinks but how do I get access to attach the page with the data?