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 gkittelson 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. hasfari

    Access to ORACLE Connection Failure!!

    Thanks Quehay, Writing a direct SQL statement workded for me. I am ignoring the stored procedures call until for a later research. Thanks for the help! Asfari
  2. hasfari

    Access to ORACLE Connection Failure!!

    Hi, I have spent hours solving an ORACLE call to a stored procedure without avail. I tried to memic a code found on this website to connect to ORACLE and get back a value from a table through the otu parameter. My code is very similar to the code for allperson procedure call...
  3. hasfari

    Access to ORACLE Connection Failure!!

    Hi, I have spent hours solving an ORACLE call to a stored procedure without avail. I tried to memic a code found on this website to connect to ORACLE and get back a value from a table through the otu parameter. My code is very similar to the code for allperson procedure call...
  4. hasfari

    How to Map Many tables to One Access Form?

    Thanks floks, I think all of the above are of great help. I will try looking into my Access DB relations, then if I still cannot update tables, I might have to combine ORACLE tables into on big Access table and follow blarson0's suggestion above.
  5. hasfari

    How to Map Many tables to One Access Form?

    Thanks for your input. But as mentioned by Mr. SBendBuckeye, I have to update ORACLE tables from one form. I have to have at least two = sign between two tables and I could not make that query updateable. Since the old Access daatbase use to have one table for most of the system, now it is been...
  6. hasfari

    How to Map Many tables to One Access Form?

    Hi, I am working with an exisitng system using many tables in ORACLE database. I am trying to keep our client MS-forms design not touched but have oracle tables (links) been accessed by forms. Doing so would require having existing Access form fields mapped to more than one ORACLE table...
  7. hasfari

    How to Access fields on one form from anopther one?

    Hi, I would appreciate the help, if someone can tell me how to access fields on one from from another one or from a module. i.e. I am lost here forms!MyForm. ...??? That is when to use ! and when to use . and on what objects. I am search VB help/Access with no avail. I have a form that has a...
  8. hasfari

    How to Map Many tables to One Access Form?

    Hi, I am working with an exisitng system using many tables in ORACLE database. I am trying to keep our client MS-forms design not touched but have oracle tables (links) been accessed by forms. Doing so would require having existing Access form fields mapped to more than one ORACLE table...
  9. hasfari

    Getting SQL Text Out from Access for Reporting/Documentation Purposes

    Hi, I want to et all of my 260 queries text that I designed in MS-Access. I can do this manually by visiting each query and viewing its SQL, but is there a better way, such as writing a query to ask Access system objects to spit out all of my queries text. I appreciate your hint hasfari
  10. hasfari

    Hi, I appreciate it very much if

    Thanks for the reply. You are right I am working on a client machine. I do not have access to the server but yet I am been asked to work as DBA! Here is a smaple script thatt I wrote and the feedback from SQLPLUS. I believe the UTL_FILE package is installed on my client machine and do not how...
  11. hasfari

    Hi, I appreciate it very much if

    Hi, I appreciate it very much if someone can tell me how to go around ORACLE spool restriction. I want to run a script that spools to a file using dbms_output.put_line function. However, spool has a limit and it stopped throwing text to the file after sometime. I checked ORACLE environment and...
  12. hasfari

    Want to know what table/column changed in ORACLE bfore posting (commit

    I want to write a generic trigger and use it for some database tables in my database to create kind of transaction log record in the transaction log table. This trigger needs to be generic if possible and on the database level instead of one trigger for each database table. This trigger is a...

Part and Inventory Search

Back
Top