Search results

re: Thankyou it worked with conditional formatting! is there a way to make the records that past todays date blink?

I have a form that loads a amongst other things a "due date" field from a table. If any due date is shown that is after todays date, i want it show red. I can make this work for 1 record, just need some help with the loop structure to test all "due date" records displayed. This is what i have...

Updated form I've used Djkarls code, and put it to use in a simple form i've attached. it will only allow paul to load a spreadsheet (paul_060407.xls) with todays date from c:\temp. Now the next part is for paul to enter some data in the form, i.e a new delivery date and comments and for him to...

re: Karl you are the best DJ dude! Many thanks :)

It works! hi ted, thats a great idea, and yes it works with the number string, i'm just struggling abit with a method to make access point to the c:\test directory and then point to find Paul* where *is the date code i.e Paul_050407. Basically, to make it simple i want access to import a file...

Hey all! need some help with an addition to the code below. Basically, when a user clicks the "open" button on the form the spreadsheet named paul.xls in C:\test is loaded into an Access table called "works" The bit of code works great, but i'd like to add the feature where the spreadsheet...