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 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: *

  1. tomatojo

    vbOKCancel BREAK?

    Got it working now, I just used Exit Sub instead of Edit Do. Thnx!
  2. tomatojo

    vbOKCancel BREAK?

    How do I exit and If Then statement (like I'm using)? I keep getting errors (missing end if with if statement, and as far as I can tell, its there!). It worked when it was a vbOKCancel so maybe it doesn't work with vbyesno?
  3. tomatojo

    vbOKCancel BREAK?

    Hi, I'm using VB in an Access 97 program I have. I'm using the vbOKCancel message box command. But it runs in a look and sometime (during program testing) I want it to break out of the loop. Now, if I click OK, it continues with program as planned (works well). When I click Cancel it skips...
  4. tomatojo

    Can't get my subform to filter correctly

    findLetter2() works Great! Thanks MajP! findLetter3() also works (works without the edit you suggested in your last post, that gave me another error) but it would require more coding, so I will go with #2. Sorry for the delay in response but this is a work project and I don't work weekends...
  5. tomatojo

    Can't get my subform to filter correctly

    Yours does Exactly what I'm looking to do but it just isn't working for me. Could it be because you're using Access 2000 and I'm using Access 97? Maybe 97 doesn't allow this code. When I look at my form properties, the subform source object is "rptBugList1" as I said. But, just in case, I...
  6. tomatojo

    Can't get my subform to filter correctly

    OK, I tried your code and got the 2465 error, "can't find the field rptBuglist1". That (rptBuglist1) is the name of my subform, see screenshot at link below (unless I'm not calling this correctly). The code I used is below: Any suggestions what I'm doing wrong here ('cause I got this same...
  7. tomatojo

    Can't get my subform to filter correctly

    I uploaded a screen shot, hope you can see it (sorry but I'm new to this). So the form will be presorted by the Order column already (that part works, in my example, Diptera). Then the user would click, say, the letter "E" command button (on main form), then the pointer would go to the first...
  8. tomatojo

    Can't get my subform to filter correctly

    Hi, I have a subform (Child?) on a form that shows filtered data. I want an additional button that will search the filtered data (data is sorted alphabetically) for the first occurrence of the item chosen in a particular column. The code I've tried is below (its some Filter code I got online...

Part and Inventory Search

Back
Top