Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jrtaylor

    Report 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...
  2. jrtaylor

    Snapshot Report Converted to Acrobat

    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]
  3. jrtaylor

    MSACCESS.EXE - Application Error

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

    MSACCESS.EXE - Application Error

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

    Problem Adding Comments/Editing Comments in a Form

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

    Problem Adding Comments/Editing Comments in a Form

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

    Syncronizing Forms

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

    Symbols on an Access Report

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

    Table Comparison Between Databases

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

    Access Report Mystery

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

    Updating Tables from a Form

    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?
  12. jrtaylor

    Updating Tables from a Form

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

    Form is not Updating Table

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

    Combo Box is not updating Table

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

    Combo Box is not updating Table

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

    Field Validation When Closing a Form

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

    Field Validation When Closing a Form

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

    Field Validation When Closing a Form

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

    Synchronizing other Form fields with a Combo Box?

    Thanks! I am on my way now!
  20. jrtaylor

    Synchronizing other Form fields with a Combo Box?

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

Part and Inventory Search

Back
Top