Search results

Hey Steve after a lot of digging I found a solution (don't remember who to thank) but thought I’d share the answer. Added "AppActivate" at the end. Set oapp = CreateObject(Class:="Word.Application") oapp.Visible = True oapp.Documents.Open FileName:=LWordDoc...

Me Again. I wrote another button with the code "msgboxxx ‘here’" which of course blows up. But, after it blows up and I close the debugger, the original code calling MS Word works fine. Got me beat.

Rats! It still doesn’t like me. I did a cut/paste and still no luck. The debugger stops on the "SetForegroundWindow oApp.ActiveWindow.hwnd", and this time the program stops at the dim "Dim oApp As Word.Application" which, like you said, could be a version thing. The Microsoft Word Object...

Hey Steve, No Joy. This is my modified code: Option Compare Database Private Declare Function SetForegroundWindow Lib "user32" (ByVal hwnd As Long) As Long . . (the command button - btnTest). Private Sub btnTest_Click() Set oApp = CreateObject(Class:="Word.Application")...

Hey guys I have an INTERMITTENT problem. I am calling MS Word from a form command button and sometimes Word opens correctly and opens on top of Access, other times it activates on the taskbar but stays behind the Access form, and I have to click on the Taskbar to open the doc. I have no idea...

Hey hey hey, We're good. I'm going to let the users just do the manual change - not an issue. I was just looking to see if I missed something. Thanx for you help. Bill :-)

Hey hey, Oh if it were that simple. Your loop code works fine, but it just prints the same records over and over. I am using a DoCmd.PrintOut acPrintAll, x, x in the loop and there seems to be no way to increment the pages being printed - x(from), x(to)count. I have a much less elegant -...

Hey hey, I am using MS Access 2000 with ADO. It is for an annual members information letter and each member has a unique number that is used as the stLinkCriteria when opening the form. I am using a form: frmEnvelopes, with the RecordSource pointed to a query: qryaddresses. I have a current...

Hey guys, Here’s the situation: I need to print @100 envelopes, but the printer physically only holds 10 envelopes at a time, then has to be reloaded, print 10, reload, print 10 more and so on until EOF. I need to have a Msgbox for each reload to tell the users to reload the printer. I need a...

Hey hey hey, Will do and thanks again for the help. Bill

Me again. Continuation of same problem. I need to change the default label number. By default it is 2160 and I need to change it to 8160 (for now). The users don't know the form number that is loaded, they just push the button. Is there any reference articles on the syntax of how this all...

Hey hey hey, Nope, I didn't have it set. I did set it as you suggested and it WORKS! Thank you for your help. (Now could you help me train my users???) Bill :-)

Thanx for the quick reply. I cut the code exactly as below. Word opens but I get an "Object Required" error msg when the last line executes. Dim oApp As Object Set oApp = CreateObject(Class:="Word.Application") oApp.Visible = True oApp.Documents.Add...

Hey hey hey, Is it possible to directly open the MS Word toolbar from Access?? I would like to write the VBA code so when my user presses the control button it opens Word on the Tool/Envelopes and Labels toolbar pop-up - They need to print a single label. The generic code would read...