Recent content by starclassic

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

Thanks Remou, I change the date field on table to DateToday and works fine now. Thanks Again

DoCmd.RunSQL "INSERT INTO tblDraftEntry (FormIDEntry,COCodeEntry,BeginEntry,EndingEntry,Date) Values" _ & "('" & Me.cboFormNumber & "', '" & Me.txtCode & "', " _ & "'" & Beginning & "', '" & Ending & "', #" & Format(Now(), "mm/dd/yyyy") & "#)" Its still get me the same error.

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," _ &...

Thanks, ED...

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

Thanks dhookom, That work fine. I'm amaze, don't know how you guys know all those double quotations. Always learn something new each day.

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

Thanks Remou, Its working fine now.

Yes the form frmQueQue is open as button Private Sub cmdFirstContact_Click() and the txtStartCanDate and txtEndCanDate are on the frmQueue.

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

I could used a bound form but I just wanna give it a try first using the ADO if its the best route especially the data are access by quite a lot of people.

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