Search results for query: *

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

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

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

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

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

I am upgrading a VB6 database application from Access to SQL Server. I am using MSDE2000 as my test engine. I converted the Access database to mdf and log files and have been successfully completing queries until I included update or insert queries which included dates. I get a runtime error...

I am upgrading a database application that I created a couple of years ago, so that it can operate on an SQL server. It used an Access Database previously and all my database operations used commands similar to: sSQL = "SELECT etc", "INSERT etc", "UPDATE etc" or "DELETE etc" Set rsado =...

After reading many of the articles in this forum I attempted to create an ADO connection to a database attached to MSDE2000A. I am using VB6 and have referenced ADO 2.8 library. The using the SQLOLEDB.1 provider, the connection opens but when I actually execute the line: .Open sSQL, Con...

A friend (??) has asked if I can help them fix an Access report that is not producing correctly. The version they have is 2002/2003 and they use it to manage their business. They produce a main report in the "details' section and a summary report in the Report footer section. My knowledge of...

After searching for information on how to import data from Excel to Access I am now confused. I am using VB6 (on XP) and have set up an ado connection to the required Excel spreadsheet. I wrote a query but could not figure out how to specify which worksheet to import from - so I started...

I am about to make the conversion from VB6 to VB.NET - just have not had time. I have a few books to help me and I have 2 copies of Visual Studio Professional 2003. One copy is a 60 day trial that came with SAMs 'Teach Yourself Visual Basic.net 2003 in 24 hours", the other copy is a legitimate...

Hi, I am still using CR8.5 and VB 6. I am passing a date from VB to CR using the entry: TaskReport.parameterfields.getItemByName ("SelectDate") .AddCurrentItem dTaskDate Taskreport is my report object and SelectDate is the parameter within the report while...

I have a report that has several text fields in the page header. The text fields are labels for column data that is being presented. In the group footer I am also presenting a couple of charts. Is it possible to turn off (suppress) the text fields that are in the page header so the user does...

I am using VB6 and CR8.5. My VB application creates an access database then creates the fields within the database. My problem is that the number of fields varies depending on what the user wants to report on. For example the table would normally have fields: RptDate, Section and Hours...

I have a couple of input/output expansion cards connected to my parallel port (LPT1). I am having troubles with communications between the port and cards and require a utility of VB code that allows me to see what is being passed between the port and cards. Is anyone able to provide me with...

I am using VB6 and CR8.5. I am creating a report from a flat database but a couple of the fields in the database are created during runtime. The number of fields depends on what the user has entered in some other table but it could be up to 2 or 3 extra fields. Before the table has fields...