Threads Replies Last Post 43 Pages: <<  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  40  >>   Reverse Entry??? I have a 'dependencies' table that identifies projects that are dependent on each other. It only has two columns. The first column is updated automatically via a subform, the second column is populated via selection from a combo box on the subform. What I need is that if I identify that ProjectZ is dependent on ProjectA, I would like the reverse to be automatically added to the depende... 3 12.03.2006 20:41:33 delete records macro I wan to start a macro by opening a table and deleting all the records... 3 11.03.2006 19:55:29 printing double side from command line macro in MS word I am trying to setup double side printing from MS Word 2002 calling word from command line with macro. There was no problem to record a macro and execute it from the word document. My problem is that it will not print double side with same macro from command line (prints single side instead) "C:\Program Files\Microsoft Office\OFFICE10\winword.exe" /mprintdx3 filename Macro name... 4 10.03.2006 16:14:01 SendObject Memo Field I have a command button that runs a macro when it is clicked. The macro is for a SendObject to send an email with the information from the memNote field in the message text box of the email. This truncates to 255 no matter how long. I was hoping to use code for this but am not a programmer. I used the instruction, that I found on this site, below to create the VB code. I know this i... 2 10.03.2006 15:59:30 How do I disable a macro in Access? I have written an autoexec macro into my database to load a switchboard automatically. However, I edited the switchboard in Basic, and slipped up on the timer. It now performs one operation every nanosecond and locks up the program, making further development and access of my database a problem. Any help will be appreciated, Thanks, Matt... 2 10.03.2006 15:46:32 Macro for creating a new TextBox in a form Hello to everybody!! I'm a new member and rather a beginner at using Microsoft Access and quite ignorant concerning macros! I would really appreciate your HELP!!!!!!! I have a form in which I want to be able to add TextBoxes whenever I want without having to transfer to the design view. I'm not really sure that I'm supposed to use a macro...What I did was to select the action "Run Command"... 4 10.03.2006 15:40:29 Formatting I am wanting to set a format on an access form, which when I select or input into a field the formatting to a number of boxes change, ie pending in one box will change the persons name to blue. ... 5 10.03.2006 12:06:28 Set Login Password How can I open the Dialog "Set Login Password" Dialog within a Macro or in VBA. (I tried to use DoCmd,RunCommand but I couldn't find the corresponding Parameter)... 3 10.03.2006 09:14:28 Run Macro from another database How can a macro in one database be run from another database? Thank you Dave ... 2 10.03.2006 07:22:14 Launch Macro in different Access db I have 3 different databases which have macros which need to run daily. They are cascading. I would like to open the next db and launch the daily macro from within the first macro. I'm thinking RunApp, but I can't figure out how to send the command to run the macro. I tried SendKeys %TMMDaily FTS Update~ , but it wants to find the macro name from within the original database, not t... 7 10.03.2006 07:20:04 is there a way to run a query as soon as you open the database is there a macro that will run at the time when i open the database or shortly there after, that i dont always have to manually run this query after i open the database... 3 10.03.2006 07:17:27 Formatting in Access forms I am wanting to set a format on an access page which looks at one foeld then changes another... 2 10.03.2006 07:12:34 How do I filter data on a subform using a macro? I've created a form in an Access 2003 database, and within that form I have a subform that displays a table of data. I want to have buttons on the form that filter the data on the subform in different ways. I can select an entry in the subform and use the "Filter by Selection" button to filter the data, but I can't do the same action using a macro (which would be activated by one of th... 1 10.03.2006 06:56:27 Macro HELL Hello, I have a macro that basically run based on a condition. In the acutal macro I have condition 1 and it's results then condition 2 and it's results listed. The problem I have is when I have it listed condition 1 then 2 one condition 1 will work. Naturally, when I list them 2 then 1 only condition 2 works. I am using 2003. Any help would be appreciated. JC... 4 09.03.2006 22:56:03 BECOME A DOT.COM MILLIONAIRE WITH ONLY $5.99Cents or $1K. ... 1 09.03.2006 20:43:07 How do run a query and export it to a table all in the same macro How do run a query and export it to a table all in the same macro?... 1 09.03.2006 19:30:14 Function Arguments I have a function with one argument that is being called from another function. In the process of testing, I decided to add a second argument to the function. So I changed the Function statement as follows: From: Function Test(A) To: Function Test(A,B) When I went to the calling statement to add the second argument, Access allowed me to add the second argument, but when I mo... 6 09.03.2006 17:16:49 Transpose data How can a data table in Access where there are multiple fields and one record be transposed to one field and multiple rows as in Excel copy/paste (transpose)? Thank you Dave ... 3 09.03.2006 13:16:30 Database properties read by macro Hello, I would like within a macro to read the value of the (e.g.) 'Reference' property (File-Database Properties-Custom-Reference), eventually assign a new value, and/or use the value as a condition within the macro. If this is not possible in a macro, is it possible in a module ? ( .. and what is the syntax ?) Thanks in advance Lucien ... 1 09.03.2006 10:32:40 Delete from Most Recently Used list I am running Offcie Professional Edition 2003 and want to clear the MRU for ACCESS 2003. I go through the procedure of unchecking and checking the Recently Used File checkbox suggested in the Knowledge database. The same list reaapears that was there before. In Word2003 I can do a macro to select what to delete (see below). Is there a way in Access that I can either delete a single file ... 2 09.03.2006 03:19:28 Why does macro not run on event in form, but runs on own? I have a marco which runs two make table queries. Query 1 performs calculations on Table 1 and creates/saves Table 2. Query 2 converts codes into descriptions and creates/saves as Table 1. This macro works fine until I tie it to an "on click" procedure in a form. When the macro is run from the form, when it tries to create/save as Table 1, I ge the error message "The database engin... 1 08.03.2006 22:21:26 set value many times I have a form to collect data for a table. On selecting one option a new form opens with a new record in the same table which collects different information but for the same table. The new record also needs to have values set for a large number of fields based on the record that was being completed on the first form. I know how to use the set value action in a macro but is there a way of... 1 08.03.2006 19:35:34 SendObject I have a sendobject report in a macro working , but would like to know if there is a way to do this in VB? Thanks, Pixie... 3 08.03.2006 16:59:36 Send Object I'm using the SendObject macro command to send an email of the current record. I want the [Notes] field to appear as the text of the email, so I have =[Notes] as the Message Text Argument. It works great on short notes, but it is truncating long notes (the Notes field is a Memo field and can be quite lengthy) Is there anything I can do to be sure the entire contents of the notes field ... 5 08.03.2006 15:50:27 open word doc from access I want to set up a macro in access which opens a specific word document. I can see how to open word as an application but not a specific doc. Is this possible or will my users have the locate the doc themselves? BTW the word doc is a mail merge with the data source being a table my access database. Note I am using macros because I don't do the whole VBA thing. Rob ... 4 08.03.2006 09:39:13 43 Pages: <<  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  40  >>