Recent content by ryand09

Thanks for getting back to me. I'm getting an error that the files cannot be found, if I rename them and take out the . (dots's) it works. I think I just need some sort of mask, but I can't figure it right now??? Thanks.

Hello I've got a number of files exported from other systems that I need to import back into Access, the files have full stops in the file name. How can I get round these issues and Import. e.g. file names ... 2016.01.14.myFile.csv 2015.12.01. myFIle.txt.01_12_2014_14_47.csv Thanks in...

Hello I’m looping through a list box returning the selected item, but is there a way to return the value of other columns in the list as I loop through the rows? For Each ItemIndex In Me.myList.ItemsSelected lngID = Me.myList.ItemData(ItemIndex) ‘Working okay lngEmp =...

Once again, thanks for the follow up. Hopefully this explanation is a little clearer … I’m trying to set dynamically the back color of a control (called Status_ID) on a continuous form. The control can have a number of values, Completed, Failed etc. Each value has a corresponding colour...

sneuberg Thanks for getting back to me. I left this for a couple of days in the hope, I would see something. but I'm totally stumped here. I've uploaded the tables and a test form. I've put the field on the form twice. Once with Field Value Is conditioning and one with (an attempted)...

Hello I’m trying to set the Backcolor of a control using a Conditional Formatting Expression. In the expression, the idea is to set the Backcolor based on a colour value in another table I’ve got the following code in the expression…...