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 Chriss Miller 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: *

  1. PhillCart

    Load VB form via string variable

    I already have a Select Case structure It looks somewhat like this Select Case intCampaignCell Case 345, 348, 367 Set frmNew = New frmDirectMail Case 389, 392, 398, 412 Set frmNew = New frmRetention ... Case repeated about 10 times ... End Select frmNew.show What I would like to...
  2. PhillCart

    what is the syntax for join on Access table and Sql server table

    Which table are you updating, SQL or Access? Try, UPDATE SQLTable SET SQLTable.field = AccTable.field FROM AccTable INNER JOIN SQLTable ON AccTable.field = SQLTable.field WHERE AccTable.Field = 36137 If you're updating the Access table switch the references to SQLTable and AccTable around...
  3. PhillCart

    Load VB form via string variable

    Hi I'm hoping that someone can give me some advice on a problem I have been presented with. We have a VB5 application that has about 11-12 different data entry forms. When the application starts the user is presented with a list of marketing campaign codes. They select one of these codes which...
  4. PhillCart

    MAPI mail profile setup to send SQL mails

    SQL Mail uses MAPI, so you need a MAPI client on the server. Either Outlook or the Echange Client that comes with NT will suffice. Then you need to login to the server with the same username that the MSSQLServer service uses. Then you setup a mail profile as you would for a normal user. Once...

Part and Inventory Search

Back
Top