Recent content by clifftech

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!