Search results for query: *

I would appreciate help on figuring out what is wrong with the below vba query. The error message I am getting is "Too few parameters. Expected1." I set up a watch on the query and provided the watch results below also. I have tried many different syntax combinations on the WHERE clause and...

I only get a chance to work with Access about once a year when I'm asked to develop a quick tool in Access. Obviously I don't have much of a chance to develop my Access skills so I need help with this latest Access tool. I need an Access form for engineers to enter hours by month for the next...

I am fairly new to VBA and am trying to figure out if it is possible to take a single large MS Word document and break it down into numerous rtf documents. I need to have the code look at each paragraph and where the paragraph starts with “%#*” it copies all the subsequent paragraphs...

I need to get values from numerous worksheets into a worksheet named "Summary". Summary worksheet has a list of all the worksheets names in column A (for example cell A1= "Worksheet_Date1") How do I pull information from cell D15 in Worksheet_Date1 by referencing cell A1 in the summary sheet...

Is it possible to get a charts maximum and minimum values to show up in designated worksheet cells. Here is what I have so far for the maximum scale: Private Sub CommandButton2_Click() Range("A1") = Worksheets("SARS").ChartObjects("Chart 6").Chart.Axes(xlCategory).MaximumScale.Value End Sub...

This should be easy but so far I haven't found a solution. In worksheet 1 I can enter values in cells for a chart manually or send values from worksheet 2 by using a command button. Worksheet 1 has an Worksheet_SelectionChange routine that updates chart 1 axes in worksheet 1. Is there a way...

Help please- I have a single column, 10 row vertcial array that I need to determine the maximum value between (including) the 2nd and 8th row of the array. (The array size and row pairs often change). Is it possible to do this using a array formula instead of vba? I have tried to use an array...

I have a worksheet range that when the user changes any cell in the range the Worksheet_change(ByVal Target As Range) event triggers property changes to a command button..which works fine. The problem is I also have a userform that can make changes to cells within the range but userform changes...

There has to be an easier way... I have 60 userform text boxes (txtBox1, txtBox2, etc.) that I need to insert values from the spreadsheet. What I am using now is: frmPax.txtBox1.Value = Range("A1") frmPax.txtBox2.Value = Range("A2") ... ... Instead of using 60 lines of code I would like to...

I am stumped and need help. From an Access command button (using VBA) I am opening 2 different existing workbooks. The first workbook1 that opens I add information to some of the cells then save the spreadsheet as a different name (new_workbook1). The second workbook2 is opened and I simply...

Help please... I'm using an Access form command button to open 2 spreadsheets. When the spreadsheets are open they hide the Access form that I need to immediately view for further processes. Is there a way to automatically set the focus back on the form once the spreadsheets are opened without...

Advice needed... Is it possible to write an Excel macro (vba code) within an Access Module? I am trying to open a new spreadsheet from an Access command button that will automatically insert values in certain cells of the spreadsheet. The values inserted into the spreadsheet will be determined...

Please help. I am trying to run an Excel macro from an Access command button with this code: Private Sub Run_xlMacro_Click() Dim objXLApp As Excel.Application Dim objXLWB As Excel.Workbook Dim strMacro As String Set objXLApp = CreateObject("Excel.Application") Set objXLWB =...

Based the resarch I've done I don't know if this is possible but I need a scroll bar that gives me incremental changes of .1 and also allows me manually enter the decimal value. For example the linked cell to the scrollbar is B11 and I need a range of .1 to 15.0 in increments of .1 I also...

I have a spreadsheet with user defined functions that I developed and work fine in Excel 2003 but will not work in Excel 2007. I just started using Excel 2007 (not my choice) so are there settings in 2007 that I need to make for using UDF or is there something in the code that is wrong? Here...

I need to develop a macro that will look at the text string value for each row (about 50 rows) in column A and trim 1 or more spaces from the end of the text string. Spaces in the middle of the text string are OK. The spaces at the end of the string need to be eliminated so that the strings can...

I need to develop a macro that will look at the text string value for each row (about 50 rows) in column A and trim 1 or more spaces from the end of the text string. Spaces in the middle of the text string are OK. The spaces at the end of the string need to be eliminated so that the strings can...

I need to list in Workbook1 all the worksheet names in Workbook2 (both Workbooks are open). I have tried using the cell() function but am not having any success. Is this possible?

I need a macro for Excel that will allow me to copy files from one directory to another. The macro will have three parameters: the file name to copy, the current path of the file, and the path where the file is to be copied. Any help would be appreciated.

I developed a VBA rounding function "MyRound()" that resolves the difference between Excel's rounding and the Access' rounding function. The function works fine in a stand alone query but when I use the query in a left join with another table it gives me an #ERROR in fields that have no value...