Search results

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

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

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

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.

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

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

In general Subroutines do not return values, only functions. However, the value of a public variable can be changed within a sub. I have read that Access Subs cannot return values but I wonder if the above method works. I have a variable declared at the very top of the form code page (not a...

When writing code for control events, access used to provide me with helpful hints as I typed. For example i would begin ME. and it would then dispaly what I could continue with, such as ME.txtVehicl etc....now all of a sudden it does not do it anymore...Did i turn some switch off...

My table has the field defined as number, and in form i input a value. I have an OnChange subroutine that tries to look at this field, and if the value > 0 to turn on a check box. however it does not work. 'if family leave hours are present turn on chkFamLeaveFlag Private Sub...