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

    Rebuilding Index

    I'm new to working with Informix database administration, and I understand from our vendor that we can improve system performance by rebuilding indexes on a couple of tables that are fairly fragmented. I've looked at the list of tables that our vendor recommends and they are not used in...
  2. TracySHC

    Arrow with Diagonal Stripes

    I'm new to Visio 2010, and have two diagrams with a variety of arrows - some arrows are two-way, some arrows are one-way. However, about 7 of the 26 arrows have dark spots on them, as if there's a diagonal stripe going through them. This does not show on the screen, but shows on color and...
  3. TracySHC

    Upgrade 8.5 Crystal reports to XI

    My organization has just purchased Crystal Reports XI Release 2. We are attempting to migrate over our reports written in Crystal Reports 8.5. So far, the links to the files are shown in the Database Expert, but the SQL query for the report does not show the joins between the files. As a...
  4. TracySHC

    Access 2003 Form Error Message

    TheAceMan1, seaboard, Yes, I did mean style and not background. The list of styles for the form is empty. There is a directory of styles available on my hard drive, but how do I redirect Microsoft Access 2003 to use this directory? (I haven't had this problem with other Access projects.)...
  5. TracySHC

    Access 2003 Form Error Message

    I am currently building a new form in Microsoft Access 2003 over a table. When the Form Wizard reaches where the background can be selected, I receive the error message "Compile error. in query expression...
  6. TracySHC

    Combo Box concern

    dhookom, That did it! Thank you very much, TracySHC
  7. TracySHC

    Combo Box concern

    dhookom, Is it significant that the combo box be dependent on another field on the form? As for code when the student id changes, what do you suggest? Courses does have a CourseID primary key - I let Access automatically add this field. I did not want to take a chance that a student...
  8. TracySHC

    Combo Box concern

    dhookom, CourseID is the same as course number. The Courses table is a list of all of the courses taken by each student. This way, the tutor is constrained to enter only the courses taken by the entered student. (The complete course list is not available.) Therefore, what I need from the...
  9. TracySHC

    Combo Box concern

    dhookom and randy700, I have 3 tables in this database: EntryInfo - student id#, student name, tutoring time, tutoring day, course needed for tutoring, etc. Students - student id#, student name Courses - student id#, course EntryInfo is linked by student id# to both Students and Courses The...
  10. TracySHC

    Combo Box concern

    Randy700, I'm working on a tutoring database. The fields on the form are being populated by the tutors. I'm creating updates for some fields based on the student's id number, to pull in student name, etc. The combo box is to hold the courses for the student during the current session. It...
  11. TracySHC

    Combo Box concern

    PHV and dhookom, If I do not need the lookup in the table, then how do I proceed to have the combo box work? I don't have either working at this moment - they're both blank. What am I missing? What should I check? Thank you for your help and advice, TracySHC
  12. TracySHC

    Combo Box concern

    PHV, Thank you for your response. I have changed the text field to a lookup field, but the field and lookup are blank in the table. What am I missing? Thank you for your help and advice, Tracy
  13. TracySHC

    Combo Box concern

    Currently, I have a Microsoft Access 2003 form built over an Access table. For one of the text fields, I need the field on the form to be a combo box. At this point, I cannot populate the combo box's options. Is this due to the text field in the table not being a lookup field? I have tried...
  14. TracySHC

    Access 2003 shuts down when field is added to form

    I'm trying to add a new field to a form. The form is built off of a table. However, when I open the form, change the view to design view, open the list of fields, and add the field to the form, the Access 2003 project shuts down with the error message: "Microsoft Office Access has encountered...
  15. TracySHC

    Best practice for hidden fields on form

    dhookom, Thank you for your insights. How does the combo box selection update the underlying field in the table? Do I write code for the After Update property? Thanks again, TracySHC
  16. TracySHC

    Best practice for hidden fields on form

    dhookom, Would this SELECT statement, when the combo box is populated, also update the field in the underlying table? Why do you choose this method rather than making the field in the underlying table a lookup field? Thank you for your advice and insights, TracySHC
  17. TracySHC

    Best practice for hidden fields on form

    dhookom, seaport, seethru, Thank you for your advice, and thank you, dhookom, for the link to document tables and relationships. Simply put, the tables that I am working with are: Customer Table: Customer ID, Name, Billing Address Line 1, Billing Address Line 2, Billing City, Billing State...
  18. TracySHC

    Best practice for hidden fields on form

    dhookom, How do you need for me to explain? Thank you, TracySHC
  19. TracySHC

    Best practice for hidden fields on form

    dhookom, Thank you for your suggestions! I've had the DLookup function working for testing, and currently have it in limited production. By the way, what would be the best practice for a visible field if a customer id had multiple sites? (For instance, Fedex has multiple stores in certain...
  20. TracySHC

    Best practice for hidden fields on form

    dhookom, The hidden field is a text box. It should be populated when the customer identification number field is populated. (The customer identification number is key to pulling in the residence information in the customer table.) Right now, I am trying to use a SQL statement to update the...

Part and Inventory Search

Back
Top