Search results

I'm not sure if the title of this post makes any sense. Basically, I'm trying to figure out how to refer to a control on a form in a query criteria based on whichever form is "active." The scenario is I have many forms where I have a form control that retains a "master ID" and another control...

I'm finally getting back into my database design after months of other "special project" distractions and needing to knock the dust off of my novice VBA. I have a form and associated subform. I have a command button on the form that has an On Click procedure to determine if values in two of the...

Dynamic Combo Box - Change List on Previous Selection - Or "Check All That Apply" I have a combo box that looks up the values in a table on one of my forms. I'd like to add the combo box a few times to allow the user to make more than one selection from the list (check all that apply...

This should be easy but I've tried several versions of a For Each statement and have had no success. The following code works, but I'd rather loop through the controls without naming them and have the code do the same thing. Basically, if any of the controls are null, the On Click to pull up the...

I have a combo box on a form that is based on a query. The combo box lists the 100 counties that are in North Carolina. I also have an option group with 27 controls - one for each letter in the alphabet that when clicked, provides a parameter to the query to only show the counties in the combo...

I have five options in an option group: [A-E], [F-J], [K-O], [P-T], [U-Z]. These "ranges" represent alphabetical ranges that I would like combo box values to be "filtered" on. The combo box is a listing of counties that occur within the state. If the user hits the option [A-E], I'd like the...

Programming novice here...but I'm slowly gaining steam. I have a form with two controls on it for the user to enter the geographic coordinates of the location they are at when collecting information in the field. The controls are named "intXCoordinate" and "intYCoordinate". I've tried to get...

I have a command button control hidden on a main form screen that will unhide the Access window, ribbon, and command bars that are set to be hidden on form open (the main form is set to be default on dbase open). My questions are: 1) Can I make the "Passw0rd" case sensitive? It currently works...

First off, I'm an Access and VBA novice. So please excuse if there is a much easier way to get what I want. I'm working with Access07. I would like my unique id for a survey to be based on the current date/time and a three letter name acronym for the person conducting the survey. Example...