Disabled And Locked Textboxes

Jun 10, 2005

I'm creating an Access form and there are three sections to the form of which the user should only fill out one. So, they are controlled by a radio group and the desired action is as follows:

There is a default choice (by far, the most common) and it will be selected when the form is opened. When the user selects one of the radio options, the section controlled by that radio option will become enabled and the other two sections will become disabled/locked.

So I found that each box (textbox, combobox, etc) has the property enabled and locked. So I just set this accordingly depending on what is selected. The actual result is that the boxes will be grayed out and become disabled, but will never become enabled again.

Here's some abbreviated code:

Private Sub accountRequestType_AfterUpdate()
If Me.accountRequestType.Value = 1 Then
enableSection1
disableSection2
disableSection3
ElseIf Me.accountRequestType.Value = 2 Then
disableSection1
enableSection2
disableSection3
ElseIf Me.accountRequestType.Value = 3 Then
disableSection1
disableSection2
enableSection3
End If
End Sub

So an example of a disable function (which seems to work) is as follows:

Sub disableSection1()
Me.text123.Enabled = No
Me.text123.Locked = Yes
End Sub

And for an enable function (which doesn't seem to work):

Sub enableSection1()
Me.text123.Enabled = Yes
Me.text123.Locked = No
End Sub

So I'm a bit lost here, any ideas would be great. Are there different steps I need to take in order to enable them again? Am I being clear?

Thanks in advance for any ideas.

View Replies


ADVERTISEMENT

Toolbars Disabled?

Feb 26, 2007

hello,

I have this filename.mdb file which was given to me for revision, so I opened it with MS access but once I opened it, the toolbars are disabled so I can't switch to form view, design view etc. How can I resolve this? I remember when I once did VBA Access that you can do this 'disable' thing. Only that I forgot it how now. So if anyone could please help me in this? I need to 'have those toolbars back' so I can start editing the file. Please do help me.

Thanks in advance

View 2 Replies View Related

Disabled Keys

Dec 17, 2006

Hello,

I have created a log in form in my database and users will enter their name using a combo. Is there a way I can force them to use the mouse and select their name and not type in the data? Basically something that will disables all keys from the keyboard? Thanks.

View 3 Replies View Related

Hyperlink's # Charactor Disabled

Feb 9, 2008

The # character in a hyperlink is used to separate hyperlink parts. Here is a case when I do NOT want this character to do the separation: a network file where the # character is part of the filename: k:datasomeFile#ref02.doc.

How can I put this URL into a hyperlink field in a table and NOT have Access treat it like this:
Address: k:datasomeFile
Subaddress: ref02.doc
which then of course results in the usual "Unable to open..." error.

(I tried replacing the # with %023 but when Access seems to convert it automatically to #).

View 3 Replies View Related

Disabled A Click Event

Dec 15, 2005

Hello,

How can you disabled a click event on a text box ? I don't want to use ENABLE = false because the background of the texte box comes gray. So, any alternative solution?

Thanks,

Le

View 6 Replies View Related

Button Disabled By Clicking Itself?????

Oct 13, 2006

Can I make a button, say "command01" deactive by clicking it.

i.e.
OnClick of command01 => command01.enabled=false

is this possible?

View 5 Replies View Related

Modules & VBA :: Mdb Menu Becomes Disabled

Jan 22, 2015

I have an mdb file that is being used in Access 2013. The menu appears in the Add Ins as it is supposed to and it works for the most part. For some reason, it remains visible but is not clickable/operable after I do the following code. This all works flawlessly in earlier version of Access so it must something peculiar to 2013 (no surprise there....). hat would cause the ribbon to stop working, what to do when it does, and best of all, how to prevent it from occurring in the first place?

This code is for an option box that either prints a report or creates a pdf and then sends the report as and attachment to a CDO generated email. Other than it (seemingly) turns off the menu..THe site won't allow me to post links so the code is an attached txt file

View 2 Replies View Related

Argh! Disabled All Menus In Startup

Apr 19, 2007

I disabled all the menues in the startup....how do I reverse this?

View 3 Replies View Related

Open Database With Macros Disabled.

Jul 2, 2007

Hello,

I have a 'legacy' Access DB which I need to get into.

Unfortunately there is a problem, whenever I try to open it (using MS Access 2003) there is an error (Disc/Network error 3043) and the database closes immediately.

How can you open an MS Access db with all macros/vba etc disabled, so that the code causing the error does not execute and I can find out what is going on ?

I have not been able to find any such options in the MS Access 2003 open dialog or menus.

Thanks,

Andrew

View 5 Replies View Related

Disabled Command Buttons In More Than One Form

Jun 30, 2005

Hi all,

I have a frmUserLoginScreen that opens frmMainSelectionScreen, which has 4 command buttons on it. Dependant on user level, some of the command buttons are disabled.

I have four user groups, manager, admin, IT and guest. When the guest logs on, the frmMainSelectionScreen only has one command button enabled. Once clicked, this opens frmClientDetails which has a command button that enables the user to add a record.

Basically, I want the add record command button to be disabled on the frmClientDetails if the user is a guest.

I've tried all sorts of code to reference the other forms but I'm not having any luck. Has any kind fellow got any ideas?

Thanks

View 7 Replies View Related

Need Help On Giving Form Labels A Disabled Look

Sep 27, 2004

Hey guys - I am creating a fake webpage looking database in MS Access Project. On the form I am using labels with hyperlinks that directs the current focused label to do something. I have user rights in my database, and depending on perimissions, i want to disable a lablel like you can do a textbox. I am trying to duplicate a disabled textbox with label look. My coworker had a procedure in API that allowed you to pass a control or label in it, and it will give it the disabled look. Problem is, he lost it can someone help me please. I don't want to go back into my system and change everything over to command buttons or textboxes.

Any help would be appreciated..

View 5 Replies View Related

Enforce Referential Integrity Field Disabled

Mar 19, 2007

Hi,

I opened the relationship window to do the relationships among my tables; however, the check box 'Enforce Referential Integrity' is disabled. I don't understand why is that? And is there anyway to change it?

Also, where should relationships be implemented? is it the FE or BE?
Any help will be very much appreciated.
B

View 14 Replies View Related

General :: User-based Security Disabled

Sep 24, 2012

I have an Access 2003 db being used through Access 2007 in order to use user-based security.It is a spit db with the be being on a shared server.For some reason, the security login has been deactivated after working fine for over a year. The user goes right to the autoexec macro file without having to log in.

They are also getting a "Read-Only" message at the top about only being able change table in linked tables.The DB is configured to utilize the logon as a parameter in some queries.

View 6 Replies View Related

General :: Navigate Pane Of Database Is Disabled

Dec 6, 2012

I need to modify the access 2010 database. But when I open it the navigate pane of that database is disabled. How to make it enable?

View 2 Replies View Related

Forms :: SETVALUE Argument Cannot Run In Disabled Mode

Oct 10, 2014

I don't know, I have noticed that the SETVALUE argument is not openly available in the lookup tables when setting a macro. (But that aside) I have set my drives c: and d: as trusted, and also thicked the sub folder option.

View 7 Replies View Related

Modules & VBA :: Sort / Filter Dropdown Being Disabled?

May 2, 2015

I'm using a dropdown that has the months of the year in it. The user selects a month and the form is then filtered by a date if its the first of whatever month is selected. It works fine but when the filter is applied I cant select the little arrow on the column headings and select the boxes (Select All, Blank, ETC...). It doesn't work on any column, just the apply text filter works but I cant select anything.

It works fine when I clear out the filters on the form. I tried to use vba to set the menusetting property to true and that didn't work either.

View 1 Replies View Related

Forms :: Controls With Data Not Locking Or Disabled

Jun 20, 2014

I've got some forms that I've set to lock controls based on an added tag. I have a loop that goes through the entire form and disables (controlname.enabled = false) or locks (controlname.locked =true) all the controls with that tag.

This appears to work fine when the form is on a blank record but when an existing record is opened, the controls that have data in them are no longer locked or disabled (empty controls are still locked). Is there an explanation for this behavior? I don't want to disable the entire form because there are controls that I want the user to be able to always access. I started by just disabling them, then when I noticed the problem I tried locking them instead but it happens with both. Is there another property I can try that will really lock them if they have data in them or not?

View 1 Replies View Related

General :: Can't Run Make Table Because Mode Is Disabled

May 17, 2013

How do you establish the Mode. I can't run a Make Table because the Mode is Disabled and blocking the action

View 1 Replies View Related

Modules & VBA :: MouseMove Event On Disabled Controls

Nov 29, 2013

I'm using a mousemove event to display help text for controls in my form.This works well, but I'd like to display help text when the control is disabled as well (to explain to the user why it's disabled).is there any way to fire a mousemove event when hovering over a disabled control?

View 1 Replies View Related

Forms :: Find Command Disabled In Ribbon

Nov 4, 2013

When I open my split form, the 'Find' command is disabled in the ribbon.

View 2 Replies View Related

Disabled Breakpoint Continues To Stop Code

Aug 15, 2014

I had to put a breakpoint into my VBA code in one of my apps to debug a problem I was having and inspect the variable values. All was well until I finished the debugging process and tried to eliminate my breakpoints. However, the next time I ran the application, the code stopped as if one of the breakpoints was still active. I closed the application and reopened it (even rebooted the computer) and the code continues to stop in the same spot in the program. The only thing I can think of to do is to create a new empty Access database and import all the objects from the old one. I'm thinking the database must be corrupt and this is all I know to try.

View 3 Replies View Related

How To Programmatically Disabled The Warning Messages In The Outlook 2003

Jul 19, 2007

when trying to automatically send email through MS Access application, the following message appears:

"a program is trying to access e-mail addresses you have stored in Outlook and asking if you want to allow this"
"a program is trying to automatically send e-mail..."

How to disable these warning messages when executing MS Access application to send email?

THANKS

View 2 Replies View Related

Disabled Append Queries - Due Patch Update To Windows

Mar 28, 2008

Hi,

I'm hoping someone might be able to help point in the right direction. Our IT department applied a patch update to windows 2000 overnight, which has had an impact on the Append queries in my DB.

Basically I have a number of append queries that use lookup tables to append the appropriate data from the underlaying table to the required table. They all have a relationship of "only include rows where the join fields from both tables are equal".

These were all working fine yesterday, but this morning, even though there is data in the underlaying table that meets the criteria, not data is being identified.

Has anyone any idea, as our IT department don't know and are not prepared to undo the patch update.

Your assistance would be most appreciated.

John

View 1 Replies View Related

General :: How To Make Previous Rows Disabled In Subform

May 26, 2013

I want to disable the previous row in the subform the moment I do a new row to prevent the user from editing information other users put before. Is it possible.

View 4 Replies View Related

General :: Create MDE With All Menus And Shift Key Access Disabled

Jul 18, 2014

How I can create an MDE with all options disabled including shift key bypass.

I want to remove all options in Tools>Startup except for the status bar.

I have tried using this code but am not getting anywhere with it

CurrentDb.Properties("AllowByPassKey") = 0

View 8 Replies View Related

Tables :: Action Or Event Has Been Blocked By Disabled Mode

Mar 18, 2013

When trying to append to a table, I get, "the action or event has been blocked by Disabled Mode!

View 14 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved