connect to Oracle database

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: docchang <docchang.2islbj@xxxxxxxxxxxxx>
Date: Thu, 14 Dec 2006 11:48:00 +0530

I have the name of the server, login name & pass, and tables I like to
work with.

How can I make query calls in VBA?

Thanks,

DC

--
docchang
------------------------------------------------------------------------
docchang's Profile: http://forums.techarena.in/member.php?userid=19888
View this thread: http://forums.techarena.in/showthread.php?t=642105

http://forums.techarena.in

.

Follow-Ups:
- Re: connect to Oracle database
  - From: Rod Gill

Prev by Date: Reduce task duration BUT Actual Work reduces as well
Next by Date: Re: connect to Oracle database
Previous by thread: Reduce task duration BUT Actual Work reduces as well
Next by thread: Re: connect to Oracle database
Index(es):
- Date
- Thread

Relevant Pages

Re: Merging content from access
... My hunch at the moment is that this is a problem in my access query. ... I agree with you that Word VBA is a more elegent solution. ... The other field-based technique requires you to have a "parent" table as ... the mail merge data source and a child table inserted using a DATABASE ...
(microsoft.public.word.docmanagement)
Re: Merging content from access
... that could well be the case - I guess you'd see if you ran the same query in Access. ... I have an expression that calls a vba function to collate records from all of the notes resulting in a long field. ... Historically, there have been character-count limit problems when Word gets data from Access memo fields (e.g. the limit for ODBC connections was increased many years ago, I haven't researched the Access limitations" problem anything like as much as the equivalent problem in Excel. ... The other field-based technique requires you to have a "parent" table as the mail merge data source and a child table inserted using a DATABASE field. ...
(microsoft.public.word.docmanagement)
Re: Form Advice Relating to Queries
... books, Mastering Access 2002 Premium Edition, Access InsideOut 2002 by Helen ... For more complex queries, use vba programming..... ... I haven't quite worked out how to use the Query Builder via ... ... The form's RecordSource property is a string. ...
(microsoft.public.access.forms)
RE: Macro
... The macro can be found by type Alt F11 to get to VBA and clicking on Module1 ... Then post the query results. ... Microsoft SQL Server 2000, which requires a server, VBA or Microsoft Query ...
(microsoft.public.excel.programming)
Re: Form in macro to not open if query result is empty recordset
... basically a redisign of a previous tool that was written solely in vba. ... macro means that one will not run until the previous query has completed. ... If not all the vendors will be in your vendor list and you have RI ...
(microsoft.public.access.forms)