Red Flag This Post Please let us know here why this post is inappropriate. Here is some background: The code resides in the worksheet object and not a VBA module.The "named ranges" (i.e. I'm still getting a compile error. I have it as: Public Sub FunctionNotValidVarType() MsgBox "VarType " & VarType & " is not supported.

Compile Error Label Not Defined Vba Access

I would still be interested to know where I am going wrong with my labelling if anyone can spot the error. In this respect we can say that Visible and IsNull(EmployeeNumber) vary directly with each other so the evaluation of one IS the value of the other. Keith Nichols View Public Profile Find More Posts by Keith Nichols

Can you upload your sample workbook? I copy and pasted the code you posted into a couple of button click-event handlers, changed the prints to a msgbox and I'm not having any problems. You currently have 0 posts. | "Institutions have a vested interest in perpetuating the problems to which they are the solution." - Clay Shirky MarkK View Public Profile Find More On Error Goto Errhandler Label Not Defined you need to define the name thats behind it.

Only problem now is I've tried to rewrite my dcount and I keep getting the syntax wrong. Vba Goto Label Posts 13,686 I would say your problem is that you're using End Sub at all of those. Password Register FAQ Community Top Posters Today's Posts Search Community Links Social Groups Pictures & Albums Members List Calendar Search Forums Show Threads Show Posts Tag Search Advanced Search Find All rights reserved.

Code: If IsNull(Employee_Number) Then Employee_Number.Visible = True Else Employee_Number.Visible = False End If ... navigate to this website Join over 733,556 other people just like you! Not the answer you're looking for? Reply With Quote Page 1 of 2 12 Last Jump to page: « Previous Thread | Next Thread » Like this thread? Label Not Defined Vb6

Can you tell me what may be causing this. ...bob Saturday, March 16, 2013 4:07 PM Reply | Quote 0 Sign in to vote What is the definition of the FormDesignViewColumns Do not worry about your difficulties in Mathematics. Why does a full moon seem uniformly bright from earth, shouldn't it be dimmer at the "border"? On Error Goto Line Now I'm getting a type mismatch error, when running this but I have no clue why I would.

Posts 13,686 If the sample code you posted is not your *actual* code, have you checked to make sure you have the label spelled the same way in both places? See Access Help or search here. Search the forum here for "Conditional" and also look in Access Help.