Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: MattN
  • Order by date
  1. MattN

    List box within a toolbar

    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
  2. MattN

    printing out table documentation

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

    Table properties

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

    Replicating an MSSQL table structure

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

    Replicating an MSSQL table structure

    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...
  6. MattN

    Replicating an MSSQL table structure

    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...
  7. MattN

    Replicate a MSSQL Table in VB Code

    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...
  8. MattN

    text box rules

    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 =...
  9. MattN

    Adding an MSSQL Identity field in vb code

    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
  10. MattN

    Send email to 2 recipients (MAPI)

    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...
  11. MattN

    Send email to 2 recipients (MAPI)

    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...
  12. MattN

    Database field as condition in IF statement

    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 =...
  13. MattN

    Database field as condition in IF statement

    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...
  14. MattN

    Executing a DTS package (SQL server)

    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
  15. MattN

    Changing CR8.5 datasource at run-time (VB6)

    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
  16. MattN

    Connect to Database on Diff server

    Can someone please tell me the TSQL syntax used to connect to a database on a different server. I am familiar with the USE command but this only works on the server you are connected to. Thanks in advance. Matt :-|
  17. MattN

    Any Comments On IGrid?

    I am looking at buying a 3rd party grid ActiveX called Igrid. Any comments on this product would be mostly appreciated. King regards Matt
  18. MattN

    Passing Parameters to Stored Procedures

    Can anyone tell me how to execute a stored procedure with a parameter within VB6 code. This code executed the procedure prior to the parameter being added. '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' Dim Qy As New ADODB.Command Set Qy.ActiveConnection = cn...
  19. MattN

    Using Parameters in a Stored Procedure

    So simple when you know how. Now I can progress to the more complex. Thanks
  20. MattN

    Using Parameters in a Stored Procedure

    Can anyone give me a sample of a very simple stored procedure which uses a parameter i.e. OrderNo This would be most helpful to get me started. I will figure out the rest. Kind Regards MattN

Part and Inventory Search

Back
Top