Recent content by ron2

in VBA language .Quit means close a instance of the whole application (Word) that is currently running the answer lies either with my initial code example or with the replies this thread is now closed

not all my client(s) machines are using office 2007+ so i usually design access with access 2000 and upgrade as i go to each machine last year i found that my custom menubars were not showing on new access 2007 machines so i found a way of getting them back using the 'current database'...

the xml code below is what i've got td to replace the ribbon with custom ribbon (the ribbon xml is in a system table named UsysRibbons and ribbon is chosen via the current database\properties ribbon cbo) the button works fine - it just calls a macro that opens a table my trouble is with the...

Regarding status bar: Have u seen the status bar checkbox in the options menu. click the round office links icon (extreme top left of screen) then Access options (bottom of dialog) button then Current database then on right you can see the check box for "Display Status bar" this switches on/off...

this works but with one problem ~ I am also new to Access 2007 but this was 1st thing I found out about Heres what you do: Click the Office link icon ( extreme top left of screen = round icon) Click Access Options (button on bottom of dialog) Click Current database Uncheck Navigation\Display...

yeh ~there they have only used .Close method and not .Quit (see the replies) My .Quit should close the Application ,this includes closing all its .docs (so you don't need to .Close them separately) I think my issue is that it must be skipping the .Quit for some reason on my clients machine>...

thanks for your interest my code creates new instances of Word then always does .Quit at end of each process it 1st bungs reports into a template(.doc) Saves as new .Doc and Quits template then either Opens and is Visible, or Prints then Quits. I find that when testing I get no problems, but my...

thanks for that will try

I'm outputting several report from Access >> Word but find my client reporting that the template I insert them into is not closing but reporting locking. So I've devised this code but find it usually only quits one instance of Word at a time unless I step through the code when it closes all. (I...

Dsum Have you investigated using DCount function in report module You could use this twice to get both the Yes totals from the reports table/query Then when you've got the two numbers eg 120, 20 place in varibles a and b You then add to get a total these eg varible x = a + b Using these 3...

Anyone know easiest way to get a report faxed from an access pc to a remote fax machine. Do my clients have to buy software eg Winfax to do this. I have in past years installed Windows fax service (winxp) but that proved not to export the report to the 'printer' so twas abandend. My client has...

My client has 14 workstations 1 has office 2000, 5 have office 2002, 8 have office 2003 Of the 5 that have office 2002 (XP) 3 have Publisher installed Recently needed to introduce code to change format of some words in a Word document all well except with the workstations with OfficeXP and...