hi Mike,
adding onto Bill's comment ...
> "walk you through it"
yes. NumWord is not a built-in Access function; it is something custom written in your project, so we need to see what it says to help you change it ... and you need to know how to navigate the logic anyway, if you are to maintain this application.
Bill said, "Alt+F11 ... Then press Ctrl+F to open the Find dialog box. Type in NumWord and make sure you choose to search the entire project. That will find the function wherever it is."
keep searching the VBA code for the function declaration (and make sure the scope to find is PROJECT not just procedure or module) ...it will be something like:
[Public] Function NumWord( ... ) [as datatype]
copy that line, down to and including the one that says "End Function"
~~~
>"When I click on my contract form I get a screen that says:
that means you are looking at the top of a module sheet, which can contain declarations and code for many procedures. Go to page 24 of this file and read the section on Modules ... then go read the whole chapter ~ and maybe all of Access Basics?
http://www.accessmvp.com/Strive4Peace/Access_Basics_Crystal_080113_Chapter_02.pdf
If you've inherited a project someone else developed, take comfort in the fact that Option Explicit is at the top of the module ... so someone knew a bit about what they were doing ... so that is good.
~~~
Code just says:
~~~
a control BeforeUpdate event might be the wrong place, to use this function, even though it may work. (Since it information that can be converted anytime, a control could be calculated with an expression to call the function to convert a number to words on the Control Source. If this text will be used to write a check, and the text is being stored in a field, then a control AFTERupdate event is a better place to calculate that since BeforeUpdate is typically reserved for data validation. If you store calculated fields, it is good to have a way for administrators to update calculations.)
~~~
as Bill mentioned, please remember to keep old messages to the thread when your respond, thanks
~crystal
No problem, Mike. We will walk you through it. First, open the database and press Alt+F11. That will take you to the code editor.
Then press Ctrl+F to open the Find dialog box. Type in NumWord and make sure you choose to search the entire project. That will find the function wherever it is.
Then copy and paste the entire funciotn into your post. Please try to remember to include the entire thread as some of us reply through email and need to see the whole conversation.
Sunday, 04 November 2018, 00:44PM -08:00 from mtamiazzo@gmail.com [MS_Access_Professionals] MS_Access_Professionals@yahoogroups.com:--
Regards,
Bill Mosca
Code just says:
Option Compare Database
Private Sub Label177_BeforeUpdate(Cancel As Integer)
End Sub
Posted by: crystal 8 <strive4peace2008@yahoo.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (9) |
Tidak ada komentar:
Posting Komentar