Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. keijen

    Checking numeric sequence - How can I?

    Thanks - I will spend a night reading the functions list! keijen
  2. keijen

    Checking numeric sequence - How can I?

    The client 1-M data, on the many side, has fields numbered sequentially from one, but this data is user-entered and errors in sequence may occur. I need to determine if, within a grouping on a sub report, all child records are in sequence from 1 up to the end of child data set. I'll send the...
  3. keijen

    Find date range overlap via SQL query

    Hi, Table: tblOnCall Fields: PKey DeptId StartDate EndDate On insert or update of a new record, I need to count how many records have any part of the new record date range overlapping any part of a date range in the table, for the matching DeptId. There...
  4. keijen

    Inconsistent field display on separate machine.

    OK - found it. The old printer dirver trick, had to widen filed a 'half-click' and it shows up OK.
  5. keijen

    Inconsistent field display on separate machine.

    This is weird. I have a vbscript formula in a subreport, which returns amongst other data, a date. Machine 1. On running the .rpt directly, the date is displayed correctly as expected. On calling .rpt via browser session using ActiveX, (latest version), date is blank. Machine 2 Both ways...
  6. keijen

    Pass ASP dates to CR in Selection formula??

    Thanks, I'll certainly retry that way. I ended up with this tangle to get a result... ' *********** Date Selection and format conversion ******** XtalSdate = Cdate(request.form("StartDate")) XtalEdate = Cdate(request.form("EndDate")) ' *** Syear =...
  7. keijen

    Pass ASP dates to CR in Selection formula??

    Via an HTML form I am collecting two dates. The vbscript (ASP) gets the dates thus: ' *********** Date Selection ******** XtalSdate = request.form("StartDate") XtalEdate = request.form("EndDate") I wish to send these dates to a report via -: ' *********** Send...
  8. keijen

    Format - Not Validate - possible with JavaScript?

    If you google for anyMask you'll find a good script that allows you to mask inputs of almost any kind.
  9. keijen

    Validate For Military Time

    <HTML> <head> <SCRIPT language=&quot;javascript&quot; type=&quot;text/javascript&quot;> // anyMask found on web library function anyMask(event, sMask) { var KeyTyped = String.fromCharCode(getKeyCode(event)); var targ = getTarget(event); keyCount = targ.value.length; if...
  10. keijen

    Time validation - at onblur

    We need a javascript military-time validation function. We've looked at samples from many places but there is no generic function that just sits and allows us to offer 'invisible' useability. The best date validator we've found, for function, useability and adaptability is Richard Gorreman's...
  11. keijen

    Formulae in Selection Criteria

    Learner having problem using a formula in a recordset selection: I have a (Basic) formula to set an onschedule flag: Dim OnSchedule as String OnSchedule = &quot;1&quot; 'now check out actual project, to set If {ProjStatus.ProjStatDesc} <> &quot;Completed&quot; Then OnSchedule =...
  12. keijen

    Refresh textbox on listbox onchange

    This is so basic it's embarrassing to ask, but I've never used one line of JS before. I have a select listbox and when client uses it, I wish to refresh a text box conditionally according to the content selected in the listbox. The textbox is on the same form. e.g. Listbox option value is...
  13. keijen

    Round / Truncate

    Thanks to you both - CAREFUL reading of the Help file for ToText does indicate the function will work stand-alone. I should have picked it out. I had stuck in the truncate/round mindmode and .....? Grateful!
  14. keijen

    Round / Truncate

    Why does this return me 24.00 and not just 24? if Count ({divisions.divname})> 0 then &quot;For all divisions there are &quot; & truncate(Count({divisions.divname}),0) & &quot; projects&quot; The Count({divisions.divname}) is a summary in the report footer. The values are correct, I just...
  15. keijen

    How to handle NULL parameters from HTML form

    Called off: OK, I sorted it, but not without some gritting of teeth. 1. Found and switched on the &quot;Convert null field value...&quot; flag in Report Options. 2. Changed the test in the select code to test for a zero for an Access database. It may not be the best way, I'll return to it...
  16. keijen

    How to handle NULL parameters from HTML form

    I'm new with Crystal ( one week) and I'm tied up here and would love some help. An HTML form collects three params from client, one text, two numeric values captured by the form. Any one, or two or all three can be null, i.e. if client selection is for &quot;All&quot; options in any of the...

Part and Inventory Search

Back
Top