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

Yes I have that working fine. It's just when it is not found I haven't figured out the best way to handle it.

That is what I like but the customer wants that last name first name middle name.

They will select the name and then enter new activity. The names are contained in tblrequesterdetails. The activity is in tblrecordlog. I have a unique id for the requester. I had it set up where they could enter Firstname Lastname. and the unique id would populate in the tblrecordlog. How would...

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

They will add their address type of business, etc. I did but a subform and made it visible for my solution but would like to know the correct way to do it.

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

I got it I was way to long thanks.

Just to clarify I use DoCmd.GoToRecord acForm, "frmpublicrecordslog", acNewRec to get to a new record.

So they have a new request and the click on the new record button to add data to all the fields. Requestnumber is on the form to be pubulated. Not the key field.

I want to click on the new request button have it populate the request number with the formulae above.

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

The best way I found to get the correct code is to open the form you want to use with the case number. Then go to your query under the case number and by the Criteria select build forms loaded forms and then the form you are wanting to use your selection from. Under the column Expression...

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

Thank you very much missingling. Worked on this all day yesterday before I posted the question.

It is only the names but some people have two last names. I thought I had it solved but the user didn't like the all caps.

I didn't say what the function was doing III because Iii and II will be come Ii. Thanks again.

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.