Threads Replies Last Post 43 Pages: <<  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  41  42  43   Cannot Update. Database or object is read-only. Hi There, When I try and run a macro to export a query, it comes back with the following error message: "Cannot Update. Database or object is read-only." I have created macros to run some other queries and they work fine. There is nothing too different about the query that I am getting the error message with, except that it does a record count of the output of some other related queries.... 1 31.01.2006 18:18:28 How do I get a button to run a powerpoint presentation? Hi, I am trying to get a button in access to open a powerpoint presentation, I see I can open a word doc and excel file easily, however the only way I can see to open a powerpoint presentation is to navigate to powerpoint.exe and get that to launch, then once in there get the macro to open the correct file. This will not work on our system as the local drive (where powerpoint is inst... 2 31.01.2006 18:18:12 How do I set up a shortcut key to take me to the next # in a doc? I want to set up some letter, faxes etc templates. I want to set up a shortcut key that will take me to the next # symbol in the document. I was thinking like control + #.... 2 31.01.2006 18:05:39 Repair & Restart when Docmd.Quit I have many db and converted these over to Access2003. On of my db a huge one (0.5 / 1.5 GB) is causing some troubles. Each time when it's finished with the macro it goes into error when I want to quit it. At the moment the "Repair & Restart" panel is shown. You know the one in which you can send the bug-report to Microsoft. Does someone know why this happening and how I can prevent th... 2 31.01.2006 17:42:43 Can I Send a Fax from a Macro inAccess? I need to create a Macro in Access to send different Reports/Tables to different fax numbers. e.g. 1 report to 1 location - Is there any way / easy way to do this? Thanks!... 3 31.01.2006 11:27:27 how to link to a a file which ll be generated in future ... 1 31.01.2006 10:40:27 pasted value won't stay Used a macro to query a table and copy the result into a field on a form. It functions perfectly, until the field loses focus. Any ideas on how to make the paste stay/new value for the field?... 1 30.01.2006 20:39:26 Output to Excel application I am learning how to output a report to a file in Excel format. Is there a way to output a report to the application (Excel)? i.e. open Excel and the output would be the rows and columns of the opened workbook. Any help would be appreciated. -- Dale... 3 29.01.2006 14:50:26 macro sous excel J'ai écrit une macro sous excel pour ouvrir plusieurs fichiers simultanément (fichiers tous placés dans un même répertoire). ChDir "c:\Répertoire\Sous_répertoire" Workbooks.Open "Fichier1.xls" Workbooks.Open "Fichier2.xls" L'instruction ChDir détermine bien le chemin pour ouvrir les fichiers sans avoir besoin d'utiliser l'instruction "Workbooks.Open Filename:="C:\Répertoire\Sous_réperto... 1 29.01.2006 08:58:37 Help with Macro to Compact Database Hope someone can help. I am looking to create a macro that will run when a command button is pressed that will compact and repair the current database. Thanks in advance for any help. ... 1 28.01.2006 19:16:04 Function not understood I am trying to amend a macro in an invoicing database written by someone else. The macro marks an invoice as paid. Following through the code I come to Function InvoicePriceIncVAT(INum As Long) As Currency InvoicePriceIncVAT = InvoiceTotal("Price inc VAT", INum) End Function InvoiceTotal is another function, and "Price inc VAT" is a field in the current table, but I cannot find wha... 4 28.01.2006 05:23:29 Stopping a macro (for others other than Primary users) I have an update macro running on the Startup Form. I need to have others use the DB but they have no access to certain files that are imported with the Macro. Does anyone know if the Conditions will help? or is there any other way. I Have a Batch File that Does a FTP extract of Files from my MainFrame. I import the File and Have it update our tables. Any help is always appreciat... 4 27.01.2006 21:07:44 How can I automate an object in Access 2003 I am trying to create a find button through Access 2003 and I have created a macro which opens a form, then goes to the control, then I use the findRecord action and I list the criteria within the arguement and I continue to get a message of "the object is not automated" Ive used this same macro with another setup and it work fine, I continue to have problems when I try to add another.... 1 27.01.2006 17:18:03 How can I automate an object in Access 2003 I am trying to create a find button through Access 2003 and I have created a macro which opens a form, then goes to the control, then I use the findRecord action and I list the criteria within the arguement and I continue to get a message of "the object is not automated" Ive used this same macro with another setup and it work fine, I continue to have problems when I try to add another.... 1 27.01.2006 17:17:03 how do you mass email I'm working on a database, I'm storing emails and doing queries based on other information, I need to know how to email everyone that is in that it lists in the query. I have forms made that I can add a control button, but I don't know how to program that button and there aren't any options for email all in query in the macros either, does anyone have any suggestions, or know of another ... 1 27.01.2006 04:23:02 building a web site I just got back working on my website. Its taken a long time to finish but I am getting there. I got great web hosting at http://www.domainnamefree.net where I got a free .com name and a good site builder. Im going to keep working on it ill let you all know how im doing. Paul ... 1 27.01.2006 01:23:37 Looping through Parameter Query I currently have a parameter query that runs from an unbound form where I can select from 95 different criteria and then run the query. This is great, but I would really like to be able to loop through the 95 criteria without having to select each one individually. Is this possible?... 4 26.01.2006 22:07:41 Multi Multi Select List boxes Help or ideas needed please.... I have a multi select listbox where the user selects different catalogue types and they click a command button which send the subscribers details to labels which they then print off. This all works great BUT now they want to be able to continue selecting the individual catalogue type but also print them by catcost i.e. paid, trail or comp. Here is the ... 11 26.01.2006 17:19:08 Sending a subform with sendobject Is there any way to include data from a subform on a email message as body text? i know i can create a attachment and send the subform data that way , or can i create a report first then send the data only from that report as the body text? Any help would be great -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-macros/200601/1... 2 26.01.2006 15:45:34 Create a Macro to Open another Database Can I create a macro in one database that would open a second database (with it's own switchboard menu)? I want to have a button on a menu that would run the macro. I can't figure out where to start. Help! Thanks... 2 25.01.2006 18:26:56 Run Excel Macro from Access Is it possible to run an excel macro that i have already created in an access? I was thinking of running this excel macro in an Access Macro. Is there a function such as "TransferSpreadsheet" or the like that would run this Excel Macro? The macro that I have created in Excel essentially opens spreadsheet "A", formats data in spreadsheet "A", then saves as spreadsheet "B". Ryan... 2 25.01.2006 10:02:45 replacing values based upon a different field having a word within a description I need to find all records in the database and then make a change in a different field of that record based on whether the text exists in the field. I have a pricing database where I have a discounting scheme that I apply. I take the list price, apply a discount, and then determine if the price is a minimum percentage above my cost. If the discount makes the price less than the minimu... 3 24.01.2006 22:59:18 Running VBA code within a Macro I have a macro that is supposed to run VBA code that contains a function. This function contains code that decides which of 2 queries to run depending on if a check box is checked or not. In my macro i have the "RunCode" option selected and "chkMisc()" selected as the Function name. I get an error when I click my update button that says "The expression you entered has a function name that ... 7 24.01.2006 22:53:03 How to send an automated email to email addrs in my Access db? I have a small home-based business and maintain my customer mailing list in an Access database. Most of my customers have email addresses so I would like to send out my twic a year mailing via email using some kind of automated means. My ISP doesn't allow me to send to everyone at once so it takes me forever to cut and paste individual email addresses into Microsoft Outlook and do this... 3 24.01.2006 22:44:36 Use macro to open form from lookup field Hi, Here is my question. I hope someone can help! I am trying to create a macro that will open a form based on the value a user selects in a lookup field in another form. Specifically: Form1 has a lookup field based on its' underlying table. It has 4 values in it. If a user clicks on the drop-down box and selects Value3, I want it to run a macro that will open Form2. Right now th... 2 24.01.2006 18:45:50 43 Pages: <<  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  41  42  43