Search results

  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

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

    calling mathematicians

    x^4 = 1.02, solve for x. how is this done? and how do you check it?
  4. 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...
  5. 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])
  6. 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...
  7. 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...
  8. 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?
  9. I

    determing if a report has been printed

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

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

    what unit of measurement is it? cause i need to convert it to inches.
  11. I

    ah! listview

    so i set the first column of the listview 0, but if i click a record and just do a simple press or a quick press, the first column shows up. is there a way to disable this?
  12. I

    good sample

    is there a good sample to attach a photo to an unbound attachment field? i have a mysql backend. i've been looking for samples but all i have found so far was a way to open it. i was wondering if anyone knows how to properly do this. thanks.
  13. I

    appending a table in my front end to my mysql back end

    hello. i am having trouble with this code, the reason being is that i am referencing the table in the front end wrong. can anyone help me correct it? Private Sub cmdsave1_Click() Set cnx = New ADODB.Connection With cnx .Open "DRIVER={MySQL ODBC 5.1 Driver};" & _...
  14. I

    retrieve last autonumber from append and use that as FK for another table

    so how is this achieved? how do i retrieve each pk from an append sql statement and use that pk as an fk for another table used to combine it with another record. say a phone number and a client.
  15. I

    s.o.s please! something odd happend

    Function startRowSourceZipCode() strStartSql1 = "SELECT qry_city_state_zipcode_01.id_us_zip_code, " _ & "qry_city_state_zipcode_01.uszipcod_city, " _ & "qry_city_state_zipcode_01.usstacod_abbreviation, " _ &...
  16. I

    i have an unbound form and a vba recordset

    so my question is this: i have an unbound form that has fields for phone numbers, sometimes the record has more than 1 phone number per client. how do i fill the unbound text boxes on my form when the recordset is filtered for a specific client who has more than 1 phone number?
  17. I

    argh! stops working when connecting to mysql LAN server

    so why is this happening? my thing is weird. for some reason, when i link the tables on the mysql server ms access stops working! any ideas?
  18. I

    need help with loop inserts with mysql

    so i am getting an error 438 with this one, anyone take a second look and tell me what's wrong? can't think straight at the moment, having gout attack :( Set ctl = Me.lstregclass For Each varItem In ctl.ItemSelected strSQL = "INSERT INTO...
  19. I

    is this possible?

    so am just wondering, is it possible when you have a modal form open the form behind/below it will turn to gray?
  20. I

    how to would this be set?

    so i have this connection settings each time i update, insert, delete something in my record though i realized when the application is placed in our LAN server i would have to change the user and password as well as host, is there a way or how would this be set each time the application starts...
Top Bottom