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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by zambrtp

  1. zambrtp

    RMAN catalog database

    Is it ok to shutdown the RMAN catalog database while no one is doing any backups or restores..then start it, resynch the target databases before any procedures occur
  2. zambrtp

    Creating a constraint verses Trigger check

    Can anyone tell me what the difference in performance if there is a contraint created to check data integrity vs a trigger created to do the same? Thanks
  3. zambrtp

    Dynamically retrieving data from an Oracle database

    David: Our programmers use the metadata to do a few things.. 1. verify the datatypes 2. Find the table column information They construct a select(s) statement(s) batch them then run the batch for the data. They handle if not all the values are used ( NULL values) and return errors for data...
  4. zambrtp

    Silent install Oracle 9i release 2 Windows Sever 2003

    HELP!! I am able to use the setup -silent with a response file that only installs ( software)...( I did this with the -record option).. I need to know how to edit that to allow the netca.rsp and dbca.rsp to spawn and create the listener .. And then I want dbca to create the database...( is...
  5. zambrtp

    Migration from Access 2000 to Oracle 9i problems

    I migrated a .mdf Access 2000 to Oracle 9i....there is one for that doesnt appear to work properly....I understand that the queries are not migrated...one form that relies on a query works fine the other is not able to work...any ideas to fix this...is it code or recreating the query on the...
  6. zambrtp

    Many to Many Relationships!!

    Richard: Sorry I missed the part about starting a new thread...Ok Ill do that..thanks
  7. zambrtp

    Many to Many Relationships!!

    Doc: Ok that is to view the data...what about input forms... I have a DB that is to request parts, do the procurement side and keep inventory based on project, delivery, interm, build and CM control names The part will be entered for ordering based on what project, delivery, interim, build...
  8. zambrtp

    Many to Many Relationships!!

    Appreciate the link...I still need an example of how someone was able to implement many-to-many using Access 2000 forms. I dont have a problem with the database design its the form that is troubling. Thanks
  9. zambrtp

    Many to Many Relationships!!

    ALL: I am working on a many-to-many relationships with multiple subforms..can I have that example DB as well...Access 2000 has me puzzled .... Tereza.P.Zambrano@saic.com
  10. zambrtp

    Dynmaic Query

    MGM: Does that allow Nulls...I want to be able to have the user Just enter 2 out of ten and have the query work? and if they dont select anything everything should come back... thanks for the help Tereza
  11. zambrtp

    Dynmaic Query

    Phil: I agree...if someone could show me a simple 10 parameter dynamic query on a form....that works consistently...I would be eternally grateful... Allowing NULL values... Once again....I have a form with 10 txt fields...the form has its txt fields associated with a query ( each txt field is...
  12. zambrtp

    HELP!!! Need to know how to capture a result from Query

    Eupher: Thanks...I see what I did wrong...I just typed the code into the After update instead of putting in a the CODE... thanks you had it aswered the first time
  13. zambrtp

    Dynmaic Query

    JDG: The form stays active ( if active means visible and not closed), The weird thing is the select statement is just a oneliner...[]![]![]! Or []![]![] IS NULL but when I reopen the query after a save...it is HUGE to large to open...and doesnt work..
  14. zambrtp

    HELP!!! Need to know how to capture a result from Query

    Ken.. Sorry I am very new to Access how do I bind the txtField to the table? Is that a procedure if so when do I do it..After Update, before, on lost Focus
  15. zambrtp

    HELP!!! Need to know how to capture a result from Query

    Ken: Thanks for the help...after is shows up...I need it to go into the database like regular data when the Addrecord button is selected... Tereza

Part and Inventory Search

Back
Top