Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: xhat
  • Content: Threads
  • Order by date
  1. xhat

    Char count with RegEx

    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...
  2. xhat

    Like Operator

    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*"...
  3. xhat

    Getting Sums on Records

    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...
  4. xhat

    Visible Property and Option Groups

    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...
  5. xhat

    Do Loop Using .Bookmark as Test

    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...

Part and Inventory Search

Back
Top