| Thread | Last Post | Replies |
|
| Formatting in a concatenated string | 19 May 2005 04:35 GMT | 1 |
I have a database in which I have a contract as a report. For several reasons this works better for me than merging data with MS Word. In some of the fields I would like to format specific portions as italics or bold. How can I do this? I have several numerical fields and ...
|
| yes no true false tick toggle | 19 May 2005 03:57 GMT | 1 |
I have a table that has tick boxes for yes/no how can i set up in a report a field that print "yes" and "no" based on the field being ticked or not
|
| round the result of an expression to two decimal places | 19 May 2005 03:03 GMT | 1 |
Need to round the following expression to two decimal places. "=(Sum([RAW]*24))/Count([raw])"
|
| How do you print a single record? | 19 May 2005 02:59 GMT | 8 |
I would like the users of my dbase to print the record they are viewing on a report. Is there a way to do this either through macro or code?
|
| Sorting Choices | 19 May 2005 00:21 GMT | 5 |
I have a form with a listbox that will display a list of items that include description and color when an invoice number is selected from a combo box. I think I can fix it so that the user has choice of viewing the listbox that will sort by description first and then color, or by ...
|
| Row spacing in detail section of report | 18 May 2005 23:50 GMT | 4 |
How do I get the row spacing in the detail section tighter? (I want the report to come out with fewer pages).
|
| How do I get a line in an Access report to port over to Word .doc | 18 May 2005 23:27 GMT | 2 |
I'm using some line to demarcate the header and footer of a report. When I try to use the Office Link to port the Report data over to Word, I don't get the lines to come with the text... Thanks for your help.
|
| trouble with report that has lots of controls | 18 May 2005 23:07 GMT | 12 |
I created a report on my system at home (Access2003) worked perfectly. I then updated my development system at work (Access2002) When I tried to preview the report from design view it would flash a blank report window for a sec then return to design view. When I ran the code ...
|
| problem with rounding | 18 May 2005 22:30 GMT | 1 |
I have a report that shows a column of numbers and then a total at the bottom. I need the numbers to be to 3 decimal places. But I'm having a problem if the total ends in a zero. Here's an example. 23.378
|
| LAbels Report To MsWord.... | 18 May 2005 22:28 GMT | 3 |
Many times we get requests for label generation. Ms Access has a nice little wizard that takes care of all the formatting. We are getting out of the printing game and I need to park the labels on a share and have the user open the file and print them. How should I do this? Is it ...
|
| How to skip records on a report | 18 May 2005 22:06 GMT | 4 |
Hell I have a table of Items with the fields ItemCode, Kind, Type, UsedFro and UsedTo My goal is to take a report that shows for every item, if the tabl
|
| Report on Blank Fields | 18 May 2005 19:38 GMT | 1 |
I want to create a report that displays the names of fields that have no data for a particular record.
|
| duplicate records | 18 May 2005 19:16 GMT | 1 |
I have a report on a query is built on a query and another table. The relationship is one to many. When I view the report I have the same record on two pages. I have already changed it so it won't show dulicate records. HELP!
|
| Error With Code | 18 May 2005 18:41 GMT | 1 |
I have a form which generates this reprt and someone in this forum helped me with this code to suppress the printing of empty field and their labels: Dim ctl As Control For Each ctl In Me.Detail.Controls
|
| Access Mail Merge to Word.doc files ? | 18 May 2005 18:31 GMT | 1 |
The following code works to print select records from DB2 table (Prtno_Num=20) to various output reports based on RESULT_CDE values and prints it's specific report. Is there some way to revert to sending this record to Microsoft Word and merge the data into word.doc formatted ...
|