I have created a query which reports description based on a numeric column that I called SortOrder. When I run the query, the following is output in this order - due to the value in the SortO...
Is it possible to get images to display horizontally (in columns) in a subreport? I am able to get it to display like I want it to in the main report ( see attachmend RptImage) but when I try...
Following the help of
http://office.microsoft.com/en-au/access/HA011170771033.aspx
I have generated a output of a query as report through a form to input the parameters.
I tried using th...
Hello, I've got a little Macro that prints 8 reports one after the other, however my user wants to have them in one Excel Spreadsheet, with individual tabs for each report. Is there a way to...
I have set up a form in Access 2000 using Microsoft Rich Textbox Control. It shows the text in the format that I want (bolded, underline, etc.) just fine. Now, I want to show the same inform...
Good Afternoon Experts,
I have an insurance database and I have 2 separate reports to print statements. I'm trying to combine these 2 reports on 1 report with my first page being the Summa...
I use Microsoft Graph in Access 2003, and it works well. I want to create graphs in Access Project, but the Access code doesn't seem to work with Project. The Access code looks like this:
T...
I need a double calendar pop-up showing this month and next, where I can manually select the date range for the activity of the task items shown in rptTasksLogPeriod. The converted values by ...
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 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
Grreting all,
I attached a sample of the database I'm creating for reference and help. I created the tables and forms I needed to collect the data I needed. Here's where i need help. I wa...
>>>Please read carefully... there are a few subtleties to what I am trying to accomplish...
>>>I will be happy to answer any questions to clarify my objectives prior to awarding points.
I ...
I think this will be extremely easy for any expert here.
Please take a look at frmProducts, the purpose is to add specifications to products.
All the subforms are related so that when yo...
Hi,
I build a report to list all the data that current on the form, but I have problem to print a report that only shows current data. Everytime I print the report and it have 100 pages si...
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 have one tabular design report width many fields (+40). The report width limit (22 inches/55.88 cm) is too small. Is it possible to "break" the report in two "design" pages? I.e in print/pre...
Hi, I am trying to figure out how to create this report in Access. Keep in mind I've never created an Access Report before, I exprimented with the Wizard but I'm still quite lost on what to d...
Hi Experts,
I'm writing several MS Access reports at the moment and I was hoping that I could make some of them a bit dynamic by collecting one or two parameters at run-time and then using ...
Hi, I have the following SQL code for a subreport
SELECT op_callout_response.op_desc, Sum(R1_A_Q_callout_responses_breakdown.[Reg Index 1]) AS [SumOfReg Index 1], Sum(R1_A_Q_callout_respons...
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 need a master detail report in SQLPlus where the linesize is 200 and has 14 columns of data.
I want the report to break on an insurance company by claim number. Once all the calims have pri...
I'm new to Access 2007 and am using it to upgrade a wholesale/stock control system. Orders to suppliers might or might not involve FOB charges or agent commissions. I have placed these values ...
I have a report in access that basicly takes all the data and puts it in an excel sheet. This report used to work but then when I added several new fields to the table it now goves the followi...
I have adopted support of a customers Access database application. It was originally written in Access 2000 format. I'm making some changes and have upgraded it to Access 2007 format.
The d...
I have a basic Helpdesk CRM tool in Access. There is a form called HelpDesk which uses three combo boxes and writes to a table titled Contacts_CustServTbl
Within the Contacts_CustSe...
