Recent content by UNC_Access

Thanks everyone for the help! FYI I think I found a super easy solution without having to use VBA: In the RowSource query of the "goal" field in form_a (which is in the Data tab in the Property Sheet of the "goal" combo box), I included the following criteria under the "category" field...

Thanks for the info! I have come across cascading combo boxes via Google, but I can't seem to translate the syntax correctly. My combo box for "goals" is "goals", more specifically: [Forms]![form_a]![goals] How would I write that in the VBE window? Dim strSource As String strSource =...

Hi! Really need some help here - I think this is pretty basic, but I'm spinning my wheels! Ultimate Goal I want end users to open a data entry form, 1st select a "category" value from a combo box, and 2nd select a "goal" value from a combo box. Immediately after the "category" and "goal"...

Hi! Here is my goal: Print sheets "01" and "01A" when the ActiveSheet is sheet "01". Here is my code: Sub Print_Sheets() Dim x As String x = ActiveSheet.Name Sheets(Array(x, x&"A")).PrintOut End Sub I'm getting an error on the red part. The key is that I need to print out 2...

Thanks! Appreciate the help!

Hi David! Works perfectly! At first I could not find the On Load event, but I realized that the event is on the Form Selection type of the Property Sheet. I figured I would add that note just in case someone searches the forums in the future! Thanks a lot!

Thanks David! However, I did not work. I copied and pasted the VBA code exactly as you have written it, except I changed the column names, as follows: Private Sub Form_Load() Me.[Level 01 and 02 ID].ColumnWidth = -2 Me.[Level 03 ID].ColumnWidth = -2 Me.[Case].ColumnWidth = -2 End...

Hi! I am using Access 2013 (but I assume that the solution for Access 2010 will apply). Here is the situation: 1. I have a simple datasheet form with three columns 2. I need to adjust the column widths so that all the text is visible 3. When I adjust the column widths, save the form, close...

Thanks a lot for all the help!

Okay, I had to clear the data. Form_0 = frm_user_interface (the first form that you see) Form_1 = actually 4 Forms (I wanted to keep my question simple): -frm_total_debits -frm_total_credits -frm_end_balance -frm_total_cleared_warrants They all act in the same way, so if we get one, we can...

Okay, I re-performed the same steps, except for #8, I put: Private Sub Statement_Field_A_Change() Forms!Form_0.Form_1.Requery End Sub For step #11, I did not get an error, but Field_A did not refresh. Am I putting the code in the correct place? Appreciate the help! FYI, when you mentioned...

Okay, I tried it and I can't get it to work. I don't think I'm doing it right. This is what I did: 01. I opened up Form_2 (not the main Form_0) in Design View 02. I selected the appropriate Form_2 field (Field_A) - This field, once updated, should change the Query_1 "Variance" field 03. I...

Let me give that a try pbaldy! Thanks!

Hi! 0. My Goal My goal is to refresh one subform after updating data in another subform. 1. The Situation A. I have two tables: Table_1: a multiple-record, multi-field table used to enter detailed data Table_2: a one-record, multi-field table that is used to enter summary data -...

Thanks for the replies! However, I am still having trouble. - I do have NZ used in the calculation as you have described, but the unbound text box still isn't auto-refreshing - Yes, all three fields are numeric (and the expression is in the Control Source section of the text box's properties)...