Search results

llkhoutx I'm sorry but I'm even more confused with you refering to forms in the OnFormat when it is between reports. These reoprts are created direct from queries with no form in between. Report 1 is called RptOvertime Report 2 is called RptSalary I have created a total in the report footer...

llkhoutx I'm sorry to sound a bit vague but how do I do this? My total in my report footer is called ID1Fynney - how do I enter this into the OnFormat part of my details?:confused:

llkhoutx Thanks for your reply. Do you mean in the OnFormat part of my report footer, where my text box is that I am wanting to pull over?

Rich Thanks that's worked a treat.

Rich MyDay is displaying Sat as its format is ddd. I have tried changing 7 to "Sat" in my code but it still doesn't like it. Any ideas?

llkhoutx & Pat Thanks for you reply, however this is where I have enter my code which is why I don't understand why it is not working. Any ideas?

Hi All I have a problem with some coding I have entered into a report I have created. My report comprises of 3 fields - MyDate, MyDay and Overtime. I want the report to show Saturdays in red, therefore I have entered the following code into the on format part of my detail part of my report: -...

Hi All I have created two reports with numerous calculated totals in the report footers. Is it possible for me to pull a total over from one report to the other? I have tried creating a text box and in its control source entering =[Rpt The name of my report].[Report]![The name of my text box]...

Thanks Pat that's worked a treat. Cheers :)

Mile-O-Phile This works well but when I try and filter on the week number it only filters on the actual date. How can I prevent this so that my query displays records for all the dates in that week number? :confused:

Hi All I have a query which is based on a table. One of my fields in my table is called MyDate. From this date field I want to create another field in my query to display the week number. Is this possible? Please advise.

Namliam I have just had another thought. I want to add another filter to my subform to choose the Years. Therefore I have created another option group called Filter Option Year. In here, at present, I have All Years, 2002, 2003, 2004, 2005. I want to be able to first choose what year I...

I didn't mean unfortunately as it sounds. It's just a figure of speach. :)

Sorry! - If you don't ask how do you get to know? ha! :D Now it is getting a bit personal! ha! - only joking. :o Unfortunately I'm happily married, no kids, 5 horses and 1 dog instead so no time for kids. Speak to you soon. :cool:

Namliam Bit of a long trip for you! just to 'show me the ropes'. Are you a tutor for Access then? I am picking more bits up from this site that any courses I've been on. Hey! Just noticed we are the same age! Anyway thanks for your help. Cheers.

Namliam Thanks for looking at this. It never occured to me that this was not a string and to try and take the ' ' off. I am quite new to VBA so am only just getting to know bits and bobs. I have also changed my code to what you have suggested. Again with me being quite new to this I always...

Namliam I have attached a quick example of my probs. I'd appreciate it if you or anybody else could have a quick look and advise your thoughts. Cheers. :(

Namliam I'm confused also. Would it help if I sent you an small example?

Namliam Good to hear from you and thanks for your reply, however its still no good. It still displays the same error message. I didn't mention before but I can't even get this to work in my subform itself as well as my main form. That's why I can't think of it being because I have other...

Hi All I am still struggling with the above - can anybody help. Could this be because I have already created an option group with filter options in the same form, however this is on a seperate tab control. Please, please advise.