Thanks guys, I have reverted to PDF as that was the only option.
Regards
User Profile
Collapse
-
Access 2007 Report Conditional Formatting
Please help: I have Conditional Formatting on a Report Field that fills the background Red if the criteria is met. This displays correctly in Report View, however, when I "OutputTo" this report to "Rich Text Format (*.rtf)", the colour is lost on the resultant RTF document when I open it up in Word 2007.
I would obviously like to retain the colours dictated by my Conditional Formatting criteria results when I output... -
ChipR, I am using queries to link multiple tables to get my data. I will try to create the calculation in my queries but they are already rather complex and any additions to the current queriws screws up my data. I will give it a bash though.
RuralGuy, I am running SP1, MSO (12.0.6320.5000 ). I will install the hotfix and see if this helps.
Thanks for the suggestions guys.Leave a comment:
-
Access 2007 Report Bug
Please help. This is driving me around the bend.
I have a report that I OutputTo Rich Text format but my Percentage calculations do not survive the conversion from the report to the saved document. Please see:
http://i56.photobucket.com/albums/g1...eportPrint.jpg
Has anyone encountered this before? I have many other reports and they all save correctly with all calculations intact.
... -
"You have done well, young Skywalker. Your training is complete" ;-)Leave a comment:
-
Nico, 1 last question: The operators that will use this system are complete technology Philistines and many of them can literally barely drive a mouse. Please can you tell me how I can replace the Right’click-Search process with a button that pops up a little form allowing you to enter the ID Number and the “Search” to execute the query. The result should still be displayed in the data sheet view.
I'm a little lost...Leave a comment:
-
Nico, you are BRILLIANT! Thanks so much for your help and patience. Your beer is in the mail ;-)Leave a comment:
-
Nico, we are talking past each other here :-)
I get the results you point out. However, the searches are repeated many times per hour, each on different ID#'s so the operator must be able to return to the full record set to enable him/her to do the next search on the full record set, not only on the previous match list.
I can click on the "Filtered / Unfiltered" button on the bottom taskbar but I would like...Leave a comment:
-
Ahh ok gotcha.
Problem is that the use of this is on a random query of the population to see if there are any matches on the recordset in the person's ID Number. Therefore a typed in search criteria will always have to be used as the operator is tasked with finding out of the random person in front of them has any records as listed in the WOA Table.
So the operator can right-click and select "Text Filters - Equals...",...Leave a comment:
-
GREAT! this works.
Only problem is, there is no way the operator can select the relevant record from a record set of 200,000 to 800,000 records on data sheet view. My original search function must still remain and the result of that search (Find Warrant) must result in your form "frmWarrantSele ction" with the matches found in the WOA record set in the Data Sheet view. I will play with what you gave me as I don't want to take...Leave a comment:
-
Looks promising but I get the attached error when selecting "Show Warrant scan" - maybe a VB class missing on my puter?...Leave a comment:
-
Here you go.
The relevant search (on the main Form) is "Find Warrant". Use the following 2 ID Numbers as examples:
7608245057081 - This should then link to the file 100286480000653 8.tif in a folder on the local machine
6508025786084 - This should then link to the file 100348480000777 8.tif in a folder on the local machine
Excuse my humble way of making the DB work but I have never done...Leave a comment:
-
Please note that the result of my Query (from an original table consisting of >250,000 records) contains 39 fields, only 1 of which contains a list of all the file names in the folder consisting of >250,000 .tif image files. I therefore must search for the correct .tif image file relating specifically to the record relating to that image. I currently have no way to access the correct 'tif file in my folder from the record listed on my Form....Leave a comment:
-
Maybe I must rephrase my question to ensure that I do not limit the scope of possible solutions to my problem:
How do I link to a file (with .tif extension, therfore an image file) from within the result set of a Select Query in Access 2007? The name of the file I need to open is listed in the result of my Select Query as a number only (without the .tif extension) and the .tif files are all situated in 1 directory on the local machine. In...Leave a comment:
-
Hi Nico, I have changed my search result to display on a Form as a Hyperlink. I can only assume I need VB code to now go and search for the matching record with the file name of the Hyperliunk in a directory on my local machine? Thie matching file will have a .tif extension. Can you or anyone help me with the VB coding to pount to
1. a spesific directory or
2. just the Common Dialogue to Browse to the directory where the file with...Leave a comment:
-
Thank you for understanding Stewart. My query is not covered in any of the online Access Help documentation I could find so help on this issue will really be appreciated.Leave a comment:
-
Search in Access
Me again. Please tell me how I can do the following: I have a report listing the results from a number of fields from a query result. The 1 spesific fileld results must be displayed as a hyperlink on my report (this I have done). When you click on the hyperlink, the following should happen:
The file name in a specific directory on the local machine must be searched and the file name that corresponds with the name of the hyperlink must be opened.... -
hehe ok I included this library. Thanks so much for al you help and patience...Leave a comment:
-
ADezii, now I am lost.
Regarding the "Microsoft Excel XX.X Object Library", what do you mean ? Surely this is correct as I have indicated before?
Regarding "Microsoft Access DAO X.X Object Library", the closest reference I can get to this is here and then get the accompanying error when trying to activate it.
Am I smoking my socks here?...Leave a comment:
-
The attachment is my entire DB for this project. Humble but there you have it ;-)
There are intricacies on the files that are imported as the original data but that is not relevant for your testing, unless you really want to be bored with the details....Leave a comment:
No activity results to display
Show More
Leave a comment: