Search results for query: *

I'm sending mail from Access 2000 to Outlook 2000 in HTML format for distribution to internet clients. Is there a way I can ensure that Outlook 97 clients can receive the email even though it doesn't support the HTML format. Thanks in advance!

Has anyone had experience of sending HTML formatted email, I'm currently sending am mail message via Outlook 2000 to internet clients. the problems is I cannot be sure of their mail client, Outlook 97 doesn't support HTML formatted email, is there a way of sending an intelligent email that...

Point taken LittleSmudge, but I don't like simple solutions when a more complicated one can be found. I like to use a hammer when a nut cracker would do. Cheers Chris

Thanks for that LittleSmudge, Only problem is that the fields vary from 8 - 255 characters. I don't really want to enter 255 C's. There must be a way of programatically limiting input. I have even messed with KeyPress event to check number of key presses and used a case statement to check which...

I have an unbound form and want to limit the number of characsters entered in each field, there must be a simple way of doing this, but I'm feeling really thick. Thanks in advance Chris

Thanks for that, I found an example that looped through the forms collection and returns the index value. I tried to loop through the controls collection of that form but couldn't compare the name value of the openargs against the control name. As you said many ways to crack a nut.

How can I extract a form/comboBox name from a string. I pass an openArgs (Forms!frmEnquiries!comboSup) to a form called frmsuppliers. When I close that form I want to pass a value back to Forms!frmEnquiries!comboSup. Dim MyCombo as ComboBox Set MyCombo = Me.OpenArgs MyCombo.Value = 99 The...

Thanks guys for your help, I will give it a go. Did you hve any idea why the code works most of the time. I tried running the code on the timer event, sometimes it would run over 2000 times before failing, other times just 70. It seemed to hold the last value in memory. The only way to clear was...

I'm currently writing some code that opens up a recordset tblTitle, finds the last library number, increments it by one and then copies the value back to a new record in that recordset together with some values from a form or adds a copy to another table if the library number exists. When adding...

I have just created a runtime version of a database, the Query by Form button doesn't work on a customised menubar, the apply filter and remove filter buttons work fine. The database run on a machine with full Access works fine. Am I missing something when I run the setup wizard. Thanks in advance.

I have converted an Access97 app to Access 2000, the problem is the database now reacts like a dog. Anything I try to do when in design mode seems to hang the machine, opening toolbars, modifying code, it sometimes takes 1 minute to react. I've tried importing the data into a new database, that...

When using the recordset DTC I cannot see the connection,tables etc all I get is Red exclamation marks! I'm using an ODBC connection to a SQL 7 database, Any help gratefully recieved. Chris

I have joined to identical tables with a union query, the problem is, that when I use this query in the relationship window i lose my primary key references. Is it possible to create the keys as part of the SQL select statement. Thanks in advance for your help

Sorted, ran later version of instcat.sql

I've just started using VB6. When adding a data environment to my project I have problems connecting to a SQL server database. I add a connection and try to set up the data link properties. I Select Microsoft OLE DB Provider for SQL Server, I can select the named server but cannot see or select...