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  >>   Send Object Macro I am using the send object macro, I was wondering if there is anyway that I can that I can send two forms instead of the usual one. Any help wouldbe appreciated. Thank you, Donbenz... 1 19.06.2006 23:24:01 Similar to SetWarnings, file output prompt to YES In a macro, is it possible to set the answer to always be YES?, when you get the prompt "The file 'C:\[filename].xls' already exists. Do you want to replace the existing file?"? Like you can with "SetWarnings", is it possible to do the same with file output in a macro? -- Thanks, Kevin... 2 19.06.2006 19:28:17 Macro for Error Message I am trying to write a macro that will bring up an error message if the data entered on a form does not match the data already entered into the database. I know I have to use the MsgBox arguement, but I am having trouble with the condition. As an example, if the user enters "James" into the First Name field on the the form, but the database record has "Jim", I need the error message to... 16 19.06.2006 18:58:50 Reading macro properties from code How to read Macro Action and Agrument from VBA??? Thanx! ... 2 19.06.2006 18:06:54 Macro for running text in Memo fields as SQL I have a form with various unbound tick boxes & combo boxes. I want to build a macro which runs a different SQL query depending on what state the tick boxes and combo boxes are in. The various combinations of tick boxes and selections in the combo boxes is potentially huge, and I don't really want to clutter my database with dozens of queries. Is there a way to set up a table where th... 2 19.06.2006 18:04:40 Change the default respond in method DisplayAlert when i use DisplayAlert = False, can i change the default respond to other choice rather than the default choice by Excel? ... 2 19.06.2006 17:41:58 Access 2000 error: "object is not an OLE object" I created a macro to set the value for a form's data entry to No. The error message returned says "The object you referenced in the Visual Basic procedure as an OLE object isn't an OLE object". I've successfully used this very same macro in another database. ... 2 19.06.2006 03:24:16 Repetitive Process Macro Can anyone assist me in designing the following macro? I have a (continuous) form in which each record has a checkbox field which the user manually clicks yes or no. I have a macro which performs certain functions depending on whether or not the checkbox is clicked to yes. I have it working fine for a form with a single record. However, when there are several records, the macro needs... 3 18.06.2006 02:31:01 How do I create a macro in MS Access to start Lotus Notes I need to create a Macro that will auto key in my password in Lotus notes. I have it where it will send an email if I am already logged in but, I must be logged in first with my passwrd. ... 1 18.06.2006 00:35:01 Search macro that only open the one record in the form PLEASE HELP I have a search macro that is search from a command button on a form. Here is my problem. when I use the search it only open the one record you can not then page and see any of the other records. you can close the form and re-open it and then see all the records. Please help what am I doing wrong or not seeing. I have been fighting with thing on an off for days. I would really appreci... 3 16.06.2006 22:11:40 Restore Deleted Macro Still slow after the England game and deleted a macro this morning by mistake which I need to restore. I've not shut down the database as I remember something about keeping it open means you can recover deletions? Can't find the original article I saw a few months ago... Any help GREATLY appreciated!... 4 16.06.2006 19:37:02 email / hyperlink field / outlook express taking over Hello I have a form that includes an email address. first of all i would like to avoid having to type "mailto:" in front of the email address, but if i don't, the program tries to open the website. if i have notmynamex@yahoo.com, it goes to the yahoo website, instead of opening an email form. how do i fix that? ok, so i can live with mailto. however, when i click on the email link, outl... 2 16.06.2006 18:29:32 Help text when using Switch board Manager Hi, I am not sure where to ask this question, but I want to do the following: I have created some macros to update tables in a database. I have added these macros to the Swichtboard as a separate switchboard page. Now I want to have a message appear when the user clicks on this shortcut to the macros to verify with the user if she is sure that this is the option she wants, otherwise she c... 3 16.06.2006 13:43:02 Body uitbreiden naar meerdere regels Hoe kan ik mijn body naar meerdere regels uitbreiden? Heb een makro waarin body staat. Al wat daar ingevuld word komt op de pagina van de e-mail. (Sub Mail_workbook_Outlook-->With OutMail-->.Body = "Dit deel uitbreiden naar meerdere zinnen" mvg Bergop ... 3 16.06.2006 13:26:03 Data transfer I want to transfer data filtered by a query from Table 1 to Table 2 and delete it from Table 1 how do I do this using a macro? Thank you for the assistance.... 3 16.06.2006 08:47:01 Exporting tables to Excel I am trying to export an Access table to an excel spreadsheet with the date appended on to the filename i.e. OutputTo excel with today's date on the end of the filename, any ideas how I can do this?... 14 16.06.2006 08:40:55 Macro button to search directory I want a command button within a form that will search a specific directory on my hard drive for a .jpg file. The macro should use the field "Type" from the form and find the .jpg file that has the same name as the current value "Type" Thanks,... 2 16.06.2006 06:55:06 Output To Action - Auto Save I'm using Output To Action to an excel file. The file overwrites the existing excel file each time. I'm using scheduler to launch the macro. unfortunately, I can't seem to get rid of the "Do you want to overwirte the existing file prompt" so the overwrite doesn't complete if the program is unattended. is there anyway to have the output to action auto save without prompting yes or n... 2 16.06.2006 06:47:52 MDE Macro Problem I have a database that I created that contains several macros. The macros work fine on my PC (in both the MDE and MDB versions), but when I go to another PC, the macros will not work. It says there is an unresolved conflict. I am using a shared drive that both myself and my tester have access to (mapped to the same drive). Any ideas on what I'm doing wrong here? ... 2 16.06.2006 06:41:29 Macro on switchboard I have created a macro to print a single page report without viewing the report and placed it on my switchboard. When I click the command button associated with the macro it not only prints my report, it also prints out a picture of my switchboard. Did I not do something right? Thanks so much! Teri.... 4 15.06.2006 20:09:03 Exporting Data Hi, I'm trying to write Sql Server view from 3 tables into a query and then export that data in view to a text file. I want to do the transfer on click of a button. I'm trying to do it through TransferText but It does not recognises the view created in the SQL Server. If any body has any suggestions as to how to Proceed for this kind of Data Export. Thanks in advance for your suggest... 2 15.06.2006 19:58:10 CHECK FIELD FOR PRINTING I have a field on a tbl I update witha update query. I want to check that field, that record, for >= 50.00. If it is, I want to show a form asking if usr wants to print a report (coupon) or not. If yes, I want to subtract 50.00 from the fld and print the rpt, if not, end. I tried using qry and macro but can't get it. (I'm still a newbe) Thanks WWV ... 3 15.06.2006 03:30:36 exporting data to excell I am trying to run a macro to export the results of a query to an excell spreadsheet. I know you can specify the path of the file to output the file to, but can you specify which cell to start in? What I really want to do is have the spreadsheet set up with some formulas and based on the data coming in from access, have it automatically show some totals from this data, is there an easier... 7 14.06.2006 21:11:38 Numeric overflow I have a macro that has multiple update queries. The macro starts with a make table query. When I try to run the macro for the second time with out compacting and repairing it will give me a numeric overflow error message on the make table step of the macro. Any suggestions on how to fix this?... 1 14.06.2006 16:37:01 Run Macro without Prompting user I'm have a macro that clears out a table and then adds new data. My question is how can I make it so that it will do it without prompting the user yes/no to delete the rows or add new rows to the table? ... 6 14.06.2006 12:19:44 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  >>