Search results

Hi all, In a report that has multiple columns, is it possible to have a report header that is centered and spans across both columns? Thanks!

Keeping track of our customers usage for each month of the current year. There is a separate table for the previous year.

Never mind! If anyone's wondering, I used a DLookup: DLookup("[" & Format([As Of Date],"mmmm") & "]","tblCPUCustomerChargesCurrent","[COID] = '" & [tblCPUCustomerChargesCurrent].[COID] & "'")

Hello, Within a query, I'd like to reference another query field based on a date specified as a parameter. In my query, there are fields for each month: [January],[February], etc. I have a field titled [Current Month], based on the parameter [As Of Date]. So if when running the query, the...

Hello, I have a report with a few subreports set to Can Grow/Shrink - Yes. I have manually created two columns. In the first is a subreport, then a few text boxes. In the second are two subreports. When the subreports in the second column are larger, it shifts the fields in the first column...

The iif(val) express worked once I added a second layer to the sort. Thanks!

I created a separate field to pull the Val(), but it's still not quite working the way I want. For example, in section number, I have values of 2a, 2c, Exhibit A. I want them in that order. If I sort by Val([Section Number]), the order comes in as Exhibit A, 2c, 2a. I tried it descending, but...

Okay, I didn't know if that would work on mixed fields. How would I do a custom sort on a form, though?

Hello all, I want to know if there's a way to sort alphanumeric fields where the number of digits aren't always the same. Example: I have the following: 2a, 10a, 3a. Currently, it sorts: 10a, 2a, 3a. Is there a way to get it to sort 2a, 3a, 10a without adding a 0 before 2a and 3a?

I'm trying to create a tabular report, but I don't want any spacing between controls. Is there a way to eliminate the space between two controls?

Yea, the rectangle drawing was my backup plan. I thought maybe there was a setting I was missing. Thanks!

In a report, I have fields with borders set to Solid. However, in both Report View and Print Preview, if a record has a null value for that field, the borders don't show. Is there a way to fix this so that even null fields show a solid border? Thanks! Jeff

Okay, this one isn't even a VBA question. I am in the design view of a report. When I make any kind of change, I am not unable to undo it. Ctrl + Z doesn't work, and the undo/redo buttons are disabled. Does anyone know how to fix this? Thanks!

Thank you very much! I tested it across computers, too, and it works. That is a huge relief! :cool: ---------------------------- Keep Calm and Chive On!

Hello all, In Access, I'm trying to transfer a table to a spreadsheet, but I only want to do it if the spreadsheet file is CLOSED. I have tried a few things that I've read online, but with no luck. So I want to run the following code ONLY if the file Metrics Monthly Metrics Report is closed...

For now, it's okay. I was more asking to see if anyone else had had this problem. It's working okay with the FilterOn function commented out. Thanks for your help, though.

Okay, I'm not sure what you mean by 'when.' I click the button and the report begins to load, including subreports. It stops when it gets to that point. I can't figure out what I do differently that it works the first time I click the button, then each time after that, I get an error message.

Okay, here is my entire code, hope this helps. I put a comment in pointing out where it fails (close to the bottom, under "BUYSIDE CPU APPENDIX".Private Sub cmdReport_Click() Dim strWarning As String 'Warn if not last day of month strWarning = "Would you like to view report to end of...

Yes, the report is in report view. I am using Access 2007.

yes, that's correct