Threads Replies Last Post 43 Pages: <<  9  10  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  >>   'OutPut To' Excel without prompt to overwrite I have a macro that outputs the results of a query to Excel, however if the file already exists it prompts to overwrite it - Can I get around this? I assumed that if I called the Macro from the Main Switchboard form which is auto opened when entering the db I would'nt have this problem but it makes no difference?... 5 25.03.2006 18:34:12 RunCode I can't set the value of a checkbox to be true. I don't know if what I did is the best or easiest way since I'm not a programmer. I'm trying to learn so I save my macros as modules to see how it's written. If I did anything incorrectly please tell me. I created two macros then did a Save As, Module, and now I have two functions. One is called CheckBoxCSA. It will set the value of ... 8 23.03.2006 18:57:23 (?)Run a macro in chosen date Oi! Excuse me for mine insist: Can I to activate a macro to run automatically in one date previously chosen? Thanks in advance. an... 4 26.03.2006 22:45:20 autorun macro without opening access Is it possible to schedule a macro to automatically run each month without even opening the database?... 2 24.03.2006 22:53:25 CursorControl I am trying set up data validation routines. This specfic one involves deposits and amounts if there is ck number then i want to enforce entering an amount. The macro for this is: '------------------------------------------------------------ ' mcrForceDeposit ' '------------------------------------------------------------ Function mcrForceDeposit() On Error GoTo mcrForceDeposit_Err ... 4 24.03.2006 19:11:51 Sending Mail When using the Macros in Access, I can from send any object via AOL mail. AOL opens and the table or query is attached. Problem is....the Send To box in AOL wont populate with what I input in the To box when preparing my macro. Any ideas? ... 1 24.03.2006 16:42:16 updating the value of control based on a calculated control Firstly, I am fairly new to access so I don't even know if this is possible. I've created a form in order to track my product inventory. One of my controls is InStock another is UnitsOrdered. I've created a calculated control reflecting the current Stock by using: [InStock]-[UnitsOrdered]. I need the InStock field to update in order to equal the CurrentStock once the calculation occurs, Is... 5 24.03.2006 08:37:02 Scheduling macros to run remotely using microsoft task scheduler? from my computer can I schedule a macro to run daily on a remote server?... 4 24.03.2006 00:08:40 Form to Macro Hi, I have a drop down list that on change runs a macro... That macro runs a query to display table data. I want to make a selective display of data depending on that drop down list. --- In Other Words --- I need when I select something from the drop down list ---> I have a result depending on the selection. OR: how to make a query that is waiting for parameter as stored procedu... 2 23.03.2006 19:52:28 TransferText Action-tab delimited file I am trying to export a table into a tab delimited file using the TransferText Action in my macro. Can someone explain what I should be entering in the Specification Name box? And how to specify the output file to be tab delimited? TIA lyric2002... 2 23.03.2006 19:19:31 delete files macro does anyone know the code that could be used to delete all my excel files from desktop. i'd like to use a wildcard like **.xls... 2 23.03.2006 19:13:30 How do I schedule a macro to run every hour in Access Is there any way to schedule a macro to run automatically every hour in access?... 6 23.03.2006 19:11:43 Step through records? Hello All I have a fairly complex A97 mdb, which includes a macro which uses the SendObject command to email a report to an individual. The report is based on a query which takes as a parameter the value of a combobox selected by the user - this is in fact the name of the individual that the report is about. The individual's email address is also picked up from the current form. Is... 16 23.03.2006 09:38:01 update one field based on the value of another Hi. I have 2 fields that I want to be dependent on each other. The first one is a yes/no. the second is a date. So when the user clicks on the checkbox, i want the date to fill in automatically. Can this even be done? I know it can be done on a record change, but I am just not sure Thanks in advance for any help... 4 22.03.2006 18:26:12 macro help does anyone have the code that would delete all excel files that you would have stored on your desktop... 1 22.03.2006 15:09:29 Create a Duplicate Record Hello everyone, I am using Access 2002 and would like to create a macro that will allow me to duplicate a record, but only certain fields in the record. Is there a way to do this, or do I need code or query. Thanks for any help Connie... 2 22.03.2006 02:48:09 Sending Files within Access I want to send an email a file (PDF style) to a list of users selected from a query. Is there a way to do that, either by a macro or with VB code? And if so, how? ... 4 21.03.2006 23:54:44 Copying from previous record to current I am using version 2002. I thought this would be easy but my every attempt results in a halt error with each try. I have a subform that contains about 10 text or memo fields. Each record represents a visit. When I create a new record (visit) in the subform I would like to copy information from the previous record into the current new record. I could just highlight it copy and paste... 2 21.03.2006 22:54:51 TransferSpreadsheet create Parameter? Apology in advance for low skill level here.....new to macro end. Have TransferSpreadsheet macro that imports from Lotus and appends a range of data to an exisiting table. Works fine. However, each week the file name I need to import changes. (Ex: c:\MyDocuments\Sch1 , c:\MyDocuments\Sch2, ....) The macro is launched on the opening of particular report. Rather than, each week, rev... 3 21.03.2006 22:40:21 TransferSpreadsheet causes data loss in Excel I have a macro in Access that transfers 5 spreadsheets to a specific spreadsheet Excel. I then go into Excel where there are a series of macros to trnsfer this data and format it. I works fine the first time but then I go back and use Link Database in Access to bring in similar data from another database. When I run the macro the first query run and then I receive an error message tha... 1 21.03.2006 19:40:31 ¤ China ZhongZhan Aids Mei Mei Killer! http://onfinite.com/libraries/175399/440.jpg elmar@digi-art.de ... 1 21.03.2006 12:48:25 ¤ China ZhongZhan Aids Mei Mei Killer! http://onfinite.com/libraries/175399/440.jpg elmar@digi-art.de ... 1 21.03.2006 12:48:19 Can output file name from access query-create table include date . I am querying sales figures by territory and generating unique reports. A series of macros are executed to run each query and develop an output table (could be a report also). The output table is specified by name and path so I can keep each territory report seperate. I currently have to manually modify the output file name specified in the query parameters to include a date so I can... 2 20.03.2006 23:42:00 Help exporting to Excel Greetings, thank you all for looking. Here is the situation...I have a database that works with transactions. Each transaction is assigned a group and a catagory and is contained in a single table. There are 9 groups and 10 catagories. What I need to do is export the transactions to Excel based upon the group and catagory. Each Group needs to be a Workbook, each catagory needs to ... 2 20.03.2006 18:19:03 Ink Sorry guys. The spam stuff was not my intent. I do oppoligies and won't happen again. I have never been on newsgroups before and not sure how to work them. I hope you guys can forgive a bad choice. Murphey... 1 20.03.2006 12:07:30 43 Pages: <<  9  10  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  >>