Threads Replies Last Post 13 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13   Adding Outlook Redemption Reference Programmatically I am trying to email automatically from Access. Many of our users have Outlook 2000 or higher and so I need to use Outlook Redemption to get around the security pop up. How would I 1: Check to see if the reference has already been added 2: Programmatically add the reference. I've found code samples for Excel but none for Access. I'm slightly confused as to how dlls need to be... 2 06.09.2006 16:15:29 Open File with doubleclick in CommDlg-Object Hello Access-Developers, I use the CommDlg-OCX to access the Windows file system. This works fine except one point: The selected files don't open using a doubleclick on the filename. It works with a rightclick on the filename and selecting "Open" from the menu. But this is not what the user wants. Thanks for any help Karl ... 5 06.09.2006 15:18:02 FREE VB6 OCX to send e-mails with images Hello eveyone, I'm writing a VB6 application and I want to send an e-mail to all addresses in a recordset. Where can I get a FREE OCX to send e-mails, but including images in the mail. I found several simple OCX where the mail contents is limited to plain text. Help will be greatly appreciated! Greetings to all Vincent ... 1 03.09.2006 14:21:50 Update problem with Datagrid Hello there, This is my last problem in my application: On a VB6 form I have a DataGrid linked to an ADODC control providing the data from the database. Properties AllowUpdate, AllowAddNew and AllowDelete of the grid are on True. However, in runtime, all data is displayd as expected but when I change anything in the contents of a cell in the grid, an error message appears ("error occu... 1 03.09.2006 13:33:43 sad asd ... 1 01.09.2006 20:52:42 hoola dsaf ... 1 01.09.2006 20:52:20 Problem with events Hi all I have a form which is used to run an update process. The update process is coded in a class module called clsUpdateProcess. clsUpdateProcess is instantiated by the form to begin the process. As the update process runs, it generates events which are consumed by the form to provide progress information to the user. I want to also have a Word document which summarises the update... 3 31.08.2006 08:27:01 How to set the Recordset for a Subform How can I link a subform to a recordset in such a way that when I browse the recordset of the parentform the linked records are shown in the subform? ... 7 30.08.2006 08:15:02 Access and Word I'm am trying to get a button on a form to open a Word document. I works in one database, but not in a second that has tables linked to the first. Both databases are accessing the same .doc, at different times. Here's my code for the button on the second database: Private Sub cmdGenerateAddressList_Click() Dim wordDoc As String Dim oapp As Object Set oapp = CreateObje... 4 29.08.2006 15:54:45 piture in a table I have a database with in a table a field for pictures. how can i load automaticle pictures from a web page in to a table yousing VBA. i now the path from the picture. Koen... 1 29.08.2006 14:31:02 Opening any Document Does anyone have any VBA code they could share that opens a document - with the correct program based on extension - like Windows does? i.e., open a ..DOC with MS Word, open a .pdf with Acrobat, etc. Thanks, Stuart... 2 28.08.2006 14:38:17 converting Access db backend to SQL Hi Everyone, I have a business application that has front end as .mde and a backend as ..mdb I am thinking of converting the backend to SQL. Right now I am using DAO to manipulate the data. Has anyone been using .mde front end and SQL database as a back end ? Also since I have clients who are using back end .mdb so the question is also in transfering the data and the structure into SQL. ... 2 26.08.2006 03:54:20 Quickest way to import data from mssql to Access table? I'm trying to determine what's the fastest method for populating a single table in Access from a select statement executed against a sql database. I currently connect via ado to the mssql datasource and also make a connection to my access db via ado. I then submit my sql statement (which is fairly complex...ie. many tables and fields) and populate a recordset with it. I then iterate t... 1 25.08.2006 17:16:02 Sorting a form with recordset a ADODB.Recordset I linked a form with a recordset in this way: Dim strSQL As String Dim rstAddresses As ADODB.Recordset Set rstAddresses = New ADODB.Recordset rstAddresses .CursorLocation = adUseClient strSQL = "SELECT ... FROM ..." rstAddresses .Open Source:=strSQL,CurrentProject.Connection, adOpenStatic, adLockOptimistic Set Forms("frmAddresses").Recordset = rstAddresses This works perfectly until I ... 1 25.08.2006 09:26:01 ADO ODBC field size I am trying to access a lotus notes database through ADO and when I do a few of the fields are having their information truncated. So next I "Linked" the table in access using ODBC and see that the fields are set to text instead of memo, so I am only getting the first 254 characters. How through VBA or the Linked table manager can I select those fields and get ALL the data in them? He... 1 24.08.2006 15:26:02 OleDbDataAdapter and Linked Access Tables I am attempting to to use Microsoft Visual Basic .NET to connect to a Microsoft Access database in order to retrieve data. I have achieved this by using an OleDbDataAdapter. I am now trying to do the same with a database (parent database) that has tables linked to tables of different databases (child databases). I can connect to the partent database and everything looks as though it is... 1 21.08.2006 15:34:02 Not a Valid Bookmark Network OS = w2003, desktop = XPPro, Access = 2003 Database #1, using all access tables and queries, uses the same code as DB #2 to find a record. DB #2 is linked to 4 SQL tables, and has 3 access queries, one of which is used by the main form. DB # 1 works when doing a record search. DB#2 using the same code (Copied from DB#1), fails with the "Not a valid bookmark error" message. I... 5 21.08.2006 13:29:01 Join Method Problem Hey All, I could do this another way but want to know why using the JOIN function will not work. Join(sourcearray[, delimiter]) My Code: Dim test as String test = Join(gConCatalogue.ConvRS.GetRows(, 1, 0), [,]) What I'm doing is taking all the items from one column in an ADO recordset and passing it with comma delimited into a string. But this does not work. Any ideas? ... 4 20.08.2006 02:46:02 converting a MS-Access2002 business application If you have experience converting a MS-Access2002 business application (about 130 different processes) to a web product with SQL backend and using , preferably, ASP.NET can you tell me: Did you use a conversion software product and, if so, which one. Briefly your experience - was it successful? Any tips and/or caveats? Comments are most appreciated. Thank you, Igor... 3 19.08.2006 11:27:41 Help Getting Key for New Record I use an ADO connection to add new records to a SQL Server 2K database. After a new record is added iit is supposed to be the current record. Yet, I cannot seem to retrieve the primary key (autogenerated) for the record. I just get a zero. The added data goes in and can be queried and viewed. Here is a code snippet: Dim cnSQL As ADODB.Connection ' SQL server Dim rsTR As ADO... 2 19.08.2006 04:36:20 converting a MS-Access2002 If you have experience converting a MS-Access2002 business application (about 130 different processes) to a web product with SQL backend and using , preferably, ASP.NET can you tell me: Did you use a conversion software product and, if so, which one. Briefly your experience - was it successful? Any tips and/or caveats? Comments are most appreciated. Thank you, Igor... 1 18.08.2006 14:37:06 converting a MS-Access2002 If you have experience converting a MS-Access2002 business application (about 130 different processes) to a web product with SQL backend and using , preferably, ASP.NET can you tell me: Did you use a conversion software product and, if so, which one. Briefly your experience - was it successful? Any tips and/or caveats? Comments are most appreciated. Igor... 1 18.08.2006 14:32:34 Retrieving OLE Object from MS Access I have Access database that contains column of type “OLE Object”. This column can store any OLE object including images, word doc, excel sheet etc. My task is to read this OLE data from “OLE Object” column & store it into a temp file say data.tmp so that the OLE data can be retrieved without any information loss. Since the definition of OLE object storage is not documented (contai... 4 17.08.2006 15:02:01 problem with newaccessproject method Hello I'm connected to foo2 dbase on sql msde server . ? CurrentProject.BaseConnectionString PROVIDER=SQLOLEDB.1;INTEGRATED SECURITY=SSPI;PERSIST SECURITY INFO=FALSE;INITIAL CATALOG=foo2;DATA SOURCE=ADIXPD001 I want to make a new access project , an adp file Dim obj1 As Access.Application Dim str1 As String str1 = CurrentProject.BaseConnectionString 'Instantiate Access session Set ... 1 16.08.2006 20:43:15 Having troubles with error 7866 .opencurrentdatabase here is the code it opens dab and then give the error 7866 when opoencurrent dbContab.Close Set dbContab = OpenDatabase(dirbase & archbase, False, False, ";pwd=" & clavebd) On Error GoTo 0 'error 7866 exclusive mode which is not true when opendatabase why Set appAccess = CreateObject("Access.Application") appAccess.OpenCurrentDatabase dirbase & archbase, , clavebd For Each tdf In dbCon... 3 15.08.2006 15:50:02 13 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13