| Thread | Last Post | Replies |
|
| Running Reports - Access 2003 | 21 Feb 2008 01:10 GMT | 1 |
I'm entering information in a database of photographs that was set up by someone else. Now, I want to run a report (or is it a query?) that picks out certain information. Each entry has fields such as: photo no.; title; description; keywords; and the photo itself. I want to be ...
|
| Unprinted characters in a report | 21 Feb 2008 00:51 GMT | 1 |
I have a contact management database which also handles communications. I have saved a communication with Romanian characters in it but when it comes time to print the report many of the characters are replaced with '?'.
|
| conditional formatting-date color change | 21 Feb 2008 00:25 GMT | 2 |
I wrote in Access 2003, having a little trouble. making this happen. What i'm doing is on calibration dates for tools. I would like to have the date that i put into [calibrationdue] change colors, 30 and 15 days before and turn Red when past due. Can anyone help me? Dumbfounded. ...
|
| Grouping Report Pages | 20 Feb 2008 20:57 GMT | 3 |
I would like to generate a report that has a general template but each page is a different Department (one of my table headings). I am generating the report off of a query looking for a specific Document Number ( table heading). I want each report page to display everyone within
|
| Continuous Pages | 20 Feb 2008 19:01 GMT | 4 |
I created a simple report that has a Report Header, Detail and Report Footer section. My report should only be 1 page but it goes on continuously to no end. Can anyone tell me what I'm doing wrong? The page is formatted on a 8.5 x 11 page landscaped. Any help is greatly ...
|
| Making one field bold in a concatanated string | 20 Feb 2008 16:12 GMT | 2 |
This issue is in MS Access 2003 I have a string with the last name and first name fields concatanated. I would like to bold the last name field only. Is there anyway to do this?
|
| What is grouping in MSAccess? | 20 Feb 2008 11:16 GMT | 9 |
Please explain what is grouping in MSAccess. How can I group a certain field as per my requirement. I need more knowlege in this area.
|
| Programmatically Close Report | 20 Feb 2008 03:17 GMT | 1 |
Hi. I have a report that, when opened with OpenArgs, prints the number of copies specified in OpenArgs. Shown here: Private Sub Report_Activate() If Len(Report.OpenArgs) > 0 Then
|
| On Time Delivery Query | 20 Feb 2008 02:10 GMT | 15 |
I'm trying to create a query for "On Time Delivery". I have query fields of PO, Date Received, Due Date and Date Shipped. I'd like to calculate EARLY (shipped 3 days early from the due date), On Time (Shipped on Due Date or 2 days early) and LATE (Shipped past Due Date) and on a ...
|
| Text objects | 20 Feb 2008 00:54 GMT | 5 |
I am creating customer invoices using a query report. What is the best way to place text into the report that is not tied to a field? Examples of such text are: "Bill to:" and "Date." I tried using text boxes but, as usual, ran into problems.
|
| Selectively Hiding Group Headers & Footers | 19 Feb 2008 20:54 GMT | 9 |
I'd like to control the printing of group headers and footers based on the value in a specific data field. Is this possible? Using Access 2003. Thanks
|
| Create Email From Access W/Information From Form or Query | 19 Feb 2008 20:11 GMT | 1 |
I have designed Databases for many years now, but never attempted this: I need to know how to create an email with information located in the active form or off of a query. I would like to have the email automatically generated with the To Address, The Subject Line and the Body ...
|
| Lookup function not working | 19 Feb 2008 20:10 GMT | 2 |
I am creating customer invoices using a form bound to a query called "Invoices Query". Invoices Query is bound to the "Customer Table". I would like to use the Lookup function in a text box to automatically fill in the billing date on the form for each customer.
|
| Report Subreport Question | 19 Feb 2008 18:38 GMT | 2 |
I have 3 reports that contain the same subreport. I am now trying to change the source in one reports subreport and it is changing the control source on all three. Is there any work around other than creating reports from scratch? Any help is truely appreciated.
|
| modify report | 19 Feb 2008 16:34 GMT | 6 |
I just realize that I need remove one field from my report and take out from report and my query. after I remove the field in both query and report, the report always ask me to fill the field removed.
|