Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by starclassic

  1. starclassic

    Query max value of Followupdate

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

    Syntax error into Insert Statement

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

    Syntax error into Insert Statement

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

    Syntax error into Insert Statement

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

    Apostrophe and Null Values

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

    SQL Statement syntax error

    Thanks, ED...
  7. starclassic

    SQL Statement syntax error

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

    How to transfer data to another table when closed = yes.

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

    SYntax error

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

    SYntax error

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

    Recordset error Too few parameters. Expected 2. (Error 3061)

    Thanks Remou, Its working fine now.
  12. starclassic

    Recordset error Too few parameters. Expected 2. (Error 3061)

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

    Recordset error Too few parameters. Expected 2. (Error 3061)

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

    ADODB relationship table not working.

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

    ADODB relationship table not working.

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

Part and Inventory Search

Back
Top