I have the following grouping/sort in my report:
Group on Job Code
Group on PO Number
Sort by Check Request Date
I want to keep these like that. The user however needs to be able to so...
I have an Access 2003 database which is used to print an Invoice into a pre-printed 8.5 x 14 form in the printer.
The report design uses an Ole (Unbound Ole Frame) of Microsoft Word.
The u...
I have a main report and sub report. Within the main reports Report Header section I have a sub-report embedded. I also have a blank text box in the main Report header section to display mess...
Dumb question..
I don't know too much about Access to begin with (except that 2007 is much more difficult to use than 2003, just like Excel), but I've made a few forms, but all my experience ...
I am looking for a sample of creating a report and populating the detail record(s) fields using VBA. I have to gather date using several queries and then summarize to build the report, and doi...
I created an Access report with two subreports grouped by a company id field. The company id field also has a header in the report. This report prints the data for all the companies at one t...
I have a query that receives date value as parameter. This query is being used in a report. The mentioned report is being opened from a Form.
I am unable to find a way to pass the parameter ...
On an Access 2003 Report, I need to filter the output for a "acOpenReport". At the presant time I am filtering the print with "DoCmd.OpenReport "ThisClientsMaterials", acNormal, , "[W/O]=" & ...
When opening a cross tab report, if any of the fields on the cross tab are null, the report will not print. Can these fields containing nulls be forced to 0s so that the report will print and ...
I have a report that I send via email in rtf format. Is there any way to make the file read only so that the recipient can't modify the document?
I'm tring to get a Report to sort (OrderBy) AND Filter (Filter) the same way that the user may have specified in the datasheet view in fSubFilingCalendar. (Clicking on the little down arrow in...
I have a table (tbl_Charges) which lists by individual a main charge classification and within the main class, it lists up to 5 infraction classifications. These are in text form. I need to be...
I have an unbound form that is updating two tables view VBA with sql query insert statments. I need to have on a button the ability to print a report that is run by a query. The problem I am r...
Hi
I am working in Excel and i have 50 different sheets sheet1, sheet2, ..., sheet50
i inserted a new sheet in which i waht to copy a cell from each sheet(1 - 50)
so i create a link ina ce...
I have a calculated field that calculates the cubic feet of heating filters by using the dimensions. 20x20x2 is 800/1728. This part works fine.
The trouble is that the Make Table query ...
I have 2 queries. I need all of the items (regardless of extra characters in the end) in query 2 to match any of the Items in Query 1, and display in my results.
Table 1
---------------
I...
I have a letter in 2 versions 1 in english and 1 in spanish that group together on a members Zip Code and then the 5 closest help centers to thier zip. I created each version as a subreport i...
I've create a report within Access 2007 which is a picking list. The detail section of the report has two types of line types, stock items and free text description lines. Each of the differen...
I have an access report with several subreports. I have gotten the subreport totals on the main report to show "0" when there are no values but I need the main form calculation to show "0" if...
I need an Access 2003 Database running on Windows to run a report behind the scenes and then return the page number where a specific record "starts".
Example: My Flower database holds man...
I have a report in Access 2007 that prints the report exactly as I need it but between every page of the report I get a blank page. Please help
I have an embedded subreport that I want to shrink when certain criteria are met. My first attempt was to set the sub report properties to can shrink and then change the visible property to fa...
I have a form which has too much stuff on it already. There is some additional data that some people might want to occasionally view. So I put this info in a separate form that can be brough...
Is there any way in Access to highlight certain words in a form or a report? The words in question are key words in a search funtion and are stored ina text field or a string as necessary
Hi,
I have an Access report with a large number of fields.
I need it to print on one page, so I have squeezed the fields together and turned on Can Grow.
My problem is that I need some sor...
