Search results for query: *

dhookom you're the MAN, thanks a lot, problem solved Richard

didn't think of that and might be the issue here, thanks for pointing that out! Richard

Hey dhookom,my weeks on the reports HAVE to start on Monday, that's why I calculate for monday starts. Is there an easy way to tell access that my weeks start on Monday in general? Thanks, I appreciate your advice, Richard

hey thanks for the quick reply, It will not show the 1st of april week and then later also not the first of june and another one! It should show me a whole week with only the 1st of april on the sunday. The double dates you see, do that for the other months, I just don't understand why it does...

Hello, I'm messing around with Dhookom's calendar style report and it works like a charm, BUT.... i'm missing some data in some weeks. This is the DateAdd line I use WeekOf: DateAdd("d",-Weekday([RotationDate])+2,[RotationDate]) , I basically want all first days of the week (week starting on...

ain't that the truth! I can print it normal, but it just takes too long and is totally unnecessary. Basically trying to save a buck or two while printing all these "samples" while coding! Richard

Let me correct my statement (again, sorry) It does print color, because 1 of my form headers is color and it does print that. What it does not print is the control fills (backcolor) I formatted. Thanks, Richard

Hey, yes I checked that several times, to no help though. I am printing this on a Canon IP3000 thank you, Richard

I have a report with a schedule of Call duties and use colors to distinguise teams! If I print this (13) page document it takes forever on my inkjet and I really don't need the "Nice" normal print-out. However if I print in Draft speed on my color inkjet it will just give me graytones for the...

You know Remou, you are right I should explain it better and I didn't mean 4-5 subforms but just 1. If I do it like the report, I can show 1 week on my form and make changes like normal, but now I want to show a several weeks, but will start with only 1 extra, with a subform that is. How can I...

Hey Remou, It gets updated through the main Form and Bound records! I got a hack right now that seems to work. I give the subform the focus and call the procedure from the gotfocus event! It isn't pretty, but it works Richard

Hey Remou, thank you for the reaction I just can't figure out how to bind the subform to the next record, it would work and I tried it, but I can't seem to figure it out. How do I show 5 different records using 4 or 5 subforms? Thanks Richard

Anybody?

Can anybody tell me what events are triggered when you update the data in a subform through the main form. I click on a date on a DtPicker control which updates the data in the subform to the right information. Now however I want to format the fields using code!! BUT I CANNOT find an event...

I guess I gave my own answer, I just put it in a module and call it, works like a charm! Sorry, Richard

Hey, I use code to format the color of a control depending on what dat is in it. Currently it looks like this: If DLookup("[Team]", "EmployeeLetters", "[LastName] = '" & Me!Mo & "'") = "1" Then Me.Mo.BackColor = T1Color If DLookup("[Team]", "EmployeeLetters", "[LastName] = '" & Me!Tu & "'") =...

I did the records wrong, the way I do it in the other post is easy enough, daaaa This is the situation: "record1""record2"".........etc. Call 1: Person1 Person2 ..........etc. Call 2: Person3 Person4 ..........etc. Call 3: ................ .etc....

Hello, Is it possible to view more than 1 record in a single form without using subforms? I have made a scheduling database and every record has a full week of call duties, in my case however a full schedule consists of 5 records! I can show this easily in a report, but can't seem to find how...

Hello, I set the format part up like this, but because of the lengthy search strings it takes the report a full 19 seconds to calculate the format on me computer (i can't imagine having a P2 do this). Is there a quicker way of doing this? Thank you, Richard Here is the code:

I'm just throwing this in, maybe you can export the html part as an html file and then show that file in a subreport. Just thinking with you, it's an interesting issue. Richard