AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Go to next record from nav bar access12/26/2023 Have you considered enforcing checking of validity of the data at the point the data is entered, rather than ignoring false inputs? If you prevent non-numeric entries at the time you can correct the user at the time. I don't find it 'strange' at all, they have, afterall provided the 'Controls' statement to use, and accept strings as control references, so it actually seems to be perfectly logical to me. Tgbyhn10, thanks for introducing me to this method of referencing controls. If IsNumeric(Me.Controls("unitprice" & intControlIndex)) And IsNumeric(Me.Controls("Quantity" & intControlIndex)) ThenÄQuoteTotal = dQuoteTotal + Val(Me.Controls("unitprice" & intControlIndex)) * Val(Me.Controls("Quantity" & intControlIndex)) If Not IsNull(Me.Controls("unitprice" & intControlIndex)) And Not IsNull(Me.Controls("Quantity" & intControlIndex)) Then If there is a problem why can't access display a message and tell me what it is - access is so pants. ![]() Also if I don't move a value to the field I can move around the table OK. I know this field is the problem as if I unbind it I can move around the table without problems. I don't get an error but I know that system does not like the value I am moving to the bound field as it takes 2 presses on the navigation bar to move to the previous / next record. I am calculating a value in a currency type field in my code and moving that value to the bound database field. I am displaying that value on a form as a bound field. ![]() I just added a currency field to a table 2 decimal places default value 0.
0 Comments
Read More
Leave a Reply. |