Search results

  1. P

    Need to run mailmerge from Access VBA

    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 =...
  2. P

    Need to run mailmerge from Access VBA

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

    Need to run mailmerge from Access VBA

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

    Need to run mailmerge from Access VBA

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

    Need to run mailmerge from Access VBA

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

    Need to run mailmerge from Access VBA

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

    Access Exit behaves differently depending on how it is run

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

    Access Exit behaves differently depending on how it is run

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

    Access Exit behaves differently depending on how it is run

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

    Access Exit behaves differently depending on how it is run

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

    Access Exit behaves differently depending on how it is run

    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"...
  12. P

    Access Exit behaves differently depending on how it is run

    "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
  13. P

    Access Exit behaves differently depending on how it is run

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

    Hello - How to Find & Replace object names within all Macros

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

    Copy from PDF and pasting to text file without using Sendkeys()

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

    Table "Missing Information:Out of Date" in Object Dependencies

    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...
Back
Top Bottom