Recent content by wiginprov

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?