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  >>   Cannot send my Report via MicroSoft Outlook Hi guy's, I am having a bit of a problem with one of my Reports being sent out using Outlook. The key here is "one" of my Reports. All the others work just fine but the one I'm working on now gives me an Error, "Unknown message recipient(s); the message was not sent." I have exhaused everything I can think of but can't figure it out. If I leave the "To" blank in the SendObject part of th... 5 10.07.2006 19:36:26 SendKey problems with macro after converting to 2003 I have several macros that were created in Access 97 that use SendKey steps to copy and past data from one form to another form (the first macro also closes the first form, and the second form is opened by use of a command button triggering another macro). In Access 97, everything works fine. In the converted (Access 2003) version, they do not work. With some sleuthing and testing, I ... 4 10.07.2006 16:31:02 Autofill fields based on other fields' responses In a table, is it possible for one field to auto-fill itself based on the previous field's entry? For example, I have two look-up fields, and both are filled with data. I would like to have the second field choose the entry that would be linked with the first field automatically, based on the selection I make in the first field. So for example, the data is linked like: Field one: Cookie... 4 10.07.2006 09:28:32 opening a report - I previously posted a question regarding openreports() . I guess there is no openreports() function in Access , unless it is created as a macro( right?). Anyway, I am still working on this problem. In the on-click event to send a report to email, there is this : =OpenForms("logentry"). Ok. It works, even though logentry is not a form, but a report. But, it sends out an error mess... 6 10.07.2006 07:50:34 runapp Missing In the beta versionof ACCESS (12.0.4017.1003) i cannot find the RunApp function for building a macro... Has this been replaced with a new function or just missing in the beta... FYI... I ported over a few macros from ACCESS 2003 and the system runs them fine, but if you look at the macro to edit it, the RunApp shows an error. Click on the function and the system brings up a window that ... 1 08.07.2006 02:53:01 Automatic queries to Email I need to run queries on a daily basic in order to get measurement for KPI (key performance indictaor). This type of information is needed as a measurment tool for quality insurance. As all queries are based on Access I will appreciate if I can setup a script in order run automatically the queries and receive and Email highlighting the results. Thank you in adance for your dedicated help... 2 07.07.2006 21:22:30 Newly created Access mdb files contain Macros, how do I stop it? I create a new Access DB using the blank template I create a new table in design view with one column and 2 rows I save the database I try to re-open it and get the following error message: Security Warning Opening "D:\....\test.mdb" This file may not be safe if it contains code that was intended to harm your computer. Do you want to open this file or cancel the operation. etc.. ... 3 07.07.2006 19:29:10 Macro security Hi, I’ve upgraded MS Access from 2002 to 2003. Now when I open a database I get a macro security warning. When I go then to Tools/Macro in order to decrease security level, I do not see the Security option. Any idea? Thanks. ... 3 07.07.2006 17:52:02 action on a button to create a new record One of the fields in one of my tables is not on the form (due to reasons of sensitivity). If I use a "duplicate record" button it adds new data for what is in the form but the field that is not on the form reverts back to zero. How can I create a macro action on a button to replicate the unseen field?... 11 07.07.2006 10:10:02 Combo Box that retirieve queries or reports Hello, Could someone tell me how I can list the queries of an access database in a combo box in my access form?... 2 07.07.2006 08:02:59 Using a macro to change Field Properties How do I change Field Properties using a macro? My macro imports a comma delimited text file using an Import Spec, and the fields are a mix of Date/Time, Text and Number in my new table. All the text fields are automatically set to 255 characters when I import the file. I want to change some of these to 1, 2 and 3 characters automatically as a step in my macro. Can I do this? I don'... 6 07.07.2006 01:50:57 =openreports("name of report") i need urgent help please hi, When a user clicks on a button for a report , there is a macro that is there - it worked before, not it no longer works. Im totally stuck. it says on the on-click event for this button: =openreports('logentry") where "logentry" is a valid name of a report. But, when everyone clicks on it, I get this obtuse message telling me that something is wrong,the expression has a function na... 4 06.07.2006 19:17:02 Get and manipulate data from cells I am importing information into Excel from another program in the form of two columns, one with strings and one with numbers. Basically I want to read the contents of each cell in the column with strings, assign the first character of the string to a variable, and test this variable against the letter "A". If the it doesn't start with A I want to delete the row. Here is a summary: For L... 2 06.07.2006 17:46:53 GoToControl troubles I’m using a macro with several GoToControl steps: GoToControl sbfDataEntry GoToControl sbfGrade This works just fine. Then I try to add a third step, GoToControl Score (where Score is a field name on the sbfGrade subform). Then the macro craps out with “There is no field named ‘Score’ in the current record." Any ideas on why this is happening? I checked the field name about... 3 06.07.2006 16:45:02 Running Macros I have the following Macro (which I need to run on approximately 200 different workbooks) -- what is the BEST way to achieve this? Should I use a Function (and if so, what would it look like)? NOTE: I'm assuming that this Macro should reside in a Module -- but, should this be run outside of EXCEL (say, from a Form in ACCESS)? Here's my code: Does anyone see anything that I may be... 1 06.07.2006 14:43:46 Help please ! I am creating a user friendly form, 1 pager, that track everything I need. I want to be able to select a name from a dropdown menu, which then paste the selected record (All fields from the query selected) to my main table (& Form). I want to select someone record from a list and link this individual and his informations to the main table; maybe with a command button only visible whe... 1 05.07.2006 16:37:02 Object not found error using transfertospreadsheet I have an Access 2003 adp based on sql server 2000. I have menu button which is supposed to populate an excel file with data from a view I created. When I use transfertospreadsheet, it keeps failing with object not found error. It works when I use a table name. All my named queries failed while all my tables worked. ... 1 05.07.2006 16:04:54 Save as I have an Access 2000 database with macros, tables, queries and reports. I would like to write a macro that would make a copy of the entire database and save the copy in a location specified by the user. I have no idea of how to accomplish this. Any help is appreciated! Thanks! ... 1 05.07.2006 13:38:01 going to last record in subform I have created a macro so that when I open the form, the control goes to a field in the subform, sorts the info according to date and then goes to the last record. How can I make the control go to the last record in the subform when I go to the next record in the main form.... 2 04.07.2006 13:10:02 Create a macro to go to a field within a subform How do I do this?... 5 04.07.2006 12:34:02 query parameter value Hello again, On my form I want to make a button with assigned to it macro which will run append-query. The query contains a parameter which value I want to be taken from one of fields on the form (let's say called DateX). Can anybody help me with it? I know it's simple, just can't find suit. command in help file. ?????? = Me.DateX DoCmd.OpenQuery "qryDLRnew"... 2 03.07.2006 15:58:43 Make-Table query and macro Using Access95, I have a make-table query whose SQL reads: "Select distinct zid.crc into [Zid Distinct CRC] from Zid;" Two questions: 1) I think it would be better if the field in the created table were indexed for faster lookup. This code does not produce an indexed field. How can I get this to happen? 2) I would also like a macro (or VBA) which would check the times that both tabl... 4 03.07.2006 09:29:01 Transferspreadsheet w/multiple worksheets I have an Excel spreadsheet that varies each day as to whether it has 1 worksheet, 2 or even 3. How would I code the macro action "TransferSpreadsheet" range to allow for these variations? Thank you in advance! JCarter Still Learning... 3 01.07.2006 12:28:01 Help Plss.. Dear All, I have another doubt in Access. Can you help in that also. I have explained it below. There are 3 tables 1. Account - (Fields - Account name, Accountid, Address, etc) 2. Account Misc - (Fields - Accountid, cpnum, Cluster, etc..) 3. CC - (contains only Account name field) Both the tables have one same field Accountid. Joined 2 tables usig that Accountid field. to retrive ... 1 01.07.2006 08:47:02 Key a field in a macro - Change Field Properties in a Macro Is it at all possible to key a field in a macro? Specifically, I want to key the first three fields a table as a step in my macro. Also, is it possible to change the "Field Size" of a text field using a macro? Thanks.... 4 30.06.2006 23:50:17 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  >>