Recent content by custsoft

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