IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

IWETHEY Home / IWETHEY Board / Databases Forum / Ya, that's it.
Post #146,333
by acagle
3/15/04 5:52:38 PM
3/15/04 6:08:48 PM
Reply
New Ya, that's it.
I used:

strSQL = "SELECT tblBLS_Add.* FROM tblBLS_Add WHERE (((tblBLS_Add.BatchNo)=" & Me![BatchNo] & "));"

Set rstA = CurrentDb.OpenRecordset(strSQL, dbOpenDynaset)


Now I'm having trouble with a stupid form losing its filter after doing a bunch of code. It's completely baffling me. And I can't reset the filter with code either.

[Edit] WEEEEEE!!!! Fixed it. But actually a head-slap because I myself was causing the filter to go off from a bit of code that I lifted for use from a different application. Bad me.
Collapse Edited by acagle March 15, 2004, 06:08:27 PM EST
Ya, that's it.
I used:

strSQL = "SELECT tblBLS_Add.* FROM tblBLS_Add WHERE (((tblBLS_Add.BatchNo)=" & Me![BatchNo] & "));"

Set rstA = CurrentDb.OpenRecordset(strSQL, dbOpenDynaset)


Now I'm having trouble with a stupid form losing its filter after doing a bunch of code. It's completely baffling me. And I can't reset the filter with code either.
Collapse Edited by acagle March 15, 2004, 06:08:48 PM EST
Ya, that's it.
I used:

strSQL = "SELECT tblBLS_Add.* FROM tblBLS_Add WHERE (((tblBLS_Add.BatchNo)=" & Me![BatchNo] & "));"

Set rstA = CurrentDb.OpenRecordset(strSQL, dbOpenDynaset)


Now I'm having trouble with a stupid form losing its filter after doing a bunch of code. It's completely baffling me. And I can't reset the filter with code either.

[Edit] WEEEEEE!!!! But actually a head-slap because I myself was causing the filter to go off from a bit of code that I lifted for use from a different application. Bad me.
Collapse All History
Post #146,399
by a6l6e6x
Picture of a6l6e6x
3/15/04 9:31:13 PM
Reply
New Cut and paste is a known killer! :)
Alex
Necessity is the plea for every infringement of human freedom ... the argument of tyrants ... the creed of slaves. -- William Pitt, addressing the British House of Commons (1783)
     OpenRecordset in Access. - (acagle) - (13) - March 12, 2004, 05:14:04 PM EST
         Join the tables and only select from one of them -NT - (ben_tilly) - (6) - March 12, 2004, 05:16:25 PM EST
             Re: Join the tables and only select from one of them - (acagle) - March 12, 2004, 05:21:43 PM EST
             Re: Join the tables and only select from one of them - (acagle) - (4) - March 12, 2004, 05:32:18 PM EST
                 I can't figure that strategy out. - (FuManChu) - (3) - March 12, 2004, 07:01:31 PM EST
                     I think - (mmoffitt) - (2) - March 12, 2004, 07:30:36 PM EST
                         Ya, that's it. - (acagle) - (1) - March 15, 2004, 06:08:48 PM EST
                             Cut and paste is a known killer! :) -NT - (a6l6e6x) - March 15, 2004, 09:31:13 PM EST
         Bookmarks? - (altmann) - March 12, 2004, 05:42:06 PM EST
         'Nother question. - (acagle) - (4) - March 18, 2004, 06:01:29 PM EST
             Oooh, fun :-) - (ben_tilly) - March 18, 2004, 06:24:13 PM EST
             SELECT DISTINCT or a GROUP BY -NT - (ChrisR) - (1) - March 18, 2004, 07:46:02 PM EST
                 In access, I think its Select DistinctRow -NT - (mmoffitt) - March 19, 2004, 11:06:48 AM EST
             Make and examine a "Find Duplicates" Query - (FuManChu) - March 19, 2004, 12:20:32 PM EST

Iggy Pop in Daisy Dukes.
84 ms