Ok, this is strange. I created a new database and imported all objects from
the old program file.
Form some reason, the option explicit statement is no longer showing in my
code modules (and I would assume any form modules as well). However, even
though in the vb code window, under options,, the option "Require variable
declaration" IS checked.
Any ideas how to restore the Option Explicit option to all my modules? I
never used to have to do this manually, and I can't imagine checking every
module to add this on.
RE: Creating an accde file removes programming ... I would remove an Option Explicit statement, for any reason whatsoever...."rbeach" wrote: ... (microsoft.public.access.modulesdaovba)
Re: Global variables cleared by forms? ... Apologies...both the procedures calling forms are clearing the variables. ... are all of your code modules got he statement 'Option Explicit' at ... > otherwise we are using different variables (Option Explicit will trap this). ... (microsoft.public.excel.programming)
Re: Macro for EACH workbook-->help modify to ONE macro for ALL wor ...Option Explicit Statement... the Option Explicit statement must appear in a module before any ... Below is my macro that works 'perfectly', ... different workbooks by clicking a button in the open workbook ... (microsoft.public.excel)
Re: Delete Spaces from text download ... The Option Explicit statement requires all variables to be declared and 'r' is a variable that was not declared. ... highlighted the r and the sub spacekiller.... Gary''s Student - gsnu200743 ... (microsoft.public.excel.programming)
Re: Delete row below once data is copied above ... An Option Explicit statement keeps spelling errors from creating problems in ...Dim partNumbers As Collection ... For Each upn In partNumbers ... (microsoft.public.excel.programming)
