| Thread | Last Post | Replies |
|
| Macro Security in Access - Excel 2003 | 15 Feb 2004 06:23 GMT | 1 |
I am trying to set the macro security level to "low" however for some reason the Office 2003 applications are not letting it go below Medium. Can someone help and point me in the right direction in fixing this problem. It is Office 2003 Pro running on XP Pro. Our IT group ...
|
| Need help representing the Alt key | 15 Feb 2004 06:20 GMT | 2 |
Group: I would like to make a macro that responds when Alt+C is pressed. However, when I try to save the macro I get an error message telling me that I am not using the correct syntax. I am trying to use %C to represent pressing the
|
| Macro | 15 Feb 2004 06:01 GMT | 1 |
Hi All, Is there is a way that you can create a macro or code in a module to do the same as "Merge it with Microsoft Word" or "Publish it with Microsoft Word"? It is under Tools -
|
| Halt screen startling inexperienced users | 14 Feb 2004 03:26 GMT | 11 |
I have a form that is populated by way of a macro that runs, among other things, a parameter query. The problem is that, if a user presses cancel on one of the parameters' dialog boxes, the macro halts and reports as
|
| OPening a Word File From and Access Macro | 13 Feb 2004 13:01 GMT | 2 |
I am trying to open a word document using the macro facility on Access. I have tried EVERYTHING suggested on the Help function and i have had no luck, please could you tell me how i could solve this problem.
|
| Search Key not found | 13 Feb 2004 12:06 GMT | 2 |
I am getting a message that says "Search key not found in any record." I can't save data, and I cannot delete the corrupted table entry. What has been entered is converted to little empty
|
| macro to change data type | 13 Feb 2004 00:10 GMT | 3 |
My users wanted a simple method of recording employee data so I created a form consisting primarily of checkboxes. What I need to do is take the fields where there are checks and convert their type--yes/no is fine for a start,
|
| macros running from forms with filtered records | 12 Feb 2004 21:15 GMT | 6 |
I have problem with a macro. I want to prevent data input on the form after a date has been in a date field. When the form is activated, I apply a filter to only select records for a particular department. The macro I use to
|
| Multi Functional Button | 12 Feb 2004 07:11 GMT | 1 |
I use Access 2000. In Access 2000, I need to save a record in Form1 (i.e. save the data just entered), then open Form2 with the ID field from the previous form (the same record), and close
|
| HELP! Getting a empty field to populate with a zero value. (example included) | 12 Feb 2004 07:06 GMT | 1 |
I have a query thats looks at another query and pulls data that matches a selected fields. Three fields always have data but the fourth may or may not. Currently I get a blank cell and I need this cell to be a zero value when empty. Can I write the query to do this
|
| Emailing from address in Table | 12 Feb 2004 02:10 GMT | 16 |
This question has been answered many times but I'm afraid, after spending all day researching it, I cannot get it to work. I have a table with one of the fields containing email addresses. I want to have a command button that can be clicked on, which will find all the
|
| HELP with using a Date as file name | 12 Feb 2004 00:51 GMT | 2 |
Is ther a simple way to add a DATE as part of the file name when exporting a text file? I.E. ="C:\audit\data_name" & sysdate & ".txt" Of course this did not work!
|
| Closing Excel from Access Macro | 11 Feb 2004 19:51 GMT | 2 |
I have a macro that is operated by a button on a form. In brief, this macro is supposed to download a dataset from an intranet page (in Excel), clean and manipulate the data, resave the spreadsheet, and then close Excel,
|
| compare macro | 11 Feb 2004 19:33 GMT | 1 |
i'm looking for the syntax for the condition of a macro that after the first and last name of a person are entered on a form that it checks the other first and last names in the table and if there are any exact matches
|
| Macro Link | 11 Feb 2004 19:30 GMT | 1 |
Can any one tell me of a good link that i can use to learn about macros. Thanks MP
|