Recent content by ANProudfoot

I can find no differences between the two sql statements. I have tried recreating the query, and even recreating the entire Database, which did resolve an other I had, but to still no joy. Any other suggestions any one? Regards Adrian

Hi Gasman, I have tried what you suggested and surprise surprise when I run the new query it comes up with no records? Unhiding the hidden forms has no affect - See ANP6 See ANP7 for the results of the debug line in the new query in sql view, ANP8 shows it in design view, And ANP9 shows it in...

Gasman, Thank you for the reply. the difference in the CompanyID is one is the UniqueID and the other is the Description. I have tried the moving of the selection criteria as suggested and even removed all the selection criteria from the query and still get the same issue? I have also...

Hi, Version of Access = 2010, Version of Windows = Win7. I have a Form showing results of a set of queries depending on the Arguments passed to the form. In the Form_Load event procedure I alter the .RecordSource property to the required query and Requery, Refresh the Form. However, on...

Hi, I live in surrey, in the South East of England. I have been using MS Access for well over 15 years now. I use it both personally to run my own business as well as commercially. I am a certified MS Office Access Specialist, however, everybody needs a little hand every now and then.