| Thread | Last Post | Replies |
|
| setwarnings in a macro for access 2007 | 30 Apr 2008 15:27 GMT | 6 |
Is there an equivalent to SetWarnings in Access 2007 Macro's as in 2003?
|
| Link Tables | 26 Apr 2008 17:07 GMT | 2 |
I am new to the VBA hence don't understand all the jargon. I have an access database which has one of the tables linked to an excel spreadsheet which changes every month ( I mean the name of the file, not the location). What I am looking for is, if possible please, can I have a code ...
|
| DeleteObject macro action | 25 Apr 2008 22:21 GMT | 1 |
The deleteobject macro action (as well as others) no longer appears in the pick list under the macro action column. Is there a way to find/use this aciton even though it doesn't appear in the pick list?
|
| Output to - pop up message | 25 Apr 2008 14:06 GMT | 2 |
I have created a macro wherein the output of few queries is to an excel. For example my query name is Priya and the output xls file specified in the Action Arguments is C:\temp\Priya. When i run a macro i get a pop up message stating
|
| Library Solutions | 25 Apr 2008 07:30 GMT | 1 |
Massive clearance sale...big discount off our Access database "Library Solutions". Please visit http://www.base1solutions.com/sale.html
|
| Access Switchboard - macros freezes system | 25 Apr 2008 07:25 GMT | 1 |
Does someone know what I can do... I set up my switchboard to run macros for routines my user needs to perform. This worked fine in 2003, but in 2007, the macro freezes up the whole application and it has to be closed and restarted. I've been looking to see if there's a fix or ...
|
| Synchronizing with Macro | 24 Apr 2008 20:52 GMT | 1 |
I have attempted to build a macro that runs the command... "SynchronizeNow". But this command does not complete the sychronization. It initiates but does not give me a status bar or message that it syncs. When using the toolbar, Tools, Relication, Synchronize Now... method ...
|
| Deleting Rows Based on Criteria | 24 Apr 2008 16:33 GMT | 1 |
I'm a newbie to VBA and am trying to construct a simple macro to delete all rows containing different characters. For instance, delete all - blank rows
|
| Macro for a report | 22 Apr 2008 02:47 GMT | 1 |
I currently have a database designed for Quality assurance. In my report, I am looking to show employees anytime a Final QA socre is less than 100 by turning that field a red. Final QA Score: ([Overall Score]+[Lag Score])/2 --Thank you
|
| Mass change of data in table | 21 Apr 2008 19:26 GMT | 1 |
I would like to search a table (Table1) field for a specific text value (call it FieldName2) that begins with the letter z. If it does then I would like to make another field (Call it FieldName3) blank. What syntax would I use? this is basically what I am trying to do:
|
| TransferText Not in Access 2007 | 20 Apr 2008 13:00 GMT | 3 |
I apologised if this has been asked before. I have TransferText macros in Access 2003. I import a fie a day into my Access db. I want to use the same app in Access 2007. But TransferText not available in Access 2007.
|
| go to a new line. | 19 Apr 2008 23:23 GMT | 3 |
In my macro I have a message that displays "Customer"&[name]*"has this issue:" &[issue] I know in many languages \n will move to the next line but that does not work? How do I get the issue on the next line.
|
| AddFromOutlook Access 2007 | 18 Apr 2008 16:43 GMT | 13 |
AddFromOutlook I was using the button inside a new database with the code AddFromOutlook from the nortwind database as was working great, then all of a sudden it stopped working so must have changed something to make it stopped, but cannot find any information on this command, can ...
|
| Macro fails from button, runs when selected directly | 18 Apr 2008 03:17 GMT | 5 |
I have a very small Access 2007 database with two tables, three queries, one form, one macro, and one report. On the form is a button to run the macro. The macro closes the form, runs a make table query, runs a SQL add column query, then opens the form back up. The form's main ...
|
| Trigger a macro to run on a specific date | 18 Apr 2008 02:35 GMT | 5 |
Is it possible to trigger a macro to run on a specified date - for example, every Monday - without any intervention? The macro is a SendObject - sending a report. Thanks for your assistance!
|