Can't Disable Form.AllowEdit

Aug 24, 2005

Hi, I got a strange problem. When I set MyForm.AllowEdits to "False", I can still edit the fields on it from Access 2002 I am working with. I searched the documentation and found I did nothing wrong. But when I copy the file to another computer running Access 2000, the setting works there. Now I can copy back the program to my own computer and it works. It is so strange to me. Why the same setting works differently in different computer? Any suggestions and expanation will be appreciated!


View Replies


Enable/disable All Controls On Form

Jan 10, 2008

Hello. I have a form with a million little buttons on it (don't get me started, I didn't design it! - heh)...

Depending upon which user is running the mdb, I would like all but 16 (of the 80 or so) objects/controls disabled/enabled. I would like to autodisable all the controls, then enable the subset (or all of them) depending who the current user is.

SO in short, other than individually disabling/enabling the many items, is there a magic command for vba, similar to enable *.* for controls [silly e.g., but I hope you get my point...]



View 2 Replies View Related

Disable New Record Button On A Form

Jan 9, 2006

is there a way to disable the new record option (>*) at the bottom of the form...i want my users to be able to search all records through the form sometimes, but not add any new ones accidentally (or intentionally) while doing so. :confused:

View 2 Replies View Related

How To Disable Form Window While The Second One Is Being Opened?

May 17, 2006

Hi all, I have a main form which contains buttons to control all other window. I'd like to prevent user to work on two forms at the same time. Can anyone advise me how to disable the main window while the second window is opened?


View 3 Replies View Related

Forms :: Disable Ctrl F4 Key On Form

Jul 22, 2014

I have tried a few combinations with No success! Using Access 2010 32 bit.

Select Case KeyCode

Case vbKeyF4
'MsgBox "The F4 key was Pressed"
KeyCode = 0
Case Else
'MsgBox "No match!" 'testing
End Select

Dim intAltDown As Integer
intAltDown = (Shift And acAltMask)

> 0

View 7 Replies View Related

Disable Showing New(empty) Record In A Form??

Apr 29, 2005


I am currently working on a database and I'm using a form to view the records. A standard Access behavior is to show an empty record (new record) as the last one. is there a way to disable this "feature". I would like my form to display only the records, which are really filled with data and not show the blank one at the end??

Thanx in advance

View 3 Replies View Related

Forms :: Any Way To Disable Hot Keys At Login Form

Nov 16, 2013

I have a fully functioning frmLogin that appears when the database opens. After correctly logging in, it takes you to the appropriate switchboard. The problem is that I set autokeys to allow F1 to automatically open the switchboard, but I don't want users to hit this to bypass my login screen. The reason for keeping the switchboard open is to force the user to close the database using the switchboard(eventually I want to limit the user to only the forms that I have created in a split database).

My other option that I tried first was writing a module that would detect when all forms are closed, then open the switchboard. But I kept getting Error91 and got frustrated/stopped attempting this method. Using the hotkey gives the user a similar functionality, but less conveniently so(since its not an automated process, etc.).

View 4 Replies View Related

Forms :: Disable Navigation Buttons On Form

Mar 20, 2015

In A2007 if you disable the Navigation Buttons on the form the Me.RecordCount will be set to 1 when the form opens ? I replace the Nav buttons with my own set but my "Go Next" button will not work untill I hit "Go to Last". This apparently restores the recordset count to the correct number of records.

View 14 Replies View Related

Forms :: Disable Shortcut / Right Click On A Form

Oct 21, 2013

I am running Access 2010. I have added the following to the "On Open" event on my main form:


Private Sub Form_Open(Cancel As Integer)
DoCmd.ShowToolbar "Ribbon", acToolbarNo
DoCmd.NavigateTo "acNavigationCategoryObjectType"
DoCmd.RunCommand acCmdWindowHide
Me.ShortcutMenu = False
End Sub

My main form (frmMain) is displayed when the database opens. As you can see, I am hiding the ribbon and the navigation pane from users. I also want to prevent users from right clicking on the form and opening it in Design view - trying to prevent any monkey business. However, the line:Me. ShortcutMenu = False

is not preventing users from right clicking on the form and getting the shortcut menu and going into Design view.If I go to Options and uncheck: "Allow Default Shortcut Menus" then I lose the ability to print reports because I have the ribbon hidden and this will not allow right click on reports.Converting to .accde is not an option at this time.

View 1 Replies View Related

How To Disable Save / Close Window In Form

Aug 14, 2012

I would like to disable this window : (which appears by right-clicking mouse on form headline)

So the users won't be able to close form by right-clicking. How to do it?

View 2 Replies View Related

Disable Textbox On Main Form From Button On Subform

Jun 23, 2005

My subform when i click the New record button on the subform i want it to disable a text box that is on the main form.

Me.Pensioners.Form!quicksearch.Enabled = False

where Pensioners is the name of the Parent Form. Thhis isnt working for one reason or another. Please advise.

View 3 Replies View Related

Hide/disable Record Info At Bottom Of Form

May 9, 2006

Apologies if this is an obvious one but is it possible to hide this:

"Record:1 out of 34" and the arrow buttons at the bottm of a form(s)?

I would rather use my own Next Record and Previous Record buttons so it would dieal to disable/hide these arrow buttons.

Many thanks for your assistance in advance,


View 2 Replies View Related

Forms :: Enable / Disable Checkbox On Continuous Form

Apr 5, 2015

I am asked to create a checklist for a number of tasks to be executed in a particular shift. However in some tasks can be skipped. There are three shifts per day.

To accomplish this i have created a continious form with a number of checkboxes per task which represent the days of the week. The tasks itself are stored in a seperate table with a checkbox per shift (task settings). If the tasks must be performed in a particular shift, the checkbox is activated (= true).

Goal here is, if a task doesn't have to be executed in a shift the task should not be visible on the continious form. The recordsource of the continuous form is a query, which contains a join between the table with the task settings and the table with the tasks performed.

I have placed some code to perform the task in the form's current event

In the continuous form current event I have placed for every checkbox the following code:

Private Sub Form_Current()
If Me. PerformTaskShift.Value = True Then
Me.MaandagOchtend.Enabled = False
End If
End Sub

However when i execute the code and load the form, not only the checkbox in the row mentioned are set invisible, all the rows are. Is there any way to set only the checkboxes on the rows mentioned invisible, in stead of all rows?

View 1 Replies View Related

Forms :: Disable All Fields On A Form When Field Is Not Null

Sep 22, 2014

I have a form called PAF_Assignment and on this form there are many textboxes for editing. After all fields are entered, the user clicks on a button and this button populates the PAF_Issued_Date field with the actual date.

Then I want to disable (enable=False) all fields on this form once there is a date on PAF_Issued_Date as I don't want any user to make any changes after submitting it, although the user would still be able to read the information submitted.

I have tried the following...

PAF_Assignment Form AfterUpdate Event
If Me.PAF_Issued_Date=Not null Then

[Code] ......

However this is not working, there is no error message or anything but the fields remain enabled with the date...

View 3 Replies View Related

How To Hide/disable A Button On A Form Based On SecurityID Level

Sep 29, 2005


Trying to remember how to hide/disable buttons on a form based on the users security levl they have. :)

View 2 Replies View Related

How To Disable Subform Untill Values Selected In Main Form?

Jun 29, 2005

Hi every body . I got a a form and sub form. I want to disable sub form untill the user finishes selecting values from combo box drop downboxes. I be happy if some one show me how to do this.

(form picture)

View 3 Replies View Related

Forms :: Table Form - Disable Fields Based On A Value Of Another Field

May 27, 2013

I have a table form (I want to have many records available in the screen)

I want to disable fields based on a value of another (main) field.

The fields are check boxes, so the automate formatting is not available.

I use the VBA code below:

Select Case name1
Case "POINT"
Me.sf1.Enabled = False:
Me.sf2.Enabled = False
Case Else
Me.sf3.Enabled = False
End Select

but the fields become disable to all records, not only to the records under the right condition. Why?

View 2 Replies View Related

Modules & VBA :: Look Up A Value In Table That Enable Or Disable Subform In Main Form

May 20, 2015

I have written code to look up a value in a table that then enables or disables a subform in my main form. The code works, but I know it is now as efficient as it can be. The main problem is that I have multiple values that determine if the subform should be enabled or disabled. I would like to use an IN statement but I'm pretty sure this doesn't work for Dlookup. Below is an example of the code I currently have:

Sub enablecontrols(setting As Boolean)
Inv_subform.Enabled = setting
End Sub
Private Sub Form_Current()

[Code] ....

Like I said, this works fine, but I am concerned if I need to add more items to look up and the stability of the code in general.

View 3 Replies View Related

Modules & VBA :: Code To Lock / Disable All Form Fields On Inputted Value?

Oct 25, 2013

I am looking to completely disable a record when a specific Yes/No tick box is checked.

By that I mean all form fields are locked and disabled when the Yes/No tick box is checked (Yes)

View 2 Replies View Related

General :: Unable To Disable Mouse Scroll Wheel On The Form

Apr 24, 2014

I'm trying to disable mouse scroll wheel on the form but no luck here,

View 1 Replies View Related

Forms :: Enable / Disable Navigation Button On Form Load?

Mar 25, 2013

Basically I want to put a code in the "on load" event of a form that enables or disables navigation buttons based on a value in a table (the table has 1 record and 1 column).

So if the value is "A", I want to hide navigation buttons on load; if it is "B", I want to show navigation buttons on load.

I know I can set this property in each form, but I have a number of forms that I want to configure at the same time.

My problem is that I don't know how to reference the value in the table.

View 3 Replies View Related

Forms :: Disable / Lock Fields On Form And Subform Based On Checkbox

Feb 15, 2014

I am trying to lock records on a form and subform after a checkbox has been ticked, have used the code below from a previous post.

Private Sub Form_Current()
If Locked = -1 Then
Me.AllowEdits = False
Me.AllowAdditions = False
Me.AllowDeletions = False

[Code] .....

This is locking the Main form records is there a way to code this so that the fields on the subform are also locked when the checkbox is ticked?

View 7 Replies View Related

Forms :: Disable Or Hide Minimize / Restore And Close Window Buttons On A Form

Mar 9, 2014

I need to disable or hide the restore, minimize and close window buttons found in the top right hand corner of a form.

I navigation buttons that controls open, close etc already set up.

View 4 Replies View Related

Forms :: Not Able To Disable Navigation Button When Login Navigation Form

Nov 15, 2014

I am not able to disable NavigationButton when i login navigation form using login form. I am using MS access 2007 - 2010.i am using below code but getting error.

Forms![Navigation Form]!NavigationButton13.enable = False´╗┐

Run-time error '438'
Object doesn't support this property or method.

Any other method to disable NavigationButton.

View 2 Replies View Related

How To Disable "right-clicking" On A Form?

Feb 17, 2006

I have a db where I have set the form properties to only allow edits in the design view, and I have disabled the tool bars/menus, but users can still right-click on the forms and get into the design view. How can this access be blocked? :confused:

Thanks in advance!

View 2 Replies View Related

Disable Min / Max

Sep 8, 2006


I know how to disable the min / max buttons on a form, but can anybody provide help with disabling the Min / Max buttons of the access application itself, I recently found some code that somebody had posted to disable the "X" button, now I would like to disable the min / max function as well.

Many thanks


View 3 Replies View Related

Copyrights 2005-15, All rights reserved