Hi experts
I am trying to create a report that has sub reports on it. Each sub report has a different recordsource. I want to be able to change the recordsource SQL using VBA code and thi...
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 ...
Hi.
Im writing a very basic helpdesk system to help me track all calls logged in our office. Everything works find except for one thing. I would like the ability (if needed) to sort by each...
I have a report that produces a directory. Towards the bottom of each entry is a list of names of the kides in the family which is NOT generated from a subquery. Is there a way to make access...
All I want to do is loop through all the controls in the detail section of a report and set the visible property to false for the text box and it's label if the textbox value isnull.
I'm havi...
I have just been made aware that now our company needs to have company registration numbers and possibly Vat numbers on every outgoing email.
Is there a simple way to set a template for al...
Hi,
I have a form in Access and a Report all setup. I am trying to have it so that a user enters the "ID" number of a certain record in a form and then based on that number a report is gene...
Hi Experts,
i need your help.
i have a report which needs to print offsite everyday.
the print has to be two sided and needs to flip on short edge.
how can i do a set up in access t...
I am using a query (obviously) to build a report and when I run the report I am getting duplicate "named" fields with different values in each. I want to only have one of each named field sho...
I have an Access 2003 Report in which I'd like to insert a Word Document as an OLE Object. I need to be able to specify the path of the word document at runtime. How can I accomplish this?
Hi,
I have access database. I setup send access report over email.
Everything was working well. Last Friday I shared this database over network.
Today when I tried send report is attache...
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...
The user would like the Funds and Services for a FileNo to show a certain way on the report. The problem is I don't have the same number of records for both. I might have 2 funds but 3 servi...
Please tell me how to Sum my detail section in the Page Footer of an Access Report. I need to do this because it is printed on a pre-printed form and the sum must be in a certain place no mat...
Hi,
In Access I have a query which accepts a start_date and end_dat. To open a report that is based on this query how do I pass in both these dates from a form. See the code below on how far ...
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 am working in an employee database someone else build and I have a request to create a report that displays the employees name and picture. The table storing this information has the picture...
Hello
Here is a strange thing. I have an Access database linked to SQL Server back end. I have several reports that run from queries. On one PC when I open a report in design mode and set t...
Is there a way to put a subreport on a form?
I have a user form. When users click the report button, I want them to be able to see the report preview in a box on the form. Will someone tel...
I created a report using the wizard that pulls data from two tables (computer and software). Each Computer can have multiple Software records.
A page from the reports is attached.
I ...
Sorry,
i feel very confused I am bad I have zero points in software building and if I find not the solution for tomorrow I can be rejected from the firm.
Capricorn 1 gave me the solution f...
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...
My report is set up to respond to parameters provided by the user. Even if the report is very short (one or two lines of sales) I still get a blank page at the end with my report footer(which ...
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 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...
