Recent content by smil3y

Thanks for the assistance. It has given me a few areas to look at. Will update when I resolve. Regards

It does seem like it is caught in a loop. It appears to copy the files and request a reboot. The computer used to create the application is also XP SP3. I will try installing the VB runtime separately. Any ideas on why it gets stuck in the loop?? Regards

I have written a couple of database applications using VB6 and using the Package and deployment wizard have had no problems installing. I have just completed another small application for my sister and before installing on her computer I installed it on three other computers. Two were brand new...

Worked - Many thanks

I have a personal.xls file which is contained in the XLstart folder. This file contains all my commonly used macros. Until now I have only run the macros via the Tools/Macro/run selection. I have inserted a button on a spreadsheet (Equipment.xls)and need to assign a macro that is in...

Yes it is an older book - Murach VB.NET Database programming with ADO.NET (suspectv1). My VS is 2005 - but dataAdapter is not visible in toolbox

I am reading through a reference book for VB.NET and it mentions using the Data Adapter configuration wizard. ie Select from data in the toolbox. I do not have the data adapter displayed. Am using XP SP3 and have tried all the MDAC 2.8 (incl SP1) but still no luck. How do I get access to the...

Thanks. I am trying to change from VB6 to .NET and find things very different. My application does require the user to pick from a list of choices, but there is also an option to edit the items in the list. I thought using a combo and allowing the user to edit and then save would be easy...

When I try to change the text in the combo box the index goes to -1 I cannot even save the editted text to the dataset.

The first section is just to indicate how I am loading dataset. My problem is within the save routine - loading the combobox works fine. I can add to the items in the combo list or edit the items in the list. If I edit I cannot work out how to save the edited item Regards

I am loading a combo box with data from an access database. I need for the user to be able to add and edit what ever is in the combo. As soon as I edit the text the index goes to -1. Have attached my code. Is there an easy way to do this. ******************************************* Private...

Does anyone know if there is a shortcut for converting an Excel cell reference to an abosolute reference. Eg =F1 to =$F$1

I inserted my crosstab and now have a summary that provides my totals as required. After completing this step I realised that I might be able to use the total in the crosstab summary further. Is it possible for me to use this crosstab total to do a mathematical calculation with. For example...

Thanks will have a look at crosstabs. Have not used these before - hopefully not too complex. regards

I have created a report in VB6 (using crystal reports 8.5). VB is passing a range of dates as parameters and the report is filtered according to these dates. The report has three parts. Part 1 provides a list of dates and distances covered by vehicles in groups. The format is as follows: Report...