Re: how to call function

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

From: Lynn Trapp (ltrappNoSpam_at_ltcomputerdesigns.com)
Date: 03/01/05 

Date: Tue, 1 Mar 2005 13:42:47 -0600

It looks like Access is recognizing "seconds" as a field in the recordsource
of your form and, thus, adding the brackets. When you say you "can't 'call'"
the function, what do you mean? Do you get an error message? 

-- 
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
"eb1mom" <anonymous@discussions.microsoft.com> wrote in message 
news:303e01c51e8e$fde7e6b0$a601280a@phx.gbl...
>I found a function that will convert seconds to text. I
> copied the code into a forms module. It works very well
> but, when I put the code into a standard mudule. I can't
> "call" it. The function is named "secondstotext(seconds)"
> and on the form I have an unbound text box named seconds
> which is date diff in seconds between starttime and
> stoptime fields on form. In another unbound text box I
> tried to put =secondstotext(seconds). It was automatically
> corrected to =secondstotext([seconds]). What am I missing
> is this some sort of restriced access word problem? any
> help would be apppreciated. thanks

Relevant Pages

  • Re: Simple calculated field problem
    ... and avoid the use of the VBA DateAdd function. ... I get an error message that reads: ... view but not in the design grid view. ... the statement have square brackets, such as MeasureDate and FatPC, ...
    (microsoft.public.access.forms)
  • Re: 1 Subform feeding into 2 tables
    ... this is the error message that comes up: ... frmMain (includes all fields from tblMain) ... frmLong (using a select statement in the recordsource property I include ALL ... the SRID from tblMain was linked to both SRID fields. ...
    (microsoft.public.access.forms)
  • Re: Strange Response to Combo Boz Selection...
    ... It's an unbound combo box. ... I saw another post regarding this error message and that person had no idea what was causing it either. ... It's just this weird new message Access has chosen to ... >> Why is my ContactID value no longer valid for my combo box field? ...
    (microsoft.public.access.forms)
  • Problems with Date() on forms - Help Please
    ... desired criteria from combo boxes or fill in unbound text boxes. ... To my knowledge I have not done any of the things the error message is ... yet I do see it on the client computers. ... Textbox control. ...
    (microsoft.public.access.forms)
  • Re: One query to two tables (?)
    ... subform gets treated as two recordsource. ... I intend to insert in new record through one form and sub form - both ... unbound - so that user that it does not know of the existing data. ... Dim rs As DAO.Recordset ...
    (microsoft.public.access.queries)