Search results

Thanks your suggestions worked...

Hello I have a SQL that gives either a null or a number and I want to use it to determine opening a form. If the strSQL is null then give a message but if there is a number then open the form. How would this be written? Dim strSQL As String strSQL = "SELECT Count(tbl_YearCalendar.AbsenceDate)...

I cant get a correct result in my query. I have a field (DelayHours) and I don't want to display anything that's in the range of 9.75 to 14.17. I tried <"9.75" Or >"14.17" As my criteria and I still get the results including numbers in that range. The only thing that works but does me no...

Sorry for the delay I been off.... Last two posts worked thanks....

I get 0 I change post to fix... Also "DelayStart" is a Date/Time

Typo it was a n....

I'm trying to write a function for military time to get the short date of a date/time based on the time of the day for the shift that was ran. If the Date/time "DelayStart" is from 6am to 11:59pm then use the "DelayStart" given If the Date/time "DelayStart" is from Midnight to 2:59am then use...

Well I did some poking around on that PC and its coming from Wonderware that Im guessing is grabbing it from the PLC. I know there is always a Intouch/Window viewer that is open that displays the start/stop ect times for each machine and its always correct. Any thoughts on how I get the info its...

For one im the only one that somewhat knows a little about access and two the guy that wrote it left the company about 12 years ago. So with that being said i would love to know how the stat time funtion works. Throw me a bone if you have time.... Thanks!

@The_Doc_Man I put break points at the line in question and opened the Locals Window and the image does indeed show the start date is 00/0/200 00:00 Suggestion's?

What could I use instead? Like I mentioned the dates are coming from a PLC which I have no control over and I have no idea how the functions work.

Date and time.... Below is the function that pulls the Date and time for each record. I have no idea whats its doing or how to grab data from a PLC this was written years ago and has never worked Im trying to get it to work... Public Function getDelayStartForRecord(ddeChannel As Variant...

Yes and on that line: DelayHours = RoundTo(DateDiff("n", plcDelayStart, plcDelayFinish) / 60, 2) the values of the plcDelayStart was 00/00/200 and same for plcDelayFinish 00/00/200

Hello, I just cant figure out why im getting these errors! I know its a date field but don't know why. The data is getting pulled from a PLC and by looking at the code it gets converted into a date/time. I tried in the error handler to skip the Error 13 to see what it did and then it gives a...

Hello, I have a series of Public Subs that run and collect data to a table tbl_Delay like below. How do I add saving the same data to a temp table called tbl_TempDelay and I can figure out the clearing of the temp table before the new cycle runs. What needs added to save the same data to the...

@theDBguy I got it working with Me.TimerInterval = 1000 In the on load event

After creating the example I noticed the Form_Timer doesn't run upon opening the form then after it "Does stuff" start the countdown from 10 min and repeat. What am I doing wrong?

Here is an example

I got it... In the button to restart and to run code again I just had to use: StartCount = 0

Ok thanks... But it still isnt doing what i needed it to do. It runs the timer when the form loads which is correct it runs again after 10 minutes which is correct The only thing that isn't correct is when I click the button to manually run the code in the form's timer it just stops the timer on...