Recent content by Lory

Thank you! I knew there was an easy way to do it...but I couldn't remember how! Thank you so much! Lory

I have a query based on an imported table that I would like to sort the records on it by date. However, the date field is actually a date/time stamp. Is there a way to extract just the date without the time? I certainly hope so!

I have a small database that we've just started using here at work. Every now and then when someone tries to access it they get the following error: "The database has been placed in state my user 'Username' on machine 'machine##' that prevents it from being opened or locked" I have tried to...

thank you I actually found my error last night. It helps if one spells the name of the fields correctly. I checked that yesterday before posting here, but when I looked at the printout of my code some time later at home...there it was plain as day! Thank you for the suggestions anyways!

I have the following code I'm trying to execute. Private Sub cmdSave_Click() Dim cnnLocal As New ADODB.Connection Dim rstCurr As New ADODB.Recordset Dim fldCurr As ADODB.Field Dim strTest As String strTest = "None" Set cnnLocal =...

What I want... Actually, I have a query that is based on what is selected in the combo box. I would like to update the text box with the result of that query if at all possible.

I know that a combo box can be updated using a query. But, is there any way to update a text box from a query? What I would like to do is have that box filled in automatically based on the change of a combo box, but I cannot seem to make it work with a text box. I did it using a list box, but...