Logo
Mail us
ben@accessdatabasetutorial.com

Category Archives: Forms

Microsoft Access Form Designs: Using VBA With On Timer Event


Microsoft Access

This Access form will self-destruct in 10, 9, 8, 7…. Using the unknown or unused Timer Event for your Microsoft Access form designs can be quite effective and really automate your background processes. I was recently asked if this application has a timer control which one could illustrate as a count down or trigger code on a set time. You can show a real time count down by using basic controls like a text box or launch another form (or […]

Tags: , , , , , ,

How To Add A Flash Movie SWF File To A Microsoft Access Form


Microsoft Access Form

Working with Microsoft Access form designs requires patience and a plan especially when wanting to work with other form controls over and above the standard tools made available by default. One particular ActiveX control is the ‘Shockwave Flash Object‘ which will allow you to play flash video (or SWF file formats) in an Access form. You will need to first load the library file if not added or enabled in order to render this control ready for use. That means going […]

Tags: , , , ,

MS Access Database Forms: Using The SelStart And SelLength Properties


MS Access form

Have you noticed when you navigate between control fields in your MS Access database forms that it automatically selects the entire content (if not empty) instead of placing the cursor to the end of the last character? Using some simple Access VBA code, you can now control the placement for the cursor to mimic and automate placing the insertion point to the last character position ready for further editing. MS Access Database Forms: Using The SelStart And SelLength Properties The […]

Tags: , , , , ,

Microsoft Access Database Tutorial – How To Use Spellchecker On A MS Access Form


Ms Access Form

You’ve seen the Microsoft’s spell checker tool across Word, Excel and other Office applications and it’s even available within Microsoft Access database too. When entering data into any input control, text box, memo fields or anywhere else users enter text, you can quickly call the spell checker tool using the keyboard shortcut F7. If you use MS Access forms and in all honesty, you should be using them, you could automate the spell checker tool on selective controls using microsoft […]

Tags: , , , , , ,

Microsoft Access Forms – How To Build Your Own MS Access Form Wizard


MS Access Form

One of the many uses that Microsoft Access forms can be used for includes the ability to create your very own MS Access form wizard feature. As you will be familiar with Microsoft Office in general, wizards are useful utilities that provide assistance for general users to complete a task that would otherwise take much longer to manually create step by step. In MS Access alone, there are many wizard features around ranging from the query wizard to adding predefined […]

Tags: , , , , ,

Access Form Designs – How To Create A Report Interface For Your Access Database


Access form

For the more polished and professional database, using Access form designs doesn’t necessarily mean viewing records from tables and queries. It can also serve as a general way to manage your MS Access database objects namely Access reports. For example, running reports from a nicely designed form showing a list of available reports that calls another form (perhaps for its criteria) before it actually displays the preview or hard copy report can improve the usability of your custom built application. […]

Tags: , , , , , ,