Recent content by atticus1802

  1. A

    Loop same record

    Thank you so much. That worked you are a genius
  2. A

    Loop same record

    Sorry about the wait in a reply. I really aprreciate your help. I have attached a sample of my database and removed information. Some buttons may not work. Basically I have populated some test data into the form "frm_Access_Entry" the button "Send Mail Merge" should populate the information...
  3. A

    Loop same record

    I have tried this as Address = rs!frmDatasheet!txt_Email_Address AND Address = rs!txt_Email_Address aswell as Address = rs.frmDatasheet!txt_Email_Address AND Address = rs.txt_Email_Address No luck I get the same error I get Run Time error 3265, "Item not found in this collection"...
  4. A

    Loop same record

    Address is a string as shownbelow:- Dim Address As String Address = frmDatasheet!txt_Email_Address
  5. A

    Loop same record

    Thank you for the quick reply. I assumed it was something like this. However if I user rs!address I get Run Time error 3265, "Item not found in this collection". My VB is not amazing so assume it is because rs! is not a string. I have tried referencing the field names as rs! however this does...
  6. A

    Loop same record

    Good Evening, I have been trying to get this work for days. I have tried various pieces of code but this is the closest I can get to it working. I have a piece of code which populates an email with values from a datasheet. The datasheet contains multiple records however when the code is run I...
  7. A

    OpenForm to record in a Subform

    Good Evening, I have looked everywhere for an answer to this so I am hoping I haven't missed this. I want to link to a specific record in a subform. I originally used the below piece of VBA code, which looked at the "Main_Contact" record from my main form which is named "frmProject", and...
  8. A

    Popup Reminder

    Sorry about the late reply unfortunatly due to other work load this comes and goes as I have time. I have tried using the 'or' function however this doesnt work and neither will show up in the query
  9. A

    Popup Reminder

    Good Morning I have posted on here numerous times and would like to thank everyone for their help. I have had an ongoing project at work to create a database showing employee details. This grew and became ever more complicated for a begineer who had never used access before. Each employee now...
  10. A

    Automatically creating a outlook task reminder 3 days before date entered in database

    Sorry by any update I meant was there any thoughts on this?
  11. A

    Multiple Reminders

    Apologises have been very busy. Basically I want to run a query which filters data accross multiple tables. Each field being searched is a date, and I would like the data to be filtered within a certain date range say one week either side of the date in the field. I have achieved this when...
  12. A

    Multiple Reminders

    Morning I have been working on a database over the course of a year for work. I change it every now and again to add extra information to collate all our work in one central place. This includes reminders for first aid training, fire marshall training security passes etc. Originally I was...
  13. A

    Automatically creating a outlook task reminder 3 days before date entered in database

    This sounds exactly what I am trying to achieve. However I am looking to get it to do this for mutiple fields. For example we have a securty pass expiry date, wire warden training date, first aider etc. Where would it be a case of putting this as an event procedure for each field which has a...
  14. A

    Outlook expirary date pop up to outlook

    Hello, I wonder if anyone could help me or suggest a way to do this. I have a large database with information on each employee in my company. This contains information on training, desks equipment, securty access etc. My question is in each table there are various expirary dates. I have...
Back
Top Bottom