Code:
If Null([txtMRN]) And [Dirty] then MessageBox GoToControl txtMRN Elseif isNull(cboProviderName) and [Dirty] then Messagebox GoToControl cboProviderName ElseIf isnull(opgEvalType) and [Dirty] then MessageBox GotoControl opgEvalType
KatcDolly
Last Activity: Oct 18 '16, 05:19 PM
Joined: Sep 7 '16
Location:
-
I have figured this out. When using Macros Access does not like the nested If...then statement. Combine the Nested If into two ElseIf like so:
... -
BeforeUpdate Issue
I am using MS Access 2010 and trying to do everything in Macros.
I have a form (frmPt) that must have data in several fields. On the BeforeUpdate event I run this macro:
...Code:If Null([txtMRN]) And [Dirty] then MessageBox GoToControl txtMRN Elseif isNull(cboProviderName) and [Dirty] then Messagebox GoToControl cboProviderName ElseIf isnull(opgEvalType) and [Dirty] then
-
Phil and jforbes,
Thank you! T
The explanation and added reading are very educational and helpful. I will be back with more questions as I process this information. Thanks for your wisdom and support.Leave a comment:
-
Phil,
I removed the Private. Then a new compile error appeared highlighting the Me. I replaced the Me with Forms!FormName! in each Me. After that, It worked!! :)
I understand why Me needed to be replaced, but what did the Private do?
Do you have a recommendation to read and learn more about Modules?
Thank you for your helpLeave a comment:
-
Phil
I do.
I have the Module set as a private sub thinking it only needs to work in this database and it is a sub not a function.
I tried calling it 2 different ways in the form and got the same error:
The first way:
call enableDisable
The second way:
enableDisable
Katc DollyLeave a comment:
-
Thanks!
It does make it easier to understand. I did not know you could do it that way.
I appreciate you showing me this.Leave a comment:
-
I recognized I inadvertently named them the same and changed the Module name to My_enableDisabl e. When I tried it again, I still got an error. It said,
Compile Error
Sub or Function not defined
What am I missing?
ThanksLeave a comment:
-
Module Compiling Issues
I have code that needs to be used in multiple events. Please see link:
https://bytes.com/topic/access/answe...nt-not-working
I am having trouble with a Compile Error when I try to run it. Here is what I did, I placed it in a Module saved the Module as My_enableDisabl e. Then created the Private sub using the code. I called it in each event AfterUpdate and OnCurrent.
When I do this... -
I just had a conversation with someone about considering doing it with Enable/Disable. So Thank you!
Thanks also for the awesome examples and where to do things. I feel like I learned a great deal from you! It feels good!Last edited by KatcDolly; Sep 10 '16, 01:20 PM. Reason: In the respecting the idea of keeping a thread per topic. I moved this issue to a new post.Leave a comment:
-
Repaint onCurrent not working
I am going to open a new discussion that refers back to this pervious one.
https://bytes.com/topic/access/answe...lp#post3805999
I have code that runs for fields to be visible and invisible in my form. It is all working except when I move to a new record. The "repaint" is not working in the OnCurrent part of the form.
I have tried moving it around, but does not seem to... -
Added it to the onCurrent. Makes complete sense.
However, my repaint is still not clearing out the form when I move to a new record.
Fickle form, any ideas?Leave a comment:
-
repaint did not work entirely. When I move to a new record the screen does not go back to having nothing showing. It will work once I select for the next record.
Oh how I wish I could send you a sample db. I think we are very close.Last edited by KatcDolly; Sep 9 '16, 11:22 AM. Reason: I tried it again. After repainting in different locations, I observed the behavior closer to what we want. So I went back and tried zmbd way and worked.Leave a comment:
-
I did try it. So the case works. But does not turn off the fields. I have a sampe to send but do not know how to attached it. Can you tell me how to attach a zipped access db?Leave a comment:
-
Hi zmdb
I decided to return to using the If...then statements. From what I understand Case is not the best use for this. Here is what I am doing. I will try again and see if I can make better sense for you.
I am capturing data for people who are late. I am trying to make the form as easy at possible for data entry.
Here are the fields on my form:
IDNum
DateofSvc
Location
VisitType...Leave a comment:
-
Select Case Help
I have not worked with Select Case before, but I have a gnarly nested If..then..else statement. I needed to try to do something different. I am working in MS Access 2010.
Description:
I created a form that has several fields on it. A person selects a Visit type (1 or 2)and then How Late (1,2 or 3) based upon the selection in the option group, I need other objects to become visible in the form. I placed it on the...
No activity results to display
Leave a comment: