Search results

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.

Yes, I used the color number as you indicated and it works fine on my computer...i just zipped up the MDB and emailed it to him...then was at his computer later in the day and tabbing from field to field did not result in any backcolor changes. But it if displays on your computer then it must...

I created some code that turns the backcolor to a special lite blue when a control gets focus, and back to white when it loses focus. I created a special color so it would be nice and light. I then zipped and sent the MDB file to the user. When he runs the form his computer does not change...

thanks. yes i defaulted to that method. i guess my general question is how do you create some variable outside on a Sub so that many Subs on that form code page can have access to it? Doing it as a Dim statement appears to not work, at least it causes my Intellisense to stop working whiich is...

I want to change the background color of each control as it receives focus to a custom color i have created, given the number 16775639. I thought I could do a Dim statement at the top of the form code page, and do an assignment such as: Dim colSpecial as Integer colSpecial = 16775639...

If I have a field in a table defined as a type number, and then in a form have a text box that displays that field, and have another contorl where i want to display some calcualtion based on many things using code for the calculation, do i need to convert the text box value to a number being...