| Thread | Last Post | Replies |
|
| How can I monitor a macro by query name and status? | 08 Apr 2006 10:08 GMT | 1 |
I have several macros that run multiple queries and would like to monitor progress as queries run. I'd like to see the query name and status. Is there a setting for this or an add-on I can get?
|
| OutputTo macro with MsgBox - Help! | 08 Apr 2006 05:38 GMT | 1 |
I have a an action macro OutputTo that exports my queries into Excel. I want to include a message box saying something like "Data exported successfully" once it has been exported (clicked "OK" in the Output To dialog box). However if the user clicks Cancel instead, the msg will
|
| Run time error 2482 | 08 Apr 2006 01:45 GMT | 2 |
This is one of those ‘Why in the world is that . . .’ questions. I have a macro attached to On_Current on frmLaurieSheet Macro reads: [txtbuyerfullname] Not Like "none” set value [Forms]![frmLaurieSheet]![cboAssignBuyer].[Locked] yes
|
| Sending Email From Access 2003, and Security Warning Popup | 07 Apr 2006 16:44 GMT | 9 |
Code example to generate error message. DoCmd.SendObject , , , "me@saccourt.com", , , "Test Sending Automatic Email", "When the SendObject is set to False, meaning that you will send the email immediately. You get this popup in Windows XP for a critical stop. ",
|
| Publish known bugs | 07 Apr 2006 13:29 GMT | 1 |
Please can you publish all known bugs for MS products. As a developer this would help me enormously. I am using Acc2003 and I have a scenario where: Claimed = 500
|
| OPENFORM | 07 Apr 2006 13:25 GMT | 1 |
I am running a macro using "OPENFORM" I would like to use a "filter" or a "where condition" to find a specific record. I don't how to create either or where to find help with coding. Please help
|
| Need Help Writing First Action Command Button | 07 Apr 2006 05:36 GMT | 2 |
In a form I have created, I have two tabs. I would like to create a button on the second tab that will take to first tab on the same record. I tried to use the wizard for this but with no luck, Any Advice would be well received.
|
| MsgBox | 07 Apr 2006 04:29 GMT | 1 |
How do you Adjust a Msg Box Window Location? I have a Msg box that comes up with Instructions for the User, but it covers the data enter window. I would like to make it pop up in a different location, so it will not the other windows in which the macro opens.
|
| DateaddDate | 07 Apr 2006 02:46 GMT | 5 |
I am trying to figure out how to calcualte a Field (Date) from another Field in the same table. I tried using the Dateadd expression as well as a query, I just cant seem to get it right.
|
| Macro/RunCode - referencing a listbox on a subform | 06 Apr 2006 23:15 GMT | 1 |
I have a shortcut menu on a listbox that calls a macro. The macro passes the listbox to a function via the RunCode command. This works fine when my form is not a subform, but it doesn't work when I place my form on another form (where it needs to be).
|
| Use Macro to Print Reports | 06 Apr 2006 19:17 GMT | 2 |
I have a form with 6 option groups. There is a report for each possible combination. I have a command button that runs a macro to get the correct report. I want to use this same concept, but have another command button allowing the user to automatically print the report without ...
|
| Security Warning when downloading Templates from Microsoft.com | 06 Apr 2006 18:37 GMT | 1 |
When I go to download the inventory management template from Microsoft.com I get a warning saying that the file may not be safe if it contains code that were intended to harm your computer. Then it asks if I want to open the file or cancel it. May macros security is set on ...
|
| How to change criteria in a query using a macros | 06 Apr 2006 06:12 GMT | 1 |
I have aprrox 50 queries that all have one field on common (Division). I need to run each query for each division (10 of them). Fortunately, I was ably to write VBA code in Excel that automatically runs and down loads the queries to an excel sheets. Unfortunately, each time I ...
|
| Transactions with VBA | 05 Apr 2006 13:16 GMT | 2 |
I want to delete and update records of different tables and when there's an error, nothing should be done. I read about ADODB.Connection.BeginTrans and .CommitTrans and .RollbackTrans. I am not sure how to use them. How do I know if a transaction was
|
| Need help | 04 Apr 2006 15:04 GMT | 2 |
I have a formula of sort that is suppose to count the number of days between two dates. I have that part down I think. I need this to happen only when the beginning date is a day other than the first day of a month. In other words if the date is 3/1/06 I need the formula to put ...
|