(user meaning the person using the inputbox not the person who implements/maintains the code). d939d8ej3.Īny hints/ideas for a different user friendly approach would be welcome. The used value is usually some alphanumeric string e.g. SomeSubThatWritesTheChangedStringBackToItsOrigin strInputBox StrInputBox = InputBox(Prompt:="Edit/Delete Value", Title:="Title", Default:=strSomeStringFromSomewhere) We can use this variable text in the further programming. This will help us to access,store and input the msgbox response or string in variable value. StrSomeStringFromSomewhere = someSubThatGetsTheStringValueFromSomeWhere If you want to delete a record you first have to move to it (see above) making it the current. The below example on vba msgbox yes no cancel return to access the response of MsgBox.
#Access vba code examples okay cancel code#
Here's the code that worked so far (as long as I don't need to use the inputbox to delete the value, since 'strInputBox = ""' is reserved for the cancel-event and I want to avoid using 'strPtr'). MsgBox 'You clicked the cancel button', vbInformation, 'Bye'. I'm trying to avoid using StrPtr for the reason I described above. strResponse InputBox ( 'Enter the Password To Continue', 'Enter Credentials') 'A clicked 'Cancel' button will result in a blank value. Now I got the case where I need to "clear" the existing default value. So far I only needed to change this value through the inputbox so the simple check for if len(inputboxString) = 0 then to determine if cancel was pressed was working well. Now, you need to make the form 'talk' to the presenter - the easiest way is to expose events in the UserForm1 code-behind - for example if we want the user to confirm cancellation, we'll add a ByRef parameter to the event, so the handler in the presenter can pass the information back to the event source (i.e. In my scenario, the inputbox pops up with a default value it got from somewhere else. I wasn't able to reproduce the problem so far so I'm looking for a different solution.
#Access vba code examples okay cancel how to#
For some reason, the solution those two questions ( Q1, Q2) give on how to differentiate between "cancel" and "ok with an empty string" for an inputbox don't always work within a specific code of mine.
0 kommentar(er)
