| Thread | Last Post | Replies |
|
| Cannot import/export or copy forms, macros etc | 17 Jul 2004 20:01 GMT | 1 |
A friend gave me her database to help her with (she barely knows access but has been developing this for a while) . When I try to import or export the forms (or even cut & paste them) I get this message:
|
| how do you schedule a macro to run daily? | 16 Jul 2004 22:58 GMT | 1 |
how do you schedule a macro to run daily? I want it to update automatically daily or weekly if possible Thanks
|
| Re-Number a table | 16 Jul 2004 20:22 GMT | 3 |
I have a table that is part of a report that has a seq. # field. Periodically I need to renumber the rows in the table due to changes and groupings. I'm sure it can be done with a macro but am unsure how. Any ideas?
|
| Macro to open table and add records | 16 Jul 2004 19:40 GMT | 3 |
I want to create a macro that will do the following: Open a table, allow me to add records, and then upon closing the table open a query. I have the first and last part, but I'm stuck on how I
|
| TransferSpreadsheet Action | 16 Jul 2004 12:44 GMT | 2 |
Hi all - I am using the TransferSpreadsheet action to import data from a series of spreadsheets. Everything works fine except for that when I move the database (or the spreadsheets) to a different folder all of my links obviously break in the 'File Name' argument. Is it ...
|
| Queries to show Last four dates | 14 Jul 2004 01:45 GMT | 1 |
Hi I have a table which contains a field called Entity For each entity there are several meeting dates with many Different Entities
|
| Upsizing Macros | 13 Jul 2004 15:22 GMT | 2 |
I am working on upsizing an Access Database which has several Macros.Could anybody please tell me how to upsize Macros to Sql Server? Thanks
|
| Blinking Macros | 13 Jul 2004 04:58 GMT | 6 |
, I've Setwarnings off, but: Does anyone know how to suppress a macro from blinking while performing open/close on forms/reports/tables/queries etcfrom the switchboard formHi , thereby creating the illusion that my macro is an efficient and elegant piece of work, rather than the ...
|
| Deleting Data with a macro | 12 Jul 2004 23:09 GMT | 2 |
Is it possible to delete all data in a table using a macro ? I don't want to delete the actual table, just the underlying data.
|
| Exporting Queries to Excel | 12 Jul 2004 20:21 GMT | 1 |
I'm trying to export a select query to Excel by setting up a macro with the TransferSpreadsheet function. In the table name field I am typing in the name of the query, however, I am unable to run this macro.
|
| SendObject how to disable if file attachment is empty | 12 Jul 2004 11:46 GMT | 1 |
Hello, I use a macro to run a query that gives output in a Excel file. I run the macro automatically every day, is there some way I can use conditions to not send the attachment if the excel file that I'm attaching is empty ?
|
| send to e-mail | 12 Jul 2004 10:21 GMT | 2 |
Who would I in a macro send or output a query's results to e-mail? Thanks.
|
| error message on conditional macro | 12 Jul 2004 09:42 GMT | 1 |
In a subform, I have a conditional macro set up to update a field (PatientID) when XXX is selected in the Sponsor field. The macro is set to run "afterupdate" of the sponsor field
|
| Run Macro Problems | 10 Jul 2004 23:03 GMT | 3 |
I am trying to initiate a Macro from another Macro using the RunMacro option. However, the problem I am having is that I want the RunMacro to only run based on a condition. Basically, I want to run a macro which sends an e-mail of
|
| pause/resume macro | 10 Jul 2004 17:58 GMT | 1 |
I can I pause a macro and then resume it? I have a macro that runs an app that deletes two files. Then, the macro outputs those file again. My problem is that it deletes one but not the other. I believe it is a timing issue.
|