| Thread | Last Post | Replies |
|
| Hyperlink & print buttons | 22 Dec 2005 19:38 GMT | 3 |
I have a database of documents and I would like to add a buttons to the form giving the document details which will (1) follow the hyperlink (per the address in the field which is already populated) and (2) automatically print the document from its current location.
|
| macro and code in the same event | 21 Dec 2005 16:00 GMT | 1 |
I have a report for which I had a macro, say Macro1 written into its 'On Open' property. Later I realized that I wanted to have the report opened maximized. Not knowing how to do that in a macro, I added a code in the Report Open event in the VBA window as docmd.maximize. But ...
|
| Macro followed by Hyperlink | 20 Dec 2005 23:22 GMT | 3 |
I want to set up a button that will run a macro that runs two queries, then open a hyperlink to another Access database. Right now it takes two buttons to accomplish this. The first button runs the macro, the second button opens the other database. Is there a way to combine ...
|
| Macro and Conditional Expression | 20 Dec 2005 23:19 GMT | 4 |
I have a subform with a 1/0 response. I would like to send the User to the next subform based on the response in this field. For example, If the User types 1 then Open Next Subform, If the User types 0 then "don't do anything and just continue on to the next variable.
|
| Do SelfCert generated certificates expire? | 20 Dec 2005 22:21 GMT | 3 |
Do SelfCert generated certificates expire?
|
| Noob asking for help - Access 2003 | 20 Dec 2005 18:59 GMT | 3 |
I'm trying to autonumber a certain field. Searches through this group lead me to trying a default value of Nz(DMax("[EmpID]","tblEmployee"),0)+1. When I try to save, I get "Unknown function 'Nz' in validation express or default value on....".
|
| RunApp giving new error | 20 Dec 2005 18:30 GMT | 2 |
I open some Excel files in a macro using the RunApp action. This has been working with a command line of "L:\Audit\CSC#.xls". This morning for no apparent reason I get an error of "AP Audit can't invoke the Application using the RunApp action."
|
| Replace | 20 Dec 2005 17:48 GMT | 2 |
I have this Macro that execute a query.I'd like to replace the column A results... Now they are numbers ...and I'd like to replace them with city names.. For example 50000 is Milan
|
| Go to the last record automatically | 20 Dec 2005 17:13 GMT | 1 |
I am using Access 2000. I have a macro that open a form for editing. I want the macro to open the form with the last record entered. I think I need a filter, in the open form macro, for this, but do not know how to create it. Can anyone help me or
|
| Randomize Macro | 20 Dec 2005 07:31 GMT | 4 |
We have a database which is constantly changing and as a result whenever we train staff we are constantly updating the training database as well. What we'd like to do is just take a copy of the database and run a macro which will randomize the staff names. We dont go in depth on ...
|
| text converted to numeric with setvalue | 20 Dec 2005 06:48 GMT | 4 |
I have a column (UseCaseNo) with values that look numeric to Access. The values are a hierarchical numbering scheme: 01.01, 01.01.01, 01.02, 01.02.01, 01.02.02, etc. When I try to use setvalue to set an unbound text box (SaveUseCaseNo) to the value of UseCaseNo, it appears that ...
|
| Can't find function in expression | 19 Dec 2005 22:25 GMT | 3 |
I have a macro that calls a function when a button is pressed on the main login screen of my database. Every employee's PC I've tested this database on can use it with no trouble, except one, who gets the message "The expression you entered contains a function name that Microsoft ...
|
| DCount function to verify username and password | 19 Dec 2005 15:14 GMT | 1 |
I am tryting to follow another posting suggestion on 12-5-05 using the DCount function to verify username and password fields are present in a table. The command is: DCount(1,"Tables![Gina Password List]","[UserName] ='" & [Forms]![Gina
|
| Import Macro | 17 Dec 2005 21:03 GMT | 2 |
I am using the TransferText Action in a macro, is there any way to code in the filename parameter to look for the file in the folder where the database resides? My users will make a copy of this database (empty) and import the file and I would like to tell them to put the file to ...
|
| How can I get plot from given equation? | 17 Dec 2005 15:03 GMT | 1 |
I need to create corresponding plot to given equation. For example if I give an equation such as Y=2x+4 or Y= 2X(power2)+5x+1, how can I constryct related plot. I tryed to find in excel.But may I have to use other sofwares. It most appreciated if anybody can send me her/his ...
|