Search results for query: *

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

I tried this but get the following error when I check the formula: This array must be subscripted. For example : Array[|] I have cut back to just one parameter and used as follows: Purchase.date = {?PM-?PRStartDate} - this works fine. Purchase.date >= {?PM-?PRStartDate} - this fails. I do not...

I am using VB6 to pass two datetime parameters to a crystal reports (8.5)main report. This works fine. I then have a sub report that I also pass these two date parameters to. The dates are a startdate and enddate. The sub report is connected to a table with a date field and I have selected...

I have an ACCESS database that logs distances (in a Table Log Sheets) travelled by vehicles on particular dates. I created a report (DistReport) that allows the user to enter start and end dates and provide a detailed listing of all dates and distances travelled for each vehicle, then at the...

You are correct - I am actually using the ODBC connection to connect to the SQL server. What I meant, was I find I now need redesign to allow the user to connect to the server they want. I do realise CR8.5 is old - my next step is updating to .NET - wont that be fun. Thanks for your reply...

I am using VB 6 on XP and Crystal 8.5. My application has been successfully using an ODBC connection but I now find I need to redesign to connect to an SQL server based database. I have been reading all the info I can find and it looks to me like I need to create a Field Definition File. The...