Recent content by icemonster

  1. I

    how to store an entire query (single field) in an array and check it's values.

    ello. basically, what's the best practice or how do we store a query's value into an array then checking what the max or min value is and how to check if let's say "4" is in the array? thank you!
  2. I

    Open Cash Drawer through VBA Command

    you'll need the api or the driver for the cash drawer and simply call that to initiate the opening of it.
  3. I

    creating a function that counts records and use that function in a query

    so basically i need help making a function that will help me count the number of records from another table/query based on a field from the current query. can you guys show me a sample or point me to the right direction? thank you.
  4. I

    calling mathematicians

    not quite, you see when that answer is .255, but when you raise to ^4, it gives something else entirely.
  5. I

    calling mathematicians

    x^4 = 1.02, solve for x. how is this done? and how do you check it?
  6. I

    counting a specific record and inserting a row in excel to get the count

    so i have a vba sql string that i export to excel and it works fine, grouping and everything. what i want to know is let's say there are 3 statuses, paid, pending and received, basically in my excel i want them grouped and counted without having to go through a report and just using vba to...
  7. I

    help rewriting this query

    hello. basically what i am trying to do here is that if the date is not equal to current date, reset count or something to that effect. (Select count(*) from [qry_01] where [id_employee] = a.[id_employee] and [datex]+[timex] <= a.[datex]+a.[timex])
  8. I

    help regarding this query

    SELECT [EMP ID], [DATE], [TIME], (Select count(*) from [tblPunchCard] where [EMP ID] = a.[EMP ID] and [Date]+[Time] <= a.[Date]+a.[Time]) AS Num, iif(Num mod 2 =1, "In" ,"Out") AS InOut, iif(InOut="In", Num, Num-1) AS Pair FROM [tblPunchCard] AS a; i found this code on this site and i am...
  9. I

    punch card query

    so i have this data 8888 03/08/2013 16:41:55 8888 03/08/2013 16:42:00 8888 03/08/2013 17:44:00 8888 03/08/2013 18:54:00 22574 03/08/2013 16:59:14 22574 03/09/2013 14:01:40 8888 03/12/2013 09:25:58 1130 03/12/2013 17:19:32 816 03/12/2013 17:19:56 971 03/13/2013 08:28:33 816 03/13/2013 09:11:28...
  10. I

    mysql back end insert problem

    ok, i'll give yours a shot, but hwo do i specify the connection?
  11. I

    mysql back end insert problem

    strSQL = "UPDATE tbl_client SET " _ & "cli_medical_record_no = '" & Me.txtmedrecno & "', " _ & "cli_lastname = '" & Replace(Me.txtlastname, "'", "''") & "', " _ & "cli_firstname = '" &...
  12. I

    mysql back end insert problem

    i have a field that i encrypt using AES but the trouble is with some certain special characters it doesn't seem to work. any ideas on how to get around this?
  13. I

    argh! stops working when connecting to mysql LAN server

    actually the problem was the driver, i used (during the time of the problem) a new released version of the driver which had bugs that's why it crashed. but it's alright now.
  14. I

    determing if a report has been printed

    does anyone know of a good method to determine if a report has been printed?
  15. I

    what unit of measurement is used to set the width in the listview?

    hmm not sure if it's cm because tried converting it and it was a lot, cause when i use set my listview it's something like this: With Me.lvemployees.ColumnHeaders .Add , , "Emp ID", 1000, lvwColumnLeft '// the 1000 here is definitely not cm. .Add , , "Employee", 3500...
See more
Top Bottom