Search results

Thank you jdraw. That did work but I still wonder how I get around the cosmetics of still having four decimal places, the last place now being zero without actually changing the Decimal Places property under a Fixed format.

I have a subform that displays doubles in a textbox as fixed with 4 decimal places as default. I have been trying to change the number of decimal places based on the value in a textbox on the main form. I have tried this: Forms![Main Form]![Holder_subform].Form![Final PCT].[DecimalPlaces] =...

I have a simple subform that shows an address block. Created as a form, the can shrink property does not kick in. Created as a report, it works fine. All controls and properties and query they are based on are identical. The report pasted into Access 2010 works fine and missing fields shrink...

Unreal!! I wouldn't have believed it. Even though you dim it as a long it wants a string. It certainly does work. Thank you so much Mr. Texas.

I gave that a try too and while it may be contributing to the problem, I am still having the memory problem, Error 7. I thought that perhaps I was doing too much at once so I made the table for updating and tried to run just the last part. Same error. Running the query "SELECT * FROM...

Thanks for the response. VB.Net I've removed the actual query strings in strSQL as they are long but work well. I'm using access to run the query because my queries contain user defined functions and as far as I know, that is the only way to use them in the query. And yes, my error trap is very...

I am opening an access db using vb.net from arcview. I open the db, perform a couple of make table queries and then add a new empty integer field into one of those tables and all performs properly. The problem comes when I try to update the new field based on other fields in that table. Below is...