Search results

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

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

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