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

The problem you mentioned seems to affect queries with any kind of criteria including nulls etc. Have you tried the fix (in Word)Tools>Options>General>Check box confirm conversions on open. Then, when you select datasource it will give you an option of how to access datasource from which you...

Duh! Thank you!

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!

aha! I knew there must be a way - there was nothing in common - we just marked them out as growth companies but now I shall flag them as such and I won't have this problem next time! 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 think it's 'record selectors'. In the properties box turn 'record selectors' to 'no'.

Could I have it too please? Thank you!(theresa.curry@bacoll.ac.uk)

This code puts the field names in my e-mail but doesn't put the current form data in. Am I missing something? Also every time I press the command button I get an 'Illegal Operation' error and MSAccess shuts down. Can you help me any more with this? Thanks.

I tried copying the code over & it didn't fix it. The import wouldn't give me a data only option. The copy and paste method I have used before & got all the phone numbers muddled up! However I think I'll go with 3/ and just be careful!! Thanks alot! Done it - phew! Have a good w/end! [This...

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

excellent, thanks alot

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

I found that if I tried to search in add mode then it just added a new record. I couldn't search in the primary key field because it had assigned an autonumber. So now I just use CTRL F with the cursor in whichever field I want to search in ie Company Name. If anyone has a better way, I'd be...

Hi, thanks for that - it's got system.mdw & system1x.mdw but when I go to open them it is prompting to convert from an older version. I created it in 2000 so I can only assume it's the wrong one. In the help files it said to copy all the objects to a new db so I shall probably have to do that.

thanks - I'll try....

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

Thanks Helena, I'll try it now.

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?