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
  • Order by date
  1. Whooo

    using a field in a hyperlink

    Thanks for your help, I will try it out in the morning Cogito ergo sum - I think?
  2. 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...
  3. Whooo

    updating a field using datediff

    thanks for the explanation and suggestion, in the past I used the "s" parameter to get seconds then divide by 60 and then the result by 60 again to get the number of days. It seemed to work on hours within the same day. Cogito ergo sum - I think?
  4. Whooo

    convert a number into time format

    thanks for your help it takes care of the formatting, Cogito ergo sum - I think?
  5. Whooo

    updating a field using datediff

    Thanks, I am using it to determine the time difference and it works okay. It is the issue of when I save it to a number field it rounds up but when I save it to a text field it works, It also works when I do a query. It is only when I do an update to a file that it doesn't seem to work Cogito...
  6. 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...
  7. 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?
  8. Whooo

    import an rtf file into access table

    I imported the file into word then saved it as a text file then used getdata and import and made sure the field was a text field and it worked. Cogito ergo sum - I think?
  9. 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...
  10. Whooo

    date picker error

    Thanks for the help, works like a charm. Regards, Whooo Cogito ergo sum - I think?
  11. 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