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

    Inserting Record

    I have just converted an Access Database to SQL Server still using Access as the front end. I am having issues with a form that before the conversion workind fine. The form runs from a query that links the Individual Table with the IndCourse table. They are linked by Ind#. This is the...
  2. aggieval

    Selecting one record per individual

    I don't think so because I need the Top 1 for each IndCourseID, but I could very well be wrong.
  3. aggieval

    Selecting one record per individual

    I am linking based on an Individual Course ID that might be 123. The table that is finding the prerequisites for the course might find multiple records (the prereq might be 001.1 or 004.4) The query as is will find: IndCourseID, Cert Code, Cert #, Cert Date 123, 001.1, 12345, 1/1/03 123...
  4. aggieval

    OLE Server error

    I am having an issue on one computer when the user closes a form. The error says that there was a problem occured wile the database was communicating with the OLE server. This only occurs when this one form closes adn only on this one computer. This form is not using any linked tables or any...
  5. aggieval

    Selecting one record per individual

    I am trying to write a query that will select one record per individual where there is a possiblity that there are more. The problem is that I need it to select multiple fields from the one table and these fields have to stay together (Cert Code, Cert #, Cert Date). In Access I had this...
  6. aggieval

    Module not found

    Thanks, I found an older copy of the database that was working fine and imported all the forms that had changed since that version. It appears that one form was having issues and making problems for the entire database. I think I have it fixed now. Thanks again. Tracy
  7. aggieval

    Module not found

    I am having an error in a database that up to this point was running fine. When I try to run any form I am getting an error that says "Module not found." It is not taking me to any specific place to show where an error is occuring although it appears to be happening on forms with...
  8. aggieval

    Speed Issues on Form Open

    I am having speed issues when a form is opening. I believe my problem is that I have multiple sub-forms and combo boxes on the form. I believe that the form is querying every single combo box as it opens. Can anyone tell me if I am correct in my assumptions and how they have gotten around an...
  9. aggieval

    Using IF in SQL View

    Thanks a lot James. I got that to work. I really appreciate your help. Tracy
  10. aggieval

    Using IF in SQL View

    I am completely new to SQL, so I may bew doing this all wrong, so any advice would be incredibly helpful. That being said, here is my problem: I have converted and Access Database to SQL server, but am continuing to use my Access front end for the time being. I am converting any slow queries...
  11. aggieval

    Counting Specific Characters in String

    Does anyone know of a way to count the number of times a specific character appears in a string. I am looking for the character '&' in a field and want to know how many times it appears. Any suggestions would be great. Thank, Tracy
  12. aggieval

    Combo Box to Open Form

    That would be the simple solution, but my users like the double-click feature. We also don't have room on the form for another button. Any other suggestions would be helpful. Tracy
  13. aggieval

    Combo Box to Open Form

    I am having an issue with a combo box I use to open a form. What is happening is that a user can double click in the combo box to open a form that will edit the table that controls the combo box. Where I am getting an error is when the user has started entering data, but the data is not in the...
  14. aggieval

    Multiple Columns in One Record to One Column

    Thank you so much, even if it's not pretty, it should work. Tracy
  15. aggieval

    Multiple Columns in One Record to One Column

    I have a budget table with one record for each account and a field for each month. I would like to set up a query, for a report, that would put the data in a format so that each month's budget is in one column, a record for each month. Any suggestions on setting this up would be incredibly...
  16. aggieval

    Need query to pull records from unrelated tables

    Thanks r937. That is exactly what I needed. Thank You, Thank You. Thank You. Tracy
  17. aggieval

    Need query to pull records from unrelated tables

    I am trying to pull data from two tables that are relatively unrelated (I will be grouping by date). Basically I want to append data from these two tables without running a make Table/Append query. Help Please. Thanks, Tracy
  18. aggieval

    Seting Focus to Text Box after MsgBox displayed?

    I don't know if this will help, but I had a similar problem and ended up working around it by putting code in the next field that got the focus (in the on Got Focus Event) that is the previous field was null (I had set field value to null if invalid) the to set focus back to the field. Good...
  19. aggieval

    Enter Parameter Value

    No other code on the button. The only code that even refers to the field in question is on after update of another field.
  20. aggieval

    Enter Parameter Value

    I am now getting an error in a form that until this point has not had any problems and still works fine in Access 2000. In Access 2002, when a button is pushed that closes the form (docmd.close) it is asking for a parameter value for a field in the form. It does not do this if you close the...

Part and Inventory Search

Back
Top