Re: How Can I Pre-Process Data in a Bound Control?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

If you are interested I have a popup four function calculator that here
http://www.WorksRite.com/Calc.htm that you can easily bind to your text box.
when activated it uses the existing value and format of the field, allows
the user to perform any number of simple arithmetic steps and save the value
back your field when closed. Perhaps not exactly what you were aiming for
but, might get you where you want to go. The calculator is a 100% Access
solution with no Active X installation hassles.

--
Ron W
www.WorksRite.com
"JonOfAllTrades" <JonOfAllTrades@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F040B92A-29C1-4265-89D0-2AC1F6C160AA@xxxxxxxxxxxxxxxx
> Good morning. I have a fairly simple question, hopefully someone
here
> has seen it.
> I have a form used for data entry. There is an HoursWorked control,
> bound to a numeric field. Often, a user needs to enter hours from
multiple
> line items. They can do this by adding the hours in Excel, Calculator, a
> separate control with Eval(), or of course a physical calculator, and then
> entering the total.
> I would like to engineer it such that a user can type either "4.5" or
> "1.5+2+1" and the control will understand the value as 4.5. I added
Control
> = Eval(Control) to BeforeUpdate. However, it seems Access is verifying
the
> format of the input before BeforeUpdate runs; it complains about the value
> entered not being numeric. If I enter simple numeric data, the code tries
to
> run but throws an error "The macro or function set to the BeforeUpdate or
> ValidationRule property for this field is preventing Access from saving
the
> data in this field."
> I could create a separate unbound control, but in that case they
might
> as well use their favorite Casio or TI.
> Any suggestions?
> Thank you!
>
> Win XP/Access 2K


.

Relevant Pages

  • Re: Browser
    ... At least when you get it wrong on a calculator the results tends to be ... With a slice rule this is much more difficult as all results tend to have ... calculator errors under control - allegedly. ...
    (comp.sys.acorn.misc)
  • Re: Can not reload windows components
    ... About 3 months ago I lost my calculator, ... volume control. ... components it gives me error message "copy error' ' setup cannot copy the ...
    (microsoft.public.windowsxp.setup_deployment)
  • RE: Struggling with Calculated Field on Form to Main Form/Table
    ... If you want to store a calculated value, ... My customers are supervisors and quality control staff who are accomplishing ... The supervisor will use my form much like a calculator to determine ... fldnumberofactualdays (unbound) NumberFullDays ...
    (microsoft.public.access.forms)
  • Re: How Can I Pre-Process Data in a Bound Control?
    ... not a spreadsheet or an electronic calculator. ... you can use an unbound control but that will work easily only ... > format of the input before BeforeUpdate runs; ...
    (microsoft.public.access.formscoding)