programmatically lock controls? - Microsoft Access / VBA

steph

Hi,

I'm using Access 2002 and this is my question:

I've got a form in datasheet view containing a checkbox. I want to
lock/unlock this checkbox programmatically dependent on the value of a
another control. I've tried it like this, but the checkbox does not
seem to be set always correctly:

Private Sub Form_Current()
If Me.BATCHVALFROZEN = -1 Or IsNull(Me.EXP_TYPE) Then
Me.BATCHVAL.Locked = True
Else
Me.BATCHVAL.Locked = False
End If
End Sub

Is there a better way to do this?

Thanks,
Stephan

Jul 7 '06 #1

Subscribe Post Reply

2940

Allen Browne

That looks correct, but you need to do it in Form_AfterUpdate as well if you
want it locked without having to move to another record and back.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"steph" <st*******@yahoo.dewrote in message
news:11*********************@75g2000cwc.googlegrou ps.com...

>
I'm using Access 2002 and this is my question:

I've got a form in datasheet view containing a checkbox. I want to
lock/unlock this checkbox programmatically dependent on the value of a
another control. I've tried it like this, but the checkbox does not
seem to be set always correctly:

Private Sub Form_Current()
If Me.BATCHVALFROZEN = -1 Or IsNull(Me.EXP_TYPE) Then
Me.BATCHVAL.Locked = True
Else
Me.BATCHVAL.Locked = False
End If
End Sub

Is there a better way to do this?

Thanks,
Stephan

Jul 7 '06 #2

steph

Thanks, it works now!

Allen Browne wrote:

That looks correct, but you need to do it in Form_AfterUpdate as well if you
want it locked without having to move to another record and back.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"steph" <st*******@yahoo.dewrote in message
news:11*********************@75g2000cwc.googlegrou ps.com...

I'm using Access 2002 and this is my question:

I've got a form in datasheet view containing a checkbox. I want to
lock/unlock this checkbox programmatically dependent on the value of a
another control. I've tried it like this, but the checkbox does not
seem to be set always correctly:

Private Sub Form_Current()
If Me.BATCHVALFROZEN = -1 Or IsNull(Me.EXP_TYPE) Then
Me.BATCHVAL.Locked = True
Else
Me.BATCHVAL.Locked = False
End If
End Sub

Is there a better way to do this?

Thanks,
Stephan

Jul 10 '06 #3

Similar topics

Lock Textboxes

by: Tom | last post by:

I have the following code as part of a procedure in a standard module: Dim ctrl As Control For Each ctrl In MyForm.Controls If ctrl.ControlType = acTextBox Then MsgBox ctrl.name MsgBox...

Microsoft Access / VBA

How to change control properties programmatically?

by: deko | last post by:

I'm trying to find a way to set form/control properties programmatically. In a nut shell: 1. Open a database 2. Open a form in design view 3. Do something like this: For Each prp In...

Microsoft Access / VBA

Best method to selectively lock/disable controls on a form.

by: Saintor | last post by:

What I do now is I put a value in the tag property, and using the form_current event, I run through all controls properties until the ones with the required tag value are met. Sound OK in theory,...

Microsoft Access / VBA

programmatically add/remove windows components

by: Tzvika | last post by:

Hi, Is there a way to programmatically add/remove windows components in c# or in any other language What is the API fro that?

C# / C Sharp

basic: asp.net user controls: how to programmatically add attribute to all text box controls?

by: | last post by:

I have a "form field highlight" javascript that I've added to some of my ASP.NET forms using the following syntax: body.Attributes.Add("onClick", "highlight(event);");...

ASP.NET

Programmatically Detect and Send Num Lock and Caps Lock

by: charlies224 | last post by:

Hi, I am writting a software that requires me to make sure the Num Lock is always on and Caps Lock is always off. First, I know how to detect if Num Lock or Caps Lock is on or off (if...

Visual Basic .NET

Programmatically changing RecordSource - too risky?

by: deko | last post by:

I have a popup form with a textbox that is bound to a memo field. I've been warned about memo fields so I'm wondering if I should use this code. Is there any risk with changing the form's...

Microsoft Access / VBA

Programmatically manipulating all controls of type X?

by: Ken Fine | last post by:

I'm interested in programmatically manipulating groups of ASP.NET controls by type. Can someone suggest code for the following? Loop through, say, all label controls on a page, and assigning a...

ASP.NET

Programmatically adding ASP.net User Control to UpdatePanel

by: ChrisCicc | last post by:

Hi All, I got a real doozy here. I have read hundreds upon hundreds of forum posts and found numerous others who have replicated this problem, but have yet to find a solution. Through testing I have...

ASP / Active Server Pages

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice