| Thread | Last Post | Replies |
|
| Report margin problem - intermittently | 02 Mar 2005 16:01 GMT | 2 |
I have a report that was created from a query. It is landscape 13" wide. When a user goes into the Swicthboard, selects the report, the report displays in Preview Mode. Problem is that it cuts off the right side of the page. I go to File Page Setup, change paper size, and on some ...
|
| Error message | 02 Mar 2005 15:50 GMT | 1 |
I tried to print my report and the following error popped out: "The specified field 'tblPerformance.Date' could refer to more than one table listed in the FROM clause of your SQL statement." I have made used of the parameter query from
|
| Error message when trying to generate report | 02 Mar 2005 15:48 GMT | 1 |
I received the following error when I tries to generate my reports. The query runs fine but the report has the following error: " The specified field 'tblPerformance.Date' could refer to more than one table listed in the FROM clause of your SQL statement."
|
| Repetitive pop up criteria window | 02 Mar 2005 15:45 GMT | 2 |
In a query based on my orders table i have a Between ... and ... on a date field. I have created a report based on a customer table then a report based on an orders table. I have included my report on orders table in my report based on
|
| Text boxes in Graphs | 02 Mar 2005 15:42 GMT | 1 |
Help....I have a graph that one of the criteria is Between[start date?]and [end date?]. I would like to add text box to the graph that would reflect this date range. I have used the expression builder in properties for the control source, tried writing my own expressions (at least a ...
|
| Property .Recordset of Reports | 02 Mar 2005 15:13 GMT | 2 |
I have created an unbound ADO-Recordset that i want to take as the RecordSource (or Recordset) of a report: Dim rst As New Recordset With rst
|
| automatic printing/saving reports | 02 Mar 2005 14:56 GMT | 1 |
I have created a report and attempted to have it be accessed when the use clicks a particular command button. The event procedure for the command button is: DoCmd.OpenReport "Report 1"
|
| Calculating across a row | 02 Mar 2005 12:18 GMT | 1 |
I am trying to collect a total across a row. When I display the report it seems to only be calculating the first part of the expression. I'm I writing this wrong?
|
| Generic tables | 02 Mar 2005 12:05 GMT | 5 |
Within an Access 2003 database I have a number of reports with associated queries,forms, etc. They use a set of tables such as Customer1, Orders1. If I need to use to use a different set of tables (but the same table layout), must I duplicate everything or is their a 'generic' way ...
|
| Different font in detail section | 02 Mar 2005 12:02 GMT | 1 |
I n my report user define the type of font (bold, italic,...) for separately record in detail section. Setings (True/False) is stored in database table for each data record separately. On Detail_Format I check settings and set properties for myDataField like this:
|
| Syntax question? | 02 Mar 2005 08:48 GMT | 5 |
I am using a DLookup expression and am checking two date controls on my report what is the syntax for dtae fields eg here is an example DLookup("[field1]","table1","[Date1]=[Date2]") I recall the these last two date fileds should be surrounded by & and " but
|
| Access Report showing pictures and names | 02 Mar 2005 02:16 GMT | 1 |
How do I create a report containing pictures and names in Access,... my only attempt at this report will only display one row of pictures on each page. I would like each page to have at least 24 pictures - 4 rows of 6. I have played with margins, columns, etc. and can't get ...
|
| Reports | 01 Mar 2005 22:57 GMT | 3 |
How do I select orders from a date section. I have a report date range built but this is as far as I got. I have no clue where to start. I am new at access and have learned what I know on my own. If someone would give me a small example and let me know a little detail as to what ...
|
| Designing a report where matching and unmatching records appear together | 01 Mar 2005 22:25 GMT | 1 |
I'm in charge of creating reports based on a third-party learning management system. I need to create a report that lists the name of a course, and under it, lists the names of the people who have completed the course
|
| How to change value of calculated control before printing if a ce. | 01 Mar 2005 22:21 GMT | 2 |
A report has 3 subreports, each one showing a sum total of amounts in different tables. 1 of the 3 examines a table that often has no data. I have an Event Procedure that cancels format of that subreport if there is no data. But the report footer of the main report contains a ...
|