Threads Replies Last Post 17 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17   Sending Email in MS Access I would like to send an email from MS Access - but instead of sending it directly, I would like to store the email in the "DRAFT" folder, so the automated email can be reviewed and or edited first, and so it can handle bulk saving (20-50 emails) before the user is prompted. Is this doable ? If so, can you tell me how this can be achieved ? Many thanks, John... 5 08.02.2006 09:47:59 what's happened to MSDN? Did something happen to MSDN? I went there, and there's no content, just the table of contents, a hyperlink that doesn't go anywhere, and a request to rate the page, but no content. Is this material not available to the general public any more? ... 2 07.02.2006 22:44:38 Importing data from a Legacy Database Hi There, I'm trying to import data from a legacy database in to the database of the new application that I am creating. I want to accomplish this by building a INTO query and will apply the query to convert the data over at launch time, ensuring that the new database is converted using the most current data. The new database uses a couple of different types to store data. Also, th... 2 07.02.2006 03:25:30 I need help every time I send and receive this error message comes up. It says incorrect password or account nameCheck the username/password or security settings. And it doesn't let me get my mail. can somebody help? my address is eli.barr@providenceday.org ... 1 07.02.2006 02:06:14 Can't find dll entry point Hi all, I'm new to API calls and have used some code I got on a training course, which is giving me an error message. I haven't got a clue what the problem is (have searched google but to no avail). Can anyone help me please? The code is: Public strUserName As String 'API Declaration - uses WNGetUser as alias Private Declare Function WNGetUser Lib "mpr.dll" _ Alias "WNetGetUser" (... 3 06.02.2006 16:49:22 Using Clipboard in VBA Office 2002 I am trying to use the clipboard from code in Office 2002. In earlier versions Microsoft Forms 2.0 had a DataObject object that allowed this but Office 2002/2003 does not seem to have loaded such a reference. How can I do this in Office 2002? Maurice ... 2 05.02.2006 04:33:06 Not Responding - Access hangs Hi, My application hangs in the below code, I am getting data from a recordeset and the displaying the data in a PowerPoint that is generated from the application... Dim pptApp As PowerPoint.Application Dim pptPres As PowerPoint.Presentation Dim pptSld As PowerPoint.Slide Set pptApp = New PowerPoint.Application Set pptPres = pptApp.Presentations.Add Set pptSld = pptPres.Slides.A... 2 04.02.2006 04:40:04 Control Anchors and resizing I have an app that runs mainly from a single form with loads of controls. I want to be able to resize the main window but whereas with VB and Delphi there are properties to link controls and to manage resizing there is nothing in Access that does the same thing. Is it possible to have components resize on a form or should I just give up and use VB .... I would appreciate any thought... 10 03.02.2006 21:49:47 How to open the browser from an Access form? I want the end of my command-button processing to open an external webpage for the user. I seem to recall a browser object. Any pointers, documentation, etc. would be greatly appreciated. ... 5 03.02.2006 20:05:24 EOF or BOF Error message help Hi, I am getting the following error messages from the code below.... Dim rstAccomp As ADODB.Recordset Set rstAccomp = New ADODB.Recordset Dim strSQL As String Dim StartDate As Date Dim EndDate As Date strSQL ="SELECT DISTINCT Accomplishment, DDate FROM tblAccomplishment WHERE ProgramIpt = '" & SelectedIpt & "' AND DDate > " & Format(StartDate, "\#mm\/dd\/yyyy\#") & " AND DDa... 2 02.02.2006 07:10:14 Detect CD drive? Hi, Anyone know if it's possible to detect if a drive letter is a CD or DVD? I'd love to be able to do that! Thanks -- Remove numeral in e-mail address to send e-mails. www.marshallarts.com.au ... 4 01.02.2006 23:12:11 Looping through controls in Tab Order After searching a through the newsgroup and not finding anything that did exactly what I want, I've created the following functions to return a collection of controls in tab order. As I'm fairly new to Access VBA, are there any gotcha's here that I might be missing? If not, then hopefully others will find this code helpful. -----------------------------------------------------------------... 1 31.01.2006 21:56:14 Transaction Boundaries... Hi; In a module, I'm updating two Dao RecordSets. So I issue a "StartTrans" at the beginning, then open the RecordSets, make the necessary changes to the the RecordSets, close the RecordSets, and finally issue a "CommitTrans". The records get updated properly. Question: Does it make a difference where I **close** the RecordSets? Am I defeating the purpose of the Transaction if I close... 4 31.01.2006 14:43:14 How to reliably hide menu bar Hi all, I want to have my application appear with no menu bar at all. I found some code somewhere that looks like this: DoCmd.ShowToolbar "Menu Bar", acToolbarNo I have put this in some code which is run from the Autoexec macro. The problem is, sometimes it works and sometimes it doesn't. If I start Access and load my app with the Shift key held down, then manually run Auto... 2 31.01.2006 01:11:37 Data changes not refreshing immediately I have a multi-user application with front-end / back-end (database on a server). I need to set the value of a field in a control table in the database. The control table is "OpenBatchOwner Table". The field is "OpenBatchOwner". There is only one record in the table, and there is only one field in the record. This is a "control record" that coordinates a certain function within the appl... 5 30.01.2006 16:45:13 Type Mismatch help Hi, I am getting and MS Access Error on the below query... "SELECT DISTINCT Accomplishment FROM tblAccomplishment WHERE ProgramIpt = '" & SelectedIpt & "'" & " AND DDate > " & Format(StartDate, "\#mm\/dd\/yyyy\#") AND DDate < Format(EndDate, "\#mm\/dd\/yyyy\#")" Thanks ... 2 28.01.2006 05:23:59 Disabling Restore Window button I've succesfully used http://support.microsoft.com/?id=245746 to selectively disable / enable the "X" (Close Window) button. I tried to use this as a model for a similar capability to selectively disable / enable the Restore Window button (the two little boxes) with no success. While I get no error returned, the code produces no visible result. For the button's constant, I used &HF120& ... 1 26.01.2006 03:14:34 Syntax Error from Insert Into Hi, I get a syntax error (missing operator) in query expression.... When I try to insert into table any statement that contain a "" or '' in it like O'Hare. I have a textbox that contain what I want to insert like O'Hare in the field but if the content contain a "" or '', I get a syntax error (missing operator) in query expression.... below is the query "INSERT INTO tblAccompli... 3 25.01.2006 12:11:08 Problem programmatically creating and linking table Hi all, I am writing some code which creates a table in a linked "data" database, then attempts to create the link in the application database. It is creating the table fine, but when I get to the bit that tries to create the linked table in the application database (which is where this code is running), it stops with an "Invalid parameter" error on the line indicated below. Dim ... 9 25.01.2006 05:10:50 Hidden Form showing on taskbar after startup properties changed I'm cross posting this message because I'm not sure where it best fits. I have an application developed in Access 2003 which I'm getting ready to distribute. In that application, I have a form which is opened when my switchboard opens but is kept hidden. I created an icon for my application and went into the startup properties to set the icon property for the application. Under the tex... 3 24.01.2006 22:34:46 Forcing the CAPSLOCK to be ON starting Access or Form Dearest, starting Access , or at the opening of a FORM I would like to have the CAPSLOCK always ON, have tried this with SENDKEYS "{CAPSLOCK}" but this doesn't do anything. Can anyone help ? Phil -- http://users.skynet.be/101airborne Official Site of the 463rd PFA ... 7 23.01.2006 17:53:55 Need clearer definition of "Transaction" boundaries I tried using "transaction" processing for the first time, but I'm unsure of what I'm getting. I'm not using DAO, simply making field changes with bound controls on a bound form. At a certain point, I start the transaction in workspace[0]. Depending on what the user does (buttons, etc.) I later issue a CommitTrans. Eventually, I'll add a button to do a rollback. I see how all that w... 5 23.01.2006 13:18:22 Syntax Error Help Hi, I get a syntax error (missing operator) in query expression.... When I try to insert into table any statement that contain a "" or '' in it like O'hare. I have a textbox that contain what I want to insert like O'hare in the field but if the content contain a "" or '', I get a syntax error (missing operator) in query expression.... Someone (-- Wayne Morgan,MS Access MVP) sugges... 2 22.01.2006 12:15:54 Syntax Error Hi, I get a syntax error (missing operator) in query expression.... When I try to insert into table any statement that contain a "" or '' in it. I have a textbox that contain what I want to insert in the table but if the content contain a "" or '', I get a syntax error (missing operator) in query expression.... Any Help will be appreciated. Thanks Tiger ... 3 22.01.2006 06:09:38 Table definition lookups I have two fields on a table, supplier and branch. I want to set the lookup of the first field to scan my supplier file, thats the simple part. On the second field I want the lookup to be the suppliers branches. The SQL for the lookup of the first field is : "SUPPLIER" The SQL for the second lookup field I would expect to be : "select branch from branches where supplier code = ... 3 19.01.2006 21:47:29 17 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17