Recent content by boblife42

Thank you both for the help, it now works.

Hello all I am getting the following runtime error 2465 - Application-defined or Object-defined error when I run the following code. Private Sub sfrm_Image_Count_Enter() Dim rs As Recordset Dim strSQL As String strSQL = "SELECT * FROM tbl_Monthly_Estimate WHERE [ProjectID] = '" &...

Thank you that worked I feel silly for forgetting that, I had it written down.

Message: Runtime Error '3061' Too few Parameters Expected 1

pbaldy: Yes the field names in the code are what I have to use.

Neither of those worked

Kinda new to this language how would change it to a DAO.Recordset

Hello I am comparing an array word to two different tables if the word is in one of the tables then I increase the count of that word, if the word is not in either table I add the word to a specific table. I thought I had the code figure out but I am getting a Runtime Error, any help would be...

Thank you for that

You are wonderful that worked. Thank you, why did it need quotes for future reference.

When I set it to CurrentDb I get the error message that it cannot find the input table. I have double checked the spelling on the table name, any thoughts.

I am getting a runtime error 424 Object Required, for the following code Private Sub DescProblem_LostFocus() Dim rs As DAO.Recordset Set rs = dbs.OpenRecordset(tbl_TempDescWord) Dim strArray() As String Dim j strArray = Split(DescProblem) For j = 0 To UBound(strArray) MsgBox strArray(j)...

Hi, thank you for trying to help here is what I came up with and it seems to be working: Private Sub PayPeriod_AfterUpdate() Dim rs As Recordset Dim strSQL As String Dim i As Integer Dim strDayNum As String Dim strDayAMIn As String Dim strDayPMIn As String Dim strDayAMOut As String...

I can not store the date and time together, the date changes every two weeks the time in/out is a set schedule. That is the main problem, I have to store a changing value with a constant value.

I need to have the following time in/out code and a specific date for a two week period to populate a specific field in a form. The "PayPeriod" is the trigger for the event, I need help with the rest of the code to have the payperiod subtracted from 1 through 13 to get the correct work date...