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 bkrike 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. RichardBott

    Upgrading a 9i repository to 10g

    While attempting to upgrade a 9i repository (9.0.2.5) to 10g, I encountered an error. I followed Oracle's SCM Repository Installation Guide for the 10g developer suite steps for 'Upgrading a Release 6i or 9i Repository' to 10g. Since this error suggested that I may have made an error during...
  2. RichardBott

    Converting from Access '97 to 2000/2002

    I have an Access 97 application that is split between its code and database. I am having difficulty in converting it to Access 2002. I would like to convert both the database and the application. When I startup the application under Access 2002, it asks if I want to convert. I choose this...
  3. RichardBott

    Programatically adding a new or updating a record

    Hi fellow Access users, In Access XP, when the user is filling out the fields for a new record on a form, one of the options I have is to go to a child form to fill out some detail there. My experience with Access shows that this new 'child' form only works well if the parent form has added...
  4. RichardBott

    Refreshing displayed list after a change

    Hi experts, In Access XP, I show a list of 'candidates' that are the result of a query view of a table. The same form allows the user to add a new candidate to the view but when that is done, the list is not automatically refreshed to include the new candidate. Using the .Refresh only helps...
  5. RichardBott

    NAV 2005 performs an illegal operation on Win 98

    After running NAV 2005 for many minutes on a full system scan, the program performed an illegal operation and a Windows message box appeared identifying Navw32. The illegal operation was an invalid page fault in module JSCRIPT.DLL. Can anyone advise me of how to fix this problem. Thanks.
  6. RichardBott

    Need to get IMS database metadata into Oracle Designer

    Does anyone know of a product that could export IBM's IMS data structures from a production environment so that I can then import them into Oracle Designer? Thanks for your help, RjB
  7. RichardBott

    Exporting IMS database structures to Oracle Designer

    Does anyone know of a product that could export IMS data structures from a production environment so that I can then import them into Oracle Designer?
  8. RichardBott

    Capture DB2 table structures to import in Oracle Designer

    My client needs to capture the design of a DB2 database in Oracle Designer. Does anyone know of a tool that could take DB2 table structure information from the DB2 database and export it in a manner that can then be imported as a data model into Oracle Designer?
  9. RichardBott

    Making an Access 97 friendly .mdb from Access XP

    I have an Access XP application that I split into 2 to separate the application tables from the application forms etc for maintenance purposes. Is there any way I can convert this to Access 97? Can I combine these 2 XP .mdb's into one? If I can, is a subsequent conversion to Access 97 fairly...
  10. RichardBott

    Report will not print from preview display

    I am working in Access XP and have a report which is opened in a macro following the opening of a parameter screen. The sequence of actions in the macro is: OpenForm (with action args: frmReportParameters, View = Form, Data Mode = Edit and Window Mode = Dialog) OpenReport (with action args...
  11. RichardBott

    Embedding carriage return - line feed in report field

    I am use the 'Detail -> On Format' event to populate some complex report cells and need to imbed a carriage return - line feed. When I put CHR(10) and CHR(13) into the field, they appear as square boxes indicating unprintable characters and not as CR-LF as I expected! Does anyone know how I...
  12. RichardBott

    Cannot add a record from a form

    Now here's a strange question... I added a record into a child table using a form opened from the parent form. While trying to solve another problem, I think I must have changed something because I can not add child records any more! I get the error message "Cannot add or change a record...
  13. RichardBott

    Using Listbox to display child table entries

    I have a parent-child pair of tables and, when moving through the parent records, wish to display a listbox of the related children. I have children in the table but they do not display! Any ideas? Some ListBox properties are as follows: Name: txtProject_Announce_ID Control Source: <blank>...
  14. RichardBott

    Can't assign a value to a Form object

    I have some code in a Form_Activate() subroutine whose purpose is to display some values on the form that are from another (the parent called from) Form. The code snippet is: Private Sub Form_Activate() Me.txtProgram_Name = Form_frmProjects.txtProgram_Name Me.txtProgram_ID =...
  15. RichardBott

    INSERTing record then Requery causes duplicate error

    During the entry of data in a custom form, rather than letting Access XP add a new record when it thinks it needs to, I have provided a [New Record] button. This has code that INSERTs a new row into a table looking after all of the non-duplicate and non-null conditions. When I try to navigate...
  16. RichardBott

    Windows Explorer screen appears @ Win XP startup

    Since I installed some MS Access sample databases (at least, I think that was the connection) every time I start up Win XP, I get an annoying Windows Explorer screen of a drive "F:\Program" folder which itself contains a folder named 'logs' which is empty like its parent. My stratup folder just...
  17. RichardBott

    Office XP S-L-O-W when navigating through folders

    In all of my office XP Pro components (Word, Office, Excel, Access, etc) when I am accessing files within folders, the navigation among folders is inordinately slow. This does not occur in non-office apps such as Adobe Acrobat or Windows Explorer etc. It often takes many secods - up to 15 - to...
  18. RichardBott

    How do I hide the Access screen in a production Access App?

    When I am developing an Access XP app, I have the Access full-screen as background for program development. How do I hide this in the 'to be delivered' system - I do not want my users to have access to this. Thanks for any help you can give. RjB
  19. RichardBott

    Application .mdb cannot find database .mdb

    In my Access XP development environment I have an application .mdb for the project code and a separate database .mdb for the database. When I initially created this, in the application .mdb I linked to the database in the database .mdb. Both .mdb's are in the same folder. When I copied the...
  20. RichardBott

    Public variable hiding from me in module procedures

    In my Access XP forms, I defined a Public variable in the declarations section of my form module (immediately following the Options Compare Database command) but found that its visibility was inconsistent within procedures in that module. In one procedure, I assign a value to it but in another...

Part and Inventory Search

Back
Top