Search results

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

ok, so nearly there - check56 is true when linecompletedims = 0 loops through ok. only thing is if all linecompletedims = -1 then once it gets to end of recordset i get an error message saying 'No current record' With Me.RecordsetClone .MoveFirst Do While Not .EOF If...

Hi Thanks - i tried the code you supplied which does go through the loop but when there is a value of 0 in one of the linecompletedims check box, check56 value does not change to true (-1). I tried changing the me.chec56.value = -1 to a msgbox but this does not appear either. Any thoughts...

Hi, Im trying to create a loop that goes through each record in a continuous form which then stops when a checkbox value = 0. At this point another checkbox value = -1 in the header. If all records have a value of -1 then the loop stops at the end of the recordset. This is the code i have...

Hi, not sure if this helps however double click on the lines within the relationship, select Join Type followed by Include ALL records from (A) and those records from (b) where the joined fields are equal Hope this helps

Hi I have created an advanced database which a site of 70 odd people use however im trying to create something which i believe should be relatively easy but appears i may be trying to hard to make it work! I have attached a department matrix as an example of what it currently looks like...