Threads Replies Last Post 43 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>   timestamp in subject line of sendobject is it possible to insert the now() function within the subject line of the macro editor sendobject function?... 2 05.08.2006 19:36:32 export several forms to the same excel file I have 5 forms that come from 5 different queries. I would like to export the data from the forms to the same excel file, as 5 separate worksheets. Right now, i have a macro that runs: OutputTo -- and this takes care of the first form To have all of these form appear on the same file, i read here that i can use the "Transferspreadsheet" to export the rest of the forms....i tried to, ... 2 04.08.2006 19:38:17 Printing a series of reports from a list I would like to sequentially print 3 reports that take their parameters from a query returning three ids (parameters). I used to do this in PDOX and it seemed much easier than in Access. Thanks wem3rd... 17 04.08.2006 14:11:55 condition for a check box in a macro I have created a database that forwards reports to various individuals via Lotus Notes Mail. It would work with any mail client. Now, once that user receives the report through the email, I have inserted a hyperlink so that when they click they go directly to the database. There will be security on this database so that certain users can only open certain forms. I have gone so far as... 3 03.08.2006 22:40:02 Merging table data I have an Access 2000 database that contains six tables. They all contain the same fields (Object, Name, Desc, CodeNo). I want to copy all the data from each table into one big table in another database file (mdb). Is that possible? Thanks, Mark ... 2 03.08.2006 20:55:27 Design View of grouped Macros I am trying to determine the actions that exist within a macro group. When I view the macro in design view, there are three RunMacro commands listed in the action column. Is there anyway I can determine the actions that are within each individual RunMacro action? ... 5 03.08.2006 14:35:38 Update Query Works but Not In Macro I have a form/subform where the form is used for record entry and I want the record to immediately roll into the subform after user hits a button. The button has these macro steps: 1. SaveRecord 2. OpenQuery - Runs an update query in order to copy the [Odline] date into any null [Deadline] field 3. Requery - runs query named Log in order to refresh the subform by receiving the new... 7 03.08.2006 08:06:43 How can i loop through a combo box? Thanks in advance. Does anybody know how I can loop through a combo box on a form. For Example, I have a combo box on a form name "Test" with value (1,2,3,4). Now I need a VB code that can help me loop through this combo box and return each value in the combo box:1,2,3,4. Any help is greatly appreciated. Thanks ... 4 02.08.2006 23:19:03 Message Box When a Form Opens My macro for a message box to appear when the form opens only works when it's being tested. What am I doing wrong?... 2 02.08.2006 19:59:03 Newbie nuisance question I'm learning macros at the moment and thought I'd venture to write one which I needed myself but I could do with some help, since I spent hours today trying everything that occured to me and searching the internet when I should be studying since I've an exam on macros tomorrow. I import an list of people from the internet by using a web query in excel (labelled provisions) I selected ... 2 02.08.2006 19:11:30 How to write macro to search files from Word I wrote several macros in Word 95 and 97 which were searching for files with specific words in the file text, but I cannot convert them into Word 2003 or write new macro in Word 2003 of this type. I cannot insert words for search into the "text or property" property in the FileSearch object and cannot write the expression for search "Word 1" AND "Word 2" in the file. In the early versions of ... 2 02.08.2006 07:20:03 How to call a SQL stored procedure from a macro We use Access for the front-end linked to SQL tables to store data. We have a "random selection" process that has been written as a SQL stored procedure on the SQL Server. I'd like to use criteria from text boxes in a form to pass to the stored procedure and run the stored procedure from this same form...using a button to launch a macro....if at all possible! Anybody know how to do th... 4 01.08.2006 20:32:17 Creating a macro to search Hi. I'm pretty this question might be accomplished with a macro, or perhaps some other kind of Access Language. If this was an Excel program, I would know how to do it lickety split with a macro! This is what I want to do (I have seen it done before but don't have access to the database to figure out how it's done): - create a database that is completely 'idiot proof'. I have it so it... 3 01.08.2006 16:40:02 excel macro i want to have a tolerance for a value in column d depending on an entry(model size) in column a. if its over or under this tolerance the entry would be highlighted . for each model size these would be subtotaled. then i would like a function that would compares column b values of the highlighted values if they are the same it would give me a value of 1, if there were 2 different values i... 1 01.08.2006 13:18:02 query Hello I asked : How I can execute in the macro Bakss the query of increase and a query of deletion that will be done Aotmtit without that I will need to approve her? Because and I am an operation of tasks of fluent work and after That we will write a conclusion of the task by means of input of the date of conclusion as regards the form can enter a history of The tasks ( the chart of hist... 2 31.07.2006 20:49:59 Command Button to record date I am trying to figure out how to write a macro for different command buttons to record the date and time every time the button is clicked. I have four butons and everytime you select one it would post the date and time in the first empty cell in that column in a table. In the table I have four columns, one for each button. Any help would be appreciated. I'm just beginning to understa... 14 30.07.2006 05:36:40 Repeat a Macro Using an Expression I am trying to repeat a macro for several months of data by placing this expression in the RunMacro expression field - Forms![frm_Params]![FinalDate] > Forms![frm_Params]![ProcessingDate]. [ProcessingDate] gets incremented at the end of the macro before it should loop. It just is not looping. If I enter a repeat count, and leave the expression blank, my macro repeats 4 times and wo... 5 30.07.2006 05:17:48 Copy Record Into a Different Form I am not sure if this is exactly the right area. I am still new to Access and slowly learning about it's capabilities and just need a little help. I have 2 forms I created - Mailing List and Clients. What I want to do is have a button/command that will appear on the mailing list to "convert" to client, and automatically copy the first name, last name, address, etc into a new record fo... 4 30.07.2006 03:15:29 Macro for copying data I would like to find a way to copy the data from a form to a website form field. An example would be if I had an "Contact" MS Access form open and the current record field has an address. I would like the address to copied to the "address" field on a web form. Is this possible? Thanks!... 3 29.07.2006 16:09:02 compare and merge two documents, the insertions and deletions When I try to compare and merge two documents, the insertions and deletions are overwriting each other. When I view it in the View format, this does not show up, but when I view it in the Print format, the overwriting shows up and it prints out the same way. What am I doing wrong?... 2 29.07.2006 08:03:29 Access 2003 SendObject with Groupwise 7.0 - multiple addresses When entering multiple email addresses separated by ';' in the Action Arguments (To, CC, or BC) of the SendObject Action, the resulting email only contains the last recipient of the list. My email client is Groupwise 7.0, and this worked under Groupwise 6.5 ... 1 28.07.2006 22:57:02 Having problems creating two buttons/macros I would like to create two buttons, but haven't figured out how: 1. I want one button that a user can click on to bring up the Form Filter option so they can search by whatever they want instead of having to make 101 queries. I have seen it done, but don't have access to the databse to look at the code. If it requires coding, please give me step by step instructinos, because I am no... 1 28.07.2006 18:26:02 runapp problems I am trying to run an runapp in conjunction with a larger macro and I continue to run into the same problem. It says "Microsoft Office Access can't invoke the application using the RunApp action. The path to the application is invalid, or a component of the application is missing. Check the path in Windows Explorer or File Manager." To my knowledge the path seems correct, but h... 3 27.07.2006 19:57:01 OutputTo commands macro not working We have two menu items trigger the macros, which use RunCommand Action for command "OutputToExcel" and "OutputToText" for our report snapshot. We found the menu items are disabled (grayed) when we run application. It used to be wroking fine. Any idea or suggestion? P.S. They are not disabled when I run the VBA project. -- Software Developer... 1 27.07.2006 19:34:02 How can I open a Word file from Access with a macro? I have a database that has a file in word that is assocaited with the database. How can I open the word file with a macro in Acesss. Thanks ... 6 27.07.2006 13:36:08 43 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>