Search results

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

Hi! Here is the situation (simplified): 1. I have a table called table_1 2. table_1 contains field_A, field_B, and field_C 3. I have form called frm_1 4. frm_1 contains text boxes to update field_A, field_B, and field_C from table_1 5. frm_1 also contains an unbound text box which...

Thanks for the reply! Yeah, your recommendation is accurate. However, the accounts are not really related to one another. All of the accounts can thought of as separate, unrelated cash accounts, for example, and the accounting entries are necessary to conduct transfers.

Hi! I have the following two-column table (TABLE1): Account, Difference 111, $30 222, $150 333, -$100 444, -$60 555, -$20 As you can see, the total of the differences adds to zero. This table implies that the following 5-line accounting entry needs to be made: Account, Amount 111, -$30 222...

Ah, I see. I was trying to get the field name information copied/pasted into an Excel file. Thanks!

Hi! Basic question: For some reason, I am unable to copy the data in a table using the square at the top left of the table: Does anyone know how I can fix this? Thanks in advance!