Search results for query: *

Found the extra ( Thanks.

not sure how to debug.print works but when I add strSql to watch expression I get "UPDATE tblEmployee_ProjectHours SET Hours = 100 WHERE (((EmpID) = 11102) And ((SubAccount) = "D6108.M.2.0.0") AND ((MonthYear) = #01/01/2013#)

So it's back to work after having a great Christmas and eating too much and starting the day off with another syntax problem. I'm getting either a syntax error or missing item in query error. ProjectID and getDate are strings and the query is a single line of code. Any suggestions? strSql =...

That works! I didn't know you could use that syntax. Is there any website or document that lists all the syntax options for vba queries?

jedraw - Here's a much more difficult vba query that is giving me different errors. One of the errors is due to the "m" parameter in the DateAdd function. Can you help? strSql = "SELECT * FROM tblEmployee_ProjectHours " strSql = strSql & " WHERE (((tblEmployee_ProjectHours.MonthYear) >=...

Month1Hrs is a field in tblGrid but when you asked the question I found that the field is actually misspelled - it should be MonthHrs1! Thanks for your help.

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

MajP, This is very very close to the tool I need. A couple of changes will be needed. First, engineers could have as many as 20 projects that they are working on which means there could be up to 20 rows. Also there are about 250 possible projects in our organization so the Project Name text...

MajP, you've given me plenty of information that I need to digest which will take me awhile. Please send me anything else you think would help. Thanks.

Both of your responses confirm my thoughts but you have given me a direction for figuring this out. Any articles, examples, web sites you can point me to to get me started would be greatly appreciated. Looks like I'm going to learn VBA over the holidays! Thanks.

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

Good advice. Thanks for your help...

The space was the problem. Works great. I am using this macro to list all the worksheets in a summary worksheet. Is there a better way (function?)to list the worksheets? Sub SheetNames() Columns(1).Insert For i = 1 To Sheets.Count Cells(i, 1) = Sheets(i).Name Next i End Sub The worksheet is...

Thanks for the quick response... I tried =INDIRECT(A1&"!D15") and get #REF!

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

Skip, You're right about needing debugging skills. I was able to get the code to work using the trial and error debugging method which took too long. Here is what I came up with: Sheets("Sheet1").Range("A1")=ActiveSheet.ChartObjects(1).Chart.Axes(xlValue).MaximumScale Thanks for the link on...

I tried that but got the error Unable to get the MaximumScale property of the Axis class.

Skip, This should be easy but it is giving me the error "Unable to get the ChartObjects property of the Worksheet class". I'm guessing it cannot find the correct chart but I only have 1 chart on the sheet. How can I be sure I am using the correct Chart name? What other reason could there...

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