Recent content by timoteo

JonFer, Thank you for the advice, you were right on. When I got the results into Excel I found three Birth Dates with garbage data in them. Once I corrected them, the query ran without a hitch. Thanks again

I am trying to run a query that returns individuals born after 1/1/1994. I am working with a legacy database and the birth date is stored as text. I was able to convert the records to date format using CDate. However, when I include a search parameter for people born after 1/1/1994 I get a...

SkipVought, I was able to get it to work using your code. Thank you. SELECT tblMutualAid.DispatchDate, tblMutualAid.FirstDispatchTime, tblMutualAid.CallNum, tblMutualAid.Unit, tblMutualAid.OnSceneTime, [FirstDispatchTime]+IIf([FirstDispatchTime]-[OnSceneTime]>0,-1,0)-[OnSceneTime] AS [Mutual...

SkipVought, Thanks for the advice on DateDiff function. It was the first thing I tried and it did not work for two reasons. First, it does not return the correct time if the two times span midnight and second it will not allow me to format the time the way I need it. DateDiff will only...

SkipVought, Here is he code you requested: SELECT tblMutualAid.DispatchDate, tblMutualAid.FirstDispatchTime, tblMutualAid.CallNum, tblMutualAid.Unit, tblMutualAid.OnSceneTime, tblMutualAid.FirstDispatchTime-1-tblMutualAid.OnSceneTime AS [Mutual Aid Response Time] FROM tblMutualAid WHERE...

I am trying to use Access to generate a report that will list the average time difference between two events by month. At first I tried using a calculated field in my query then group by month in the report and use an unbound control and the Avg() function in the group footer. My formula in...

I think I found a solution. I used the Update Method for the recordset and trigger it with the LoseFocus Event for the datagrid. Private Sub dgdMain_LostFocus() rsSubMain.Update End Sub Thanks ArtieChoke for pointing me in the right direction.

imterpsfan2, Excellent suggestion, at first I thought that was the problem too. I tried this trick and still got the error: If rsSubMain.State = 1 Then rsSubMain.Close End If This way the program will only try to close the recordset if it is open. ArtieChoke, Thank you for the reply. I...

I have some code that allows users to filter a list of street address. It works fine except for when a user makes changes to a record then goes to search for a street. I get error number 3219 "Operation not allowed in this context". And the program stops on the Close method (see code below...

I recoded the last name search to requery rather than use the filter method. It works very fast; eventhough there can be a maximum of 13,000 records. zemp, that is a very interesting link. I will keep that in mind just in case I notice performance lags as the database grows. Bob, zemp thanks...

Now I think I understand what you are talking about. On each keypress I should close the recordset then reopen it using a query based on the user's input. And what you are *not* talking about is the Requery Method of the Recordset Object (i.e. rsSubMain.Requery). I will try that and let you...

Bob, Zemp, Thanks for the suggestion on the requery. I must admit that I am unsure how to use the requery method to achieve my goals. My only experience with this method is using it to refresh a recordset based the query that originally defined it. Could you point me in the right direction...

Bob, Thanks for the excellent tip. Unfortunately, it did not help in this situation. I think the problem has to due with the recordset being empty because as long as there is data in the recordset the filter works very fast, with or without an index. I found a partial work around using the...

I am using the code below to filter a list of names that appear in a datagrid. As the user types in the letters of the last name, the program filters the recordset to those records that start with the letters typed in. The code works fast as long as there are records in the recordset...

netadmin19355, Yes I did find a solution. The Exchange System Manager does not always report the proper information. There are 2 ways to check: 1. Look in the Add/Remove Programs and see if the roll up appears there. 2. Look at the properties information for any file that is updated by the...