Search results for query: *

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

Thank you Crowley16 for the response. I see what you're talking about about all the data being processed locally. I will definitely utilize more pass-thrus....

Thanks for the responses...I use pass thru's alot...but some of the queries can get complex... what I'm looking for in the dual core is the ability to alt-tab to another application while the query is running. What happens now is that Access seems to lock up the whole PC. I have no issue with a...

Is anyone using a dual core processor with large access queries?? When I run a large query against our DB2 backend ODBC database, sometimes a large query can take 1 hour to process, and it locks up my PC. This seems to happen to most Access users. Dell has come out with a new processor which is...

i used another way...password with a table..works ok

I would like to limit who can run reports in my application. Currently, I used If Environ("UserName") = "XXXXXXX" then I print the report. This works fine except the user is currently working from home via VPN, and the pc she is using is Access 2002. She is getting an error message on the...