| Thread | Last Post | Replies |
|
| Macro | 17 Dec 2005 07:55 GMT | 1 |
Is it possible to add a macro to a form that will open an empty new msg in Outlook 2000 and copy a list of e-mail addresses collected via a query from the same Access database (or via other means) and paste them into the To field separated with ;?
|
| How do I run a macro to run several querries? | 17 Dec 2005 07:42 GMT | 2 |
I am trying to run a macro that will run several make table querries but it will stop because it will always ask for permission to change or delete the table that it is creating. How do I get around this problem?
|
| Show progress of large macro | 16 Dec 2005 17:28 GMT | 2 |
I have a macro that runs a series (38 in all) of queries, functions and macros to assign work items to various teams of people in our department. Can anyone show me a way to display the progress of the macro while it is running (other than leaving the warnings on and having to ...
|
| AutoKeys and Macro Names | 16 Dec 2005 17:19 GMT | 1 |
I would like to know if there is any way I could assign an AutoKey to a macro that already has a name. This name is used in some forms (attached to button.) I want to make things a little easier and add an AutoKey to run the macro,
|
| Non Access programmer needs to export report to excel | 16 Dec 2005 17:17 GMT | 2 |
I don't do access real well :) I'm the DBA for our company and I write reports that everyone wants. Needed to have a timed run of a report on a daily basis, so my boss said to make an Access db with linked tables and put in a repot and a macro autoexec
|
| Maximize a page automatically when Access opens....... | 16 Dec 2005 14:38 GMT | 1 |
I have a database that I set up with a menu switchboard and a desktop icon to open the database. My problem is the switchboard opens up as minimized. I want in max'd. I have a macro created and it works when I run it but I want it to run automatically when you click on the ...
|
| Modules dont work any more? | 16 Dec 2005 13:42 GMT | 5 |
I was using Access 2002 before and now i changed to Access 2003. Right after that I noticed that, for some reason, the 2 modules in my database dont work any more. Can anybody fix them for me please?
|
| Change a record, update field | 15 Dec 2005 22:25 GMT | 3 |
I have the following: INPUT_NUMBER: input a number DN: True if Area_Code merged with INPUT_NUMBER are found in DN tbl Sometimes Area_Code and/or INPUT_NUMBER needs to be changed on the fly. I
|
| Using MS Access to call an Oracle Stored Procedure and capture DBMS_OUTPUT | 14 Dec 2005 23:55 GMT | 1 |
I am using MS Access (2000) as a front-end to run various stored procedures in an Oracle database (8.1.7.4). These stored procedures update data and I would like to capture the DBMS_OUTPUT from them and return them to Access so that I can use them to populate a message box
|
| Autoexecute VBA | 14 Dec 2005 17:38 GMT | 1 |
For grins, I ran the Analyzer tool on an Autoexec Macro that runs a VB function. It suggested I convert it to VBA. The converter created a function called Autoexec_Autoexec. Is this the standard name for a VB function that will execute each time the
|
| Click for form button from Macro | 14 Dec 2005 05:36 GMT | 3 |
Sorry for simple question. I want click form button from Macro. Any Help please. Regards
|
| Access 2003 - Security doesn't show up under Tools / Macro, Why? | 14 Dec 2005 00:21 GMT | 2 |
What do I need to change?
|
| Access freezes after running macro from switchboard | 13 Dec 2005 21:58 GMT | 1 |
I have a macro in my database which prints a report, then runs an update query. If I run it directly from the Macros menu, all is well. When I invoke the macro from a switchboard item, it runs fine, but then Access locks up, and my only recourse is to shut Access entirely and ...
|
| close excel in macro | 13 Dec 2005 18:41 GMT | 1 |
hello - I have a macro in access that exports a report to excel. however, it opens the report in excel upon the export - but I would like to include in the macro that excel closes, or the file gets exported blindly. is this possible ?
|
| Newbie can't find his macros | 13 Dec 2005 02:57 GMT | 3 |
I am just a simple guy who keeps my bank accounts and cash flow forecasts in the simplest of Excel formats. After 20 years of doing this successfully, I suddenly get warning messages that my worksheet / workbook contain macros, and that I should
|