Re: Reference Error

Try "refreshing" your references.
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html

tonym415@xxxxxxxxx wrote:
I think this is a reference error. All of a sudden my database doesn't
know what a "control" is. I have written forms and I get a "Module Not
Found" error. The line that is highlighted is a sub definition. (Sub
tbFormat(ctl As control))

I've tried fudging it and changing the statement to: Sub tbFormat(ctl
As object) then I get an error in another module on a line saying the
following: dim db as database.

I think there has to be some default references that have gotten
deleted. Can someone help please!!!!

--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200707/1

.

Relevant Pages

  • Re: CORRECTED TEST AND ANSWERS.
    ... Private Function MyFunctionas integer ... >A Sub cannot have a return value. ... >A form is Unloaded specifically set to Nothing while one control on it is ... >references per se; what you are saying is any reference to a control on the ...
    (microsoft.public.vb.general.discussion)
  • Re: CORRECTED TEST AND ANSWERS.
    ... Private Function MyFunctionas integer ... A Sub cannot have a return value. ... A form is Unloaded specifically set to Nothing while one control on it is ... references per se; what you are saying is any reference to a control on the ...
    (microsoft.public.vb.general.discussion)
  • Re: Reference Error
    ... know what a "control" is. ... The line that is highlighted is a sub definition. ... I think there has to be some default references that have gotten ... HTH - RuralGuy acXP WinXP Pro ...
    (comp.databases.ms-access)
  • Re: Simple Insert Into...
    ... You can store unbound control data in a variable, ... in the sql. ... Dim strSQL As String ... In your form's Sub, you'll wind up with something like the following: ...
    (microsoft.public.access.modulesdaovba)
  • Re: Simple Insert Into...
    ... it is in a control on the form; and is unbound (it's actually a combo ... box that is used as a dropdown list, values taken from a different table; SQL ... I need this value to assign a unique ID to the entire recordset being ... In your form's Sub, you'll wind up with something like the following: ...
    (microsoft.public.access.modulesdaovba)