Search results

  1. oxicottin

    Solved Check SQL for number

    Thanks your suggestions worked...
  2. oxicottin

    Solved Check SQL for number

    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)...
  3. oxicottin

    Solved Query criteria between two hour/decimal numbers

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

    Solved Get date based on times

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

    Solved Get date based on times

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

    Solved Get date based on times

    Typo it was a n....
  7. oxicottin

    Solved Get date based on times

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

    Solved Error 13 then 3421

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

    Solved Error 13 then 3421

    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!
  10. oxicottin

    Solved Error 13 then 3421

    @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?
  11. oxicottin

    Solved Error 13 then 3421

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

    Solved Error 13 then 3421

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

    Solved Error 13 then 3421

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

    Solved Error 13 then 3421

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

    Solved Temp Dynaset subform

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

    Countdown Timer with reset button

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

    Countdown Timer with reset button

    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?
  18. oxicottin

    Countdown Timer with reset button

    Here is an example
  19. oxicottin

    Countdown Timer with reset button

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

    Countdown Timer with reset button

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