Microsoft Access Developer 8

Microsoft Access Developer 8
By Richard Rost

2 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.

Spaces in Search As You Type Link
Adam Schwanz

24 days 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

24 days 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

13 days 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...

Add a Reply