| Thread | Last Post | Replies |
|
| Switchboard Macro | 15 Mar 2005 20:53 GMT | 4 |
I have created an AutoExec Macro, which opens the switchboard but this also allows the user to get to tables, forms, queries options. How can i hide these from the user everytime the database is opened and how could i display them when i need them.
|
| Give a letter automaticly a letter-number and put it in an Access. | 15 Mar 2005 18:56 GMT | 2 |
If I make a letter I have to give it a documentnumber in a separate Access-file. Is it possible to give automaticly a number to the outgoing letter and automaticty put this number in a Access-database and in the same record of that number should be automaticly take over from the ...
|
| VB Code of a Macro | 15 Mar 2005 18:45 GMT | 1 |
Is there a way to see the VB Code of a macro? Thanks
|
| Using OUTPUTTO and saving to folder for backup | 15 Mar 2005 17:08 GMT | 2 |
I am trying to use outputto to send a snapshot of my report to another server/folder for a backup. How do I bypass to get Yes to auto reply when promp another file by the same name already exists? Thank you
|
| Macro open query action with action fail | 15 Mar 2005 01:18 GMT | 1 |
I have macro to open a query with the query input prompt. It works. However if I decided to cancel the query, I got the action failed screen then I have to click on Halt or 'X' to close the macro. It is annoying. Please help me to fix that action fail
|
| Creating Excel Spreadsheet within Access VBA | 14 Mar 2005 21:08 GMT | 1 |
I set up the code listed below to create an Excel spreasheet from within access VBA which worked successfully except it displayed a warning message when I wanted to save the file. I entered DoCmd.SetWarnings False which did not work. I then entered: xlApp.Application ...
|
| AutoExec Macro | 12 Mar 2005 04:28 GMT | 5 |
My AutoExec macro will not make my files "Read-Only" it goes to the beginning form properly, but won't put it in a read-only mode, I use Find Form, GoToControl, please help, no one ever responses to my questions!
|
| Need macro to enable a control based on value in another | 11 Mar 2005 23:44 GMT | 1 |
pretty straight forward stuff, I know. Can someone tell me how to do this?
 Signature MV in LA
|
| macro to send query results to excel | 11 Mar 2005 21:41 GMT | 2 |
I'm a macro novice. Is it possible to create a macro that opens Access 2000, runs a query, sends the results to Excel, and then sends the Excel file to a mail recipient? thx
|
| Command Button for Macro works once | 11 Mar 2005 21:37 GMT | 2 |
I have a command button that runs a macro sendobject. If I hit the command button again it doesn't do anything. What action would make this button work again? Right now, I have to get out of Access to have it work again.
|
| Open a Word document | 11 Mar 2005 20:36 GMT | 2 |
I am trying to have a macro open a Word document. Is it possible to open a Word document from a macro? If not, is there some alternative that can be utilized to do this (forms, switchboards, etc.)? Thanks, in advance, for the help.
|
| Edit query macro | 11 Mar 2005 19:03 GMT | 1 |
I have a query that includes a field called "state". I need a macro that will open the query, change the state to each state in the query, and then export each state specific query to an excel file. I've figured out the export function, but cannot figure out the edit query ...
|
| AutoExec Macro | 11 Mar 2005 17:57 GMT | 2 |
I've written an AutoExec macro so my database will open in a "Read-Only" mode and its not doing it, what am I doing wrong..Shelia Simpson 16
 Signature M.Simpson
|
| Time date stamp | 10 Mar 2005 22:40 GMT | 2 |
In a form... I would like for a time date stamp to be placed in a text box at the exact time that a macro (enter button)is ran. TFTH
|
| use command button in access to open excel file | 10 Mar 2005 21:21 GMT | 9 |
I would like to have a command button on a form that I could click that would open a specific file in Excel. So far, all I have been able to do is create a button that opens a blank document in Excel. Is there a way to do this using a macro, or would a code have to be written? ...
|