Search results for query: *

Thanks for your help, I will try it out in the morning Cogito ergo sum - I think?

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...

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?

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

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...

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...

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?

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?

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...

Thanks for the help, works like a charm. Regards, Whooo Cogito ergo sum - I think?

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...