Wrox Programmer Forums
Pro VB.NET 2002/2003 For advanced Visual Basic coders working .NET version 2002/2003. Beginning-level questions will be redirected to other forums, including Beginning VB.NET.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Pro VB.NET 2002/2003 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 October 24th, 2008, 11:46 AM
Registered User
Join Date: Oct 2008
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Access project


How is everybody?

I have a problem with an Access Project:
My project has a form. In that form, I have several controls (fields to fill data in). I need to disable one control until another control (operator ID) is filled. I also need to disable the operator ID control as soon as it has been filled.
I am working with Access 2003
For the 1 problem i tried to create a BeforeUpdateEvent, then a CodeBuilder, with an IF/Then transaction:
Private Sub Operação_BeforeUpdate(Cancel As Integer)
        If Me!ID_Oper_B = "joaquim" Then
        Me!Operação.Enabled = True
        Me!Operação.Locked = False
        Me!Operação.Enabled = False
        Me!Operação.Locked = True
        End If
End Sub

Can you tell me what's wrong with this transaction? Should I try something else?

For the second problem, i am thinking about doing an AfterUpdateEvent which Disables the control after it has been filled. how do I do that?

Can anybody help me?



Similar Threads
Thread Thread Starter Forum Replies Last Post
AllowBypassKey for Access Project U.N.C.L.E. Access VBA 3 October 11th, 2007 11:42 AM
Access Data Project moedev Access 1 April 19th, 2006 06:40 AM
Remote access to an Access Project Database bright_mulenga Access 0 February 9th, 2006 10:51 AM
From 1 project to get access to another project hplim18 Pro VB.NET 2002/2003 0 March 30th, 2004 10:33 PM
Access project refresh VBAHole22 Access 6 July 16th, 2003 11:59 AM

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