The Linux Page

combo

Automatic ComboBox in MS-Access

In MS-Access, you can select a special value for your combo boxes called:

"Find a record on my form based on the value I selected in my combo box"

In older versions of MS-Access, all you had to do is select the option and be done with it. However, the option would have no effect if the form was not properly assigned a source query.

In order to paliate to that problem, Microsoft decided to check the current form status and, if unlinked, hide the option altogether so you cannot make a mistake.

The problem is that for many people the train of thought was not automatically that way.

ComboBox bug

I created a form in MS-Access and noticed, after a little while, that a ComboBox would not render properly.

The problem is pretty simple, I marked the combo box as having a Normal Back Style. When I first open the window or when I click in that ComboBox, it works and renders the specified Back Color. That's great, but that's not exactly the solution, is it?

The box has a Fore Color of Black (that's the color of the text). That Fore Color is used because the background is expected to be either gray or green. Either way, black shows pretty well.

MS-Access weird = [Field] error...

I started using MS-Access not too long ago, but this one is really getting me each time.

Once in a while I get this error telling me that the Form is messed up, that a field or a macro just do not match. That macros are missing even though I ask the Form to call the corresponding functions. And some other strangeness like those.

Syndicate content Syndicate content

Diverse Realty

Diverse Realty Team

Want a New Home?
Want to Sell Your House?

Call Alex at
+1 (916)
220 6482

Alexis Wilke, Realtor
Salesperson
Lic. # 02024063

Cory Marcus, Broker
Lic. # 01079165

     

Terms of Site Index

Find the page/content you are looking for with our index.