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

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

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

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

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

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

I am sure there is a simple answer, but I can't find it. Is it possible to use an "in" statement in code? I don't want to use multiple "or"s, but "in" doesn't work. Any help? Thanks

I am having an issue with a form that has run correctly for months and is now not working. Based on data entry in the main form, I am updating the record source of a subform that is not linked to the main form. I have been telling the subform to set the linkedchildfields and linkmasterfields =...

I am having an issue with a form that has run correctly for months and is now not working. Based on data entry in the main form, I am updating the record source of a subform that is not linked to the main form. I have been telling the subform to set the linkedchildfields and linkmasterfields =...