Search results

I had tried that before in an iif statement and got an error about not completing the argument. Someone else recommended this to fix it: IIF(Len(Me.ReportFieldName & "") = 0,True,False) Haven't tried it though...

Figured it out for the VBA (still not sure what's up with the expression). I had been putting it in the Open event of the report, but it needed to be on the Load event. I used: If Len(Me.ReportFieldName & "") = 0 Then Me.ReportFieldName.BackColor = vbBlack End If

Thanks for the reply. This looks like what I need, but I still am unsure what I can use in the expression area to state that when the field is blank use the color. I tried "" and used Nz without success.

I have a report where some field values will be blank at times. I would like to write an if statement (in VBA or as an expression) to state that if the field is blank, to change the back color of the field value on the report. I can't seem to get it to work in either VBA or as an expression. In...

Thank you!

Figured it out. Just had to use the OpenReport macro and change the window view option from Normal to Hidden!

I have a form that opens two reports. I need to hide one of the reports after it opens. I then need to add a button to the 1st report that makes the 2nd report visible again. I know of Me.Visible = False This has not worked for me. I placed this in the On Load, On Open, and On Activate events...

Simplest solution was to use the Criteria of my Date field in the query: =[Forms]![UserInputFormName]![ControlNameFromUserInputForm]

Unfortunately, this doesn't help me as it doesn't include a way to reference End Date. Thanks for the reply.

I have an input form that a user can insert a Start Date and End Date, and then open a report with charts in those date ranges. I need to populate some of the field values in the report with field values that correspond to the End Date only. Can I use the DLookup expression for this? I've been...

I have two issues: 1) I have two charts that need to display information for same start date and end date. I can get it so that the criteria of the query prompts the user, but then it has to occur twice (once for each chart). I can just have the report query prompt once for a start date and end...

I want to call a field from query that is self-contained in a report. How do I do this? Beyond this, is there any performance difference between creating a query and having a self-contained query?

Actually got it solved! Thanks for all the help!

I have actually taken a different approach, but still arrive at a problem. I create a field in the query that multiplies the two fields. I then create a textbox and add an expression to take the created field and divide it by the total sum of the first field. However, it only multiplies the...

Hi Smig, Can you please tell me how you got the issue fixed in the database I sent? I can switch my dates to be for non-US. My computer is from the US so I am used to using it now. This is really a big issue for me and all your help is appreciated.

Thank you Galaxiom. I am still getting the Run-time error 3078 for the same line after replacing your line of code. Can you please check the database I uploaded to see if you can tell what I'm doing wrong? Thank you!

I think the Query statement is throwing me off. When I run the function (in a report from a textbox using an expression), I get stopped at sunItems. I get Run-time error 3078, which states it can't find the query statement. I tried to make a query and place the strQRY query statement in it...

The user needs to put in specified dates as project dates are always random. If I use your answer, and query and name the the parameters for date [Start Date] and [End Date], would I use that in place of Date1 and Date2?

Would something like this work: SELECT Sum(a.numItems) AS SumOfnumItems, Sum(a.NumItemsXnumBuys) AS SumOfNumItemsXnumBuys, [SumOfNumItemsXnumBuys]/[CountOfnumItems] AS TheResult FROM ( SELECT myTable.DayDate, myTable.numItems...

I have a formula that at first glance I thought would be simple to do as an expression: Take a range of days for two fields and multiply their values for each day. Then add each of those values to the other days. Finally, divide by the sum value of one of the fields. EXAMPLE: 4/1/12 -...