Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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