Search results for query: *

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

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

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

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

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

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

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

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!!

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

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

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 '...

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