Search results

  1. C

    How to reference a button that calls a macro?

    I have a macro that opens a form. The macro then sets a value in that form. I would like for that value to be the caption value of the button pressed. Forms![frm_Menu]![button].Caption I want to know what I need to put in that button field to have it reference the button that the macro is...
  2. C

    Stop Macro if any required fields are blank

    I have macros that will close the current form and open another, but when there are required fields not filled in then problems arise. Is there anyway to first have the macro check to see that all required fields have a value, and if they do then continue on with the current process. If there...
  3. C

    Using Date/Time equation to alert users of overdue updates

    This is what I am trying to implement: I have a form for priority work orders, it has fields that automatically update the time when modified. On priority 1 work orders I want to make it so that if the time modified is 1 hour past the current time(and priority 2 is 2 hours past), then either...
  4. C

    Want query critera to match any part of a string

    I have a query where the criteria is entered in a form through the user. Lets say that I have the fields of Money, Honey, Pickles, Phone. I would like the user to be able to type in a string such as "one" and have it return money, honey and phone. (since they all contain that string) Or if the...
  5. C

    Sending an Email through Access 2007

    I am trying to use the SendObject macro to send a record out using Outlook 2007. Eventually I would like to make it alot more complex, but for now I would be happy with it just sending the email. So when I click the button that has the SendObject macro I get this message: My Outlook client...
  6. C

    Need help with a query in a form

    I am trying to get a form that has a table in it that the user can search through and also be able to click on any of the entries to open it up in its own form for editing. This seems like it should be pretty easy, but it is giving me a little trouble. I am thinking that this should be a form...
Back
Top Bottom