Environment: Win XP
Access 2000
Microsoft VBScript Regular Expressions 5.5
I'm teaching myself regular expressions, so I'm starting slow. I want to test for the presence of a defined number of occurrences of a particular character. For example, if the string were...
Working in Access 2000 on XP box:
VBA code uses Select Case structure to search a text file for a string pattern...
Do Until StrComp(PSrsc.Fields("Field1"), "NEW HAND", vbBinaryCompare) = 0
bnDeadHand = False
Select Case True
Case PSrsc.Fields("Field1") Like "*collected*"...
Working in Access 2000.
A table records, among other things, the date a transaction was entered, and two currency fields. The goal is to Sum the two currency fields based on their common dates. So, for example, let's say I had three entries all occurring on 2/1/10:
Example A
1) field1...
Hi. I have an option group, and based on the option chosen in the group, I want certain labels and textboxes to have their visible property set to True (the default on the form is False). So I wrote the code below:
Private Sub Frame13_AfterUpdate()
If Me.Frame13.Value = 4 Then...
I'm calling a sub that takes 3 parms - a DAO Recordset object, and two variants that have been set equal to .Bookmark property in a previous sub. The two variants are called StartPoint and StopPoint respectively. I clone the recordset object (rsc), and set rsc.Bookmark = StartPoint. This...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.