Microsoft Access Developer 8

Microsoft Access Developer 8
By Richard Rost

4 years ago

Microsoft Access Tutorials Access Developer 8 continues our in-depth study of Visual Basic for Applications programming with Microsoft Access (Access VBA). This course will continue our coverage of partial payments on invoices, and we will develop a Search As You Type form.

If you're serious about building quality databases with Access, and you want to learn how to automate your database with VBA, then don't miss out on this course.

Contents include:

More Partial Payments on Invoices
Combo DropDown Method
On Unload Event
Locking Invoices if Paid
Creating a Public Global Function
Globally Search VBA Code
Allow Additions, Edits, Deletions VBA
Search As You Type
On Key Press, On Change Events
Lots more

Click here for more information on Access Developer 8, including a course outline, sample videos, and more. This course was recorded using Access 2016, but most of the topics covered are valid for all versions of Access from 2003 on. This class follows Developer Level 7. The next class in the series is Developer Level 9.

Creates Search As You Type Upload Images Link
Roger Alberto
5 months ago

Hi Richard,

Your courses online are very helpful. I hope you will continue updating your course and adding more design like student database. How do you start the CustomerList Box so it won't show the customers in the box.? Read More...

Richard Rost
5 months ago

Just leave the RowSource empty.

Spaces in Search As You Type Upload Images Link
Adam Schwanz
2 years ago

Hello Richard, I have this working I believe with a macro to open the selected customer as well, however I'm unable to add spaces into the text field. I may be missing the obvious but how can I add spaces so I can do like Fort Myers, Fort Lauderdale etc without just searching the last word?

Richard Rost
2 years ago

Yeah, that's a tricky one. I'll have to think about it. The way I have the code written (if memory serves, it has been 2 years since I recorded that) every time you press a key the string gets "trimmed" so the trailing space would be removed. All I can think of is you'd need to keep a second hidden text box or memory variable with the actual value you type in that doesn't get trimmed.

Todd Auer
2 years ago

I was able to accomplish the spaces by:
1.Make list box. Go to properties, select row source "...", Expr:1 [field 1] & [field 2]
2.Make a SearchBox. Go to properties and set the On Change with Code builder type DoCmd.Requery "List Box"
3.Like "*"& [Forms]![Form Name]![SearchBox].[Text] &"*" The .Text will select the text inside of the searchbox

I am also wondering how to make this happen with VBA, can't wait for the update. Thanks!

Show 2 More Replies...