[AccessD] 2 Questions

2. I use Tools | Relationship to create foreign key constraints ("enforce referential integrity"). Without foreign key constraints the data will soon loose consistency.

Asger

-----Oprindelig meddelelse-----
Fra: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] På vegne af Max Wanadoo
Sendt: 9. marts 2010 21:45
Til: 'Access Developers discussion and problem solving'
Emne: Re: [AccessD] 2 Questions

Tony:

1. At the top of  the module put
Option explict

Then compile it, all the unspecified variable will be picked up.


2. Me neither.  I seldom use relationship and much prefer to handle them in
code.

Max
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Tony Septav
Sent: Tuesday, March 09, 2010 7:25 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] 2 Questions

Hey All
Just pondering
1. Access2003 does not seem to pick up erroneous variables.
If on a form I assign for a control
Dim JTnum as double
then in code
..................
I make a spelling error
Jnum = rst.Pnum
...................
rst!dnum=jnum (which gives me 0).
When I run a compile I do not get an error message.
In previous versions of Access I am pretty sure the above would generate an
error message. Have I inadvertently turned something off????

2. I do not use the Tools Relationship.
I establish them in my queries and in my forms/subforms link or in code.  I
also (because I have never liked Access's error messages) warn users with my
own error message if a problem might occur.  Is this a feature designed for
non-developers just like the table lookup (which I don't use either) or am I
missing something (life has been good without it, just curious)????


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com