Re: module not passing information

Tech-Archive recommends: Speed Up your PC by fixing your registry

It sounds to me that you are calling a control
from the module without specifying the form
that it is in.
example you are using Grid1. instead of Form1.grid1




"Gonzosez" <nospam@xxxxxxxx> wrote in message
news:ui4DywsGGHA.3624@xxxxxxxxxxxxxxxxxxxxxxx
>I have a module that connects to a database and creates a recordset.
> The problem is that when I try to call the recordset in the form I get the
> error that an object is required.
> What do I have to set for the variables in the module to be used by the
> form.
>
>


.

Relevant Pages

  • Re: Simple Insert Into...
    ... The form is based on an SQL in the form's Record Source property, ... holds the current text in the control, ... Sometimes the unbound controls do have a value (such as when they are set ... I need this value to assign a unique ID to the entire recordset being ...
    (microsoft.public.access.modulesdaovba)
  • Re: Select query with parameters
    ... I can use data grid control if it will be better for my situtaion. ... When you Open a recordset you pass an SQL query statement as a string. ...
    (microsoft.public.vb.database.ado)
  • Re: Me! vs Me. (was temporarily Re: !fidlname vs .controlname)
    ... .controlname is to refer to a control (and if it is not on the form, then the recordset will be searched) ... change the NAME of another control on your form --> Test whose ControlSource is something else and is filled out ... In this case, however, the bang and the dot can be interchanged. ...
    (microsoft.public.access.formscoding)
  • Re: DataGrid not showing programmatic changes
    ... It's been awhile since I've used the DataEnvironment... ... The DataGrid is usually bound to a Data control which in turn ... rsCashbook is a recordset of that Connection with a source of SELECT * FROM ...
    (microsoft.public.vb.general.discussion)
  • Re: Reference forms and fields with variables
    ... There are so many ambiguities here, that it may not really help to follow ... If Field2 is a field in the underlying recordset, ... but the reference is unstable. ... LinkChildFields property of a subform is NOT represented by a control in the ...
    (microsoft.public.access.formscoding)