Search results

Yes an SQL

My only issue with Super Easy Word Merge by Albert D. Kallal is that when you filter your databasefor certain criteria like say a specific city and then you do the mail merge it still merges the entire database????

Hi guys Thanks for all your help! it looks like I may have cracked it with easy mail merge. Will keep you posted if any different.

Also I've followed theeasy word merge and I just get compile errors throughout the code. :banghead::banghead:

I'd like the option to mail merge one or lots of records.

Not sure i understand what you mean? The code above just opens Word but doesn't start a mail merge. And the same with the link you gave me, I down loaded the DB and it just opens Word and not mail merge.

Thanks for getting back to me, looks very intersting. :D

Hi All I want a click button that will start a mail merge in Access, so far I've tinkered around with some code over the past week and when running the below code which just opens the Word doc but does nothing else. Any help would be lovely :D :banghead::banghead::banghead:

Hi guys, Thanks for getting back with your response. It seems if you install it to documents then yes it just ask to enable. When you save it to program files it asks to be enables & saved which when you do and save it the same place as you've installed it, you can't save it because a user is...

Hi Guys When I copy Access into a new PC location it always asks to be 'saved' when you first open it up which is a pain because if you don't then it opens the DB but locks all editing. Is there a way of disabling this???? Many thanks. :D

I see thanks for all your help. (-:

But is there a geniric path for any Network target like the environ?

Hi Minty Thanks for getting back to me, I've sorted it and the code works fine, just me being silly. However I am trying to get it from a Network drive and can't get it to work??? :banghead::banghead::banghead:

Hi Guys I'm trying to set the desktop icon using VBA which is fine, however the shotcut isn't picking up the target path. Any ideas?

Thanks sneuburg!!! I was thinking it was this as I've been researching. but this line works a treat! THANKS FOR EVERYONE'S HELP:D:D

This is how it looks full code. I'm still getting runtime error )-:

Hi Guys Thanks for your replies, The idea is when the user enters a new company in the text field it will check for duplicates and show a warning message that this company already exsits in the database. If a name like for example Shem's Resturant I get the runtime error 3075 syntax error...

Does anyone know how to allow apostrophes in a text field with this code running on the after update event? :D:D:D:banghead::banghead::banghead::banghead:

Hi CJ Thanks for getting back to me, explorer gives me this \\User32\Users\Public\Adminfolder\Template.docx

Hi Guys I've touched on this topice previouly however to no avail, but I really need some help on this. In the DB the user can click a button which opens up a word doc which is stored in a folder along with the DB. The DB is stored on a shared drive (Network) and will be used in different...