Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
|
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old January 7th, 2009, 01:04 PM
Registered User
 
Join Date: Jan 2009
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Code not showing and undeclared variable

Hello,
I have 2 questions, I am working on a project in Access 2003 and I can view the code for all of the forms except one. It runs like it is suppose to I just can't view the code for it.

1. Is there anyway to view the code?

I also have an issue with a variable that isn't declared and works fine. It is located in two different code sections, I've looked at all of the code and it's not declared anywhere, not as local or global.

2. How can I locate a variable that is not declared anywhere?
 
Old January 13th, 2009, 08:02 PM
Authorized User
 
Join Date: Jul 2008
Posts: 38
Thanks: 1
Thanked 2 Times in 2 Posts
Default

1. You could have corruption of the form going on.

2. Add Option Explicit to the top of all of your code modules and then run Debug > Compile and it should find any undeclared variables.
__________________
Thanks,

Bob Larson
Access MVP (2008-2010, 2011)
Free Access tutorials, samples, tools





Similar Threads
Thread Thread Starter Forum Replies Last Post
UTF-8 in XML: "Undeclared Entity" errors? richcon XSLT 3 April 30th, 2006 03:19 AM
Code showing current datet& time of server pareshk Wrox Book Feedback 1 June 6th, 2005 10:06 PM
php _get and undeclared variables wolferd1 Beginning PHP 10 January 23rd, 2005 10:31 PM
Getting Error 'EXEC' : undeclared identifier JAPPY Visual C++ 0 April 7th, 2004 09:35 AM
How to reference Public Variable in Code Gino Liu Access VBA 2 June 18th, 2003 01:42 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.