Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

pop open ms access using script or batch file

Discussion in 'Information Technology' started by gregor suttie, Jul 28, 2006.

  1. gregor suttie

    gregor suttie
    Expand Collapse

  2. Loading...

    Similar Threads Forum Date
    Sikhs Declining As A Percentage Of India's Population Hard Talk Apr 18, 2016
    Christianity How Pope Francis made me better appreciate my Sikh faith (COMMENTARY) Interfaith Dialogues Sep 27, 2015
    Declining Sikh population percentage in Punjab Sikh Sikhi Sikhism Aug 26, 2015
    Christianity Pope Francis Dines in the Vatican Cafeteria, Denounces the Mafia in Naples Interfaith Dialogues Jul 27, 2014
    Christianity Pope Francis admits reveals Bible metaphors - in agreement with Sikhi! Interfaith Dialogues Jan 3, 2014

  3. Douglas J. Steele

    Douglas J. Steele
    Expand Collapse

    See that big white space underneath the subject? That's where you're
    supposed to put details of what you're looking for, not strictly write a
    cryptic subject!

    Doug Steele, Microsoft Access MVP
    (no private e-mails, please)

    "gregor suttie" <gregor suttie@discussions.microsoft.com> wrote in message
  4. Albert D.Kallal

    Albert D.Kallal
    Expand Collapse

    Ok...I'll bite...despite a big white empty area!!!

    If you just need to start ms-access, or a given "file" of you choice, then a
    batch file is fine

    start "c:\data\myWordDoc.Doc"


    start "c:\data\mydata.mdb"

    The above command at the windows prompt will thus launch the file of your
    choice as if you had clicked on it....

    However, if you need more control, or want to run a particular piece of
    code, and then shutdown ms-access, then likely a windows script would be a
    more appropriate.


    dim accessApp

    msgbox "Click ok to run batch job",64

    set accessApp = createObject("Access.Application")

    accessApp.OpenCurrentDataBase("C:\Documents and Settings\Albert\My

    accessApp.Run "TimeUpDate"


    set accessApp = nothing

    msgbox "Job complete", 64

    The above would launch ms-access, and then run/execute a pub sub called
    TimeUpDate in a standard module. The application is then quit.

    So, a windows script is somewhat more flexibility, as you don't have to
    'quit' the application in code after you run a routine of your choice....

    If you just need to launch a particular .doc, pdf, or in your case mdb
    file...use the "start" command at the windows prompt, or a .bat file. If you
    need the 2nd case where you want to run some code inside of the mdb..and
    then quit...use the 2nd windows script example. It is not clear which
    scenario you need...but, then again, that comes back to you not using the
    big white space to further give details about what you need...(so, I was
    either forced to skip your question, or write a *longer* post guessing as to
    what/which scenario you are looking for).

    Albert D. Kallal (Access MVP)
    Edmonton, Alberta Canada
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     

Share This Page