Launch an application from Access

How can I launch an application from an Access 2003/XP/2000/97 database?
I just recently upgraded from Access 97 to 2007. Our department inherited and application program programmed in Access (user interface for extracting specific data) that was programmed by somebody else using lots of VBA code.

There are only 2 things suprisingly that are not functioning 100%. What I would like to know is what is the first command that happens when I double click the application to launch it. One issue I have is a form is launched that I always have to close out before I can use the application properly.

I want to see if I can either remove that pesky form from lauching or moving it down later in the sequence so I don't have to close it everytime.

Also, I placed the application and supporting files in the "Trusted Location", but I am still asked to "enable" the file before I can launch it.

I have about 3% knowlege of VBA programming BTW

Sponsored Links:

Related Topics

Very First Step In Launching an Application?
I just recently upgraded from Access 97 to 2007. Our department inherited and application program programmed in Access (user interface for extracting specific data) that was programmed by somebody else using lots of VBA code.

There are only 2 things suprisingly that are not functioning 100%. What I would like to know is what is the first command that happens when I double click the application to launch it. One issue I have is a form is launched that I always have to close out before I can use the application properly.

I want to see if I can either remove that pesky form from lauching or moving it down later in the sequence so I don't have to close it everytime.

Also, I placed the application and supporting files in the "Trusted Location", but I am still asked to "enable" the file before I can launch it.

I have about 3% knowlege of VBA programming BTW


Opening a file with default application
How does one launch for instance an Adobe Acrobat PDF file from within Access using VBA code?

I would like something that would also be used to launch all other known file types, such as TXT, JPG, DOC etc.


Package file creation
I am using Ms access 2.0 database management application. I have created tables, queries, modules, forms, reports, macros.
How to create setup.exe so that user can install and launch the application by clicking on setup.exe.


How to launch and application or file from a command button
I just created a new db using Microsoft's Contact List db as a template. I have modified the fields and imported all my data, now I just need to tweak it to make it more functional.

One thing I am looking at doing is putting command buttons on my forms to launch various apps, websites, and email templates. Seems simple enough but there isnt an option for these in the commmand button wizard so I assume some coding is involved


HOW DO I: Add or Launch Report from a Form?
I have an Access 2003 form and I have created a Report.
I cannot figure out how to put the Report or a way to launch it on my Form.

Also.
I need to pass a Date to the Report.
I have a Date Picker and Launch button on my Form.
I just can't find the control for a Report


Launch URL from code
I'd like to launch a URL from code and
paste the contents of the clipboard into
the field currently displaying the cursor.

I already have the text string on the
clipboard, I just can't seem to find any
methods that carry out a paste function.

I'm assuming I can Dim an application
object like IE and pass the URL


Open a pdf file from Access
I have an application that requires User help. I want to use PDF files for this purpose as the help information contains both text and graphics so I don't want to get into the Microsoft help thing which is too complex for this application.

Is there a best way to launch the User's default PDF viewer by pointing at the file and doing the equivalent of double-clicking


Create Windows menu toolbar in Access 2007
I'm building some forms for an Access 2007 database and need to try and find a way of having all these forms called from the same environment, so in other words have a top menu as youwould in Word or Excel or another standard Windows / Office application, so you could have File -> Print, Exit, or Edit -> Copy, Cut, Paste, or Clients -> Add New, Amend and so on.

There doesn't seem to be a way I can do this in Access 2007, is this true?

I don't want to have lots of completely independent forms in my application, ideally they should all exist and be placed in the same environment so that all the user has to do is click theicon to launch the application, and do everything they need to do from within that, using the navigation menu at the top.


launch access db using vbs
I use the following to start up our db

sDBFullPath = sPath & sFrontEnd
Set appAccess = CreateObject("Access.Application")
appAccess.OpenCurrentDatabase sDBFullPath
appAccess.visible = True
appAccess.DoCmd.RunCommand 10 'Maximize MS Access

This has always worked, but now some new users are being deployed using the runtime version rather than the full blown version. Is there a way to modify it so it works with runtime sinceruntime cannot CreateObject("Access.Application")?


Open Internet explorer and navigate to dropdown
I want to launch IE from MS Access and tab to a particular field and key in the value 990. I can launch IE, but when using sendkeys to tab to the particular dropdown list nothing happens.


Launch Notepad from Access
How can I launch Notepad from an Access 2003/XP/2000/97 database?


Scheduling a Acess Macro
Is there a way to schedule a MS Access Macro. I know I can use windows scheduler to launch MS Access on a set schedule, but how do I pinpoint to the macro I want to execute to run on that schedule. Do I need to launch MS Access, then create a macro that launches on startup that calls the other macro I am looking to schedule


Launch Microsoft Excel from Access
How can I launch Microsoft Excel from an Access 2003/XP/2000/97 database?


Launch Microsoft Word from Access
How can I launch Microsoft Word from an Access 2003/XP/2000/97 database?


Launch Access via phone call
A small business asked me about the possibilities to display caller info on screen.

If we for a moment forget about Microsofts Communication Server, has anyone knowledge of some s/w and h/w that can be piggy-backed onto a normal phone line (or ISDN) and either lauch a specific (Access) application, or, if already running, cause it to look up the caller info if existing


Making the launched form seperate from Access
I have this nice little application I've written, all the forms are contained in a single form, tabbed interface, all that.

I'm thinking about a netbook which has a vertical res of 768. My app would fit in this, except when it's contained in access with the top and bottom bars, menus, toolbars and all that.

Is there a way to make it launch in it's own window?


Ms Access database application
Can I create database application using only MS Access.
If yes please tell me tutorial how can I achieve this.
I like my application to have buttons,password fields for entering in the application etc .

If this is not possible creating application using only MS Access please tell me tutorial for achieving this using C++.

Please tutorials to have 20 pages


Launch Access Record from Email and attach email
We have numerous requests that come into our department via email. We want to quickly get them logged into our database with minimal effort and time. We can then go back andsystematically address them when we have time.

We have a vision:
1. Open email and realize it is a valid request
2. Hit a button in Outlook launch VBA code that:
3. Opens Access DB and creates next Quote number
4. Extracts and logs sender name, time and date
5. Grab that email and store it in the database as an attachment.

Can this be done and how?

I know we can use the data collection form in Access 2007+ but we were hoping for this faster way.


command buttons : only works after choosing another one first
I have a main form that has command buttons to launch other things. The last one I created doesnt work until I select one of the other buttons and launch something. I close and then the button that wont work does. It only works after choosing another one first. Is there someone out there that has had this happen? Im using access 2003 and xp-pro for an O/S.


Find tables
I was asked to improve an existing old Access application. I was given no documentation at all. All I have is the icon which starts the application which runs with lots of flaws. Now, once in the application I don't have the options neither the menus to see and modify tables, queries,forms etc. How can anyone get access to all this on a running application