Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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