Search results

  1. M

    Updating every records value for a field.

    I am looking for a way to move monthly data between columns, as I am only required to store information for the past 5 months. CARRY OVER - Month 1 - Month 2 - Month 3 - Month 4 - Month 5 when I press a button I would like for month 5's information to populate the month 4 column, month 4's...
  2. M

    Browse for attachment to email

    Hello, I have been able to send emails and send attachments if the path is static, but I am looking to create a browse function to attach items to the email. So far my code is... for the selection of files: Dim f As Office.FileDialog Set f =...
  3. M

    Data Entry Form if Record Does Not Exist

    Good Morning, I was wondering if anyone could help me out with a small problem I am having. Currently I have a form that holds all information for each "Club". When a button on this form is clicked a pop-up form opens showing the "checklist" for each club, which is stored on a separate table...
  4. M

    Opening Hyperlink dependant on field data

    I am attempting to open a website hyperlink, some of the fields contain https:// and some of them dont. Private Sub Facebookbut_Click() Dim Hyper As String If InStr([TEAMFacebook], "https") Then Hyper = Me.TEAMFacebook Else Hyper = ("https://www.facebook.com/" &...
  5. M

    Attach Multiple items to outlook email

    Hello, I am currently in the process of creating a form that will allow you to enter details for an email sent, select a number of documents from a list box and then open the mail message pre-written with attachments. The attachments reside in a list box currently, and I am attempting to use a...
  6. M

    Filter subform by nth column in combobox

    Hello, I am currently having trouble filtering my subform by a different column than the bound column set in properties. the comobobox shows the ID for the last email sent, with the combobox drop down showing the name and date of email when dropped down. I have tried 2 things and neither...
  7. M

    Change a field for all records in a filtered subform.

    Hello, I am currently developing a crude Contact manager database and need a quick way of entering data into a selection of records (around 1000 at a time). At the moment I am manually going through all records and changing the "DateLastEmail" field manually, which can be very tiring. I was...
  8. M

    List box on pop up form

    Hello, I currently have a list box that filters though a list of records on the main form using a text box. I have got the search function working, and the list box filters correctly, the problem I am having is that I need to be able to double click the record and have that record show on the...
  9. M

    Clearing Worksheet before export of filtered query data

    I am currently working on a form that exports a query that changes after a user set filter is applied, and am able to get the filter to apply and the query to export. The problem I am having is that the worksheet that the query is copied into retains all previous data, and if the earlier query...
  10. M

    Send Form Fields to Word Template

    Hello! I have been searching the internet and racking my brain, but I am fairly new to VB coding so I might just be being really stupid and I am truly sorry if this has been asked and answered before, but I did a search and couldn't find much that related to my problem... I have a form with...
Top Bottom