Search results

I have five Option Groups on my form. I was running into a problem where after selecting options for one record and then moving onto the next record, the previous options would stay selected for the new record. I "thought" I had found a solution by setting the Option Group values to Null in...

I came up with something: I set the afterupdate event for the first option group (1-Team 2-Rep). Each option has four possible reports that can be run, and they are themselves contained in two separate option groups. If a user select Option 1- Team, then I set the option group value for...

I have a form that opens by showing an option group: Search by: 1-Team 2-Rep Based on the option chosen (1 or 2) another set of boxes and options appear that let you select the team or rep and the report you want: If 1: Combo: Team A/Team B/Team C Option Group: 1-Report A, 2-Report B...

I have a macro that is run via button on my switchboard. It is set to import data from an Excel spreadsheet and then run an append/update query. Everything works fine, but I get a pesky Microsoft Access message saying: Microsoft Access was unable to append all the data to the table. The...

I figured this one out, so I thought I'd post up a solution in the event anybody runs across a similar situation and does a search in the future: The fields being pulled in the report were calculated fields of type If/Then from a query. Ex: (CalculatedFld: If [fieldx] = y,"text", " "). As you...

I am trying to eliminate the vertical space for null fields in my report using the CanShrink property. I have set the CanShrink properties to YES for all fields and for the section where the fields lay. However, the space is not shrinking. The labels are on the same line as the text boxes...

I got it to work. Don't know if the code was the most efficient ever, but I have the form doing what I want it to do! Thanks a bunch to all of you again!

DocNice...can you get me started on what to put in the Open Form Event? I tried some things, but can't get anything to work. Basically, I want the form to open with option 1 and it's corresponding tab visible.

I don't know if they can be hidden in design view or not. I think this requires a VBA solution, IMO. I know the hiding of tabs might be counterintuitive, but I wanted to avoid the clutter of 7 tabs on my form. I actually wanted to avoid using tabs altogether and just have invisible portions...

I have created a form with an option group containing seven options. I have linked each option to a tab. Thanks to the help of people on this board showing me how to code visible/non-visible, I was able to write logic that hides all tabs except for the option selection: Private Sub...

Pat, My fault. I entered Failed_Indicator when I should have entered Reason_Code. Your logic works great (when I actually enter it correctly!). Problem solved! Thanks alot for all of your help.

Thanks for the help PH! The logic works as intended. I have encountered one problem though...when the Failed_Indicator box is selected and then deselected, I receive the following error message: Run Time Error '2165' You can't hide a control that has the focus -END -DEBUG When I click the...

Where do I find the form's "current event" to enter the code?

Greetings from America! I am attempting to set a validation rule for one field based on the value of the previous field. I have developed a table that contains insurance policy QA information. The sampled policies that are pulled for QA have their Policy # entered, the processor's name, a...