Recent content by pdauction

Apologies, I have now fixed this with the following code; SELECT * FROM 1st_Lives UNION ALL SELECT * FROM 2nd_Lives;

Hi, I have googled this but can't seem to find a solution. Will be really grateful if someone could help on this. I have a Union query as follows; SELECT ALL * FROM 1st_Lives UNION SELECT ALL * FROM 2nd_Lives; 1st Lives has 465,414 records and 2nd Lives has 151,852 records. When I run...

Cheers for the debugging technique, I'll remember that as I normally use a clumsy Msgbox. Also thanks for the tip regarding spaces - I have come across problems before with this and was tempted to rename my field, again something I need to remember for the future. My code does seem to work...

jdraw, Thanks fior getting back, that did seem to be my sticking point. I have now managed to solve this (I think); Dim mmm As String, yyyy As String Dim rstGetMonthEndDate As Recordset Dim mthenddte As Date 'Get Month End Date Set rstGetMonthEndDate =...

Hi, I'm thinking this is obvious so apologies if it is (I have spent quite some time searching for the answer but can't seem to find it). I have a parameters table that has in it one field called Month End date there is only one record which contains the month end date (user enters this via...

Yep my bad, apologies.

Firstly, thanks very much for spending time to understand my request. Secondly, thanks for answering my query, the solution works great. I just changed the policy number bit as its actually numeric and changed the comparison operator from > to <. Solution below; If DCount("*", "[Life...

Hi, I hope this is as clear as possible; I have a multi tab form called 'Life Claims Form' that has a date on it called date of death from a table called 'Life Claim details'. On a separate Tab on the same form I have a subform called 'Life Benefit Subform new' that has a field called...

Hi, I'm new to the forum. I'm from Lytham in England and would class myself as fairly proficient in Excel VBA but am relatively new to Access VBA and am trying to get to grips with it all...