| Thread | Last Post | Replies |
|
| working - message box | 26 Jan 2005 18:51 GMT | 1 |
I have a backend database on the network with a lot of temp tables, and combined queries. How is it possible to display a "working, please wait"-like box and remove it when the work is finished?
|
| Using macro to paste | 26 Jan 2005 18:46 GMT | 1 |
Is there a way to create a macro to 'gotocontrol' copy and paste the "control" then have it entered into a parameter query. ie I want to run a macro that first will go to the control on a form named "Policy Number" then copy that 'policy number' continue the macro to run a ...
|
| Newbie macro problem | 25 Jan 2005 18:01 GMT | 2 |
scenario: need to run a query at a certain time each day and save results as text file in particualr location. db is access97 Solution: I have both acc97 and 2002 installed. I have created a macro that does the following (in both programs):
|
| exporting results of a query | 25 Jan 2005 12:57 GMT | 1 |
Ok, I'm def not an expert to Access. We do auto exports of data results from a query into text files right now. For some reason the vendor in charge of the picking up the text files can't get them to load on their 2003 server, he thinks there's problems with the text driver. ...
|
| How do I create a log-file | 24 Jan 2005 23:41 GMT | 1 |
How do I go about creating a log file for Access which shows changes and the login which made the changes?
|
| how do I create a macro that will run after a specified time? | 24 Jan 2005 17:11 GMT | 3 |
I am looking to create a macro that will run another macro or application after a specified time. eg. macro runs a 10:00 am every morning. eg2. macro runs ever hour or every 15 minutes
|
| Query to generate multi records | 24 Jan 2005 17:02 GMT | 1 |
I need to generate each employee a record for each week in the month. I have a table that has all employee names, another table that has the week no of the month. In order to do this I have to create 3 queries. 1. to retrieve employee name from employee table (a1)
|
| Set up a macro in Access | 24 Jan 2005 16:54 GMT | 4 |
I have been trying to set up a macro in Access 2003 tto automatically insert a number. I don't wish to use the autonumber field for this as I need to start at a specific number and increase from there.
|
| New Excel user needs help with simple Macro... | 24 Jan 2005 02:10 GMT | 1 |
I am relatively need to Microsoft Excel and I need help creating a simple Macro. I would like to create a Macro that will: - take the value of the selected value
|
| Delay sending emails?? | 23 Jan 2005 14:35 GMT | 2 |
I am using the sendobject command in a macro to send out numerous emails. This seems to be causing a problem with our exchnage server. Is there a way to delay sending the emails for a few seconds between each one? Is there something I could include in the macro??
|
| How to find a specific record | 22 Jan 2005 17:58 GMT | 1 |
I'm creating a database for many users to access. I want a feature where an employee can type in a client# or client name to pull up that client's information. Can this be accomplished by a macro? Also I have three seperate tables of client information based on the type of ...
|
| Null in conditions | 22 Jan 2005 17:41 GMT | 1 |
I am writing a macro with conditions and I want one thing to happen if one or more of three fields in a form are empty and another if none are empty. I have tried various conditions like "(not IsNull("field1")) or (not IsNull("field2")) or (not IsNull("field3")). Could someone ...
|
| New graph from imported table using macro/module | 21 Jan 2005 11:03 GMT | 1 |
All I want to do is create a new graph in Design view from data in a table I have already imported, and according to a Formula set already opened. Usually I would do this using the Insert->Chart command, then go through the wizard specifying what fields go to what axis, what type ...
|
| Find Null | 21 Jan 2005 07:25 GMT | 1 |
I am trying to use the FindRecord action in a macro to find any field that is blank or null. In the find what I put =Null, Null and it gives me an error. I don't care which record or which field it is I just have it as an error checking field to make sure that there are not any ...
|
| running a macro from within a DAP - Data Access Page | 20 Jan 2005 23:45 GMT | 1 |
Does anybody know how to execute a macro from a Data Access Page? My pages were initially developed using FORMs. The application looks great. Other users want it and would prefer using it on the Intranet. There are many buttons and macros. How do I execute macros from within DAPs?
|