I am trying to make a control on a form Vertical,
When I change the properties to Vertical the value in the control dissapears and when I preview the report there is nothing displayed in t...
I have an Access 2003 ADP with SQL Server 2000 Backup.
I have about 30 user using this system. I print some word documents internally and lots of differnt Access reports.
The majority work o...
In print preview the report logo and images in the report display fine but when sent to the printer the logo and images do not appear at all. This happens on two different printers which both...
I am trying to pass Form Values to A Report using the following command:
DoCmd.OpenReport stDocName, acPreview, , "AxysCode = '" & AxysCode & "' ", "StartDate = " & StartDate, "EndDate = " ...
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...
I have the number I need in an unbound control on the report named ManagerID. I need the report's record source query to know the value of ManagerID. The record source query is attached. Cu...
Hello,
I have a report that sorts by Employee name. I'm trying to get it so that the individual employee will be grouped on each page. Basically so all the results for each employee will be...
I have about 250+ text boxes on a report that contain DLOOKUP or DSUM which reference the report name. Sample:
=IIf(DLookUp("[DTyp]","[Date_t]","[Date] = #" & Format(Reports!rptSched45Days...
How I need to arrange my query and which calcualtion expression I need to enter into report design view to be able to count the number of records selected by this query?
Say, my query selecte...
I have a report that I am emailing to a recipient who doesnt have access. What type of file should I use to save it? I am using my PC computer.
My options are Rich Text, Microsoft Excel 9...
Without using specirfic usernames, is there a way of limiting the number of simultaneous connections to a database? i.e. you might have 10 usernames but only 3 can be using the DB at the same ...
I need to change the report layout in MS Access based on a query.
First format includes a section based on the field [Company]
The second format has no section.
On the reports open even...
Hi Expert,
I have a quick question.
I am seeking a function that can change words into bold format in a textbox.
for example,
="Today Date is " & Boldfunction(Date()) & "."
the ...
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...
When I create a Tabular style report I can fit multiple records per page but when I create one using the Columnar style it only puts one record per page. How do I create a Columnar report tha...
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...
Hello,
Question about access cross query.
I have one report based on cross query. Right now when I try open report I have error:
"The Microsoft Jet database engine does not recognize [3] ...
I have produced a report in Access that runs from a query.
The report contains a few labels that contain text relevant to every copy of the report we produce. Also on the report are text bo...
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...
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 ...
In an Access 2007 application I am enhancing, I need to add a 2nd page to an already existing report (rptMain). This 2nd page will be having 12 different MS Graph.Chart.8 objects (Unbound). Ca...
Greetings,
I have a calculation that is completed in one of my queries.
TimeFRMT: (Format(([Minutes]\60)+(CInt(([Minutes]-(60*([Minutes]\60)))/15)*15/60),"Fixed")*[Number_Of_Children]
...
I have an Access 2003 report. WHen I run it I want the page numbering to restart after each certain group.
It is working fine example Page 1 page 2 page 3 then will restart with a new group ...
Hi,
Is it possible to output a report as HTML and then send that report as an email which is visible in the Body/Message section of the email? I currently send email from access coded into...
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...
