Recent content by newbie786

Hi Bob_fitz The fields in JulyLinked are Day and month, I have tried to change them but still not working

Hi I cant seem to get my head round this, im trying to lookup 2 fields in a xls file with 2 criteria's in my dlookup, this is what my code looks like for lookup of 1 field; =Dlookup("morning","JulyLinked',"day=" & day(date())) this works for looking up the day field in the linked table...

Managed to sort it with the timing issue thanks :D

How do I refresh the form every 30 seconds? Would this not be to do with the timeinterval setting?

I was thinking, when the time has reached for example [morning] i would like the afternoon to become bold look at the code in Conditional Formatting

Hi, Yeah I was thinking I would have to put them all in one file and have them lookup the date corresponding to todays date. Im also looking to update the afternoon field and tea field before the time has lapsed, I have used CF on this but not sure why it doesnt automatically update. any ideas?

So I have attached my code with the excel link, and it does show the link with the excel file and im looking to know how I would deal with the update of times when the time lapsed for the month how would I be able to link this to the following spreadsheet on the excel file. At the moment I only...

Hi, I m looking to import data from an excel file but from different worksheets on the same excel file. I can import the data from a specific worksheet, but I would like to know how to lookup a different worksheet on the same xls document. thanks