Search results

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

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

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