Recent content by b_karv

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