Search results for query: *

All set. It worked in the Report Footer. MANY THANKS!

I was looking at that. I'm not sure I understand the situation. I do not have a subreport. Am I correct that I need to add a field to my query? If so, what do I add and what criteria do I set? Regrets,...newbie.

Excellent. Thanks.

Yes. I should add that the report is reading a query, and filtering on records for a particular individual. The formula works if I am reading a full table, but not with this report from a query. ?

I tried it and I get #Error. Any suggestions?

How do I capture a parameter value in the report title? Example: I am running a report to filter data for a particular individual. A prompt appears to enter the individual's initials. I want these initials to appear as the report header. Many thanks.

Can anyone offer suggestions on how to change and SAVE page setup commands to print a query? Every time I close a query, the default setup resumes. Is there anyway to compress the data to print on one page?

Sounds good. Will this allow the user to, say, number consecutive as pages 1, 4, 5, 8, 15, etc? I need to be able to assign any number. Forgive me, but I am waiting to get the software, and I cannot test this just yet.

That is precisely the problem. Thank you very much.

We have an Excel file with multiple hyperlinks that acts as an Intranet in our office. Users like to keep the file open for easy access to forms and information. Often times the Excel file will close after you click on a hyperlink. What causes this and can it be avoided?

Is there a way to produce page numbers, but give users the flexibility to change them? The reports we will be producing may, or may not, be consolidated with material from other sources and consequently, the page numbering may change.

Awesome. Thank you. Wow!

I have a macro that searches a database for a tax id number. I need a message box that reads "Tax id number not found" if the tax id number is not in the database. How do I do that? Here is my syntax: Dim strMessage As String strMessage = Application.InputBox("ENTER TAX I.D...

I have a macro that searches a database for a tax id number. I need an error message if the tax id number is not found. How do I do that? Here is my syntax: Dim strMessage As String strMessage = Application.InputBox("ENTER TAX I.D. NUMBER (Example: ###-##-####)", "SEARCH FOR...

That looks great, but my sender could be one of 150 people, not consistently the same individual. How do I grab the sender's identity and cc them?

I have the following macro to send a workbook to a specific individual: ActiveWorkbook.SendMail Recipients:="Smith, Joe" How do I cc: the sender, which could be one of 150 possible individuals? Any thoughts appreciated. Many thanks.

Thank you segmentationfault and Goska. That makes sense and IT WORKS! THANK YOU!

I have placed the following syntax in the general declarations section (VBA Project, Microsoft Excel Objects, ThisWorkbook) of a workbook, in an attempt to coax the file to always open with the cursor in a specific location, but it is not working. Does anyone have any suggestions...

I need a total for each text box. The total is in the detail section. How can I accomplish this?

Newbie Access Question: Can I have two headers in one report? If so, how do I do this? I am trying to fit a significant amount of data onto one page.