Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Software > Access Macros > Type mismatch
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 4 Topic 5655 of 5947
Post > Topic >>

Type mismatch

by =?Utf-8?B?WW9kYWJveQ==?= <Yodaboy@[EMAIL PROTECTED] > Jul 22, 2008 at 07:23 AM

On opening a database I have created, I have an auto exec macro which runs
a 
re****t to tell me when I have expired records in my database. This then
runs 
another macro which if the expired records total more than 1 pings a pop
up 
message to tell me i have expired records. Howver if there are no expired 
records the macro runs and errors with a type mismatch error. Please help
the 
macro code is 

[Re****ts]![Expiring Records]![Total Expired]>0

i have tried zero's, "", Null and sums that = zero and it still doesnt
work.

HELP ME OBI WINDOWS KENOBI YOU ARE MY ONLY HOPE!

Thanks
 




 4 Posts in Topic:
Type mismatch
=?Utf-8?B?WW9kYWJveQ==?=   2008-07-22 07:23:02 
Re: Type mismatch
"Jeff Boyce" &l  2008-07-22 08:23:38 
Re: Type mismatch
Steve Schapel <schapel  2008-07-23 09:23:26 
RE: Type mismatch
=?Utf-8?B?WW9kYWJveQ==?=   2008-07-23 02:25:02 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Fri Nov 21 14:22:41 CST 2008.