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!

Register Log in
  • Congratulations derfloh 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
  • Order by date
  1. xhat

    Char count with RegEx

    strongm, Thanks for pointing out that error with my test of .Test. Completely missed the the quote marks. When I properly referenced the variable, tsuji's pattern did, indeed, work correctly. I'm still not convinced that what I'm looking for in a string is not a pattern. As you've probably...
  2. xhat

    Char count with RegEx

    A word about the choice of which forum to post in: Microsoft themselves cannot seem to make up their mind about where regular expressions live. If you follow this link to the Regular Expression introductory page on the MSDN website http://msdn.microsoft.com/en-us/library/28hw3sce.aspx, you'll...
  3. xhat

    Char count with RegEx

    tsuji, I'm going to cut and paste my test code and output. I don't believe I have any transcription errors, but it is possible, I realize. Code and output with .Count: Public Sub SeeHand() 'Test sub to get hand data and sort it Dim rs As DAO.Recordset Dim rsq As DAO.QueryDef...
  4. xhat

    Char count with RegEx

    tsuji Thank you for the post and the possible solution. My need is not to search for a particular character in succession within a string, but rather to search for a particular count of characters within a string, no matter where they appear in the string. The Sub code snippet's purpose is...
  5. 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...
  6. xhat

    Like Operator

    Thank you both for looking into this. My thoughts regarding the pound, at first, was that the pattern would match on any of the alpha chars listed, or any number. As I read more online, I began to suspect that the pound should fall outside the brackets to work properly, but that made me start...
  7. xhat

    Like Operator

    Never mind. I figured out the issue. Replaced the '#' with 2-9, so that the new search pattern looks like... [AKQJT2-9]. Why this works, I have no idea, since in theory, using the old pattern with the pound should have produced results in the case of [AKQJT] holdings, but apparently having the...
  8. 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*"...
  9. xhat

    Getting Sums on Records

    PHV, I used CLng() on the dates, but because the dates had time stamps in them, the conversion of the dates to longs was generating different values for the same dates. Thus, the summing was coming out incorrectly. In other words, 3 of the 4 1/24/2010 dates, for example, were being converted...
  10. xhat

    Getting Sums on Records

    PHV and smedvid, It is a date formatting issue. CLng() produced some results that "appeared" correct from the standpoint that it was not returning more than one record with the same date, but the summing is incorrect. The issue, I'm suspecting now, is that the form where the values are...
  11. xhat

    Getting Sums on Records

    smedvid, Yes, that is precisely how the table looks (in addition to other fields that aren't being queried in this instance). And, like yourself and Skip both stated, I have run the query using GroupBy on the Date field. The output does not properly sum as it should. I still get multiple...
  12. xhat

    Getting Sums on Records

    Skip, Yeah, like I said in the body of the post, I've already done that and the results are not coming out as expected. "There is no spoon..." - anonymous enlightened child
  13. 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...
  14. xhat

    Visible Property and Option Groups

    Ok, interesting development. Apparently, Access doesn't like you to make a textbox's label visible without also making the textbox visible as well. Who knew? Thanks for the debugging tip. It got me thinking in the right direction. "There is no spoon..." - anonymouse enlightened child
  15. xhat

    Visible Property and Option Groups

    MajP, Thanks for the reply and the debugging suggestion. The msgbox did, indeed, fire ("Event fired."), however the control did not become visible on the form. A little more info on this problem: For aesthetics sake, controls are overlapping each other, both made not visible at form load...
  16. 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...
  17. xhat

    Do Loop Using .Bookmark as Test

    MajP & Harely - Thanks for your help guys. Everything is working smoothly now, and I've learned a good crash course in DAO recordsets and bookmarks.
  18. xhat

    Do Loop Using .Bookmark as Test

    Well, all, thanks for your help. Nothing like a little reboot of the O/S to set everything back to working order... Oh, and blowing away a reference library. Who the heck knows... But Harley, looks as though your StrComp idea is working, so what the hell...
  19. xhat

    Do Loop Using .Bookmark as Test

    Also note that the Type Mismatch error occurs at runtime, not compile time! I had to put a msgbox in my error handler to get the err.number and description.
  20. xhat

    Do Loop Using .Bookmark as Test

    Harley - thanks for weighing in. I'm working in Access 2000, and when I try to make the following assignment in my parent Sub... 'Move record pointer to bookmark rs.Bookmark = bytCurrRec ... when my var is DIM'd as a Byte, I get the following error: "Compile Error. Type Mismatch:array...

Part and Inventory Search

Back
Top