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]

I cannot open the report manually. I haven't tried opening the report query yet because Access shuts down when I try to open the report manually or with the button.

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...

The comments and status are stored in the same table and there are multiple comments/status records per contract number. The person must select his name from a combo box so when the comments are entered the person who entered the comments will be entered with the appropriate contract number. The...

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...

So what you are saying is I create another query which is an update query different from the query creating the form. This update query updates all the other tables. How do I get the query to run on the Form_afterInsert?

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”...

Ok, what am I missing here? The code was added but the table is not being updated. What code can I add to the code above to so the table is updated when the information is entered? I need the information in the Combobo to update the table. Thanks, jrtaylor

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)...

Thanks guys! That fixed the problem. As for the last line I had in there before, it was my own shot at fixing the problem. As you might have noticed I am new at this code business but the more I learn from Tek-Tips the more I am finding out how much more flexibility it gives you to accomplish...

WildHare, That worked great except if there are comments to be entered it still pops up with enter comments if there is a value in "txtComment". I tried the following but it did not work. Please help! Private Sub Form_Close() If Me!Frame87 = 1 Or Me!Frame87 = 2 And...

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...

Thanks! I am on my way now!

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...