Threads Replies Last Post 43 Pages: <<  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  41  >>   automate from access sending an excel workbook via email I have a code that opens an exel workbook from an access form command button where the user may enter data. After my user enters the data, I would like to program from Access a way to send the Excel workbook via email to a defined group? (I understand that a macro can be created that sends an "Access" object - not an Excel object.) Thanks.... 3 07.03.2006 18:47:27 Send a email with attachment Hi All, How can I use "SendObject" to send email with attachment? Thank You Very Much!~ Hung ... 3 08.03.2006 02:50:04 Comparing tables for changed records I receive a nightly extract from a database of employee records. I'd like to be able to compare 2 successive extracts and produce a list of changed records (either new or tweaked). This list of "deltas" will be used to update a system hosted at a service provider. It would be nice to automate this comparison and generation of the delta file. I know this must be pretty easy, but could u... 3 08.03.2006 01:59:38 calling module function from macro How do you call a function from a module (class module - module shown in the database module list) using the runcode command in a macro.... 4 08.03.2006 00:17:39 ASP.NET 2.0 Webservice cannot be consumed... Hello, an ASP.NET 2.0 webservice cannot be consumed by Access/Excel 2003, if the webservice uses the new nullable datatypes. Is there an update for the Office 2003 Webservice Toolkit 2.01 available, which deals with that types correctly? Regards ... 3 07.03.2006 15:14:44 Thousand of records become millions- literally! I have a series of macros that check for duplicates, delete duplicates, and append records to a linked table in another database. I've tested the macros on recordsets of 7,000 records and everything works fine. However, once we started handling larger datasets (eg. 38,000 records) we began getting problems. In the final append to the linked database the database thinks we are appending 7... 1 06.03.2006 21:38:27 Setvalue Macro to a Subform I don't usually have problems with simple setvalue maccros but this one confuses me. I am using Access 2002 and bring information from a simple open form and trying to populate a subform on another open form. The information is being transferred but it only appears after I change the record and return to prior record that was open on the setvalue macro For example : Forms![FormMain]!S... 3 06.03.2006 14:31:18 where is runtime files on Access 2003 cd? i was told before purchsing access 2003 upgraqde that the CD contained what I needed to make a runtime version of my software. I cannot locate anything like that on the cd. Help!!... 2 05.03.2006 22:05:18 condition macro - displaying the fieldname(s) from a query in MSGb Hi, I have a problem where i am using a condional macro where it will display a message box alerting the user that there are 5 unpaid bookings. Using: DCount("[Student ID]","QRY Students that have not paid")>=5 which i think works. But what isnt working is the message iin the message box where i am trying to say "Title Forename Surname has 5 or more unpaid lessons" I have tried to ... 3 05.03.2006 21:48:29 reading in the system info Hi Is there any way of reading in the system info from windows hardware device manger i what to find out the flowing Make and type of graphics card Make and type of network card Make and type of sound card Make and type of processor And how much memory the computer has Matt... 3 04.03.2006 17:16:27 access macros I'm pretty good at this access stuff but a simple Macro has me stumped: I have a number of append queries to run. They append to the same table. I want to run these queries. (I cant get these to run) Any where from one to three screens come up requesting yes or no answers. I want to answer Yes to these screens to finish each append.... 2 04.03.2006 02:10:19 What is wrong with this? [Nome] Like "*[Forms]![Form1]![box1]*" I have used this sintax in Access 97 but it is just not working on 2003. Although these variants would work: [Nome] Like [Forms]![Form1]![box1] [Nome] Like "*mar*" ... 3 03.03.2006 19:07:30 How to run Form_Current() from macro? or module? I have the following function in a module named Module1 Public Function CheckCommandLine() Dim strRecNo As String Dim intRecNo As Integer strRecNo = Command MsgBox ("You typed " & strRecNo) intRecNo = Val(strRecNo) 'Couldn't get this to work 'DoCmd.OpenForm "PRRequisition", acNormal, , "PRREQNo = '50000'" 'The Following Works but I need it to run Form_current ... 1 03.03.2006 19:03:28 Command no longer executes We have an inherited macro we have run for years, using Access 2000 and 2002. We just upgraded to 2003 and now the macro won't run. It stops on a line with the command "Mid$([Customer/Acct],14,9)". Any idea if this command no longer works or works differently than in prior versions?... 2 03.03.2006 16:58:53 Cannot find SelfCert.exe I need to sign my macros; the warnings are driving me nuts. The help file tells me to instal the "Digital Signature for VBA projects" from my installation CD. But it's not on my CD! I bought Access 2003, not the full version of Office. So if it's not on my CD, how can I digitally sign my macros? Is there a download somewhere? Surely I'm not the first person to encounter this...?... 3 03.03.2006 16:07:27 message box if a condition is true or false I am rather new to access and I would like to have a message box appear if a condition is either true or false. I have a yes/no checkbox that I would like to have a message box appear for if the box is unchecked. I am not sure where to begin with this at all and I would also like to use this across many tables if possible. If I can figure out how do do it for one I think I can get the re... 7 03.03.2006 16:07:26 Update word document with one record from Access vba I want to update an existing word document with data from the fields in the current form. I have found a lot of info about how to do this from VBA in Word, but not from vba in Access. I have a standard letter with date, Name, Address, Title and Contact person fields which I want to replace with the data I have on my Access form by just pushing the button. I also want to create more pag... 2 03.03.2006 07:29:05 Transferspreadsheet From an Access Macro how do I transfer a specific worksheet into an access table? Bill ... 3 03.03.2006 07:09:27 Stop macro by the number of cycled records less one The RUNMACRO number of repeats is always a number and can never be a function. I have found a way to repeat the related MACRO by the cycled number of filtered records, but once it reaches the final record I always have an error and a halt macro question. Is there any way to repeat a macro by the number of records being cycled less one?... 10 02.03.2006 18:31:04 Imported XLS requires PrimaryKey in visual basic macro Hi:- I am having a small problem assigning a primary key to a imported XLS file which has no key. The import was done via tranferspreadsheet in visual basic . Does anybody have an example of a VB macro that takes a imported file and adds the primary key to a current named column or adds a new column /index containing a primary key. The microsoft example using ADOX is over complicat... 3 02.03.2006 16:28:20 Macro works when open, but when double clicked closes database?! I have a macro that runs a series of queries that build off of one another, closing each step of queries along the way, and leaves the final query results open for viewing when completed. It works fine when I run it from the design mode, but when I double-click and run it from the macro window it runs through the steps and then after the last query is run, it closes the entire database?... 4 02.03.2006 15:28:08 Running batch file Hi there, have a batch file I have created that when I open through Windows Explorer, it will launch a programme and write the export files. How can I get this batch file to run as part of a macro to automate the batch process, have tried loads of ways, but no joy. Thanks... 3 02.03.2006 02:41:33 Make query macro with automatic YES I have a macro that runs a Make table query once a button is pushed. When the macro runs the Make table query it prompts the user to be sure if they would like to overwrite the original table. Is it possible for me to make the macro so that it will answer yes for the user and they never see the prompt? I've tried adjusting the options under the tools menu for prompting table changes but that didn... 3 02.03.2006 02:37:46 Macro Append Table Query I have Macro that appends a Table several times and each Time it does this I get a warning that I have to hit enter to get past. How do I get around this, also the beeping is an irratant.... 2 01.03.2006 20:01:08 how do i export from access to user's temp drive? I have created a module to do the following: DoCmd.SetWarnings False DoCmd.OpenQuery "Look-Up by Name", acViewNormal, acEdit DoCmd.Close acQuery, "Look-Up by Name" DoCmd.OutputTo acQuery, "Look-Up by Name", "MicrosoftExcelBiff8(*.xls)", c:/Look-Up", True, "", 0 But i want to change the Output to the user's temp drive. how do i do this?... 1 01.03.2006 16:51:34 43 Pages: <<  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  41  >>