Check Register Seminar Lessons

Welcome to the Check Register Seminar Total running time is 5 hours, 27 minutes.

S M L XL FS | Slo Reg Fast 2x | Bookmark

Lessons

Addendums

1. Currency to English (4:53) - Getting the CurrencyToEnglish function to work in a different database

Database Files

Database File ACCDB

Resources

Course Notes, Upgrades, Bug Fixes - Read Me!
Full Course Description Page
Topic Outline
Handbook PDF - Coming Soon
Video Lessons Download ZIP File (1.15 GB)
Skills Test Quiz - Under Construction
Certificate of Completion
Post-Class Survey

Questions

Post your questions or comments below

Copying existing Excel Data Upload Images Link
John Schulte
2 months ago

How does a person copy existing transaction from Excel to Checkbook and still have the Query calculated fields accurate? Seems like the first two rows wont calculate.

Richard Rost
2 months ago

Perform an import from Excel directly into the table. Then the query should work.

John Schulte
2 months ago

No matter what I do, if I import into the CheckRegT, the calculated fields wont populate only those records. Any records I type in for example opening balances, will calculate in all three fields. I've imported number fields as number fields. Will continue on with rest of the lessons as they are really good stuff!

Show 1 More Reply...

Print Words on Check Upload Images Link
Tim Schmidt
13 months ago

Where might I find the Code Vault or Template for the printing out the words on a check.

Richard Rost
13 months ago

Hi Tim. You're not a Code Vault subscriber, however you did purchase this seminar, so you can download the template right from this page (see above). The code will be in a module in the database.

Tim Schmidt
13 months ago

I get the following
Sorry...

You must purchase this class to access the requested resource.

Click the BACK button in your browser and then click the BUY NOW button.

I am following the lesson 3 to priny checks and I can noy understand where I get the function for the wording. I am building my own database and not using a template. I muust be missing something..

Hope you have a nice holiday...

Show 13 More Replies...

Tim Schmidt
13 months ago

Am I not able to get this code in my database I am building?? I am no programer or develper so I am truly sorry for all the questions..

Tim Schmidt
13 months ago

I guess I fail to get how I get the module from the downloaded database to my database.... I( have tried the copy and paste with no success.

Thank you

Alex Hedley
13 months ago

No need to apologise, so have you been able to locate the code in the sample db through the VBA Editor?
There should be a Module that contains the function.
You would have to create your own Module in your database then copy and paste it from there.

There are a few ways to do this
In the Navigation Pane on the left hand side is a list of all the Objects in the database.
There should be a section called "Modules"
Find the module called "CheckRegCurrencyToEnglishMod" and Copy it, then paste it into your db.

Another option is to click on the "Create" tab, on the far right is a Module button in the "Macros & Code" section.

The third option is open the VBA Editor
Right click on the Database and Insert | Module
Copy the Function from the sample
Paste
Save
Give it a name.

You can then use this Function in your Forms/Queries/Reports etc

Tim Schmidt
13 months ago

Thanks for the speedy response, I will try this afternoon.

Have a nice Thanksgiving.

Richard Rost
13 months ago

Yes, Tim, like Alex said you'll have to copy that module from my database to yours. If you need more help with Access VBA programming, I'd recommend my Access Developer 1 class.

Tim Schmidt
13 months ago

I think I got everything, but when I go to binf the Description field to say "=CurrencyToEnglishDebitAmount and I close it I get a "Enter Parameter V... CurrencyToEnglishAmount...

Any thing I did wrong

Richard Rost
13 months ago

Check your spelling. #1 reason for unexpected "enter parameter value" prompts.

Tim Schmidt
13 months ago

My mode is named: CheckRegCurrencyToEnglishMod

and the Control Source of a Copied Description is: =[CurrencyToEnglishDebitAmount]
Do you ever taje a day off???

Alex Hedley
13 months ago

The module is called "CurrencyToEnglishDebitAmount"

The function you want to use is inside the module and called "CurrencyToEnglish".
It takes an argument of a Currency amount so you would need to add the field or value that has your amount in it like

=CurrencyToEnglish([Debit])

Have you gotten to the video where Rich shows this yet?

Tim Schmidt
13 months ago

I find that the mod I find was called
CheckRegCurrencyToEnglishMod

And the Control Source was abeled:
=CurrencyToEnglish([Debit]) & " " & String(120-Len(CurrencyToEnglish([Debit])),"-")

Either way I can not get it work

Tim Schmidt
13 months ago

I just got done watching Lesson #, the mode was called CheckRegCurrencyToEnglishMod. This is what was typed in, said and was saved.
The Control Source of the copied Description dield was labeled
-CurencyToEnglishDebitAmount..

Just who am I to believe. I was told to do the abvove with no good results. If you say something else, I might suggest you listen to the videos..

Tim Schmidt
13 months ago

Gentlemen

I have tried to the best of my ability to get this wording to print on the check I can't do it anymore I've tried over 50 times every which way possible. is there anyway you could just put the function in a word document and email it to me so I can copy and paste it from there. Please I need help

The only thing different I can find is the function that actually works has four or five other functions or sum modes. And I don't know which ones I need to copy and paste.I open that function I don't know if I need to copy all of hem or just the one mentioned in your video. I need some help, any thing you can give me in the simplest way would be greatly appreciated.

Please I look forward to your reply.
Tim Schmidt

Richard Rost
12 months ago

Tim, I recorded an addendum video (above, under the Addendums section) just for you to show you how to copy the module you need into your database and use the CurrencyToEnglish function. It's a very simple process if you know VBA. Again, I only guarantee support for things I show in my lessons. If you're having problems with YOUR database, you can find how to get custom help on my consulting page. Alex and I do our best to help you here in the Forums as much as we can, but it's a courtesy.

Downloading Upload Images Link
Tim Schmidt
13 months ago

I can not find the location of the download access to the seminar I have purchase. Can you give me instructions

Thank you for the speedy response to my other issues...

Alex Hedley
13 months ago

Theres a section above called Database Files, if you click on the link below that Database File ACCDB it contains the sample db built in the Seminar.
Is that not working for you?

Richard Rost
13 months ago

All of the available downloads, both the class database and the videos in a ZIP file, are available above on this page. The handbook will be available soon. For details on how to use all of the new features of the site, watch the WalkThru Tour.

Show 2 More Replies...

Show Older Comments...
View in Table Format