Search results

Hi Cronk, sorry about the lack of info (I'm new at vbs and forums). The "MatchingData" is MatchingData.xls aswell as the CList.xls. I've used this code (I decided to keep it simple. It refreshes data but shows CList, then closes it : CODE: Dim x Dim y Set y = Workbooks.Open...

Hi, I have a file "MatchingData" thats linked to another file "Clist" . What I'm looking for to open "MatchingData" and update from "Clist" on opening. I don't know if I can do this without opening "CList". I have a feeling that I may have to open the "CList" (Hidden), update,then close...

Thanks for that, it didn't work but found that : =Date() - (DatePart("w", Date(), 4, 1)) + 6 :) works! I'm using Access 2003 and just wounder if that has been the problem?

Hi Paul. Found this code on another thread. It gives the Monday of that week (starting Sunday). Can you modifiy this code? =Date() - (DatePart("w", Date(), 2, 1)-1)

Hi Paul, Run-time error '13': type mismatch

Sorry. Paul. closed the form and reopended it and it stops with and errror @ line 3 of the code: 'getMonDate = ...' . Am I missing a field in '(Optional inputDate)'?

Thanks.Got a date '01/01/1900'?

Thanks for the promp reply Paul. I've tried this, coped the code to Module1 and placed the '=Module1' in the text box Default Box but I get an error '#Name?'. Any suggestions?

Hi All, I'm a first time user and just gettinting to grips with Access so here it goes. I have a textbox in a form. What I want it to do is to display the following weeks Monday date. Sounds simple but requires you to know the Monday dates in advance :confused: Fisky