Search results

This may help http://support.microsoft.com/kb/q182867/

Thanks for that. The reason why I like to do this is that I am making my db auto-update. What happens is that when the db is loaded if an update is nessecary it opens up another db. This db then copies all the latest files across and the re-opens the db. However I ended up using bat file...

Thanks for that but not 2 bother now, I ended making a bat file instead to the do copy, which I then call via macro in Access Cheers Karv

Hi Everyone, I am wandering if anyone can give me hand in coding this problem. I need to copy a folder & all its sub-directories(and files) to another destination. I have tried various codes floating around on the net but only for them not too work. I would greatly appreciate if anyone can...

Opening a MDB within a MDB via VB Hi All, How would you open another Access mdb via another mdb that is already open using vb or macro. I am at the moment doing the following: Application.OpenAccessProject "C:\UpdateAccess.mdb" Also tried: Application.OpenAccessProject...

Actually I figured out how to do the INSERT TEXT thing. But does anyone how I would modify the code below so that I can save the newly merged document to a specific filename???Cheers Karv objword = Null Set objword = GetObject("C:\WordDocuments\" & filename, "Word.Document")...

Hey first of all thanks. But would you be able to elaborate on this? Also is it possible via VB code to save the merged document as a specific file name?

Combining 2 word documents into 1 I am probally asking the impossible but worth a shot. I am currently mail merging from access (using VB code) data to 2 different letters. I am wandering if it is possible after doing the mailmerges to then combine these 2 seperate word documents into 1 word...

Thanks mate, it seems exactly what I was looking for!!!

Hi All, I am wandering if it possible to check programatically whether a query returns a NULL result? I am writing a program(VB) that involves an IFF statement where if there are records in the query it does a specific calculation & if there are no records returned in the query it does...

Hi all, I am wandering if anyone can help me here. I have a form which is linked to a table called tbl_File. Within in this form & tbl_File there is a field called Country_Code. In the Country_Code field the user places a number that corresponds to their country they want. Now Country_Code &...

Hi all I am using the following code done by Fizzio(found in another thread) to my mail merge. Public Sub MergeToWord(strDocName As String, MyQuery as String) Dim objApp As Object 'Change cursor to hourglass DoCmd.Hourglass True 'Open Mailmerge Document 'Start Word Set objApp =...

1. Get Latest updates of MS Office & Access ( see below) 2. Make sure all date formats in Access DB is set to medium date 3. Apply the formatting function in Word eg {MERGEFIELD "dates" \@ "d MMMM, yyyy" } where dates it the merging field........... These are the latest update filenames off...

Yeah I had the same problem..... Basically in Access makesure the format of the dates are in medium format. Then in word right click the merge field then click on toggle field codes. For example if you have a field called dates it would like: {MERGEFIELD "dates" } Pretty much then type the...

Thanks alot for that. I will give it a try. :)

Hi, Doesn't anyone know how to add a Dword to the window's registry via VB. As Access\word now requires users to have to place SQLSecurityCheck key within windows in order for the mailmerge to work automatically from Access. As I have multiple users using the program it would be alot easier...

After talking to microsoft the solution to this problem was: 1. Set to regional settings to right country this also includes the Language tab in regional settings (located in control panel) 2. Get latest update OFFICE(SP3), JET SP8 & Access Update After we the 2nd option, the dates merge...

Hi All have a problem, I have an Access DB that automatically runs a mailmerge to Word. Within Word I have also written a macro that when the Word document is open from Access lets call it Data.doc for was, it runs the commands: 'merge to new document' close Data.doc However when I execute...

This is a strange thing as it only occurs sometimes. What happens is when I click on my command button to do a mailmerge to word, nothing happens. When I then go to the word doucment(that access was merging too) to check what's wrong, I find that it has forgotten my query. In otherwords, no...

Well, I had done the above but it caused it to work one computer but not the other. And if switched it around it will do vice verse on the comps. I found what was going wrong. What it was, word date settings NOT the computer was set to as a US date. Also there are things called smart tags...