Recent content by Heywood43

Another satisfied developer I just want to echo the sentiments of the others here. I changed my default printer and all is well now. It's funny how a post from years ago still is paying dividends. Thanks so much for saving me time!

Hello I have a strange issue occurring on one computer and not the other. In Excel 2007 I have a xlsm file copying data from Sheet1, pasting it to Sheet2 and then saving as a CSV. The goal here is to create a new file in CSV format with only the contents of Sheet2. Everything works fine on...

Hello Please excuse me if this is in the wrong area. I am attempting to solve this problem with VBA so I figured this might be the place. I work on an Access 2007 database that has some pretty complex queries. One of these uses multiple steps in order to ultimately produce query results in a...

SOS - thanks so much, that is exactly what I need. I also added your reference material to my bookmarks. These web sites look like they will come in handy. Thanks again for the quick response.

Hello I am new to Access 2007 and one of the new features seems to be the controls that are generated from a form wizard are grouped together. When you click on the top control for example it shows all of the text boxes highlighted. I created the form based on a query and the form layout was...

Wow. That's a harsh comment. The truth is - like him or not, Bush has appointed more women and minorities to high ranking cabinet positions than Clinton ever did.

I would never discourage anyone from writing a script to do what they need but there are a couple of handy tools that come to mind I think you could make use of: Microsoft Sync Toy 2 Beta SyncBack Freeware Both actually sync so you don't waste time over-writing unchanged files. I know...

Nice tool. I like how it retains formatting of your SQL also. I always cringe whenever I see my nicely formatted SQL get turned into a stream of text the next time I open it up. I wonder why Microsoft doesn't have this type of functionality out of the box.

Because they are proficient at writing SQL queries? To correlate it to Operating Systems it is the old argument "why use a command line when you have the GUI?" The answer is of course you usually can do more with a command line prompt. As you suggested you don't always get what you want from...

I have an Oracle database which contains views which I need to pull data from daily. All of these view exists in the Access database as linked tables via ODBC. Becuase of business requirements I have a bunch of users that only have the ability to use Access to get thier reporting done. Rather...

I have used this to get Month To Date information: Between month(now()) & "/1/" & year(now()) And now())) Just place that in your date condition. There is only one problem I have with this, maybe someone else on this forum can help me with. On days like today (the first of the month) the...