| Thread | Last Post | Replies |
|
| Code to change color of field depending on another fields results | 07 May 2005 13:19 GMT | 5 |
I've searched the newsgroup and not finding an answer to this: I have a report that's build on a query. In the detail section of the report I have 4 fields. [CCNumber]
|
| Printing Reports from other forms. | 06 May 2005 23:09 GMT | 4 |
I have a form that I would like to be popup and modal. However, I cannot print the report from the File menu. I have tried to change the modal on the form to no, and have tried to make the report popup. What is the standard for forms and reports using popup and modal? Is ...
|
| print selected reports | 06 May 2005 22:58 GMT | 2 |
I'm new to Access. I have created billing statements from data tables in Access 2003. How can I print only the reports that show balances OTHER THAN ZERO in the balance due field? In other words, I don't want to print those statements that show zero balances. Save on paper, ...
|
| how to identify what value has a max occurence in a report/query | 06 May 2005 22:50 GMT | 1 |
I have a simple report with fields such as Day, Product, Thrown Out Qty, and Reason. For some period the same reason (e.g. cutt off) can occure many times. How could I identify which reason has a max frequency in the records?
|
| Summing unbound text box in report | 06 May 2005 22:40 GMT | 2 |
I have an unbound text box, called [NoSchools] in the detail section of a report that gets it's data from Select Case statements in the onprint event . I want to be able to find the sum of the numbers in this text box, but can't because it is an unbound text box in a report. The ...
|
| Newbie: best way to send a value to many queries at once | 06 May 2005 21:36 GMT | 4 |
I have many queries that do different things depending upon a user-entered number. I want to put these queries in one report so that the user can open the report, enter the number and all the queries will display the results for that number entered.
|
| accessing data for a report from a remote location | 06 May 2005 20:30 GMT | 1 |
I am looking for ways to run a report using data located in a database external to the one i'm running the report in. I do NOT want to link tables due to security concerns related to some of the data stored in the tables. I could import specific data into a "temp" table on the ...
|
| Flagging Printed Records | 06 May 2005 20:11 GMT | 1 |
I have a database with a table full of records I wish to report. I have it set up so that a single-page report will print--one for each of the records in the table. How would I go about having the record flagged in the table once it has been printed so that I will not print it ...
|
| Help with On Print Event | 06 May 2005 20:01 GMT | 1 |
I am printing time card labels for our employees. The user need to change the pay period dates for every pay period. In the label report I created an unbound field for the user to input the pay period date. The dates are inputted from a form and pass through to the On Print ...
|
| Conditional page break in report | 06 May 2005 19:38 GMT | 2 |
Trying to add conditional page break in Access 2003 report. Following instructions found in <http:\\office.microsoft.com/en-us-assistance/HP051873361033.aspx>. My OnFormat event procedure statement "Me![CondPgBreak].Visable = False"
|
| Snapshot Reports | 06 May 2005 18:18 GMT | 5 |
I have reports that when I view them in snapshot on one computer they look perfect, yet when I view the same reports on another computer, the right margin cuts off a few letters and pushes to a new page. Any ideas might might cause this?
|
| problem exporting access report to excel- wrong data after export | 06 May 2005 18:04 GMT | 1 |
I need to export the access report to excel 97-2000 format. but after I export the report, data in one column has changed from '10298169-3' to '2599492' appreciate any help
|
| Daily Occurrance Report | 06 May 2005 17:05 GMT | 5 |
I have a query qryDailyDressCodeCount that I pull a daily count of all dress code violations. The query uses a form with 2 combo boxes to select a range of dates to include on the report. No problem. What I don't need is Access including weekend dates in the report when they
|
| Text box problem | 06 May 2005 16:02 GMT | 2 |
Hi, I am new to ACCESS and i am building a report that i need a text box to print "Call Me" if a field (Coord) of the query is blank or to print the field (Coord) if the field (Coord) is populated. I have tried the IIF statement:
|
| Calculated Fields | 06 May 2005 15:57 GMT | 1 |
I hope that someone can help? I have a report with a simple field with the following control source. =[text193]/[Text207] however the text boxes are summing the data from a table and this works fine
|