Recent content by ron2

  1. R

    VBA~how to quit all Word applications

    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
  2. R

    1st menu office 2007

    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'...
  3. R

    access 2007 custom ribbon, combo values

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

    Access 2007 property sheet not visible and status bar gone

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

    Access 2007 Ribbon- hiding groups

    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...
  6. R

    VBA~how to quit all Word applications

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

    VBA~how to quit all Word applications

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

    VBA~how to quit all Word applications

    thanks for that will try
  9. R

    VBA~how to quit all Word applications

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

    Sum totals in a report

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

    Pc >> Fax

    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...
  12. R

    officexp Acces/Word vba

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