Search results

OK so here's the solution I came up with: Private Sub RunMailMerge() Dim txtMailMergeFile As String Dim objWord As Word.Document Dim i As Integer txtMailMergeFile = DLookup("txtFilePath", "tblConstants") & DLookup("txtBAMailMergeFile", "tblConstants") Set objWord =...

I am able to come up with this code: Private Sub RunMailMerge() Dim objWord As Word.Document Set objWord = GetObject("C:\MCLAP\Buyer Agency - Mailmerge.docx", "Word.Document") ' Make Word visible. objWord.Application.Visible = True ' Set the mail merge data source...

I was able to get a code snippet from http://support.microsoft.com/kb/209976/en-us to "sort of" get me where I need go. But when I run the code, the following happens: When I try this approach, Word does not open up. But when I open my mailmerge document manually, 1. I get a prompt "The...

It's interesting that multiple people can work on a problem on one forum without issue. But as soon as the issue is shared to another site we have Dudley Do-Right "telling" on you. For a community that works in a field that requires a high level of logic, this practice defies comprehension...

And here: http://www.utteraccess.com/forum/Mailmerge-Access-VBA-t2013300.html

I am using Office 2010. I created a mailmerge document in Word that uses my Access database as its data source. That data source is a local table in the database. When I open the Word document, I get the prompt to connect to my data source and run the mailmerge. When I do so, the mailmerge...

OK, point taken about cross posting. Sorry. I didn't know. I'll follow the guidelines from now on. I'm relatively new to forum posting but not new to Access development. I'm 99% sure no other queries are running. On the form on which is the Exit button that I am trying to get to...

So far, the best workaround is to forcibly re-open "Login Screen" just before exiting the application. This in my opinion is a weak solution and does not address the root cause. I am still looking for an actual solution.

Galaxiom: I am running a accdb, not a accde Alansidman: I do not understand the purpose of the cross-post. I posted the same question on 4 forums to try to get an answer more quickly. ChrisO: I'm not using that Global variable in any Close/Unload events. I apologize for my impreciseness...

A bunch do. But none of them are running when I try to exit. In fact, for my test, I start the app, which loads Login Screen, I log in, it closes Login Screen and takes me to a form called "Switchboard", and I immediately click the "Exit" button. No other queries are running when I click...

Hear is what happen "On Load" Private Sub Form_Load() Call ClearAllAppts DoCmd.GoToControl "Combo114" Call SetSwitchboard1Screen End Sub Function ClearAllAppts() On Error GoTo ClearAllAppts_Err DoCmd.SetWarnings False If (DCount("user"...

"Login Screen" is the first form to load. "Login Screen"'s OnLoad Event goes like this: Private Sub Form_Load() Call SetSwitchboardScreen End Sub which calls Sub SetSwitchboardScreen() strSwitchboard = "Switchboard" End Sub I'm just initializing setting a global variable

I have an application called "MCLAP4". In the Access Options-Current Database-Application Options, I have the "Display Form:" set to "login screen". That is an existing form that works fine. On one of my forms, I have an "Exit" command button. The "On-Click" property of that form is the...

I have Access 2010 64-bit, and the V-Tools utility complains when I try to load it. What are my options? I really don't want to search through all 155 macros individually for object references

I need to do the following: 1. Open up a PDF file using Acrobat Reader 2. Select all data 3. Copy all data 4. Close the PDF file 5. Open up a preexisting text file 6. Select all data 7. Paste my copied data 9. Save the text file 10. Close the text file I can do steps 1, 5 just fine. The other...

I inherited an Access 2007 database that is using ODBC links to a back-end MySQL database to a remotely hosted site. During my discovery phase of this database I ran the "Object Dependencies" tool for a linked table and some of the results state "Missing Information: Out of Date". Can anyone...