Search results

Is there an easy way of doing alternating colors in the details section of a report. This isn't critical, it would just be nice and if there is an easy way of doing, that would be great! -Stoss

If I get time I will look into that but for now you helped me get it up and running, THANKS AGAIN! -Stoss

Thank you so much!!!! I had to put in Nz() function for each because some of the values are Null but it works perfectly now. *Bows to vbaInet* When you said do the calculation in the record source, did you mean in the query itself? If so, this is where I was having problems due to the fact...

Hello, I have a crosstab query that I populate a report with. In the details section, I have 12 textboxes (which are months). I want to sum up all those boxes for each detail (i.e. each row). I was thinking that having an additional text box with (the following code in that textbox control...

Hmm, I must be missing something. I created a query but it still does the same thing. If I put an employee off of active, it doesn't show their name in older records. -Stoss

Hello all, I was just wondering how the best way to handle this situation.... I have a combo box that has employee information (i.e. Name) and this is used when creating a new Purchase Order, and shows their name when selecting previous records. The question that I have is what is the best...

Wow, I can't believe it but it works!!!!!!!!!!!! Almost on the first try too! Here is the code that I finally settled on 'Sets Priority 2 Priorities ElseIf strPriority = "Priority 2 (7-Days)" Then If (OpenDate + 7) > Date Then If fromQuery = True Then...

Thanks so much for your advice. I think that I will go with the boolean route. I will have to go that route because of all the different type of calculations and I have a lot of extra date manipulations for the form but not for the query. I really appreciate your time in helping me get on...

Ok, Thanks pbaldy! I think I understand and as of now makes total sense. I still have the problem of having 2 different sources access this function and then give out different info based on where it is coming from (i.e. the query or the form). So, in the code above, how do I return the value...

The function looks like this (this is just a couple but hopefully you will see the structure that I am looking at). As is right now, called from the form it populates a textbox called Priority that I pass it through the function (ctrl) as me.priority. That works great! But, now, using the...

I think that I understand calling the function from the query (I think LOL). Where I am confused it how to I extract certain data. In other words, if the function is called from the form "ctrl" populates the text box by ctrl = "This Discrepancy is......blah" but when called from the query...

Hello all, How do I get specific information from a function that I run from a query? I will pass 2 parameters to the function but I want to get some text in return. I use this function for populating text boxes from other forms but it has the same logic structure so i would like to also use...

I have two reports that are fairly similar. In both I used Me!txtMyCaption = strLocation & "'s " & "Priority Report as of " & Date (same name in both reports) It works fine in one report but not the other. In the one that doesn't work, it prints all the text you see above except the date...

Correct, the current event is to set the textbox when you go through the records. The after event on the combo box is just in case someone want to change the "priority" of the record being displayed at that time. So, I guess the only way to do it is to run the function from the after event (as...

I did get it to work just by calling the function from the PRIORITY_AfterUpdate() Dim strPriority As String strPriority = Me.PRIORITY Dim myDate As Date myDate = [OPEN_DATE] Call Priorities(strPriority, myDate, Me.txtClosedBy) I was just hoping there was a cleaner way...

Repaint did not work. The textbox that gets updated is unbound. The value is set by the function when I call it in the Current Event. I pass me.txtClosedBy as a parameter so it knows what control is to set with the proper value (i.e. which priority was set(that is a bound control) and then...

Thanks for your help on this one. I am going to have to dig into this on my own I think. It is probably too complicated to explain well. I don't think it is that hard, just have to figure out the best way to do it. I really don't want to take up your time on this one, you have helped me more...

Sorry, the call is actually Call Priorities(strPriority, myDate, Me.txtClosedBy)

I am using a function because it has a some date manipulation in it and more importantly, I also use the same code for some other reports. So, instead of having basically the same code in multiple spots, I put it in Module1 to access it from these different areas. Here is a same of some of the...

I run a function from "Current" event on form2. This sets up different text boxes with the proper information for that record. On that form I have a drop down menu that changes what would be shown in those text boxes. To clarify, on current form, function sets text boxes. On the same form is...