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

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

Here's final code Private Sub txtExpDate_AfterUpdate() If IsNull(Me.txtExpDate) Then Exit Sub ElseIf CDate(Me.txtExpDate) < CDate(Now) Then MsgBox "Expiration date entered should be greater than date today", vbInformation, "Lunch Voucher" Me.txtExpDate = ""...

I will post it after I clean up all the bugs out... Thank

After trial and error I was able to get it workin. Thanks...

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