Recent content by MattN

I am wanting to add a pull-down list into a toolbar (similar to the toolbar within word which has a pull-down list for the fonts). Does anyone know how this can be achived? Thanks in advance MattN

Have you thought about linking the tables into Access then using the documenter in Access. Works for me! Regards

Have you thought about linking the tables into Access then using the documenter in Access. Works for me! Regards

Thanks Claire, All is ok now :-) Regards Matt N

Hello Clare, I have run this command;- select * into NewPaths from Paths where 1 = 0 through SQL analyser and the following message has occurred. Server: Msg 268, Level 16, State 3, Line 1 Cannot run SELECT INTO in this database. The database owner must run sp_dboption to enable this...

Currently I have an import table which inserts data into temporary tables which I have manually created. Whenever I add a field to the import table I need to manually add the field to the other tables. This is obviously time consuming and primitive! Is there a Stored Procedure (or other way) I...

Currently I have an import table which inserts data into temporary tables which I have manually created. Whenever I add a field to the import table I need to manually add the field to the other tables. This is obviously time consuming and primitive! I would therefore like to be able to create...

This may help to some extent. May have to think about how your going to handle 10, 11, 12 and 13 though Private Sub Text1_KeyPress(KeyAscii As Integer) KeyAscii = KeyCheck(KeyAscii, "0123456789") End Sub Public Function KeyCheck(KeyIn As Integer, Optional allow As String =...

Could anyone tell me how to add a field in an MS SQL table. This field must be;- Integer Identity = Yes Identity Seed = 1 Identity Increment = 1 Kind Regards Matt N

FYI, This seems to work. Thanks Anyway MAPISession1.SignOn MAPIMessages1.SessionID = MAPISession1.SessionID MAPIMessages1.Compose MAPIMessages1.RecipIndex = 0 MAPIMessages1.RecipAddress = "test@mailserver.com MAPIMessages1.AddressResolveUI = True MAPIMessages1.ResolveName...

I would like to send an email to 2 recipients using the Mapi controls. I have tried with the semi-colon seperating the two addrersses (see below) but this soes not work. NOTE: I don't want to use a loop as I want both recipients to see that the other person has received it. MAPISession1.SignOn...

I would have liked to be able to store the crieria contents of an IF statement in a string but it seems that Golom's response answers my question - VB does not support this feature (unless anyone knows any different?) ============================================================ strCriteria =...

I want to use a database field as a condition in an IF statement. This has obvious maintenance benefits to the program as I can add conditions and msgbox strings to the recordset without having to update the program. For Example;- rs_Conditions contains the following records - Database Field...

I would like to execute a DTS package package using VB6. Does anyone know the correct API to use. A simple code example would be most appreciated. Thanks in advance. MattN

I have a Crystal Report 8.5 report which I need to print through a VB6 application. The report needs running three times. Each time the data source needs changing to a different database. Is there a way that I can use one CR object and update the Report datasource at run-time? Regards Matt