Search results

I need to delete the records that come from this query SELECT qryforlastactivityyesterday.EmpName, qryforlastactivityyesterday.LastOfDateDBActivity FROM qryforlastactivityyesterday INNER JOIN qryforyesterdaysreport ON (qryforlastactivityyesterday.EmpName = qryforyesterdaysreport.Employeeeod)...

I have 3 combo boxes, LastName, FirstName, MiddleName. Customer wants to be able to select lastname, firstname, then middlename(Optional) how do I populate tblrequesterdetails with all three names. I have used notinlist event with one combo box but haven't used it in this situation. Customer...

I select from names in combo184. If the name is not in the list I found this code that works Dim strTmp As String 'Get confirmation that this is not just a spelling error. strTmp = "Add '" & NewData & "' as a new Requester?" If MsgBox(strTmp, vbYesNo + vbDefaultButton2 +...

Client wants to populate leading request number based on 20130001 ... 20130010..20130999...20131000 and so forth I have the code Public Function Leadingzeros(StrTable As String) Dim db As DAO.Database Dim rec As DAO.Recordset Dim rec1 As DAO.Recordset Dim mycount As Integer Dim RequestNumber...

I am trying to delete a record in tblinclude where record from tblexclude are equal to clientid and codeid Here is the sql DELETE tblinclude.ClientID FROM tblexclude INNER JOIN tblinclude ON (tblexclude.ClientID = tblinclude.ClientID) AND (tblexclude.CodeID = tblinclude.CodeID) WHERE...

I am using a function I found at it works most of the time Except WHen a Name Has a suffix like your name III will change to Your Name Iii. Here is the function Function Proper(X) 'Capitalize first letter of every word in a field. Dim Temp$, C$, OldC$, i As Integer If IsNull(X) Then...

Thanks for letting me join the group. I am constantly amazed at how many business still use Excel and not Access. I am looking forward to helping others get their answers and also others helping me.