Search results

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

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

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

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

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

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!

Hi! Here is my issue: 1. My goal is to have a time stamp which will update if a record in a table is modified or created. 2. I want that time stamp to show up on the user form (but not for editing, just for vieweing). 3. I tried to follow these instructions (using Access 2010)...

Hi! I am trying to fix a combo box to remove decimals. Here is the info: 1. The combo box is used to search records in a form. It is linked directly to a table. A field called "OP" is the item that needs to be searched. "OP" is a four-digit number. 2. Here is the "OP" field's properties...

Hi! I used the form wizard to create a form which can be used for basic data entry. My problem: Some fields that the wizard created are not text fields (such as Last Name), and Access will not let me change to text box. When I go into Design View and right click the list box --> Change To...

Hi! Here is my idea/issue: 1. I have created query that has the following expression/field: Days Outstanding: [Reporting Date] - [Table1].[Filing Date] 2. [Filing Date] is contained in a [Table1] of course. But [Reporting Date] is not in any table. I guess it is a query parameter. 3. I...

Hi! Basically, here is my situation. I have a table with the following fields: ID Amount Here is a sample table: ID, Amount A, 1 B, 2 C, 3 D, 4 E, 4 I want to create a query with a new field called "CountOfAmount". I need this field to count the number of occurrences of "Amount". For...

Hi. I am nearly positive I'm not asking this question in the most efficient method possible, so any advice is welcome! I'm new to Access and am not a programmer (as is obvious). Basically: 1. I have two tables: Table1 and Table2 2. Table1 has two fields: ID Number and Amount 3. Table2 has two...