Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: BillMc
  • Content: Threads
  • Order by date
  1. BillMc

    Click on E-mail address and Create Mail

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

    Create Desktop ShortCut with Packaging Wizard

    I would like the Access Packaging Wizard to create a desktop shortcut for my application. How can this be accomplished? Thanks, Bill
  3. BillMc

    Installing Access Runtime on a Server

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

    Hide Query on Run command

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

    Find and Replace form open on entering the form

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

    Go to hyperlink address upon entering field (event)?

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

    Sort/Filter in datasheet application running in Access Run Time ?

    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?
  8. BillMc

    Cannot create an .mde ???

    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
  9. BillMc

    Invalid use of Property: Please take a look

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

    Error in Code: Compile error. Please take a look.

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

    Password that is Date Sensitive?

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

    Access2K .MDB will not convert to .MDE

    My Access 2000 database will not convert to a .mde. Anyone know why? BillMc
  13. BillMc

    Create a Macro that will link to an open excel file

    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?

Part and Inventory Search

Back
Top