Search results

Thank you for your response. Just to make sure I am understanding your recommendations correctly you are recommending (1) That instead of having the following coding in each On Exit event of the required text fields I should remove those and do it all in the On Click event of the Main Menu...

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...

Sorry....real stupid oversight on my part. When I created the form the minimum billing amounts were bound fields to the Base Price field of the table. As soon as I made these 12 fields unbound, everything worked. The trick will now be to capture the data when the form is completed and transfer...

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...

PBaldy, Thank you for your help. I figured it out based on something you had written when you referenced whether the first column was bound or unbound. I had the second column as the bound column. I had read elsewhere that if the default value is in the data of the bound column then the default...

Too big. It is huge. 800 Mb. One road I was thinking of going down is that the combo in question (CboCCDescription) is dependent on the selection of the functional roll-up combo (CboFuncRollup). For example, if Sales is selected in the functional roll-up then only the Sales related cost center...

The bound column is column(1) which is the description. Cost Center number is the unbound column. From what you said, shouldn't "All" work? I tried putting that in the combobox default value under Data. Should I use VBA to set the default? If so, how? I do have a series of directions set for...

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...

Ha! I am good like that! I will start a new thread. Thank you again for resolving the Group By portion. Now I just need it to factor in all the criteria.

Okay.....Thank you for the solution to the reporting Group By. That worked perfectly! Now I need to figure out how to tie it all together. I don't know the proper etiquette as it relates to this but I am assuming it requires a new thread. Here is where it stands.... The report is grouping by...

Okay....let me try it. Thanks plog. Much appreciated.

So, if I am understanding this correctly, don't have the report pull from a query but rather the source data table directly instead?

plog, Now we get to some of the actual details. Below is the VBA behind the report that is fed by the query. Do you see any issues in this VBA that could be keeping me from grouping as preferred? Private Sub Command126_Click() Dim vFields Dim vValues Dim where As String Dim...

And then have the form feed the Where clause correct? That is what I did. Let me try again from scratch and see what happens.

Thanks plog. Here is the part where I am hoping for patience! I do not know SQL. I know how to view the SQL behind the query but not how to use SQL from scratch if that makes sense. So, that being said, when I create a query I do it the "normal" way. I select Create > Query Design > select the...

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...

I always feel guilty relying on experts such as yourself in these forums so I do make sure I am learnign instead of just relying on you to fix everythign for me so I am in the middle of really learning VBA I bought Access 2013: The Bible or whatever it is called so progress on that end. The...

Here is the SQL for the query. SELECT REF_ACT_Expense_Current_Final.Category_Sort, REF_ACT_Expense_Current_Final.Category, Sum(REF_ACT_Expense_Current_Final.Functional_USD_Amount) AS Functional_USD_Amount, REF_ACT_Expense_Current_Final.Region, REF_ACT_Expense_Current_Final.Function...

Good catch arnelgp. I did fix the space but the error is still the same. Man....I wish that simple mistake had fixed it!