User Profile

Collapse

Profile Sidebar

Collapse
Phil Frankel
Phil Frankel
Last Activity: Oct 10 '12, 11:54 AM
Joined: Jan 15 '12
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Phil Frankel
    replied to filtering on a date field in Access using VB6
    in Visual Basic
    Thank you both. The BETWEEN syntax works fine as part of a SQL statement, but in VB6 (using DAO), it doesn't seem to be accepted as part of a Filter.
    Anyway, I have resolved it to my satisfaction now, and once again, thanks for your input and thought provoking ideas.
    cheers
    Phil
    See more | Go to post

      Leave a comment:

    • Phil Frankel
      started a topic Read-only data instead of Updatable records
      in Visual Basic

      Read-only data instead of Updatable records

      Hi all,

      I am having trouble with DAO (VB6) reading an Access database. I keep getting a "read-only" recordset instead of Updatable one.

      Code:
            Set qdfLocal = dbsCurrent.OpenRecordset(myQuery, dbOpenDynaset)
      the help file suggests that the Jet engine can't create an editable recordset, but I don't know where to look for the error.
      This code works in other parts of the application...
      See more | Go to post
      • Phil Frankel
        replied to filtering on a date field in Access using VB6
        in Visual Basic
        Good point, thank you.
        See more | Go to post

          Leave a comment:

        • Phil Frankel
          replied to filtering on a date field in Access using VB6
          in Visual Basic
          Hi all,

          Thanks for the input, but I have created a "work-around" as follows.

          Code:
            Do While Not rsDiv.EOF
     If Month(rsDiv!DateIn) > 6 And Year(rsDiv!DateIn) = FY or Month(rsDiv!DateIn) < 7 And Year(rsDiv!DateIn) = FY+1 Then
'   do stuff here
          many thanks to all who replied.
          cheers
          Phil
          See more | Go to post

            Leave a comment:

          • Phil Frankel
            replied to filtering on a date field in Access using VB6
            in Visual Basic
            Thank you gentlemen, but your idea didn't work either. My system date is set to Australia, so I don't usually have to worry about American date.
            I agree with Mike about the FilterOn property.

            many thanks for your input though.
            Phil
            See more | Go to post

              Leave a comment:

            • Phil Frankel
              started a topic filtering on a date field in Access using VB6
              in Visual Basic

              filtering on a date field in Access using VB6

              Hi all,

              I am having trouble with VB6 (running in windows7) talking to an Access database, and was hoping someone
              could help me locate the error.

              the database contains a "DateIn" field of type "Date" (short Date)
              I am reading the table into a recordset called "rsDiv"

              I am trying to read only records for the financial year, between [1 Jul (name the year)] to...
              See more | Go to post
              • Phil Frankel
                replied to image rollover
                in Javascript
                Thanks for the reply.
                I have 2 distinct elements. A <Div> called 'ImgBox' where I want the image to rollover, and a table.
                I want to be able to mouseover any cell of the 2nd column, which will trigger individual <a href="#" .... </a> links to change the image in the 'ImgBox'
                ie. row1, col2 --> Img1
                row2, col2 --> Img2 etc.

                I only used the alert() because I understood...
                See more | Go to post

                  Leave a comment:

                • Phil Frankel
                  replied to image rollover
                  in Javascript
                  Tried that too - did not work. I also tried removing the data from the 'ImgBox' and simply hid it - that worked.
                  See more | Go to post

                    Leave a comment:

                  • Phil Frankel
                    started a topic image rollover
                    in Javascript

                    image rollover

                    I want to "rollover" an image on a mouseover event, but the image is to be displayed in a different location from the mouse. The image will be in ('ImgBox') and the mouse can be in any cell in a specific column of a table -> giving diff. images.
                    My code follows, but doesn't work. Any help would be appreciated thanks.

                    Code:
                    function ShowImage(artImg) {
//    document.getElementById("ImgBox").src=artImg;
                    ...
                    See more | Go to post
                    Last edited by Dormilich; Jan 15 '12, 11:10 AM. Reason: please use [CODE] [/CODE] tags when posting code
                    No activity results to display
                    Show More
                    Working...