Search results for query: *

I would have put it in the Lead Time field under arrive. I may have taken it out because it didn't work, but that's where I had it. I just copied and pasted it in. WG

There aren't any differences between the your and mine. Does it have to do with were I put the script in the form? WG

I copied it into a new script and ran it. I tried a couple times and it worked. WG

What script do you want? Any script associated with the form should be in that file. WG

The Windows Time is set to the format 1:20:00 PM. I don't know how it would have changed if it did. WG

I copied it straight from the board. Would it still be something to do with the format of the string? Weather Girl

I inserted it into a new blank script and it does the same thing. I changed the minutes field to a number and I still get the longInt. Weather Girl

I think I changed everything to the same time format. When I use the format I have everything in it gives me all the data like I didn't even enter any search parameters. Weather Girl

I'm still having problems with the format. The query works when I use HH:mm:ss but it comes up with no data even when there should be. Is it not able to read the times because of the different formats? Weather Girl

It didn't work sorry to say. The view box of the number comes up with a "default" value that appeared the 1st time I used it, but it never changes. Then it inserts a number like 599940 when there's a difference of twenty-five minutes. I tried changing a couple things but that only...

I put in 5:40 PM for the start time and 5:50 PM for the end time. In the tot minutes it calculates 12:09:59. It seems to not round up the seconds and I don't need the hours or the seconds on there. Just the number of minutes. Weather Girl

I found that using HH:MM:SS works to run the query manually. I tried adding the AM or PM but then it gave me an error of missing comma. So I need to add the :ss to the string, but how do I do that? And what do I do with the AM and PM part? Weather Girl

I found that using HH:MM:SS works to run the query manually. I tried adding the AM or PM but then it gave me an error of missing comma. So I need to add the :ss to the string, but how do I do that? Weather Girl

It gives the correct minutes, but when I tried dividing the number was much further off. I also tried inserting the formatStringAsTime() but it gives me a syntax error when I do that. Weather Girl

Mac, This script works to a certain extent. The subtracted value is put into the tot_minutes field but it doesn't subtract the hours. I don't know if it's the format of the fields; they are all in the same format of 3:30 PM. I already have a field that does the calculation by using the field...

I tried doing the query manually and it doens't work. I'm guessing it has something to do with the format. I have the time in a format like this 5:50 PM. I tried using >= and <= to do the manual query and I also tried LIKE. Neither of them worked. Even just a simple =Time didn't work. I...

I tried using that script and it gives me an error when I run the form. It said &quot;an error occured when setting the property named 'Value' of the object named 'Lead_Time' of type 'Field'&quot;. I can't run the form when this script is inserted.

I've tried using a if statement which works to get a value to appear in the right field. But the number that appears is not the right number. The formats of the fields may be are different but I can't change them to be the same. This is the code I used: method newValue(var eventInfo Event)...

I'm calculating the difference between two times in a field on a form. I need this value to be entered in the table for further calculations in reports. I created another field to manually enter the minutes or the difference between the two times. Is there any script that would make the...

Mac, I think what you've described sounds like it might work. I've tried inserting a formatStringAsTime() but nothing happens. Where should I insert the code and what esle to do I need to do with the string variables? Thanks, Weather Girl