Search results for query: *

Hello everyone, How do I query only the max date to show up on the database with 2 or more contacts. I have this query but it will show all record regardless of the follow update. I only need to show the up to date follow up date not the previous date. Any help will do. I try the...

DoCmd.RunSQL "INSERT INTO tblDraftEntry (FormIDEntry,COCodeEntry,BeginEntry,EndingEntry,Date) Values" _ & "('" & Me.cboFormNumber & "', '" & Me.txtCode & "', " _ & "'" & Beginning & "', '" & Ending & "', '" & Format(Now(), "mm/dd/yyyy") & "')" Not sure where the syntax error as it worked fine...

Hello everyone, I have this SQL Statement: 'Add record to first table contact to print the First Contact Letter DoCmd.RunSQL "INSERT INTO tblFirstContact (LName,Address,Address1,Address2,Address3,City,Province,PostalCode," _ &...

Not sure whats wrong with the statement.. StrSql = " SELECT *" _ & "FROM tblContact " _ & "WHERE tblContact.OtherExplain Is Null " _ & "And tblContact.GComments Is Null" _ & "And tblContact.ByPhone = 0" _ & "And tblContact.LeftMessage = 0" _ & "And...

hello I have2 table tblClient(main) and tblActivity. tblClient has the following fieldname. PolicyNumber -> Primary Key Name - Text Closed - Y/N tblActivity ActivityID - Auto Number PolicyNumber - Integral relationship to tblClient(main) Comments - Memo Paid - Currency. Now how do I move...

I'm getting syntac error on this RunSQL DoCmd.RunSQL "UPDATE tblCollectionsData Set tblCollectionsData.ContactMain = 1 WHERE (tblCollectionsData.PolicyNumber) = " & rst![PolicyNumber]

Hello eveyone, I created a query below and supply the date from form frmQueue but when clicked on firstContact button gives me a error. debug would show on Set rst = dbs.OpenRecordset("qryFirst") Any help greatly appreciated. ~~~~~~~~~~~~~~~~~~qryFirst~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ SELECT...

Hi, Im still fairly new with ADO, but I have a back end database (tesing.mdb) with table tblCollectionsData and tblAdjustments which both have a relationship base on policynumber. Front end have mainfrm(tblCollections) and subform (tbladjustment). I Have these code to connect to database and...

Hello everyone, For some reason the txtExpDate_AfterUpdate() does not carry the date to next record. If date is entered manualy will work but if I choose the date from the form Calendar thats pop up when click doesn't carry the value to next record. Any Ideas.I try everything and seems not...

I need help on expression builder on the report. Needs to reformat the output for policy number when opening the "credit" report. the field strPolicy on table is showing like this 601234567 Output on report if strCompany = "A" then strPolicy = 1234567-60 Else strPolicy 60-1234567. I'm not...

I have a lot of email address with this format jane.doe.abcd@companyname.com wants to write a funtion and results will be like this --> Jane Doe Any Idea?

Here's my sql statement to update yes/No and date where IndexID(primary key) is the current record selected. DoCmd.RunSQL "UPDATE tblCreditDetails SET tblCreditDetails.ysnSentByMailToStaff = -1, tblCreditDetails.dteFUDate = Date() WHERE (tblCreditDetails.IndexID = '" & Me!txtIndexID1 & "')"...

I have this code right now but is not working properly. If I query for the date between and particular agent code, it display all of date between and the agentcode which i did not want to display. It works fine if I want to search for agent code alone and blank the date and vice versa. If all...