My form contains a field "EMAIL", data type Hyperlink. I want to click on this field and have the following event take place: 1.Open Outlook Express, 2. Create Mail, 3. Automatically enter this "EMAIL" field as the send to address. How do I accomplish this? Thanks, Bill
I use the Access Packaging Wizard to create the install program for my applications. It automatically installs Access Runtime on the local computer. I have a situation where I need to install Runtime on a server. Where can I get an installation program that will allow me to install Access...
My application uses many action queries that run as an Event Procedure. Following is one example:
DoCmd.OpenQuery "AutoQDate", acViewDesign, acEdit
DoCmd.SetWarnings False
DoCmd.RunCommand acCmdRun
DoCmd.Close acQuery, "AutoQDate"
Although I have reduced...
Upon entering my form "Reservation Look UP" I have the macro go to the "LastName" Field and then go to a command button that opens the Access "Find and Replace". I really want the "Find and Replace" form to appear automatically on entering my form...
With action buttons you are able to go to an address. In this case I want to play a sound file that speaks (instructions) about the field that has just been entered. In properties/Event/On Enter. I want to run a macro that will play the sound file.
My question is: what are the macro actions...
I called Microsoft Support about having the ability to use the tools contained in an mdb or mde to sort a table or query in the Run Time version. It can be done. They want me to pull out my credit card and spend $250.00. Can anyone help me with this?
I had this problem once before and I just can't remember exactly how to fix it. I believe I need to run a utility that is accessed in the forms design view... Can anyone help me. Bill
I want the YRID field to be updated to the current year Year(Date) if the field is blank. If the field has been filled in with let's say next year's date, then I want it to be unchanged.
My formula is as follows:
Private Sub VehicleID_Exit(Cancel As Integer)
If Forms!ORPInsForm!YrID > 1...
My Form name is ORPInsForm. The field I am working with is called YRID. On exiting my field named VehicleID the event procedure occurs:
Private Sub VehicleID_Exit(Cancel As Integer)
YrID = Year(Date)
End Sub
so the result is 2001
and that works.
However, I want to be able over-write the...
In addition to securing my database with a password, I need the user to enter a password (let's say each month) in order to gain access to the application. I will be billing my customer's each month for the application. If they do not pay, I must have the ability to shut down the application...
I need to Create a Macro in Access that will go to an Excel file(shared) that is already open. This file is Linked to my Access database. I need to have the macro go to this file and save it. This action will update the linked table in Access. What string of macro commands should I use?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.