Search results

I try not to name fields with spaces in them - too easy to get errors. try DoCmd.OpenForm "ProvidersF", , , "[Provider ID]= " & Me.ProviderList i will check similar code when i get home but try that. .

I have a couple screens like this. When i save the data on the details screen, i close it and use the code below to refresh the list screen Private Sub Form_Activate() Me.Requery End Sub

Hi Spike, i figured it out. On my select statement i am only retrieving the ID field and in my edit statement i am trying to update another field that isn't in the recordset. I agree with the datediff function - i just ran across that and plan to use it. Thanks very much for responding to my...

Thanks for replying Spike, I am not having a problem with the query - it finds that the record exists - i am getting the error when it hits the rsLogout("DateOut") = Now() line. I am not splitting the date/time s up - i capture the date/time logged in using a general date/time format and i...

Hi, i am trying to update a loginout table with the date/time out but i am getting an item not found in this collection message - here is the code. Dim MyDB As DAO.Database Dim rsLogout As DAO.Recordset Dim MyQuery0 As DAO.QueryDef Dim strSQL As String Dim stDocName As String...

Hi Everyone, I am from Edmonton, AB Canada current temp is -20C I took Computer Programming at NAIT but that was 12 years ago I am just getting back into doing some work with Access 2010 A lot of new stuff compared to what i learned. Hope to meet a lot of great people here (or at least...