Thanks. I feel like a dummy. The data type in Access was Number but the decimal places was set to Auto. Once I changed auto to 2 it worked.

When I enter a decimal into a field by the time it gets written to a recordset it has been changed to zero if the value is less than one and it is rounded up if the value is greater than one.
Any...

I am using an access 2000 database which is on my hard drive. I've created the database and a vb 5.0 program for my small home improvements business. I use it to make bids and to keep track of...

All of a sudden I'm getting this error message in vb 5.0:
Run- time error '3027' Can't Update Database or object is read-only.
Can anyone help me with this?
Thanks

I figured it out. This is the solution:
[If DBGrid1.DataChanged = True Then ....]

Could someone please suggest a way I can get the following sub to work? I'm trying to check to see if a field in a datagrid has been changed. I get runtime error 424 Object Required.
Thanks
...

Got it. Thanks

How can I run some code when I click on an arrow of a data control?

Thanks!

The following code comes up with a number that has 13 digits past the decimal point. How can I cut this down to 2 decimal places?

[Let drivetimeexpense = (rstdrivinginfo.timefromhome *...

Thanks, Veena. That did the trick. Could you tell me how i can concatenate 2 vb fields into 1 excel cell?
Thanks

Thanks. I'm using vb 5.0 so I don't know if I could use that method. I tries Veena's tip and got it to work. Thanks

From the posts in this website I see how to open an Excel spreadsheet from VB 5.0 but I don't see any examples of moving data (not an array) from vb to excel.
Can anyone show me an example?
Do you...

Thanks, Veena - can you suggest a book that would have information such as you gave me?

How can I stop processing in a sub so that the user can choose an option button for input?

How can I tell when vb executes something that I don't know about, such as this onchange?

My vb 5.0 program is adding 2 identical records to a table each time I run it. Does anyone know what would cause this?
Thanks

The enable property was set to false and once I changed that the problem went away.
Thanks

Has anyone ever had a form freeze up in vb 5.0? When I run by program the form is displayed in the smaller size and the 3 buttons at the top of the screen (the minus sign, the box and the X) are not...

Thank you very much!

Comatose - In order to simplify things as much as possible I created a new folder on my C drive named testdatabase in which I put a database created in Access named db3. This contains a table named...

I am trying to refresh a data control but I keep getting the following message no matter what I try:
Run-time error 3464
Data type mismatch in criteria expression.
If I leave the where clause out...

Guess I need to be told twice. Thanks!

The message box has two buttons - 'OK' and 'Cancel'. How do I access the flow from the 'Cancel' button. Thanks

I have an input box in my program and I want to be able to control the flow when the 'cancel' button is pushed. Any help would be appreciated.

I've created 2 tables in Access and have created a form for each table in VB5. Each autonumber field is the primary key of it's table. When the first form comes up the autonumber field has a value...

I've got a bunch of fields displayed in a form and I can change them on the screen and the changes are saved in the database. How can I make them so they cannot be changed?

Thanks, that got me going again.

How do you pass the data in a field on one form to a field in another form?