Recent content by atticus1802

Thank you so much. That worked you are a genius

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

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

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

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

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

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

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

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

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

Any update on this?

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

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

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

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