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!

  • Congratulations strongm 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: ccwj
  • Order by date
  1. ccwj

    determining if a directory contains files

    Look up the Dir function in VB Help. You can use wildcards to look for files. You may need to set Microsoft Scripting Runtime in your program reference befor this will work. Carl W
  2. ccwj

    How can I extract a portion of a string

    Read up on the SPLIT Function in the VB Help Let me know if this works for you
  3. ccwj

    Help Combobox

    oRSMain.movefirst Do until oRSMain.EOF MYcomboBox.AddItem oRSMain![BillCountry] oRSMain.movenext Loop Try this... I hope oRSMain is your record set and Bill... is the field you want to populate the combo with. Let me know.
  4. ccwj

    ? about limiting access to Access db while using VB

    Why don't you just make the DB password protected? Set QcWs = DBEngine.Workspaces(0) ConnectStr = ";DATABASE=" & dbPath & "Qdata.mdb ;PWD=rdqa" Set QcDB = QcWs.OpenDatabase("", False, False, ConnectStr) The password for this DB is "rdqa" let me know if this helps
  5. ccwj

    How to send an email using exchange server?

    I do not have that code in my program, you may need it depending on your code, do you have the MAPI controls on the form? Do you have Outlook as a reference in your project?
  6. ccwj

    How to send an email using exchange server?

    You will have to take out my Var's but this code works for me. Also make sure you have MAPImessage and MAPISession control on the form. Also i am not sure if you need a reference to OutLook set in your project. I have Outlook 9 as a reference in mine. CODE: MAPISess.LogonUI = True...
  7. ccwj

    VB code record set

    state = "select Employee!employee from table employee" I think i would write it like state = "select [Employee] from [employee] order by [What ever] asc;"

Part and Inventory Search

Back
Top