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 General > Corrupt DB??
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 13 Topic 92509 of 97661
Post > Topic >>

Corrupt DB??

by =?Utf-8?B?U2VjcmV0IFNxdWlycmVs?= <secretsquirrel@[EMAIL PROTECTED] Aug 7, 2008 at 06:48 AM

My database has been running using 2003 for almost 2 years now and the past

couple of days when you click to open a certain form the database closes 
completely. Some users are using 2007 with the same database and I have no

problems with it. I have this code in the open event of this form and when
I 
remove it the form works fine. Why all of a sudden would this be causing a

problem? Could there be something corrupt with Access 2003? It works fine 
with 2007. And it also works fine when I test it using 2003 on my laptop.
But 
the users that have 2003 are having this problem. Here's the code I'm
using 
that seems to be causing the problem:

    If Len(Me.OpenArgs) > 0 Then
        Me![RMA#].DefaultValue = Chr(34) & Me.OpenArgs & Chr(34)
        Me![Customer].DefaultValue = Chr(34) & 
[Forms]![frmARNCMR1]![Customer] & Chr(34)
        Me![PO#].DefaultValue = Chr(34) & [Forms]![frmARNCMR1]![PONumber]
& 
Chr(34)
        Me![PartNumber].DefaultValue = Chr(34) & 
[Forms]![frmARNCMR1]![CustomerPN].Column(1) & Chr(34)
        Me![DescriptionOfCondition].DefaultValue = Chr(34) & 
Replace([Forms]![frmARNCMR1]![DiscrepancyDescription], Chr(34), Chr(34) & 
Chr(34)) & Chr(34)
        Me![Qty].DefaultValue = Chr(34) &
[Forms]![frmARNCMR1]![QtyRejected] 
& Chr(34)
        Me![NCMR].DefaultValue = Chr(34) & [Forms]![frmARNCMR1]![NCMR] & 
Chr(34)
        Me![WorkOrder].DefaultValue = Chr(34) & 
[Forms]![frmARNCMR1]![WorkOrder] & Chr(34)
   
    End If
 




 13 Posts in Topic:
Corrupt DB??
=?Utf-8?B?U2VjcmV0IFNxdWl  2008-08-07 06:48:01 
Re: Corrupt DB??
a a r o n _ k e m p f <  2008-08-07 06:57:23 
Re: Corrupt DB??
=?Utf-8?B?U2VjcmV0IFNxdWl  2008-08-07 07:04:00 
Re: Corrupt DB??
"Ken Snell \(MVP\)&q  2008-08-07 10:07:28 
Re: Corrupt DB??
"Allen Browne"   2008-08-07 22:14:50 
Re: Corrupt DB??
=?Utf-8?B?U2VjcmV0IFNxdWl  2008-08-07 07:37:24 
Re: Corrupt DB??
"Allen Browne"   2008-08-07 23:22:24 
Re: Corrupt DB??
=?Utf-8?B?U2VjcmV0IFNxdWl  2008-08-07 12:28:04 
Re: Corrupt DB??
"Clif McIrvin"   2008-08-07 18:11:18 
Re: Corrupt DB??
"Pete D." <p  2008-08-07 19:24:11 
Re: Corrupt DB??
=?Utf-8?B?U2VjcmV0IFNxdWl  2008-08-15 09:39:11 
Re: Corrupt DB??
"Dominic Vella"  2008-08-08 01:20:13 
Re: Corrupt DB??
a a r o n _ k e m p f <  2008-08-16 11:44:38 

Post A Reply:
  Go here to Signup

AddThis Feed Button


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

Contact
tan12V112 Thu Dec 4 22:00:33 CST 2008.