Recent content by stoka

Read Access tables inside excel Yes the strDataPath1 is defined on a module level elsewhere. it is the complete path to the file to be opened.

i have several tables in access. we want excel reports produced that can access the Access tables, determine min max ave etc, and create the excel reports. i can either bring the data in to a scratch worksheet or do it in memory. have been able to get the ADODB connection but system stops...

I have a vertical line of the left hand margin of the form. i did not put it there. how do you get rid of it.

I have a form to input date range, detail or summary report wanted, one person or entire list with combo box to select the person, sort by name or date, and whether to show sub-totals or not for the major sort. I have a command button that when clicked launches the report. In the VB code is...

have a report with a front end form to get date ranges and sorting order. used vb code to lauch one of two reports (one for sort by name, another for sort by date -- didn't know how to change sort order in report from the form) so now i want the ability to use a combo box in the form to select...

Underline on Reports FOund it...it was under conditional formating...

I have a report that subtotals on group level, and totals at end of report. For some reason whenever it prints a value, either on detail line or on any reporting line it underlines the value and places an underline. i have verified that the Underline or Bold setting are not turned on forthe...

sample database thanks so much. the sample helped me understand how it works. i have posted another question about using sorting and totaling option selections on that form and passing them to the report....i tried to do a comment back about your help but it said i needed to spread it around...

I have a Report Parameters form that accepts the begin,end date and whether to sort by Name-Dates or Dates-Name, and whether to have subtotals by major sort with report total, or just report total, or no totals. I can set up separate reports for each combination of the above but is there a way...

I have a Report Parameters form that accepts the begin,end date and whether to sort by Name-Dates or Dates-Name, and whether to have subtotals by major sort with report total, or just report total, or no totals. I can set up separate reports for each combination of the above but is there a way...

I am using a simple " >= [BeginDate:] and <= [EndDate:]" in the criterion section of a query to allow a date range to be selected in the query which is used in a report. How can i get that [BeginDate:] and [EndDate:] info available to print on the report so it shows the actual date range being...

I am using a simple " >= [BeginDate:] and <= [EndDate:]" in the criterion section of a query to allow a date range to be selected in the query which is used in a report. How can i get that [BeginDate:] and [EndDate:] info available to print on the report so it shows the actual date range being...

Blank pages thanks that was it.

when i click to run a report is first receive this message: The Section width is greater than the page width and there are no items in the additional spaces so some pages may be blankk. and i do get a blank page 2. i have it set up for letter, page size 7.5, and the report itself is only 6.5 ??

what is the best method to have a report request the user to input the date range for the report. for example sales figures, and allow the user to request a range of dates to include in the report. i know i can hard wire the query but want someting at runtime. thanks.