Recent content by dheim70

Thanks Skip, got it working now

Hi Skip, thanks for the response,I did the debug process and I am getting that run time '9' error on the line: Set wkbDest = Workbooks("C:\B Drive\TestSpread\NYCPA-May2.xlsm") I double checked the file spelling and it is ok, I even copied and pasted it and the path is the same as the previous...

Hi All, I'm a novice with VBA and Excel, I am trying to do something that I would think is simple but I can't get it to work. I have an excel (2010) spreadsheet with multiple sheets in it. I want to have a button that will import another spreadsheet from a different workbook when clicked. (the...

Cool! I think that will work! Thanks

I am trying to get the Case Numbers, not the Transaction Types, thanks fo giving it a look tho!

I'm pretty much a sql novice, so bare with me : ) I have a table that has Case number as a primary key and then Transaction type as another field and then there are several more fields. a record with the same case number can appear many times and will have different transaction types. What I...

Hi, I am a Total SQL novice, but need to do this. I have a table as follows: Contract_No ProgressID ReportingPeriod ReportingYear FinalFlag 2185 721 Jan-Dec 2010 Y 2185 831 Jun-Aug 2011 N 2190...

Yup, should have worded that better. Thanks for the code Skip, that is what I needed. much appreciated!

I've used this function before with success but today I created a query and it is returning the wrong date. I have the following as a calculated field in my query: Due DateX: DateAdd("m",9,"06/30/2011") And is returning the following 03/30/2012 instead of the correct value 03/31/2012 Has...

Thanks for getting me going in the right direction, I think I found some scripts I can use. Much appreciated

Hi, I have never dealt with exchange before (I'm a database and report guy...) Is there any way to link to exchange 2010 server database files .EDB so I can view data and create reports? Or can you create a flat data export? ie. spreadsheets? I have been able to find very little on the topic and...

Thanks, I'll check that out and work up a procedure as I am going to have to make this move for about 15 databases

I thought about that as well, but I also wanted to be able to move over all the logins and stored procedures as well.

Hi folks, Trying to copy a user database from an SQL Server 2005 to an SQL Server 2008 install on another server. I am using the copy wizard to do this. I have the same Domain account setup on both SQL servers and both have sysadmin rights at the server level. However when I run the job at the...