Search results for query: *

I have a need to produce a report where all of the names in a particular group show on the report even though all have not entered comments. My tables include “tblName”, “tblComments”, and “tblContracts”. tblContract - key field – Contract Number tblCommnets – key fields – Contract Number and...

Is it possible to convert a snapshot report generated by Access to Acrobat format so a user can download the report to his PDA? Thanks, Jackie [spineyes]

A Microsoft office push was done this week by our IT department and I think it may have something to do with my problem that we have had several experts working on since. I have a report in a database accessed from a button on a form. Since the push I have not been able to open the report and I...

I have a form for entering comments and a status. Works great for adding new comments but if a person has already entered a comment and status for a contract number, which is the key field, it is not reflecting the information. How can I have the form pull the comments already entered for a name...

I have a main form called Contract Data that contains contract information and on that form I have four pop-up forms all coming from the same query. The four pop-up forms are Trade-Ins, Concessions, Credits, and Pricing. There are totals on the Trade-Ins, Concessions, and Credit pop-up forms...

My users want symbols to print out on a report; a red hexagon, yellow triangle, or green circle. Is this possible and can it be stored in the database. How do I do this? What is the code? Thanks, jrtaylor

I have been working in the backup of a database developing additional forms and reports for the last couple of weeks while users have been working in the original database. My question is probably very basic, but is there an easy way to compare the table contents of the two databases so I can...

I have a report created from a query where labels are visible or not depending on the model. When the report is previewed it is exactly the way it should be but when it is mailed the first sheet shows all of the labels regardless of the model. How can I set the mailed report to look exactly the...

I have a database where there is the same key field in most of the tables. I have a form where a new record for the key field is added. How can I automatically have all the tables updated when a new record is added to the key field without bringing all the tables into the query of the form...

I have a form created using a query where nine payments are tracked by date. There is also a total payment field. My form is totaling the payments because of the following in the Control Source of the properties for the “Payment Total”...

1. This is really puzzling me. I have a Combo Box on a form that is not updating one of the tables in the query that created the form. The combo box contains four columns: Name, Group, Area, and QuestionbyGroup. Three of the fields are now text fields. For example txtgroup = Combo76.Column(1)...

I have a form with an option box that says “Approve with Comments”, “Disapprove With Comments”, and “Approve Without Comments”. I want a message to pop-up when the reviewer clicks on the “Submit Comments” button or the “Exit” button of the form to remind the reviewer that comments are required...

Synchronizing fields on a form. I have a form where comments will be entered. I have a ComboBox on the form that looks up values in a table named “tblName”. Also in the “tblName” are other values I want looked up based on the name that is selected in the ComboBox. These values include Group...

I have created a form that most of the data will be hyperlinked. In my table are hyperlinked-formatted fields. These fields are hyperlinked to documents related to a contract and the contract is the key field. Is there a way to open a hyperlinked field of a document hyperlinked in the table with...

I have an Access form where documents are hyperlinked but sometimes there is not a document for the reviewer to review. Is there a way to have a button or rectangle change color when a hyperlink has been added so the reviewer will know when a document is available? If the button or rectangle...

I developed a report in Access 2000 that a snapshot is sent out on a weekly basis to a distribution list. There have been several people complain that they are unable to open the report as a ".snp" file. Their PCs have Windows 98 and Office 2000. What could the problem and is there a...

I have an Access Form that I am adding a date when the review of the hyperlinked data must be complete. Is there a way to have the date flash so it gets the reviewers attention or is there another way to draw attention to the due date on the form? Thanks, jrtaylor

I want a report I have created in Access 2000 to have the current date the report is being mailed and the name of the report assigned when the button for mailing the report is selected. Is this possible? If this is possible the person receiving the report can save the attached report that has...

I have created an Access report where labels appear only on certain criteria. In the report preview the labels appear or not appear appropriately but when I mail the report as a snapshot one label keeps appearing. Why? All of the other labels behave, as they should.X-)

I have an Access Database that generates a report. Last Friday the report worked fine on anyone's PC that viewed and/or ran the report. Yesterday 3 or 4 people who could run the report on Friday now get the message below. Currently several are still able to generate the report including myself...