| Thread | Last Post | Replies |
|
| Run Time Error 13 | 31 May 2005 23:06 GMT | 1 |
Function DisableByPassKeyProperty() Dim DB As Database Dim prp As Property Set DB = OpenDatabase("testing.mdb")
|
| Using Macro to export from Access to excel. But Error message | 31 May 2005 16:45 GMT | 2 |
I'm trying to export a table in access to excel. I get the error that the "you tried to use a form,report,or datasheet that contains an OLE object, but the OLE server(the application used to create the object) may not be registered properly.Reinstall the OLE server to register it ...
|
| Send Object Macro for multiple objects in an e-mail | 31 May 2005 03:43 GMT | 2 |
I've set up a macro that e-mails a report to a recipient. It's just a simple send object macro. It works fine. The only problem is that it does a great job of sending one report to one recipient. We need to be able to send multiple reports to the same recipients.
|
| autokeys with terminal | 30 May 2005 15:14 GMT | 4 |
I'm using auto keys in my access application. Like ctrl+A or ctrl+b or ctrl+c etc In local computers it's works fine, But when I'm using terminal it doesn't work
|
| Create an expression that uses a value from a table and 1 from a f | 30 May 2005 06:40 GMT | 1 |
I want to set up an expression that calculates the difference between the last entered value in a table and the value entered on a form (which is based on the same record set). i.e. This week's meter reading minus last week's meter reading.
|
| How can I automate the importing of text files into access? | 30 May 2005 03:36 GMT | 2 |
I have been trying to write a macro that will automate the transfer of data from text files into tables in access. So far I have found two ways of doing it, but neither are exactly what I am looking for. The first way is to use the sendkeys function to open the get external data
|
| How to check for the existence of a file in an access macro? | 28 May 2005 10:11 GMT | 2 |
i want to find out how i can stop an access-macro if a certain file does not exist on my computer... can anyone help me ?
|
| Running a report with a user defined variable in a query | 27 May 2005 16:27 GMT | 5 |
I have a Report who's data source is a query which requires a manager's name to be entered. I am using the code below to run the report stDocName = "rptTimes"
|
| New at Macros | 27 May 2005 04:17 GMT | 4 |
I have been an accountant for about 5 years now and they recently want us to start using Access. I have really NO idea how to use it, and have NO idea what a macro is or how I would use it in the accounting field. I have been searching up and down and actually going into the ...
|
| Macro to Enter Criteria | 27 May 2005 00:51 GMT | 1 |
I have a report I am trying to automate based on a query. The Criteria Section states [Enter Area:] How do I get the Macro to enter "South East" by default? Thanks in advance
|
| Button to get a module to run | 27 May 2005 00:47 GMT | 2 |
I converted a Macro to a Module last week. The task runs much better as a module. The problem that I'm having is that I need to be able to run the module from a command button. I have no problem doing this from a macro, but I have no idea how to do this with a module. I have a ...
|
| exit sub not working | 26 May 2005 23:09 GMT | 7 |
I have the following code with an error handling in one part of the code. Once the For...Next loop has finished running a macro is called and then after it should stop (by going into the Exit_Adhoc_Click and then exiting). However it seems to ignore the Exit_Adhoc_Click and ...
|
| Using a macro to print 2 reports | 26 May 2005 19:46 GMT | 1 |
I have a table that prints a report when data is present. I want to be able to check the table if no data print another report. Can you or how do you setup a macro to do this. Thanks
|
| cpn file | 26 May 2005 19:40 GMT | 1 |
We are exporting an access table which runs everyday from a make table query. Is there a way to export the file with the extension .cpn? It is a list that looks like a txt file, but the system that will open it looks for a .cpn extension. Thanks,
|
| checking the existence of a file | 26 May 2005 19:37 GMT | 1 |
Maybe a stupid question, but can't find the awnser: How can i check the existence of a file (for instance "c:/images/image.jpg") in an access macro? any help is welcom
|