Recent content by jeep2001

Is there a way to stuff a keypress in a macro. I have an EXCEL macro that deletes a column, then saves the worksheet. When the macro runs, I get the prompt...click yes and all is fine. This is great, but I want the macro to run overnight, how can I invoke a keypress "Y" or turn off the "Do you...

thank you

Can I force the changes to yes without user input in the macro?

I have an Excel macro that I run from Access. It deletes a column in a spreadsheet...Before the delete takes place, there is a prompt "Do you want to save the changes..." . Is there a way in EXCEL to make this go away...

First off I use pass-thru queries whever I can. However, there are times when I am asked to run a query for our managing director at a whim and he needs the info quickly...therefore I use the QBE form. Most times the query takes up the whole machine..I can't alt-tab to anything else except...

I am interested in hearing if anyone is doing any large queries with the dual core. Thanks

I need to bring in a from to date to display on a report. I have done this before, but I don't remember what I did. What is the best way to do this.

Find and Replace worked like a charm. Thank you.

I have a column in an Excel sheet that contains a 1 or 0 value. I would love to replace the 1 with a tick or check. The column contains 4,000 rows, so I need a programmatic way of changing the value. How can i do this in EXCEL?

I stumbled onto an Access site where I read something about do's and don't do's....One of the issues was to avoid at all costs -- memo fields that they can bring down a database? I never heard that one, but what kind of havoc can they reek? I am about to do an update to one of my databases and...

How can I automate saving an attachment to My Documents. I receive a daily email with an Excel attachment. I save it to my documents, and rename it. I would love to be able to do this via a command button in Access.... Anyone have an idea.... Thanx

How can I save and rename an attachment in Outlook via macro code. I am trying to automate a daily process. thx

How do you simulate the "make table command" in DB2. I was trying a pass thru with insert into....and unsuccessful.

Yes, if the tables are large enough. I don't care how long a query takes, as long as I can alt-tab to something else and have a stable operation. Additionally, when I am given an assignment, in order to solve it, it can take creating several queries (make table queries) then grouping..... I...

I have 4 queries that I output to Excel sheets, my question is how can I get each Output To into a separate workbook so all the queries can reside in 1 file. This is my statement from access.... Dim strFileName As String strFileName = "G:\Derek\BreachedByDay\BreachedAlerts" & ".xls"...