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
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
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.
Thank you June
No
I mean, I'm not reporting
I mean, in the form
In the language of Visual Basic 6.0
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.
Thank you june
I do not understand the language VB6
But one of the friends asked me to help
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.
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
Thank you Missinglinq