Ms Access Input Box
For the point of sales app I want to use the input box because for Tax purpose because the tax rate keep on changing year in year out , what I want to do is to hard code the txttax control to be only receiving percentages not absolute values , how do I do it? For example I want to be seeing rates like 10% , 16% etc whatever is applicable not values like 10,16 etc.
Private Sub ProductID_AfterUpdate()
Dim s As String
s = InputBox("Tax Value required", "Internal Audit Manager ", "Tax Percentange")
Me.txtTax = s
End Sub
Regards
Chris
Private Sub ProductID_AfterUpdate()
Dim s As String
s = InputBox("Tax Value required", "Internal Audit Manager ", "Tax Percentange")
Me.txtTax = s
End Sub
Regards
Chris
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You are welcome!
Strongly disagree with this concept. Allowing (requiring) users to enter this data is a recipe for error and corruption.
Tax rates should be stored in tbl_TaxRates which includes columns like:
Locality - may not be needed
Type - (state, local, ...)
Rate
EffectiveDate
ThruDate
Tax rates should be stored in tbl_TaxRates which includes columns like:
Locality - may not be needed
Type - (state, local, ...)
Rate
EffectiveDate
ThruDate
ASKER
Regards
Chris