Search results for query: *

I need a VBA statement(s) that will supply a variable with the sheet number of a specific sheet. For example the sheet number of the sheet named Index. Thanks Ron

I need assistance with coding cell validation. In a worksheet I want the user to enter a value in one of two cells, a value cannot be in both. Also a message box would be display indicating the error to the user. Thanks Ron

I need assistance creating a macro for outlook to add a specific string of text to the subject field of a message. The user would open a new message run the macro and the text would be entered in the subject field as well as the ability to run the macro on a forward or reply message. Thanks, Ron

Hello, The code below is executed from a workbook (WB1), the user selects a workbook (WB2), it loops through all sheets and copies values from specific cells in WB2 to WB1. The values from each sheet of WB2 will be entered in a new row on WB1, starting on row 3. I would like to alter the code to...

I require some help with an error I receive when a macro executes. The purpose of the macro is to copy data from a workbook the user selects to the workbook the macro is in. It loops though the sheets and copies data from specific cells on each sheet to a row, one sheet to each row. The error...

Hello On a form I would like to display specific text boxes depending on a selection the user makes in a combo box on the same form. In the form load event the text boxes are visible = false. Would the code be similar to this: Private Sub ShowEntry() If Me.cboEntry.Text = "Comments" Then...

I have a tabbed form I am having difficult sizing. When the form is opened the top of the form is not visible. I can use the vertical scroll bar and scroll up to see the top of the form but I would like the complete form to show when opened. The form size is small enough to fit on the screen...

I need assistance with a query. The query will include fields from two tables, “Client” and “Donations” with a one to many relationship. The results I would like to receive from the query are the records from the Client table that do not have a donation within the last six months. My query SQL...

Please, suggestions for books on creating reports in Access. Most Access books I have seen give some information on reports but they do not get into complex reports and subreports. Thanks. Ron

In a report that is formatted in columns with the data grouped, is it possible to specify how many groups will print per column? Thanks. Ron

Hello, I require some assistance with adding a message box to the below listed code to notify the user there was no match for the value entered in the text box, “txtSearch”. The code is executed from a search form, “frmSearch” which is opened from a button on the form, “frmMain”. The form...

Hello, What would be the factors in determining whether to choose a field’s data type as either Yes/No or text? In my situation, the field will be used on a form and have a combobox with a drop down, listing “Yes” and “No”. The user would select yes or no and it will be store in a table. The...