Threads Replies Last Post 13 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13   Workaround to SendObject in Access 2000 This is my second posting on this, but I'm hitting my head against the wall so I'm hoping someone can help. Thanks in advance - I have code that sends a Lotus Notes email from a button on an Access form (which I'm using because SendObject in Access 2000 has a bug). Everything works fine in the code except I need to send a screen shot of the form that the button resides in, much like ... 2 18.11.2005 22:47:32 Open pulisher from Access Hi I am aware that you can open excel and word from access and reference documents to be printed. Does the same function exist for Publisher and if so how do i go about opening it and print a document and then closing it again. I am using Access 2000 on windows 2000 if that's of any relevance. Thanks in advance for any help Gillian... 10 18.11.2005 19:20:56 DAO reference problems Hi I have copied a database we designed for one of clients to be re-used again. For some reason the module has lost the reference to DAO 3.6 and every time i try to reselect this reference i get a fatal msaccess.exe error and it boots me out. I can't really post my code as there is pages and pages of it. Does this problem sound familiar to anyone? Any help would be greatly appre... 3 18.11.2005 16:35:47 SQL string hangs when executing When the first string runs, it takes 45 seconds to execute. When I run the second string, it runs immediately. Any idea why?????? SELECT * FROM qryDonationSearchOutput WHERE (donationID IN (SELECT dtDesignation_FdonationID FROM tblDTDesignation WHERE dtDesignation_FdesignationTypeID = 2) AND ((parentName LIKE '*candace*'))) OR (donationID = 970) ORDER BY donationID DESC SELECT * FRO... 5 17.11.2005 17:17:56 The specified module could not be found When I astart the Access 2000 application, I recives the error message "The specified module could not be found". If I click the debug button the VBA code points to rst.Open strSQL CurrentProject.Connection, adOpenForwardOnly, adLockReadOnly In reference I select "Microsoft AvtiveX DataObject 2.1 Library". Can any one please help. ... 6 11.11.2005 07:55:45 Button not working I am at wits end. I deploy my application by giving the end users the latest Front End as an MDE. This has worked for many years. Last week, I did a new installation and this time some of the buttons will not work at this particular site. The OS (XP or 2000) and Office (2002 or 2003) are the same. I have installed at other sites since, and they all work, bar that one. Has anyon... 4 07.11.2005 20:51:03 multiple "INSERT INTO" queries Hopefully all of you can once again help me with a problem I am having running multiple INSERT queries in my VBA code. My code looks something like this: ' Form condition 1 If condition1 = True Then CurrentDb.Execute "INSERT INTO tblTable " & _ "(Field_1, Field_2, Field_3)" & _ "VALUES (Val_1, Val_2, Val_3)" End If ' Form condition 2 If condition2 = True Then ... 3 05.11.2005 20:00:38 Recordsetclone problem Hi , My need in the form I'm talking about is very simple. I say this because I've seen posts that say recordset clone can be used in a snap to find a record. I have not used access before. The little db work I did used oracle 8i or sql server. So the "user friendliness" of Access just doesnt work for me. Scenario: I have a form with 6 fields. These are 6 fields that are bound to e... 6 01.11.2005 17:32:56 Index, appendix, the whole world.... ISSUE 1: I have two tables with a one-many relationship. I have designed a report with a group header for the one side and the many side spanning to each detail section. something like: p.1 category header: food --------------------- roast beef chicken salad category header: drinks -------------------------- lemonade beer page break (using keep together: whole group) p.2 ... 4 01.11.2005 15:11:34 Add Tables to the realtionship Window with VBA Hello world (;>)... I am searching for a code fragment to add Tables to the relationship Windows with the help of VBA. I know how to add realations with VBA, I know the way to show them in the relationship windows. But: The user has to add the tables manually to the window to show the releations. Is there a resolution to do this with VBA ?? Many thanks and greetings from ... 1 30.10.2005 17:42:26 encryption FE and BE I have an application split into Front End and Back End, running for the last 3 years. It works well. I have both the FE and BE encrypted. Also both the FE and BE are passworded. One drawback is that the encrypted files cannot be compressed with ZIP and now I am thinking that the FE files need not be encrypted (leaving the BE to be encrypted). Since I only keep temp files in t... 1 30.10.2005 00:53:02 Linking to a dbase Hi, I am wanting to use access to develop a number of reports with the data source being IBM DB2. I am wondering if someone can tell me what is involved in creating a link from access to the source. Note: I know nothing at all about DB2. Any advice greatly appreciated. In real dummy language even better. -- Thanks... 1 29.10.2005 05:41:01 13 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13