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 Rhinorhino 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: *

  • Users: Whooo
  • Content: Threads
  • Order by date
  1. Whooo

    using a field in a hyperlink

    On a form, the user inputs a symbol, i.e. HLT for Hilton. I would like to use this field in a hyperlink to go out to a web site and do a lookup. I have created the command button to do the hyperlink but need to figure out how to add the symbol. I need to add s={whatever the user enters in the...
  2. Whooo

    updating a field using datediff

    when updating a field that is a text field using the datediff function, decimals are displayed. when updating a field that is a number (fixed 2 decimals) the datediff updates the field with a rounded number (no decimals) go figure? datediff("m",[start],[finish])\60 start is a text...
  3. Whooo

    convert a number into time format

    I have a long integer field that I would like to convert to a short time field. the field is called start and it contains starting times such as 830 or 2300 I have tried several different steps with no luck. THanks for suggestions Cogito ergo sum - I think?
  4. Whooo

    import an rtf file into access table

    I need to create an Access table and populate it with two fields from an rtf file. Any suggestions on an easy way to import in the rtf data. I have loaded the file in Word, saved it as html, asci and copied and pasted into Excel all without success. Data drops off or doesn't convert fully when...
  5. Whooo

    date picker error

    I added the ActiveXCTL dtpicker to a form and as long as it is'nt tied to a control source - a field called workdate, I have no problems with the form. When I designate the control source and use a command button on the form to add a new record (DoCmd.gotorecord , , acNewRec) it adds the blank...

Part and Inventory Search

Back
Top