Threads Replies Last Post 13 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13   EMailing several snapshots using SendObject I am trying to use a command button to send Access reports via Outlook as snp files. Does anyone know how I would attach more than one snp to the same EMail? I would like for the user to have to push the button only once. Much thanks in advance. -- Joe Micheli CPA, CMA, CFM, CPIM... 1 19.04.2006 15:29:01 objEmail.HTMLBody inserts "! " after 1900 characters? I have code in a module that is sending e-mails, the content of which varies beased upon the content of fields within the database. I am creating the body using a number of string variables and then concatenating them together and assigning them to the objEmail.HTMLBody object similar to this: CompleteBody = Body1 & Body2 & Body3 & Body4 objEmail.HTMLBody = CompleteBody Originally, I... 12 19.04.2006 03:08:45 Update the Laptop replica with the the network I have two databases that I am currently testing. I have created a Replica copy but would like to have the replicate as soon as the can connect to the network. we connect two ways. 1. Direct 2. VPN With the VPN they are not directly mapped to the drive. I can get it to work with the \\{network name\ etc. but I would like for it to loop until it finds it or have a button that sy... 1 17.04.2006 20:30:55 for sale: internetDotComs.com domain for sale: internetdotcoms.com http://www.afternic.com/name.php?id=11866440 ... 1 16.04.2006 13:28:36 Clearing some records out of a recordset I have a parts planning system that stores the list of parts in a Pervasive database like so: Car - Engine - 1 - 1/1/1999 Car - Tires - 4 - 1/1/1999 Car - StdWheel - 4 - 1/1/1999 Car - StdWheel - 0 - 1/1/2000 Car - MagWheel - 4 - 1/1/2000 What this says in a nutshell is that the car had started with StdWheels in 1999, then in 2000 they were changed to MagWheels. The line for 0 StdWhee... 1 13.04.2006 19:24:18 Copy ADO RST to ACCESS TABLE (MDB) I need to copy an ADO recordset to an Access Table. How can this be done? Thanks! ... 2 11.04.2006 19:34:31 hidden relationships between tables I tried to change a field size of a table but got error msg about the relationships. I looked the relationships under the tools. I don't see any relationships for this table. However, this table will store the result of an append query. This append query use one table which has relationships with other tables. But I already disconnect those relationships. I don't know what can i do at t... 2 11.04.2006 08:25:03 Pasting Error Handler Into Module/Class Module I would like to be able to be able to invoke code that will paste in a standard error handler. The code is currently held in a text file. I open this file and copy/paste it into places where needed - not already done by Access. From time to time I have to customize this 'standard' error handler, but that is okay. At work our PC's are locked down, so add-ins cannot be installed. Does someo... 3 11.04.2006 01:41:04 Refresher When I first started database development with Access, I knew the answer to this question, but it slips my mind now. What is the difference in VBA between: Me!Anything Anything Me.Anything [Anything] If I remember correctly, it has to do with the value shown on a control versus the recordset behind a form, but cannot remember which is which. ... 2 10.04.2006 20:34:32 Cannot update error Hi I was wondering if anyone could help i have picked this database up from a designer who has now left the company. The code is a couple of years old. On click of a button it open a recordset which is a query loops until it finds the required people and then trys to update one field in the query. I then get the error message "Cannot update database or object is read only". But this ... 4 10.04.2006 12:38:01 Outlook Automation Hello... I would like to find some sample code that would allow me to send an email with the reciever having the ability to select Yes or No and send the email to a defined reciepent. Thank you... 3 10.04.2006 07:27:30 Returned mail-- --XRMgmEGBBrRQNDgJjVBiQGJHIqveWoKk Content-Type: multipart/alternative; boundary="rRidSSSPeQoFtYYwvcLIoOfQwNJYnmbT" --rRidSSSPeQoFtYYwvcLIoOfQwNJYnmbT Content-Type: text/plain; Content-Transfer-Encoding: quoted-printable See the attached file for details. --rRidSSSPeQoFtYYwvcLIoOfQwNJYnmbT Content-Type: text/html; Content-Transfer-Encoding: quoted-printable <HTML><HEAD>... 2 10.04.2006 00:01:27 Start Earning Money 15 Minutes From Now Did you know? $29 can make you $1,000? And $1,000 can return you $3,081,484 in 3 years? (without you lifting a finger) Yes, we will show you how AND give you the method Yes, InvestPlace uses extremely powerful tools InvestPlace contains a powerful combination of two match winners... This is some valuable information. I'm using it and watching my money grow everyday. ... 1 09.04.2006 14:21:33 2 records short when writing to a SQL Server table. I have a Microsoft Access 2002 ADP that goes against an MS SQL Server 2000 database. Within this MS Access ADP I have a recordset (forward only, read only, cachesize 1) that is the result of a SELECT. . .WHERE EXISTS query. This recordset is gone through to create corresponding records (1-for-1) in another recordset which is open for write (forward only, optimistic locking, cachesize ... 2 08.04.2006 03:56:01 ayuda con regillas en vb Les agradeceria me ayuden a construir la siguiente aplicacion Con cualquier tipo de acceso a datos de base de datos access en vb6 necesito un ejemplo de formularios don regillas mis tablas mayor <cuenta Nombre debe haber> diarios <numero fecha cuenta glosa debe haber> quiero un form en el que me permita grabar 1 numero de diario en un fecha dada y en un regilla culq... 1 07.04.2006 16:46:29 Editing records can somebody help me with the logic of a record EDIT procedure. I want the user to click on a botton to edit a record I have a combo box to find the record so the form opens with me.dataentry = true me.allowedits = false but this does not allow me to change the value in the combo box What is the correct way to do this? Moiz ... 4 07.04.2006 10:05:40 Full Text Search in MDB Blobs? Hi! We are developing an application that archives files. The files are stored in mdb-Databases in Blob(Binary)-Format. Now the customers want to do a full text search. Is there a possibility to do a full text search on blobs in MDB Databases? The programming language is VB6. Thank you for your answer! Sincerely, Ch. Mueller AIB Informatik AG info@aibinformatik.ch ... 5 06.04.2006 23:14:32 How To Bypass Login Prompt When Opening Linked Table Hi folks! I have been trying to migrate an Access 97 database to an SQL Server 2000, but I have been dealing with problems related to linked tables. Basically I have an Access database and an Access MDE accessing it. I migrated all access 97's data to an SQL Server and I tryed to change MDE's linked tables from the old Access database to the new SQL Server tables through an ODBC conn... 2 06.04.2006 23:08:42 hey,why i can't pass a control to a function? thank you looking at my post i have a problem to pass a control to a function,here is my code: Public Sub getmaterialSql(ByRef combobox1 As combobox) Dim id As Integer If IsNull(combobox1.Value) Then MsgBox ("Can not be Null") Exit Sub Else id = cint(combobox1.Value) End If ..... .... End Sub when i refer such a function,The ... 3 06.04.2006 14:05:13 why ... 1 06.04.2006 03:55:50 Browse control to browse through a folder I want a control that will enable the user to browse a folder for files. Does anyone know the name of the control? It will be used in a form. Thanks Suneel ... 2 05.04.2006 11:19:31 VB Reference Libraries Hi, I need to activate certain VB reference libraries within a VB6 project using code (e.g. Microsoft Office 11.0 Object Library). This will ensure all users applications have reference to the correct Reference library!!! Can anyone help? Cheers, Steve. ... 4 04.04.2006 16:02:16 ADO & SQL string Hi Just wondering how would I construct this SQL string to use inside VBA code: F_PUPILS.PU_SEQ, tblAcadGrade.AcadYear, tblAcadGrade.FS_Set_Code, tblAcadGrade.FS_Subject, tblAcadGrade.Autumn, tblAcadGrade.Spring, tblAcadGrade.Summer, tblPastoralAcad.WiTutor, tblPastoralAcad.SuTutor, tblPastoralAcad.SpTutor IN tblPastoralAcad ON F_PUPILS.PU_ROLL_NO = tblPastoralAcad.PU_Roll_No WHERE ((... 2 03.04.2006 08:14:36 More troubles with ADO and SQL Server 2005 Hi all! Up to now, I was working with a SQL Server 7 and VBSQL. It was easy to call a stored procedure with (usually) a SELECT parameter and retrieve a cursor from the stored procedure. As I am in the process to migrating to a SQL 2005 Server, I can't use VBSQL anymore. What I try to do is as follows: I have a stored procedure like "SELECT * FROM <Table> WHERE <Table.Field&... 5 02.04.2006 06:01:00 Manipulating data in textbox with VBA code I am getting ERR 3326 "This recordset is not updatable" when trying to manipulate data in controls on a form with VBA. The code is in a form module, examples: Forms!frmMembership!DateJoined = Date Forms!frmMembership!DuesAcct = -Forms!frmMembership!CurrDues What triggers ERR 3326?... 6 01.04.2006 19:10:39 13 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13