Recent content by ittech73

You can simply expand the width of the list box when you click on a selection in the listbox on enter of the listbox and set back the width of the listbox when you exit the listbox. ex: on Enter me.Test1.width = 7200 on Exit me.Test1.width = 1850 extremely simple and works!

If you have more than one report with no data it will still blow up. Since technically as far as Access is concern you have not left that error event. I have already tried the NoData Event. I have already came up with the solution. You trap for the error and use Resume Next. If you want a...

I currently have a list box containing the report names and when one is selected the report is printed. What I want to do is when I click a command button have several reports print at the same time. The problem is any one or mor than one can have NO DATA in the report. I have a procedure that...

If you where only looking at the name and the amount. Using sum in the query would work. That would be grouping it out by the names, but your looking at another factor month. With month in there access can't group cause there is no common factor in the month only the employee's names. This make...

I don't know if this will help but, I have taken reports from various applications that don't allow the report to be saved as a Acrobat pdf file with in the application itself. You can print the document to Acrobat distiller or Acrobat PdfWriter. This will change the report into a pdf format. If...

In the page setup properties you can create a multiple column report that could be what you are looking for by the sounds of it. If not let me know there are other options. This is an easy solution.

A very simple solution to your ?, why don't you just sum them up in the query or is there a reason you want it done in the report only?

scroce, Here is a sample select query: SELECT Employees.EmployeeID, Employees.LastName, Employees.FirstName, Employees.Title FROM Employees; Here is the code to run this select query, hope this helps your question. Dim strSQl As String strSQL = "SELECT Employees.EmployeeID" &...

I'm using VBA code to make data updates to a Graph in a PowerPoint slide. Is there a good web site or any where else that I could find VBA code on PowerPoint. Such as how can I determine what the different graphs are through use of VBA code. I want to have bar graphs and pie graphs and other...