Results 1 to 8 of 8
  1. #1
    azhar2006's Avatar
    azhar2006 is offline Expert
    Windows 7 32bit Access 2007
    Join Date
    Mar 2012
    Posts
    528

    start date and the end of date VB6

    Hello all


    How do I work search form for the start date and the end of date but in the language of VB6
    What is the lines of code VB6
    Any help
    Thank you

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Do you mean VBA?

    Do you have two unbound textboxes for user input of start date and end date?

    Do you want to build filter criteria for a form or report?

    Something like:

    DoCmd.OpenReport "report name", , , "[date field] BETWEEN #" & Nz(Me.tbxStart, "1/1/2000") & "# AND #" & Nz(Me.tbxEnd, "12/31/2900") & "#"
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    azhar2006's Avatar
    azhar2006 is offline Expert
    Windows 7 32bit Access 2007
    Join Date
    Mar 2012
    Posts
    528
    Thank you June
    No
    I mean, I'm not reporting
    I mean, in the form
    In the language of Visual Basic 6.0

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    VB6 and VBA are very similar. Why are you asking about VB6 in an Access forum? VBA is the programming language for MS Office products.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    azhar2006's Avatar
    azhar2006 is offline Expert
    Windows 7 32bit Access 2007
    Join Date
    Mar 2012
    Posts
    528
    Thank you june
    I do not understand the language VB6
    But one of the friends asked me to help

  6. #6
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    As I said, the languages are very similar. Much of the vocabulary and syntax is the same. There are plenty of books on VB6 programming. I bought 3 used ones from Amazon for less than $10 total. They helped learn VBA.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  7. #7
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,016
    VBA for Access is derived from VB6, and as June7 said, much of the vocabulary and syntax is the same, but at the same time, much of it is different! Functions are particularly troublesome, as both languages use a great many Functions that have identical names, but work entirely differently!

    It's been a while since I worked in VB6, but I believe you'll find that searching in VB6 is going to be very different from doing the same with a Bound Form in Access. If you google using the search terms 'search records VB6' you'll get a slew of hits. You might also look at these forums for help:

    http://forums.codeguru.com/forumdisp...-0-Programming

    http://www.vbforums.com/forumdisplay...-6-and-Earlier

    http://www.vb6.us/forums/general-visual-basic-questions

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  8. #8
    azhar2006's Avatar
    azhar2006 is offline Expert
    Windows 7 32bit Access 2007
    Join Date
    Mar 2012
    Posts
    528
    Thank you Missinglinq

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 12
    Last Post: 01-23-2014, 03:24 PM
  2. Replies: 3
    Last Post: 03-15-2013, 03:16 AM
  3. Replies: 15
    Last Post: 04-06-2012, 10:57 AM
  4. Replies: 1
    Last Post: 07-07-2010, 04:22 PM
  5. Replies: 1
    Last Post: 12-09-2005, 10:29 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums