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!

Register Log in
  • Congratulations derfloh 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. Ptrace

    Centre MDI Child Forms

    Thank u both, It's working great now. PTrace [afro2]
  2. Ptrace

    Centre MDI Child Forms

    Hi, I am having a problem trying to center the child forms of my applications main MDI form. It will not allow me to change the StartUpPosition of the child forms without giving me the following error: Invalid Property Error It is stuck on '0 - Manual'. Why is it doing this and how can I...
  3. Ptrace

    Copying Access Tables Between Databases

    Hi, Yesterday I posted a problem about copying an Access table from one database to another using vb6. Well I got it sussed. This copy includes the complete copy of the table structure, indexes etc. Take a look at it and if it is of any use to anyone, then thats good, but if anyone notices...
  4. Ptrace

    Transferring Data Between Tables on 2 Different Databases

    Hi, I have 2 Access databases (A & B) and I need to be able to transfer the data from a table in database A to a table (same name) in database B. It is not an append, I want the data from the table in database A to overwrite the existing data on the table in B. I have tried the following...
  5. Ptrace

    Datalist Text Change

    Foada, I would still be interested in even using the regular listbox as long as you can think of a way of binding another field to it, as well as the one being displayed. The fact that I need the code associated with the name selected in the listbox, to be placed into the textbox is...
  6. Ptrace

    Datalist Text Change

    Hi Foada, I am using a DataList Control in this case because the list is only 'filled' upon login and I want to assign a Bound Column which stores a code for each name in the list. Therefore, when the user selects a name, the relevant code should appear within a textbox beside the list. The...
  7. Ptrace

    Datalist Text Change

    Hi, The application I am working on requires the user to manually select a name from a Datalist then enter data about the name selected into textboxes, then subsequently submit the data. This must be done individually for each name in the list. The problem is that I wish to in some way...
  8. Ptrace

    ADO or DAO

    This might sound stupid but I am developing apps using VB6 with an Access database background and have been hearing conflicting reports of which access method to use, ADO or DAO. Which is better if I intend to run these apps across Citrix? Very confused!!
  9. Ptrace

    Excel just won't die!!!!!!!

    Got it sussed!!! As well as changing the method of inserting the actual data into the cells, as mentioned in my last post, I also changed the way I created the new excel application. Previously, I used this method: Dim xlsApp as New Excel.Application Set xlsApp = Excel.Application But then...
  10. Ptrace

    Excel just won't die!!!!!!!

    It's just getting even more strange!!! As well as including the bit of code given by softwarescience (thanks by the way!) I also noticed that when loading the sheet with the data I was using: xlsApp.Range("A3").Value = "Surname" So I changed this to: xlsSheet.Cells(3...
  11. Ptrace

    Excel just won't die!!!!!!!

    For what it's worth, here is part of my code: Dim xlsApp As Excel.Application Dim xlsBook As Excel.Workbook Dim xlsSheet As Excel.Worksheet Set xlsApp = Excel.Application xlsApp.Visible = False Set xlsBook = xlsApp.Workbooks.Add Set xlsSheet = xlsBook.Worksheets.Add '...
  12. Ptrace

    Excel just won't die!!!!!!!

    I am exporting data to an Excel sheet. The problem is when I try to quit the Excel application it disappears OK, but the task manager still indicates an instance of it running. This causes excel to crash when I go to either open it directly or run my program again. I have tried numerous...

Part and Inventory Search

Back
Top