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

Thanks for taking the time to reply, chrissie1. I think you might misunderstand my question. I can get the record to add and it automatically assigns a new consecutive number to the autonumber field. I just can't get the value of that new autonumber. It always shows as zero. I have searched...

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

Sorry again, I was wrong about references in my first form being messed up. It appears as long as I use me. it seems to be OK.

Sorry, but this is getting more complicated. What is the difference between application.run(something_else) vs something_else.showDailog(). It appears that my initial startup screen which was called Form1 now has to reference everything as something_else????

That worked. Thanks TipGiver. I am not sure why it didn't work when I did "Public Form1 as New Form1" but that did not work. You have to use a different name. Thanks again.

Thank you very much, I understand what you are saying but I am new to VB.NET. How do you add a sub main to the program? Do you know, without spending much time on it, how the solution would include the .showdialog ? Thank you very much, again. It must be gratifying to be able to help...

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

Yes, I do understand. It looks like the compactdatabase will accomplish the fix. I thought that ADO would have a specific error number for the unrecognized database format but I will just try the compactdatabase when the program first opens the database and an error occurs. Thanks for all of...

Just for clarification, I use ADO to access the Access2000 database when I open the program. If that database is corrupt, I get the 'unrecognized database format' which I can't find any documentation on. I want to trap that error and then repair the database, like you can do using Access2000...

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

Hi bjd4jc, The above works if you have defined the recordset in code using set x = new adodb recordset. But I made the mistake, apparently, of using the ADO data control. It seems when I use the data control versus creating the recordset in code I get the error mentioned in my initial post...

Thanks for taking the time to respond to my inquiry. In regard to not using a select in the open. I used the following: rv.Open "dogmstr", PetsCN, adOpenKeyset, adLockPessimistic but this returned all of the records in the database (I used the recordcount to see how many...

Thanks very much, makeShift.

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

Just FYI, Originally, opened the record set and then did a form show. I put the opening of the recod set in the activate section of the form and then the first cell was not blank. Joe.

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