Recent content by jamesdpmullan

There is a solution to this for tab controls. 1. Add a blank tab 2. setfocus to the blank tab 3. setfocus to the tab that is flickering hey presto, no flickering...

Hi, Thanks this works a treat. The add on "AND [YourDateField]<=Date()" doesn't seem to work though - an error appears, however, i only need to first section - thanks for your help

Apologies: Lets say we are in December 2015; I would expect to see full 2013,full 2014 and 2015 YTD. I get 2015 YTD, full 2014 but only December 2013. Thanks,

Hi, After some help if possible. I am trying to obtain data for the last two full years are current year. So, i need the query to show data in this case for all of 2014, 2015 and current YTD. The criteria below doesn't seem to work - any ideas?

OK - now i get not a valid file name error. I kind of expected that but the "\*.*" should find everything?? run time error 3055 not a valid file name

Hi, I am trying to allow the user to click a command button which will then attach all documents held within a specific folder to an attachment field in the database. I have managed to write the code to a specific file within a specific folder, however, i need to be able to attach all files...

Hi, Thanks - i gt the dir function working fine, its just the recursive search im struggling with

Laminate C of Cs contains around 10 subfolders. Any help appreciated.

How can i search the contents of [CofC] field in all subfolders within "\\as-tamworth-50\midlands.qa$\Tamworth\Laminate C of Cs\"

Hi, OK, so I know how to search for a file using the dir function, however, i need to search for a file from a main folder which may have several sub folders. I am having no luck so far - i understand there is a recursive search facility but im not sure how i can get this to work with what i...

Hi, Im 2 years into my database however this is really getting to me! :mad: Im trying to find and open a folder based on a text box. The problem is folder could be in many sub folders which is hold on our J:\ drive. To further complicate, the folder i am searching may not be exactly as the...

Hi I have been trying endlessly to get this working but to no avail. I have looked and used sample codes posted on the net. Im trying to get top 1 [route_list_code] per [works_order_number] I have attached three images: - Query as isQL code - Query with top n in criteria (pulling wrong...

Hi Thanks for your reply. I may not have explained myself correctly. I have added this subform (subform 1 - white boxes) which contains around 2 million records. What i am trying to do in affect is run an append query without the query, hence the loop. all im trying to do is move the data...

OK, i thought i had finally understood loops but this seems to be my downfall! Before i ask my question, i am where i am as this is the only way i can go about getting the data...I have attached an image of what i am trying to achieve so here goes: I need to add data from one subform to...

Chris, Your a genius, thanks. I cant believe i was trying to setup a loop when i could put a bit of code in the checkboxes control source! thanks James