RE: Trouble Shoot VB Code error 3301

Tech-Archive recommends: Fix windows errors by optimizing your registry

Unless rs is a global defined elsewhere, you need to declare it:
Dim rs as DAO.Recordset
--
Tom Unkefer

.

Relevant Pages

Re: DIM and Set db once per module
... > dim db as database ... > What I'd like to do is declare this once for the entire module so that ... Prev by Date: ...
(microsoft.public.access.modulesdaovba)
Re: Recent File
... > lol, got ya.... ... I made that comment as the OP had declared them as Dim ... The only times you should declare a ... Prev by Date: ...
(microsoft.public.vb.general.discussion)
Re: Merging Two Codes Into one code
... In your code variable i was not declare. ... Dim Lrow As Longdim. ... For more info see VBA Help for option explicit statement & ... Prev by Date: ...
(microsoft.public.excel.programming)
Re: Dim inside If..?
... You can certainly declare a variable with Dim inside of an "If", ... If statement (Block Level Scope). ... Prev by Date: ...
(microsoft.public.dotnet.framework)
Re: Querying a database
... Use My Database ... Declare @sCnt VarChar ... Set Nocount Off ... Dim pairsAdapter As New MWFNTableAdapters.MWFNTableAdapter ...
(microsoft.public.vb.database)