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
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.
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
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?
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...
state = "select Employee!employee from table employee"
I think i would write it like
state = "select [Employee] from [employee] order by [What ever] asc;"
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.