Search results

Good afternoon, I am currently working on a project in access 2010 and I am having a search for record dilemma. I have a main form that has a subform in it under a tab control. I place a search box at the top of the form so that user could select either the ID, the internal case number...

Okay, good so then how would I go about coding it VBA, with multivalue fields? Both tables are of the same exact structure. Like step by step a.k.a VBA for dummies status? Thanks,

Yeah, I seen that Microsoft link already and read it in hopes that it would give me some guide but, I still ran into problems. I was really hoping that someone could probably show me another way like maybe VBA. Thanks anyway

Good morning any and everyone, I am in need of some very detailed/step by step assistance and fixing my append/update query. To start I know it is a shame on me moment for using a multi-valued fields because it is a known problem child, but it was a mjor request by my co-workers in the review...

you would be correct, the report would be printed on white paper with the value within the textbox would be black. thanks for your help

Good morning, I am trying to create a macro to search for selected quarters and entered years. I have a form that asked for quarters and years, in the section quarters there is a combo box that list Q1, Q2, Q3, and Q4 in which the users have to select from. And then there is a textbox that...

Still no luck, any more suggestions?

Name of the form is called: KPI_frm_Findings_Recommendations Name of the textbox in the form is called: Txt_Annual_CQM_Findings_Recommendations Name of the report textbox is called: Annual_CQM_Findings_Recommendations Name of the report textbox label is called: lblAnnual Private Sub...

Good morning, I tried the solution provided and I got and error saying that the code could not find the form. If possible could provide a little more detail of how the code should me written like up until the part of end if. Or provide other possible codes. Thanks.

Will do, thanks for the advice.

My apologies what determines the form textbox visibility is a combo box on the form. If the user selects quarterly on the combo box then the form textbox should be hidden, but if selected annual the form textbox is shown. Hope this helps and thanks for your help.

Oh sorry the form textbox visibility determines the reports textbox visibility, if the form textbox is visible then the report text box is visible and vice versa. Thanks in advance,

Yes, the form would be open when the report is genrated.

Good morning, I am currently working on a project that is almost complete, but my only problem is that I am clueless as to how I can get a text box in my report to hide base on if a text box in my form is hidden. Meaning that whenever this particular text box in my form is hidden then the text...

Good afternoon everyone, I have hopefully really simple and quick question, is it possible to create a query that will delete the fields within a table? Thanks,

I think I may have confused the situation, I am just looking to auto select one combo box based on the other combo box selection. Please see attachment below for more detail. I am trying to get the second image to auto select itself no matter what the user selects from the first image. As you...

Didn't want you to think I forgot about you. ;) Thanks for the advice it helped out a lot.

Hey pbaldy just wanted you to know that I figured it out and thanks for the advice it worked. ;)

Okay thanks, but what kind of code would I write in the after update to get the second combo to auto select? Thanks again.

Good afternoon, I using access 2010 and I am trying to code (VBA) one of my combo box to auto select if another combo box consist of multiple selections. So for example I have a multi select combo box that has a list of departments and based on what the user selects I want the other combo box...