Search results for query: *

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

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?

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

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

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

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

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

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