Can't Find the Date field
in [Forms]
|
From: poorboy13 via AccessMonster.com on 14 May 2010 08:48 Here is the whole Sub The specific line is BODDate=Date Private Sub Command10_Click() BODDate.Locked = False BeginTime.Locked = False BODDate = Date BeginTime = Now() BeginTime.Locked = True BODDate.Locked = True Present = -1 End Sub I do appreciate the help but in the interest of time I reverted back to older version and re-wrote it all and it is working fine now. I know at some point I named 2 objects "Date" (Not thinking, obviously) but even though I renamed them after this problem presented itself, it never fixed the problem. It is just curious that the forms I wrote before I named those 2 objects continued to work after my mistake but any new creation with that same code did not. BruceM wrote: >Please post the line of code at which the error occurs. > >>Nothing. I tried the Option Explicit and compile and it shows no errors. >>I added the Me.Prefix and changed the Control name. It still gives off the >[quoted text clipped - 11 lines] >>>>>of a missing reference, and the VBA Editor will, indeed, strip the trailing >>>>>parens. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/201005/1
From: BruceM via AccessMonster.com on 14 May 2010 09:22
Did you try doing a Compact and Repair (Tools >> Database Utilities >> Compact and Repair)? Back up the database first. Make sure you do this. Really. I'm guessing you have Name Autocorrect enabled. For more information: http://allenbrowne.com/bug-03.html It may be worthwhile going through this recovery sequence: http://allenbrowne.com/recover.html poorboy13 wrote: >Here is the whole Sub >The specific line is >BODDate=Date > > Private Sub Command10_Click() > BODDate.Locked = False > BeginTime.Locked = False > BODDate = Date > BeginTime = Now() > BeginTime.Locked = True > BODDate.Locked = True > Present = -1 > End Sub >I do appreciate the help but in the interest of time I reverted back to older >version and re-wrote it all and it is working fine now. >I know at some point I named 2 objects "Date" (Not thinking, obviously) but >even though I renamed them after this problem presented itself, it never >fixed the problem. It is just curious that the forms I wrote before I named >those 2 objects continued to work after my mistake but any new creation with >that same code did not. > >>Please post the line of code at which the error occurs. >> >[quoted text clipped - 3 lines] >>>>>>of a missing reference, and the VBA Editor will, indeed, strip the trailing >>>>>>parens. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/201005/1 |