User Profile

Collapse

Profile Sidebar

Collapse
ruvi
ruvi
Last Activity: Jul 3 '07, 12:22 PM
Joined: Apr 3 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • ruvi
    started a topic What's wrong with this sql query which uses a date range?(I'm getting a syntax error)
    in Visual Basic

    What's wrong with this sql query which uses a date range?(I'm getting a syntax error)

    Hi,

    I am using Vb 6 and Access.
    I am getting syntax error in the following sql query.

    strSql = "SELECT tblInvoice.Proj ID,tblInvoice.C usID,tblInvoice .InvoiceNo,tblI nvoice.InvDate, tblInvoice.Tota l,tblInvoice.Pa id,tblInvoice.B alance,tblCusto mer.CustomerNam e FROM tblCustomer RIGHT JOIN tblInvoice ON tblCustomer.Cus ID=tblInvoice.C usID WHERE tblInvoice.InvD ate >= #" &sDate& "# AND tblInvoice.InvD ate...
    See more | Go to post
    • ruvi
      replied to DateTimePicker control - how to display a blank date when the form loads?
      in Visual Basic
      But, the checkbox also gets displayed. Is there anyway to do it without displaying the checkbox?...
      See more | Go to post

        Leave a comment:

      • ruvi
        started a topic DateTimePicker control - how to display a blank date when the form loads?
        in Visual Basic

        DateTimePicker control - how to display a blank date when the form loads?

        Hi,

        I have a datetimepicker control in my form. It works fine except for one thing-
        Its default value is automatically set to today's date. I want the control to be blank when the form loads.
        Can you please point me in the right direction about how to do this?

        Thanks for your time.
        See more | Go to post
        • ruvi
          started a topic Listbox - Help needed
          in Visual Basic

          Listbox - Help needed

          I have a listbox with style property set to 1-Checked.
          I populate the listbox with records in a recordset.
          Then I select some of the items in the listbox.
          Now what I want is- I want to be able to display the listbox with the selectd items having their checkboxes ticked every time the listbox is loaded.
          Help please..
          See more | Go to post
          • ruvi
            replied to Runtime error 3021- Either BOF or EOF is reached , unable to resolve this
            in Visual Basic
            Thanks for ur time guys.

            Strangely I get the runtime error only while clicking on the first project in the combobox, and not while clicking the second or third or fourth project or any subsequent projects. Why is this so?

            Also, after Recordset.reque ry, I am able to print all the records(project s) in
            the recordset. It means that the recordset is not empty, isn't it? Then why is it that I am getting the error...
            See more | Go to post

              Leave a comment:

            • ruvi
              started a topic Runtime error 3021- Either BOF or EOF is reached , unable to resolve this
              in Visual Basic

              Runtime error 3021- Either BOF or EOF is reached , unable to resolve this

              I am getting runtime error 3021 - Either EOF or BOF is true or the current record has been deleted.....
              I have 2 combo boxes in a form- One for the client and the other for the project.
              When the form loads, the client combo box gets populated with all the clients.
              When a particular client is clicked, the project combo box gets populated with all the projects corresponding to that client.
              So far, so good. Now when I click...
              See more | Go to post
              Last edited by Killer42; Apr 5 '07, 03:16 AM. Reason: Please use [CODE]...[/CODE] tags around your code.
              No activity results to display
              Show More
              Working...