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

    Data type mismatch with a calculated column

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

    Data type mismatch with a calculated column

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

    Cannot Average Time Difference

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

    Cannot Average Time Difference

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

    Cannot Average Time Difference

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

    Cannot Average Time Difference

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

    "Operation Not Allowed in this Context" Error

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

    "Operation Not Allowed in this Context" Error

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

    "Operation Not Allowed in this Context" Error

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

    Any ideas to speed up filter of a recordset?

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

    Any ideas to speed up filter of a recordset?

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

    Any ideas to speed up filter of a recordset?

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

    Any ideas to speed up filter of a recordset?

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

    Any ideas to speed up filter of a recordset?

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

    Installing Exchange SP3 Rollup questions

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

    Installing Exchange SP3 Rollup questions

    I am trying to install the SP3 Rollup. I downloaded this file: Exchange2000-KB870540-v2-x86-ENU.exe and double clicked on it. It decompressed several files, shut down some services, and then installed the files. I then rebooted the server. However, when I view the server properties under...
  17. timoteo

    "Server has not yet been opened" error

    Thanks for the suggestion BiggerBrother, but I was not able to get it to work using "save as". vidru, you were right on with your suggestion. Thanks to the both of you for taking the time to post. Timoteo
  18. timoteo

    "Server has not yet been opened" error

    I have VB application that manages a SQL Server 2000 database. I also use a CRViewer control to allow the user to view and change reports designed in Crystal Reports 7.0. The reports display fine, however when a user clicks on the refresh button it displays the following error message: "Server...
  19. timoteo

    Question about moving parts of network

    netmanrick, These 4 PCs will be the only ones to move and the move itself is just temporary. Thanks for the suggestion. Timoteo
  20. timoteo

    Question about moving parts of network

    bcastner, Thanks for the information. Timoteo

Part and Inventory Search

Back
Top