Search results for query: *

I would like to be able to show unique building layouts and then indicate whether a room is vacant or not based on database information. Is it possible to program that or are there software tools out there that might accomplish this? Thank you for any helpful advise. I appreciate your help. Joe

I have an access database that I am adding data to with a dataadapter and dataset with the following code: Me.DstOwnerInfo1.Clear() Me.oledb_adaptOwnerInfo.SelectCommand.Parameters ("ownerid").Value = 0 Me.oledb_adaptOwnerInfo.Fill(Me.DstOwnerInfo1) OwnerBindingManager =...

I have a startup form that allows a person to select an existing record from a datagrid. After you select a record to change, the second form displays the details of the selected record in a text box format. Once the update button is selected on the second form I want to update that record in...

Now and then my Access 2000 file is corrupted and I have to run the repair utility in Access 2000. Is there a way to do that in VB6 code? I did see a posting that said to use repairdatabase(databasename) but what is that? What error code do you check for when you get the unrecognized database...

I am using VB6 and ADO 2.5. When I open a recordset where I will be doing an addnew I have been using a select like "select * from database", which I assume fills the recordset with all of the records from the database. It seems like a waste to fill the recordset with old data when...

I use a recordset created by using an ADODC. The problem I am having is that when I try to set the recordset to nothing to release all of its' resources from memory, I get an error "data source name not found and no default driver specified". If I create the recordset in code I can...

I use VB6, ADO 2.5. I have an ADO data control and a datagrid. Originally, the connection string and the record source properties were in the data control and things worked fine. I changed the connection string and record source to be set by the program. Now the first cell of the datagrid is...

I am using Installer 1.1 to package a VB 6 application. It installs OK on Windows 2000 machines but on machines with Windows 98 I get a message that at least version 2.5 of MDAC must be installed first. How do you get the installer 1.1 to install mdac 2.5. Using the VB package and deployment...

I am using the Visual Studio Installer 1.1 to deploy a VB 6.0 application. It seems to install OK on windows 2000 machines OK, but on SOME Windows/95 I get the error message MDAC 2.5 needs to be installed. I thought it was because DCOM 98 was not installed but that does not seem to be the...

I am using vb6.0 and crystal 7.0. I used the .datafiles(0) option of the crystal control in VB to change the main report input table which seemed to work OK. But I can't figure out how to change the two subreport input tables. I tried using .datafiles(1) and (2) but that didn't work. How do...

I am using VB6 with ADO 2.1. I have a datagrid connected to an ADODC. I am currently using the Adopenkeyset cursor type, the adUseClient cursor location and a select * in the record source but it is veeery slow on networks. I am testing this on a standalone. When I change the cursor location...

I am running Crystal Report 7.0 through a crystal control in a VB program. I have packaged and deployed it to a user. The reports run fine on some of the users machines but when setup on a recently purchased machine the user gets the runtime error 20599 can't open sequel server? It must be a...

I am using ADO 2.1 in VB6 and an ACCESS 2000 database. I have three ADODC's on one form each connected to the database in different sequences. The ADODC's are connected to datagrids. If I disable the ADODC control will it still be populated and therefore the datagrid when the form is loaded...

I am using VB 6.0 and a datagrid. In Access you can select the first record you want and then press the shift key and select all records between the first and last record. Does anyone know how you can accomplish this in VB? (other than selecting each record individually) Thanks for your help.

I currently clear the bookmarks in my datagrid by doing a refresh but need a different way to do it. I would appreciate any help. Thank you.

I am using ACcess 2000, VB6.0. I can select records from a datagrid one at a time and process them by using bookmarks but how do I select a group of records like you can in Access 2000 by selecting the first record and then pressing the shift key and selecting the second record and all of the...

I am using an Access 2000 database, ADO 2.1 in VB 6.0. I have an ADODC control hooked to a datagrid. When they select a record and change something I use the adodc.recordset.movenext and that should update the Access 2000 physical file right? I am basically confused on what updates what...

I am using VB 6 and updating an Access database with ADO. I am doing an Update to the ADODC. Then I do a movenext and then a moveprevious, so I make sure I am updating the database. I then call the crystal report, where I am printing a license that should show the new dog tag number that I...

We know by using the OnError command we can determine what error occurred but don't know what statement in what procedure is causing it. Any help would be appreciated. Thanks. Joe.

We are using VB6 and ADO 2.1. We are using the ado recordset.update and then doing an ADO refresh. We then use a crystal report control to execute a crystal report that uses the mdb file. Mainly we do this before printing a payment receipt but it appears that the payment detail doesn't always...