Re: Loading query into a recordset...

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

From: Goe (Goe_at_discussions.microsoft.com)
Date: 08/31/04 

Date: Mon, 30 Aug 2004 19:59:01 -0700

Hi,

Actually, i've tried that before when i read someone else's posts, and i
received the following error:

Runtime error '2482':

MS Access can't find the name 'Please enter Rep Code below:' you entered in
the expression.

That expression 'Pls...' is in one of queries in Criteria as [Pls...].

Thank you Ken!!!

"Ken Snell [MVP]" wrote:

> Between these two lines of code:
>
> Set qdf = MyDB.QueryDefs("Q- Rep Planner")
> Set MyRecordSet = qdf.OpenRecordset("Q- Rep Planner")
>
> put these lines of code to evaluate the parameters:
>
> For Each prm in qdf.Parameters
> prm.Value = Eval(prm.Name)
> Next prm
>
>
> --
>
> Ken Snell
> <MS ACCESS MVP>

Relevant Pages

  • Re: Error saving record on a form
    ... The SQL ... >Do you have any criteria in the Form's RecordSource? ... >> save a record it gives a runtime error '30014', ... >> underlying record source. ...
    (microsoft.public.access.forms)
  • Runtime Error R6025
    ... point and just hangs. ... Runtime Error ... As it does not crash I cannot send an error report. ... I also noticed in other posts mentions of "Microsoft Visual Studio". ...
    (microsoft.public.windowsxp.moviemaker)
  • Re: Runtime error 429 - With a twist on Drive installed
    ... I know there are tons of posts about this problem. ... then it gives the Runtime error 429. ... it's not a dependency of any dlls. ...
    (comp.lang.basic.visual.misc)
  • Re: Valid Collection?
    ... If I create a collection based on some criteria, ... collections you can itterate through them more than once with 'For ... Each' loops, and with other collections you can only do this loop ...
    (microsoft.public.scripting.vbscript)
  • Re: Error saving record on a form
    ... Do you have any criteria in the Form's RecordSource? ... MVP ... "Jim" wrote in message ... > save a record it gives a runtime error '30014', ...
    (microsoft.public.access.forms)