Search results for query: *

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?

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.

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...

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.

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...

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.

Any tips on how to change the font size of the footer in a Word document? This macro captures the filename and places it in the footer, but I cannot get the fontsize reduced. Dim ThisFile As String ActiveWindow.ActivePane.View.Type = wdPageView ActiveWindow.ActivePane.View.SeekView =...

Any tips on how to get the font size of the filename to be a smaller font? When I run the macro below, the font size is still 10 pt. Dim ThisFile As String ActiveWindow.ActivePane.View.Type = wdPageView ActiveWindow.ActivePane.View.SeekView = wdSeekCurrentPageHeader If...

I have several pie charts in a user workbook, where the source data sometimes displays "0%". In these cases, I want to suppress the label and the value. A possible solution is to put a button next to the graph, with a macro which deletes this text. I have played with the syntax a...

I have a pie chart in an Excel template that requires input from users. A sample follows: Bond Type Market Value Corporate 0 Municipal 100,000 US Treasury Notes 0 US Treasury Bonds 300,000 Govt Strips...

What is the best way to store macros so that they can be accessed from multiple Excel spreadsheets for multiple users on a network, and yet be maintained at one location?

I need to identify duplicate names and addresses in an Excel file. I have the following syntax, which will highlight the specified text: Dim strClient As String strClient = Application.InputBox("Please enter a client name.", "Search for client name") With...