Access JumpStart 2.0 | Blog
A Rapid Development Framework for Microsoft Access
Recent Articles
Gotcha! You thought you deleted a subform record but…
I recently experienced a frustrating issue that had me scratching my head for a while. I had a PO form with a Line Item subform and I could edit lines and when I tried to delete a line it was removed from the subform. BUT... If I closed and reopened the same PO...
Print button on Ribbon prints form instead of report
So I had a form that opened a report using a function in another module using DoCmd.OpenReport. This worked fine and the report popped open and appeared to be the active object on the screen. However, it was not. The behavior this caused was that when I clicked on the...
Friendly Form Auditing in Microsoft Access
Recently, a customer requested that all changes to their form be logged and added to the email that is sent to the project manager associated with the project assigned to the form. I found some code to walk a form during the BeforeUpdate routine and look for and...
Centering content on a form using Layouts
As you mention, you could determine the available screen space. You are going to have a somewhat complex job because you will have to set the top and left of every visible control on the screen. That is one way of doing it that will work. The other way...
Wrong background colors on buttons with shadows
Jon: Fix is either in the on open or on click events Jon: The issue occurs for me only when hovering over the button. See attached database for the simple workaround solution for this issue. I do think this is a bug in Access but at least there is a workaround for it....
Updating the Access Front End for a client
If you have worked with Access Front Ends and Back Ends on a client network with many users, you may have experienced some of the difficulties of making updates to the Front End to apply new updates to forms and reports for the end users. Having a front end in general...
When entering an order query for how much inventory is available
Presented with the problem: You have a stock of inventory of items you are renting. You know how many you have purchased. You have what customers have ordered for particular dates. You want to know while entering an order, how many items are available for a...
Front end / Back end Split
Thanks Michael, Yes, that is good to experiment with. I have found that many modern offices have a decent enough wireless connection with a router wired into their local network that you can easily use a wireless front end to connect to a back end on a...
Using a function and a modal form to retrieve user data
Fetch! Let's say you want to set a text control to a date allowing them to use either a date picker or the keyboard to enter the date using a mask. Or you may need a dialog box to get a password from a user or a piece of information needed for a report, and you want a...
Using an Access file as a shared library for other Access files
Start by creating a blank Access file anywhere (this will be your library). The only restriction here is that it should be accessible as a file either on the same computer or a shared drive of another computer on the same network as the Access app that will reference...
There’s nothing in my combo box!
Hi Charles, Usually when the item isn't displaying in the dropdown it has to do with either the display properties of the combo box or the value attached to the combo box is not a value in the row source. A couple of things to check: 1. The display columns property. ...
Nested Data Relationships Tutorial
A common database issue in the world is the need to store lists of related items. This might be a Bill of Material (or BOM) for a business application to describe all the parts and assemblies needed to ship a particular product, or it might be something like meal...
Quick Links
About
Our goal is to help people simplify their business by providing software products to streamline their work.
Contact
(630) 423-4994