Click here to Skip to main content
15,913,854 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: VB.NET Selecting datatable for Login verification Pin
darkelv1-Jul-08 23:46
darkelv1-Jul-08 23:46 
QuestionSetting frame in animated GIF Pin
threemp31-Jul-08 14:01
threemp31-Jul-08 14:01 
AnswerRe: Setting frame in animated GIF Pin
jzonthemtn2-Jul-08 6:05
jzonthemtn2-Jul-08 6:05 
QuestionPassword Decryption Pin
raing31-Jul-08 13:23
raing31-Jul-08 13:23 
AnswerRe: Password Decryption Pin
Christian Graus1-Jul-08 15:56
protectorChristian Graus1-Jul-08 15:56 
GeneralRe: Password Decryption Pin
Paul Conrad1-Jul-08 16:57
professionalPaul Conrad1-Jul-08 16:57 
AnswerRe: Password Decryption Pin
Dave Kreskowiak2-Jul-08 4:14
mveDave Kreskowiak2-Jul-08 4:14 
QuestionI need help with VBA to extract Oracle data to Excel Pin
torgerjl1-Jul-08 12:07
torgerjl1-Jul-08 12:07 
I know minimal VBA (one online class that took an hour) and now I need to complete a project in Excel that queries an Oracle database. They would like the user to input a search criteria and then push a button to populate the sheet. For example, the user inputs "shoes" and pushes a macro button that says, "Refresh" and the database then returns the current database "Sizes, Colors and Styles, etc."

D'Oh! | :doh: So far I have been able to make a connection to the database:
Sub OpenDatabase()

Dim strConnection As String
Dim wrkSheet As Worksheet

Application.StatusBar = "Opening Database"
strConnection = "Driver={Microsoft ODBC for Oracle};" & _
"Server=X;uid=Y;pwd=Z;"

Set g_conDB = New ADODB.Connection
g_conDB.Open strConnection

End Sub

Can anyone help me with what to do next?

thanks
QuestionGet "Created" date from and Access table Pin
chuckf1-Jul-08 9:37
chuckf1-Jul-08 9:37 
AnswerRe: Get "Created" date from and Access table Pin
jzonthemtn1-Jul-08 11:19
jzonthemtn1-Jul-08 11:19 
GeneralRe: Get "Created" date from and Access table Pin
chuckf2-Jul-08 2:19
chuckf2-Jul-08 2:19 
GeneralRe: Get "Created" date from and Access table Pin
jzonthemtn2-Jul-08 5:59
jzonthemtn2-Jul-08 5:59 
QuestionProgress bar help Pin
Cory Kimble1-Jul-08 7:12
Cory Kimble1-Jul-08 7:12 
AnswerRe: Progress bar help Pin
jzonthemtn1-Jul-08 7:52
jzonthemtn1-Jul-08 7:52 
QuestionHow to Set Security? Pin
Trupti Mehta1-Jul-08 4:21
Trupti Mehta1-Jul-08 4:21 
QuestionHow to maximize third party app [modified] Pin
JLTBDY1-Jul-08 2:47
JLTBDY1-Jul-08 2:47 
AnswerRe: How to maximize third party app Pin
jzonthemtn1-Jul-08 4:54
jzonthemtn1-Jul-08 4:54 
GeneralRe: How to maximize third party app Pin
JLTBDY1-Jul-08 5:19
JLTBDY1-Jul-08 5:19 
GeneralRe: How to maximize third party app Pin
jzonthemtn1-Jul-08 5:34
jzonthemtn1-Jul-08 5:34 
GeneralRe: How to maximize third party app Pin
JLTBDY7-Jul-08 7:28
JLTBDY7-Jul-08 7:28 
GeneralRe: How to maximize third party app Pin
jzonthemtn7-Jul-08 8:11
jzonthemtn7-Jul-08 8:11 
GeneralRe: How to maximize third party app Pin
JLTBDY8-Jul-08 12:00
JLTBDY8-Jul-08 12:00 
GeneralRe: How to maximize third party app Pin
jzonthemtn8-Jul-08 12:19
jzonthemtn8-Jul-08 12:19 
AnswerRe: How to maximize third party app Pin
JLTBDY9-Jul-08 6:07
JLTBDY9-Jul-08 6:07 
GeneralRe: How to maximize third party app Pin
jzonthemtn10-Jul-08 3:17
jzonthemtn10-Jul-08 3:17 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.