Search results

By no means am I a VBA expert. I am getting better and probably to the extent where I am most dangerous! I have a form with required fields. In order to force these requirements on the user I use a message box to alert the user of the requirement followed by a SetFocus back to the required text...

I have created a new contract data entry form. An early part of the form's data entry handles tiered pricing selection. I used check boxes for this area. The result of clicking a check box (among other things) is that it populates 12 text fields with monthly minimum billing amounts (Ex., If I...

I have a budget report that has 24 text boxes displaying numeric values. 12 are monthly actual amounts (i.e., JanAct, FebAct, MarAct, etc.) and 12 are budget fields (i.e., JanBud, FebBud, MarBud, etc.). Depending on a pull down menu from a form that displays month [cboDate] (i.e., Jan-2016...

I have a combobox (CboCCDescription) with two visible columns (Cost Center and Cost Center Description - i.e., 200 - Sales; 300 - Marketing, etc). I would like to set the default to "ALL" but it is not accepting that as a default. I suspect it is because the combo box is now a two column...

I have set this issue aside for a few weeks now in order to protect my sanity. Out of the gate, I probably require some patience from those willing to help me through this issue! Using sample fields as a starter to explain the problem and avoid getting bogged down by the details, I can apply...

Stupid question but I guess that asking the stupid questions helps us get smarter! What exactly is the difference between SQL and Access VBA? I guess the next logical question is why does MS Access make it possible to code with either? If you were advising an Access user on which to use and...

I must have this wrong because it keeps returning an error message when I try to run the command button. For the life of me, I have researched how to use the DoCmd.SetParameter and it is set up exactly how I have seen it used. Please advise.... * "Country_Code" is a field in the query to be...

Is there a way to ignore fields depending on criteria selected in a form? I want to be able to run a summary query that totals by Category. In addition, I want to be able to select geographic criteria so that the summary query totals for the geographic selections (or consolidated). The problem I...

I have data in two forms. Depending on suggestions I receive on how to handle the problem I will describe below I could go either way. The common format between the two is I have GL Transaction detail. Two of these fields are [MonthName] (i.e., "Sept-2015") which was populated based on the...

I am hoping I can get some help with a date parameter that isn't cooperating. I have a parameter form that feeds a headcount report. Among the various parameter possibilities on the parameter form is a combination box (Combo132) containing operators (>, <, >+, etc) and an unbound text box...

I have a a combobox (Combo118) on a form ([Frm_REVIEW_Parameter]) in which the options are either "U$D" or "LC". I have a report ("RPT_REVIEW_EE") on which I want either the U$D number to be visible or the LC numbers to be visible depending on the selection in Combo118. In the After...

I am trying to combine the results of a combo box and a text box from a form and use the result as criteria in a query that feeds a report. The combo box is a list of operators (=, >, <, etc) and the text box is a user entered amount (i.e., 5000). The combination would be "> 5000" and should...