| Thread | Last Post | Replies |
|
| Non-descriptive error message | 29 Aug 2006 18:15 GMT | 8 |
I am using Access 2000 on a XP Pro machine at work. I created a report this morning and had another open to copy some elements from and paste in the new one. General stuff: company logo and such. Was testing it out and started receiving the first of 2 messages.
|
| Printing a selected report from a subform | 29 Aug 2006 13:20 GMT | 1 |
Wonder if anyone can please help. I want to print only selected records from a subform. My main form [Newform] contains individuals name, address etc. The subform [AppointmentDetailsSubform] contains specific appointment details. Both forms
|
| Pie Charts | 29 Aug 2006 00:51 GMT | 2 |
I would like to be able to display a pie chart with 5 fields of one record, which total 100%. How can I create this type of chart instead of a summary? Thanks, RH
|
| Error Message when running report | 29 Aug 2006 00:35 GMT | 5 |
I have a report, which runs off a query, which runs off a table. I added a column of data to the table and then that column to the query. I went into the report via Design View and added a text box to display the value of the new column. When I try to run the report, I get the ...
|
| Report to print color bars to 60 horizontal slots | 28 Aug 2006 22:01 GMT | 3 |
I have this report which prints horizontal color bars in 60 slots which represent months over a 5-year period. I build the report in a temporary table which then feeds the report. Currently I have columns called M1 thru M60 in this table.
|
| Empty report condition | 28 Aug 2006 21:07 GMT | 2 |
What is the correct way to handle the 'empty report condition'? Currently, I have an event procedure set up which displays a message. However, the procedure that opens the report also has an 'on error' handler and this is being triggered and so shows a second message.
|
| Calculations on report... | 28 Aug 2006 19:54 GMT | 25 |
I am new in doing calculation in Access. I am using Access 2000 and need a little help with If Then Staements using in the Control Source. Do I still need to DIM anything?? Here is the code that i would like to use that I thought I could use in Vb but an error is coming up. When I ...
|
| Filter Data in Report | 28 Aug 2006 19:17 GMT | 1 |
I have a report that contains a customer listing with phone numbers. I want to filter out all of the customers who do NOT have a phone number. Do I need to go back and run a query off of my table or is there a way to filter data directly from the report designer?
|
| Start and End Dates show error | 28 Aug 2006 16:44 GMT | 1 |
I now have my start and end dates in my report but if there is no data entered between the start and end date it shows error not the dates how do I always show the dates even if there is nothing in the detail of the report thanks
|
| I am a Chart Idiot...looking for help | 28 Aug 2006 14:01 GMT | 5 |
I am missing some pretty simple concepts I guess. I have created a 500 page report...one page per record. The data on each page is organized into 4 categories...call them A B C and D. And a numeric total is reported for each.
|
| Thermal label printers | 28 Aug 2006 13:56 GMT | 5 |
I'm researching a thermal (roll type) printer for barcode labels. The client is looking at a Zebra printer, which, from my understanding is Unix based. Therefore, there is an intermediate program needed between Access and the printer. I would prefer to just go with a TryeType ...
|
| Records goto next command | 28 Aug 2006 06:25 GMT | 1 |
I want to have my code send the focust to a new record in code. When running "DoCmd.RunCommand (acCmdRecordsGoToNew)" it does not know what form I am refering to - What is the syntax for this (the form is "Forms![ST_Enter_TR]![ST_TRANS_HD subform]")
|
| nested iif statement syntax | 28 Aug 2006 05:30 GMT | 1 |
I have two y/n fields that need to trigger printing on a report. I am using the following, but i keep getting a syntax error. If first Y/N=true the test the next Y/N to print BadgeText4 =iif([events],=IIf([RSVP4],[BadgeText4f],""),"")
|
| Counting records that are not null | 28 Aug 2006 01:42 GMT | 4 |
I am trying to count the number of records that are not null in a specific field. My field is a 4-digit text field. I know the proper syntax for counting records if the field is null, i.e., =Sum(IIf(IsNull([field]),1,0)). My problem is that I don't know the syntax for ...
|
| Start Printing 3 col labe at choice of column/row | 28 Aug 2006 01:08 GMT | 1 |
Don't have a label printer, but on 3 column, 10 row (Avery type) label sheet, would like to start print labels at specific column and row, say 3rd column of 3, at row 7 of 10. Perhaps a little parameter query prior to print?
|