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

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.

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.

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

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

I have a nightly batch file that copies all my development access apps onto the server...I would like to add to the batch file, when it has finished the copy, I would like to write a little file to the folder with the time the file was copied.... something like : G: XCOPY C: /Y echo >...

I sometimes get this message when I am adding new objects from the development MDB, and at the end I run a compact and repair. I am using 2003, and I don't get it. How can one recover from this....

I have a report that I would like to set up to export to a file (in the current directory) with a date value as part of its name.

I need to clean off some space on my drive. I was playing with the disk cleanup tool. I noticed a check box for Compress old files....What exactly will it remove...How does it know what to delete.

I was making changes to an application, cleaning out some old stuff, I can't say exactly what happened...but when I went to do a compact and repair, I received "file already in use" message. I can't even delete it and bring the back up version back. How can I delete the file and restore the...

I was making changes to an application, cleaning out some old stuff, I can't say exactly what happened...but when I went to do a compact and repair, I received "file already in use" message. I can't even delete it and bring the back up version back. How can I delete the file and restore the...

I have a form/subform and the user is able to right click on the subform and click design view. How do I disable this? Thanks