Search results

  1. I

    Pass ID Of Row In Click Event

    @arnelgp in another thread of mine gave me a function that would open a form filtered to show only the specific ID information for the row I clicked on my form. My database became corrupted and I had to re-create it and now it is not working. In the double click event of the field on my form I...
  2. I

    Double Click Record In Form

    I have a form set to continuous view. I was wondering if there is a way that a user can double click a specific row in the form and on the double click launch a separate form that shows all of the user_notes for the clicked record?
  3. I

    VBA To Reply All Email

    I have seen lots of threads on how to create an email with access vba, but I want to pass an email address to a 'search' function and scan my "Sent" mail in outlook for the most recent email to the email address. Once found, I want to "Reply All" the email (so that it sends to the original...
  4. I

    VBA To Create Email

    Hi all - I have a Customers table that has roughly 4,000 rows in it (and growing). I am attempting to automate some things that are currently manually done. Below is the process.. 1) Query Table1 For all customers whose ContactFUTimeFrame is current month 2) Create Two groups of the current...
  5. I

    Validation For Form

    Hi - I have a form that has the below controls 2 combo boxes 1 listbox 2 text boxes 1 button What is the best way to ensure that when the button is pressed all controls have input/selection made?
  6. I

    Create Email Draft With All Attachments From Directory

    Hi - I am attempting to create an email draft with all files from a directory as attachments. I attempted to utlize this handy script I found online, but I am getting an error of: Run-time error '9': Subscript out of range on this line For i = LBound(allFiles) To UBound(allFiles) And this...
  7. I

    Hi

    Hello all from good ole Georgia, USA!!! DAWG Country here :)
Top Bottom