Search results

I have a report that has many fields. Of course, I don't want every field to print if it is null, the report would be long and ambiguous and nasty. Is there a way to skip a field and have the next field (if not null) print in the same position?

I don't know exactly your setup but for the field where you are doing the subtotals use an IIF statement in the controlsource property of you field, such as: IIF ([AgentGroup] <= 1, [AgentGroup].visible = false, [AgentGroup])

Thank you. What is the FIRE IN THE HOLE comment?

Does anyone know how to open Windows Explorer programatically (VBA)? Thank you.

Are you trying to pull the table name as to use in a criteria expression?

Is it possible to pass criteria to the criteria part of a query field from Code? I'm trying new things. If so, can someone show me an example. Thanks.

I have a good example for you, if you want it I can send it to you. That way you won't have to do the big runaround with all of this other feedback, that is probably overwhelming you. If you need it, just reply a post with your email and I will send it to you.

I finally got it to work. I did use the variable name with the recordset, that was the problem of not finding the position. I then used the Left and Mid variables to find the position and eliminate it, as follows: Function GetRidofAsterisk() Dim rst As New ADODB.Recordset...

I thought of that too, but it didn't work. Thanks for the idea, though. Can you think of anything else?

Public Sub GetRidofAsterisk() Dim rst As New ADODB.Recordset Dim SearchCharacter As String Dim MyPosition As Integer rst.Open "Select Billing_name from LTR_CodeA", CurrentProject.Connection, adOpenDynamic, adLockOptimistic SearchCharacter = "*"...

I am trying to use the InStr variable to search through an ADO recordset. Problem: I get a type mismatch error within my code when trying to run the ADO in a recordset. Another thing, when I just type in a string, and use the InStr variable, it works. I'm thinking, maybe you can't use the...

Thanks for your help. I was trying to make a mountain out of a mole hill. Here is what I did in the criteria section of the query for the time field: Between ([Forms]![frmSelections]![cmbStartTime]) And (#11:59:59 PM#) Or Between (#12:00:00 AM#) And ([Forms]![frmSelections]![cmbEndTime])...

Problem: I have a user that wants to be able to select phone calls that were received during a certain time period (i.e. #10:00 PM# to #04:00 AM#). As you know, queries will not select the records between these times with a Between (StartTime) And (End Time) Statement, because it crosses...

I don't know about every 4 records, but if you want to shade every other record in your report, try this code. Remember, you want the code to be in the same section that the records are located. For example, your records are mostly likely contained in the detail section of the report. If so...

If you are using 2000, try using the Conditional Formatting property that is new with 2000. On your continuous form, select Conditional Formatting from Format on the toolbar. Under Condition Select if value is equal to than, then the number (12). From there you can specify which color you...

Has anyone ever had the need to create an index or table of contents from an Access report, like you can do in Word? I can save the access report as an RTF to open in word, but wouldn't it be nice to be able to just create one in Access? If anyone has ever attempted this, or knows something...

I am currently employed with a healthcare network, and I am tracking vehicles and deliveries. In my destination field in my location table I have numerous destinations for one run. For instance, I have 12 destinations for the 12:00 run. I am trying to create a form that will not only show the...