Can't Disable Form.AllowEdit

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!

DNB



ADVERTISEMENT

Enable/disable All Controls On Form

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...]

Thoughts!

Thanks!
-madEG

View Replies View Related

Enable/Disable Table Or Form?

Enable/Disable table or form?

After setting both accounts if user is accessing the database then I want to disable him from editing or adding a new record sth like this Form(name).enable = false and if the user is admin then he can edit and add records Form(name).enable = true, is that possible?

am not sure if I have to use the enable or locked property :)

This is my code

Private Sub Command7_Click()
Dim strSql As String
Dim rs As DAO.Recordset



strSql = "Select adminpass From admin"
Set rs = CurrentDb.OpenRecordset(strSql, dbOpenForwardOnly)


If ((Nz(txtpassword, "") = "") Or (Nz(combusername, "") = "")) Then

MsgBox "Please Enter A Valid Access", vbOKOnly, "Error"

ElseIf (txtpassword = rs!adminpass And combusername = "admin") Then

DoCmd.Close acForm, "Secure"
DoCmd.OpenForm "Home"


ElseIf (txtpassword = "user" And combusername = "user") Then

DoCmd.Close acForm, "Secure"
DoCmd.OpenForm "Home"

Else

MsgBox "Wrong Password, Please Try Again", vbOKOnly, "Error"
combusername = ""
txtpassword = ""
combusername.SetFocus


End If
End Sub

View Replies View Related

Disable New Record Button On A Form

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 Replies View Related

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

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?

thanks

View Replies View Related

VBA Code To Disable A Filter On A Form

Hi Everyone. Listen, I am creating a database and in one of the forms I am trying to build a button for the user to click on to remove a filter from the data that they are currently viewing on the form(s). I don't want the user to have to use any of the filter buttons that are built into Access. I would rather that the user click on a button I built within the form, however I am having some trouble with the VBA code that would be needed to do such a thing, this is due to the fact that I have not work with VB in long time. Please help me remove these filters.

Thanks,
Spicoli

View Replies View Related

Disable PgUp And PgDown In A Form

Disable PgUp and PgDown keys in a form



First set the Form's “Key Preview” property to True ….. then put the following code behind the "On Key Down" event.

code:Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)

Select Case KeyCode

' 33 = PgUp; 34 = PgDown

Case 33, 34

KeyCode = 0

End Select

End Sub

View Replies View Related

Enable/Disable All Controls On A Form

Description
Enables or disables all controls in the specified section of the specified form

Comments
Controls that have focus cannot be disabled. Therefore, if you call this procedure for a section that contains the control that has focus, all controls except that control will be disabled.

Example
Sub DisableControls()
' ==============================================
' Example code for EnableDisableControls()
' ----------------------------------------------
' Disable all controls in the detail section
' of the form named 'Customers'
' ==============================================
Dim bOK As Boolean

bOK = EnableDisableControls("Customers", 0, False)


End Sub
Function EnableDisableControls(strForm As String, intSection As Integer, fEnable As Boolean) As Boolean
' Comments : Enables or disables all controls in the specified section of the specified form
' Parameters: strForm - name of a currently open form
' intSection - number of the section to enable/disable controls in
' fEnable - True to enable controls, False to disable
' Returns : True if successful, False otherwise
'
Dim frmIn As Form
Dim ctlTmp As Control

On Error GoTo err_EnableDisableControls

Set frmIn = Forms(strForm)

For Each ctlTmp In frmIn.Controls

If ctlTmp.Section = intSection Then

On Error Resume Next
ctlTmp.Enabled = fEnable
On Error GoTo err_EnableDisableControls

End If

Next ctlTmp

EnableDisableControls = True

exit_EnableDisableControls:
Exit Function

err_EnableDisableControls:
EnableDisableControls = False
Resume exit_EnableDisableControls

End Function

View Replies View Related

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

Hi,

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
Luke

View Replies View Related

Disable Right Click On A Form - Version: 2003 (11.0)

is there a way to disable the right click of the mouse in a form?
Any help appreciated.

View Replies View Related

Disable Textbox On Main Form From Button On Subform

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 Replies View Related

Hide/disable Record Info At Bottom Of Form

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,

Paul.

View Replies View Related

Open Form And Disable Adding New - Version: 2002 (10.0) XP

Hello all. I'm trying to open a specific record on a form from a command button. Here's the code: DoCmd.OpenForm "frmAuditFindings_EditOnly", , "[Audit_Finding_ID] = " & Me.Audit_Finding_ID, acFormEdit

No problem so far.

The problem is that I don't want the user to be able to Add a new record. I've tried setting the "Allow Additions" property of the form to No with no luck. Any ideas?

Thank you very much

View Replies View Related

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

Hi,

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

View Replies View Related

How To Disable Subform Untill Values Selected In Main Form?

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.


http://i5.photobucket.com/albums/y180/method007/disablesubform.jpg

(form picture)

View Replies View Related

How Do I Disable Copy/Paste In An Individual Form? - Version: 2002 (10.0) XP

Well, that's pretty much the whole question.

We've had problems with our call centre logging phone numbers incorrectly, so we want them to verify the numbers in a separate box, but we don't want them to simply copy/paste the info they have.

Other forms in the database do still require the copy/paste function so the command mustn't lock the whole database.

Thanks in advance.

View Replies View Related

Disable Opening Specific Form In Design View - Version: 2003 (11.0)

I would like to prevent users from opening a specific form in design view.
This includes preventing the form from opening when the user clicks on the
Design button in the Forms tab of the database window.

Thanks for any ideas.

Sha.

View Replies View Related

Using User Level Security To Disable Form & Report Controls - Version: 2003 (11.0)

At times a developer will have to restrict access to certain controls on forms or reports depending on who is logged into a database. To achieve this, the develop would have to write custom code via a logon form and include it into the design.
Doing this can be time consuming and somewhat inefficient if different groups are continually going to be added and possess varying levels of access.

As such I have written some code that would allow you to disable controls on forms and make invisible controls on reports by using Microsoft Access User Level Security (ULS) (note: this code will not work on switchboards)

Using the sample in the download.
The zip file holds the “Disable Controls with ULS” folder with 4 files inside. These files are listed as follows:
1.Information on the workgroup ID : "WorkGroup ID"
2.The DB itself. : " ULS to Disable controls"
3.The workgroup file: " Secured"
4.Shortcut connecting the DB and Workgroup file. "Shortcut"

You first need to extract the zip file to your C: drive. Once it is on your C: drive open the " Disable Controls with ULS" folder and click on the Shortcut. The passwords for the various groups are as follows:
Group..........................User..........................Password
Clerk.........................Roger........................Roger
Supervisor................... Mark..........................1234
Manager..................... Leslie.........................5678
Admins....................... Miller..........................password

What you can do is keep logging on using the “shortcut” as a different user and open the various forms and reports to see how the controls are disabled.

Using the Code in your DB that already has ULS set-up.
If your DB already has ULS set-up and you want to use the code to disable controls on forms or reports then you need to import the following objects from the “ULS to Disable Controls.mdb” These objects are:
Tables
Tbl_Controls
Tbl_Groups
Tbl_Form_AND_Control_Names
Forms
Administrator
Administrator_Subform
Modules
Enabling Security Controls.

After the objects are imported you need to open the administrator form. Opening this form causes all the existing groups to be added to the Tbl_Groups. The next thing is to click on the “Set Group Permissions – For Form and Report Controls”. Then you would need to click on “Update New Controls” by doing this all the controls on all forms and reports will be added to the table Tbl_Form_AND_Control_Names.

You now need to use the navigation buttons to choose a group and the relevant form or report. Then select the name of the control in the sub-form and tick disabled.
The last thing to do is call the function (SecurityEnabled) from the module Enabling Security Controls. The function is called from the OnOpen Event and the syntax differs depending on if you are on a form or report E.g

Report: Call SecurityEnabled(“YourReportName”, “Report”)
Form: Call SecurityEnabled(“YourFormName”, “Form”)

And that’s it you are good to go.
Final Points to note:
1.I recommend using the administrator form last when you DB is 99% finished. That way you are sure that your form and report controls names are not continually changes.
2.Users can only belong to two groups, the “users” group and any other group you so decide.


Never used ULS
For Starters I must say that ULS is a bit difficult to understand first time around and I know many of us have experienced being locked out our DB’s. As such I am providing some links as a guide on setting up ULS. I URGE ANYONE WHO HAS NEVER SET-UP ULS BEFORE TO READ THE LITERATURE CAREFULLY.

Security.mdw
Steps to Securing and Access DB using User level Security
This next site has some excellent literature and links. Make sure to read properly.
www.geocities.com/jacksonmacd


Dallr

View Replies View Related

Disable Access To A Form Button Based On User Level - Version: 2003 (11.0)

I have a form (frm_mainmenu) that contains a button (btnOpenMaintain) that opens another form (frm_maintain). I want to place restrictions on access to frm_maintain.

There is a log in form (frm_logon) that has a combo box (cboLogin) which has a list of users defined from table dbo_users displaying the field strUsrLogin.

On this table dbo_users there is a field lngUsrType, which stores a number. I intend to use this number to define wether they can operate btnOpenMaintain. If the user is a level 9 then they can not access. If they have any other level, between 1 & 8, they can.

So I figured I could write a code like this, which will basically kick in wether that button is useable or not.

Code: Private Sub frm_mainmenu_Initialize()

Dim xuser As String
xuser = [Forms]![frm_Logon]![cboLogin]

If DLookup("strUsrLogin", "dbo_users", "lngUsrType=" & xuser) < 9 Then

btnOpenMaintain.Enabled = True
Else
btnOpenMaintain.Enabled = False
End Sub

My intention was that when the form frm_mainmenu opened it would trigger this blocking. However I can't get it to work. Does anyone have any suggestions how I can?

By the way my VB coding isn't to hot, so if you can suggest improvements be my guest.

View Replies View Related

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

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 Replies View Related

Disable Min / Max

Hi

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

Plug

View Replies View Related

Disable Password

Hi:

i have a aplication in MS ACCESS, and in VB editor i put a password (not the MS access but only the source have password)
Now i have a patch that open my aplication and try to delete a Form (that have VB language associated) and didnt delect. i try to turn off the password manually and everything ok.
So my question is, i need to turn off the protection but in vb code in my patch.

Sub DeleteForm(bdados As String, tipo As String, Nome As String)
'Define as Static so the instance of Access
'doesn't close when the procedure ends.
Static acc As Access.Application
Dim db As DAO.Database
Dim strDbName As String
strDbName = bdados
Set acc = New Access.Application
acc.Visible = True
Set db = acc.DBEngine.OpenDatabase(strDbName, False, False)
acc.OpenCurrentDatabase strDbName
acc.DoCmd.DeleteObject tipo, Nome
db.Close
Set db = Nothing
End Sub

when this line run "acc.DoCmd.DeleteObject tipo, Nome" give me a error because the Form that i want to delete have a VB password


thanks

View Replies View Related

Disable Shift Key, F11 Etc..

Hi,

I am just about to set up user level security for my database. Before I do, how do I disable the holding the shift key thing when opening a database to get into the database window?

I want to make it so the users can't see the database window or access the backend data. As I will need to give permissions to use most of the tables, how is this done?

I am using Version: 2002 (10.0) XP

Any help would be much appreciated.

Thanks

View Replies View Related

Disable The [Shift] Key

I need to disable the [Shift] key so that when the users open my MS Access database, they cannot by pass the open form and display the database window.

We had code that worked correctly with an MS Access 2000 MDB, and even works with an MS Access 2003 ADP, but the same code is ignored by MS Access 2003 MDB.

We add Module named "DisableByPassKey", here is the code...

Public Function SetProperties(strPropName As String, varPropType As Variant, varPropValue As Variant) As Integer
On Error GoTo Err_SetProperties

Dim prps As AccessObjectProperties
Dim prp As AccessObjectProperty
Dim isPresent As Boolean


Set prps = Application.CurrentProject.Properties
For Each prp In prps
If (StrComp(prp.Name, strPropName, vbTextCompare) = 0) Then
isPresent = True
Exit For
End If
Next

If (isPresent) Then
prps(strPropName).Value = varPropValue
Else
prps.Add strPropName, varPropValue
End If

Exit_SetProperties:
Exit Function

Err_SetProperties:
If Err = 3270 Then 'Property not found
Properties.Append prp
Resume Next
Else
SetProperties = False
MsgBox "Runtime Error # " & Err.Number & vbCrLf & vbLf & Err.Description
Resume Exit_SetProperties
End If

End Function

The code does not cause an error, it just seems to do nothing. When I set the [Shift] key to "disabled", then re-open the database, the [Shift] key works once again.

If you have any ideas, it would be great.

Thank you!

View Replies View Related

Disable Spaces

Hi, I have a text box in a from for data entry, how do I disable a space. For example I don't want the user to have a space between charaters or before and after a charater. Thanks.

View Replies View Related

Disable Problem

The code to disable shift keys at start up that has been posted here numeroous times is causing me problems. I am a complete novice with vba. but i cannot seem to get it to work and there seems to be a problem with the following line of code:-

db.Properties(strPropName) = varPropValue

Can anyone explain what may be going wrong. The shift key still by-passes and no password is asked for. If I do click the button on the start-up screen and enter the password I get error 3270 and the line above is highlighted.

View Replies View Related

Yes/no Enable Disable

Here is my problem: When a certain yes/no box is true (checked) other fields on the form are not enabled. That works just find when I am on the record that I click the yes/no field. When I go to another record and then go back to the previous record the fields that should be disabled due to a certain yes/no box being true are now enabled and not disabled. Below is my code. Can anyone tell me what I am doing wrong?

Private Sub Form_Current()

SetCheckBoxes

End Sub

Private Sub SetCheckBoxes()

If Me.StaPrimary = True Then
Me.StaUp.Enabled = False
Me.StaUpTrainerFirstName.Enabled = False
Me.StaUpTrainerLastName.Enabled = False
Me.StaUpVerifyDate.Enabled = False
Me.StaUpReverifyDate.Enabled = False
Me.StaBack.Enabled = False
Me.StaBackTrainerFirstName.Enabled = False
Me.StaBackTrainerLastName.Enabled = False
Me.StaBackVerifyDate.Enabled = False
Me.StaBackReverifyDate.Enabled = False
Me.StaOther.Enabled = False
Me.StaOtherTrainerFirstName.Enabled = False
Me.StaOtherTrainerLastName.Enabled = False
Me.StaOtherVerifyDate.Enabled = False
Me.StaOtherReverifyDate.Enabled = False
End If

If Me.StaPrimary = False Then
Me.StaUp.Enabled = True
Me.StaUpTrainerFirstName.Enabled = True
Me.StaUpTrainerLastName.Enabled = True
Me.StaUpVerifyDate.Enabled = True
Me.StaUpReverifyDate.Enabled = True
Me.StaBack.Enabled = True
Me.StaBackTrainerFirstName.Enabled = True
Me.StaBackTrainerLastName.Enabled = True
Me.StaBackVerifyDate.Enabled = True
Me.StaBackReverifyDate.Enabled = True
Me.StaOther.Enabled = True
Me.StaOtherTrainerFirstName.Enabled = True
Me.StaOtherTrainerLastName.Enabled = True
Me.StaOtherVerifyDate.Enabled = True
Me.StaOtherReverifyDate.Enabled = True
Me.StaPrimaryVerifyDate = ""
Me.StaPrimaryReVerifyDate = ""

End If

If Me.StaUp = True Then
Me.StaPrimary.Enabled = False
Me.StaPrimaryTrainerFirstName.Enabled = False
Me.StaPrimaryTrainerLastName.Enabled = False
Me.StaPrimaryVerifyDate.Enabled = False
Me.StaPrimaryReVerifyDate.Enabled = False
Me.StaBack.Enabled = False
Me.StaBackTrainerFirstName.Enabled = False
Me.StaBackTrainerLastName.Enabled = False
Me.StaBackVerifyDate.Enabled = False
Me.StaBackReverifyDate.Enabled = False
Me.StaOther.Enabled = False
Me.StaOtherTrainerFirstName.Enabled = False
Me.StaOtherTrainerLastName.Enabled = False
Me.StaOtherVerifyDate.Enabled = False
Me.StaOtherReverifyDate.Enabled = False
End If

If Me.StaUp = False Then
Me.StaPrimary.Enabled = True
Me.StaPrimaryTrainerFirstName.Enabled = True
Me.StaPrimaryTrainerLastName.Enabled = True
Me.StaPrimaryVerifyDate.Enabled = True
Me.StaPrimaryReVerifyDate.Enabled = True
Me.StaBack.Enabled = True
Me.StaBackTrainerFirstName.Enabled = True
Me.StaBackTrainerLastName.Enabled = True
Me.StaBackVerifyDate.Enabled = True
Me.StaBackReverifyDate.Enabled = True
Me.StaOther.Enabled = True
Me.StaOtherTrainerFirstName.Enabled = True
Me.StaOtherTrainerLastName.Enabled = True
Me.StaOtherVerifyDate.Enabled = True
Me.StaOtherReverifyDate.Enabled = True
Me.StaUpVerifyDate = ""
Me.StaUpReverifyDate = ""

End If

If Me.StaBack = True Then
Me.StaPrimary.Enabled = False
Me.StaPrimaryTrainerFirstName.Enabled = False
Me.StaPrimaryTrainerLastName.Enabled = False
Me.StaPrimaryVerifyDate.Enabled = False
Me.StaPrimaryReVerifyDate.Enabled = False
Me.StaUp.Enabled = False
Me.StaUpTrainerFirstName.Enabled = False
Me.StaUpTrainerLastName.Enabled = False
Me.StaUpVerifyDate.Enabled = False
Me.StaUpReverifyDate.Enabled = False
Me.StaOther.Enabled = False
Me.StaOtherTrainerFirstName.Enabled = False
Me.StaOtherTrainerLastName.Enabled = False
Me.StaOtherVerifyDate.Enabled = False
Me.StaOtherReverifyDate.Enabled = False
End If

If Me.StaBack = False Then
Me.StaPrimary.Enabled = True
Me.StaPrimaryTrainerFirstName.Enabled = True
Me.StaPrimaryTrainerLastName.Enabled = True
Me.StaPrimaryVerifyDate.Enabled = True
Me.StaPrimaryReVerifyDate.Enabled = True
Me.StaUp.Enabled = True
Me.StaUpTrainerFirstName.Enabled = True
Me.StaUpTrainerLastName.Enabled = True
Me.StaUpVerifyDate.Enabled = True
Me.StaUpReverifyDate.Enabled = True
Me.StaOther.Enabled = True
Me.StaOtherTrainerFirstName.Enabled = True
Me.StaOtherTrainerLastName.Enabled = True
Me.StaOtherVerifyDate.Enabled = True
Me.StaOtherReverifyDate.Enabled = True
Me.StaBackVerifyDate = ""
Me.StaBackReverifyDate = ""

End If

If Me.StaOther = True Then
Me.StaPrimary.Enabled = False
Me.StaPrimaryTrainerFirstName.Enabled = False
Me.StaPrimaryTrainerLastName.Enabled = False
Me.StaPrimaryVerifyDate.Enabled = False
Me.StaPrimaryReVerifyDate.Enabled = False
Me.StaUp.Enabled = False
Me.StaUpTrainerFirstName.Enabled = False
Me.StaUpTrainerLastName.Enabled = False
Me.StaUpVerifyDate.Enabled = False
Me.StaUpReverifyDate.Enabled = False
Me.StaBack.Enabled = False
Me.StaBackTrainerFirstName.Enabled = False
Me.StaBackTrainerLastName.Enabled = False
Me.StaBackVerifyDate.Enabled = False
Me.StaBackReverifyDate.Enabled = False
End If

If Me.StaOther = False Then
Me.StaPrimary.Enabled = True
Me.StaPrimaryTrainerFirstName.Enabled = True
Me.StaPrimaryTrainerLastName.Enabled = True
Me.StaPrimaryVerifyDate.Enabled = True
Me.StaPrimaryReVerifyDate.Enabled = True
Me.StaUp.Enabled = True
Me.StaUpTrainerFirstName.Enabled = True
Me.StaUpTrainerLastName.Enabled = True
Me.StaUpVerifyDate.Enabled = True
Me.StaUpReverifyDate.Enabled = True
Me.StaBack.Enabled = True
Me.StaBackTrainerFirstName.Enabled = True
Me.StaBackTrainerLastName.Enabled = True
Me.StaBackVerifyDate.Enabled = True
Me.StaBackReverifyDate.Enabled = True
Me.StaOtherVerifyDate = ""
Me.StaOtherReverifyDate = ""

End If

End Sub

View Replies View Related

Disable Button

I am not sure but this how it should work in VB, I am trying to disable a button that exists on a different form:

ACAudio!Command89.Enabled = False

Where ACAudio is the name of the form and Command89 is the name of the button but I keep getting an error saying object required.

View Replies View Related

Disable Right Click

Hi, Im currently creating a database for an A-Level project.
I am required to create a database for a real company.
They have asked me to stop the right click function on forms.
I have disabled almost every feature on the forms, however i cannot find a way to disable right click.
Please help.

Pete

View Replies View Related

Disable Button

I want to disable the button "cmdNew" unless certain criteria are met. Here is the code that runs in Form_Current :

Private Sub Form_Current()

Me.cmdNext.Enabled = (Me.RecordsetClone.RecordCount > Me.CurrentRecord)
Me.cmdPrevious.Enabled = Me.CurrentRecord > 1
Me.cmdLast.Enabled = (Me.RecordsetClone.RecordCount > Me.CurrentRecord)
Me.cmdFirst.Enabled = Me.CurrentRecord > 1

If (Me.cboStatus.Value = "Approved" Or Me.cboStatus.Value = "Approved as Noted" Or IsNull(Me.cboStatus) Or Me.RecordsetClone.RecordCount > Me.CurrentRecord) Then
Me.cmdNew.Enabled = False
Else
Me.cmdNew.Enabled = True
End If

End Sub

The navigation buttons work flawlessly but the cmdNew button still is enabled when it shouldn't be. THe idea is that is will be disabled if:

-current record is not the last record
-cbostatus is blank(null)
-cbostatus is "approved"
-cbostatus is "approved as noted"

The only code that seems to work is the "me.recordsetclone.recordcount > Me.currentrecord" .

Am I going about this the wrong way? How can I check what is in the cbostatus box and have the cmdnew button enabled/disabled based on its value.

Thank you

View Replies View Related

Disable Menus

I have the following code in the on_load of all of my forms to disable all menus:Dim i As IntegerFor i = 1 To CommandBars.CountCommandBars(i).Enabled = FalseNext iThe problem is that when I open a report in preview mode I cannot close, print, etc.Two questions:1. Is the above approach the best way to disable all menus and toolbars?2. How do I add a custom toolbar (already created) to the report preview only. I've tried doing in in the properties and by me.toolbar = "custom toolbar." Neither approach works. I suspect that the code I've used to disable the menus is keeping me from adding custom menus where I want them?I should also mention that I have also turned off all of the menus, toolbars, etc. in the options/startup.Thanks for your help!

View Replies View Related

Disable VDU Output

Hi Everyone

Does anyone know how to disable the vdu output to the screen when loading multiple forms etc.

I have an annoying flicker when my main form is reloading.

Thanks in advance for any help,

Kindest regards

Tony

View Replies View Related

Disable VDU Output

Hi Everyone

Does anyone know how to disable the vdu output to the screen when loading multiple forms etc.

I have an annoying flicker when my main form is reloading.

Thanks in advance for any help,

Kindest regards

Tony

View Replies View Related







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