| Thread | Last Post | Replies |
|
| AutoKeys macro | 17 May 2005 20:43 GMT | 3 |
Hi, i have an autokeys macro that i have until now used to open different forms when a specific 'F' key is pressed. however, now i have created a option group on a form and i would like each 'F' key to open each option. is there any way i can do this?
|
| Macro doesn't replace an existing file. It did in Access 97. | 16 May 2005 22:11 GMT | 2 |
I have a macro that performs several functions. It runs six queries, the last one creating a table. I then have the macro setup to export that table to an AS400 location. This is where it fails. It halts the macro and gives me an message box that tells me the table "payrolje ...
|
| automate macro every 30 minutes | 16 May 2005 18:28 GMT | 1 |
Hi, I need help. How can I automate macro every 30 minutes without manually running the macro so as to backup my tables. Thanks for the kind attention. Jack
|
| Scheduled Tasks problem firing Macro | 16 May 2005 15:28 GMT | 4 |
I'm trying to execute an Access 2003 macro called "ExportIt" using the Scheduled Tasks utility bundled with Windows 2K. This syntax (note, without double quotes) does work: C:\Express\ImportExport.mdb
|
| Using a macro to send an object to a variable e-mail address. | 16 May 2005 13:05 GMT | 4 |
I am trying to get my database to send one of its records to an e-mail address which is one of the fields of the record. There seems to be no way to set the "TO" field to anything but an actual e-mail address. Does anyone know a relatively simple way around this?
|
| automate macro every 30 minutes | 14 May 2005 09:00 GMT | 3 |
Hi, I need help. How can I automate macro every 30 minutes without manually running the macro so as to backup my tables. Thanks for the kind attention. Jack
|
| error 3021 | 14 May 2005 00:11 GMT | 2 |
I am writing an Access application using macros. I have a form with several subforms that are used for data reference or data selection only. The purpose of the form is to select the desired "package" from the available "packages" as displayed in the "package" list. Once ...
|
| Set Focus within the subform? | 13 May 2005 22:00 GMT | 3 |
not sure if this should be going to the Forms group, but here goes. I have a form/subform which when opened, needs to begin editing in the first field of the subform dispalyed as a data table. What is the correct way to SetFocus on this field? My tab order in the sub is correct, but ...
|
| Conditional delete object | 13 May 2005 21:29 GMT | 2 |
I have a macro that runs an import of a text file. typically there are some errors that create an error table. To keep from having them buildup I would like to have a condition to delete object (the error table) before import so that it removes the last error table. Has to be a ...
|
| HELP Adding a Date to the field | 13 May 2005 20:45 GMT | 2 |
As I add new records to my table, I want to have the date the record was added to the table automatically put into a "DateAdd" field. Any help in doing this will be much appreciated. the records are moved to one table (without DateAdd" field) to another
|
| Reference a value in a subform??? | 13 May 2005 20:16 GMT | 1 |
I have a macro that uses FindRecord to search for a record based on a value in an open subform. The macro is currently returning an error that it cannot find the form--It's as if I misspelled the form name in the FindWhat field though I assure you I did not. As a matter of fact, ...
|
| Email from Access | 13 May 2005 19:36 GMT | 4 |
I have a contacts database which contains an email field. I want to be able to click on the content of that email field, and have an outlook email window open, with the recipient's address already input into the TO Field. The
|
| Re HELP with this Macro Import | 13 May 2005 12:40 GMT | 1 |
Here below is a sample of the data which I am trying to import. This import of .txt data files. What happens is that I get a number of data conversion errors. What I'd like to know is why, since the data is obviously text. Then, again, maybe it's not! The actual data file has ...
|
| Macro fails to run at start up | 13 May 2005 12:09 GMT | 2 |
I have a database on a network that is shared by client PCs who have a shortcut to the file on their desktops. There is a macro that runs at startup that does not seem to run on one PC. Normally we have been able to add a shortcut to a PC to allow them to access
|
| HELP Compare two tables MACRO | 13 May 2005 08:54 GMT | 1 |
HELP - Does anyone have some code to compare two shts (TABLE) from EXCEL. The table may have 2000 rows with criteria that may have changed in the columns (10 off). The criteria may have been added, deleted or changed. I'd preferable like a column adding denoting A, D or C against ...
|