why "allow value list edits" button disappear when "allow full menus" disabled?
Is there a way to show "allow value list edits" button when "allow full menus" disabled?
why "allow value list edits" button disappear when "allow full menus" disabled?
Is there a way to show "allow value list edits" button when "allow full menus" disabled?
Guess I never used it, where do I find the 'allow value list edits' button?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Okay, found it. I have comboboxes set not to allow value list edits. Never had reason to allow.
My guess is that if it is tied to disabled ribbon or shortcut menu then it won't be available, period. Maybe the NotInList event could be used.
Last edited by June7; 03-29-2012 at 11:18 AM.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
ok thanks I'll try that one
June7 I made some code like this:
the question isCode:Private Sub Costumer_NotInList(NewData As String, Response As Integer) Dim intAnswer As Integer Dim i As Integer intAnswer = MsgBox(Chr(34) & NewData & Chr(34) & "is currently not in the list." & vbCrLf & "Do you want to add new costumer?", vbQuestion + vbYesNo, "Not yet in List") If intAnswer = vbYes Then DoCmd.OpenForm "Costumers Form", , , , acFormAdd, acDialog Response = acDataErrAdded Else Response = acDataErrContinue i = MsgBox("Choose Costumer from list.", vbOKOnly, "Info") End If End Sub
1. How do I make when user answers "no", it will clear the newdata just typed on "Costumer" field(combobox one)?
2. How do I Insert newdata just typed on "Name" field of Costumer form just opened if user answers "yes"?
If no: Me.Costumer = Null
If yes: automating to fill in the value on calling form (instead of requiring user to enter again) gets tricky. One way is for the customer form to set the value on the first form before closing, like:
Forms!firstformname.controlname = Me.CostumerID
Costumer or Customer?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
LOL I got spell wrong.. it's customer..
Another approach is for the first form to grab the data from the second form. I use this when a form can be called by several forms. Example from my project.Code:DoCmd.OpenForm "DialogGetDate", , , , , acDialog, "Logout" If CurrentProject.AllForms("DialogGetDate").IsLoaded Then Form_SampleManagement.tbxDate = Form_DialogGetDate.tbxDate DoCmd.Close acForm, "DialogGetDate" End If
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
I realized that we can do it without NotInList event and the "button" I said earlier to add a list and open customer (now I spell it correctly LOL) form automatically.
just write some text that isn't in the list yet and just tab over or enter it and the msgbox from microsoft access pops up.
is there a way to change the msgbox content to something else? because I need to change it to some other text in msgbox?
I'll try the one you offered.
I think one reason for the NotInList event is to allow alternate message.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.