Search results for query: *

I have one table, PEOPLE, with names id nameLast nameFirst 000003 Sherwood Hugh 000004 Walter Wolfgang - 01 000005 McFadden Bruce - 01 000006 Power Des another table, TELE_LINK, with phone numbers and emails idPerson idTeleType useAreaCodeFormat numberOrAddress 000003 01 -1 2505463008 000003...

thank you for your help. i had to do it in two steps: Select Case cmbMONTHS.Text Case "JANUARY" myMo = 1 Case "FEBRUARY" myMo = 2 Case "MARCH" myMo = 3 Case "APRIL" myMo = 4 Case "MAY" myMo = 5 Case "JUNE" myMo = 6...

thanks, you are right - now it says 'undefined monthname function'. is anything wrong with 'UCase(MonthName(Month(DATE1)))'? http://www.techonthenet.com/access/functions/date/monthname.php it doesn't give me error when run directly in ms access as query

there is no data - recordcount is null (not zero), fields.count is zero

well, in the vb code i just changed one line with the sql (i updated an existing, working code). nothing else has been changed (connection, variables, etc). instead of running 12 different sql queries in ms access based on selected month, i try to run just one updated query from vb code. i am...

i have this sql in my vb6 program sSQL = "SELECT [LUMBER].[INV] AS INV_NUMBER, Sum([LUMBER].[VOLUME]) AS _VOLUME, Sum([LUMBER].[TOTAL]) AS _AMOUNT, [LUMBER].[CUST] AS CUSTOMER, LUMBERD.MIL, LUMBERD.COND, LUMBERD.SPEC, LUMBERD.USD, LUMBERD.NOTE From LUMBERD Where...

excellent, thanks. this is the proper format: sSQL = "SELECT Count([WDATE]) From WHOURS Where [EMPID]=" & EMPID & " AND [WDATE] Between #" & DM31 & "# And #" & DM1 & "#;

i have this query in vb6 program: sSQL = "SELECT Count([WDATE]) From WHOURS Where [EMPID]=" & EMPID & " AND (([WDATE] Between (" & STD & "-31) And (" & STD & "-1)));" debug.print sSQL looks like: SELECT Count([WDATE]) From WHOURS Where [EMPID]=154 AND (([WDATE] Between (7/01/12-31) And...

WDAYS is date format (long) like in here: SELECT Query3A.EMPID, Query3A.FULL_NAME, Count(Query3A.WDAYS) AS WDS, Query3A.WDAYS FROM Query3A GROUP BY Query3A.EMPID, Query3A.FULL_NAME, Query3A.WDAYS; EMPID FULL_NAME WDS WDAYS 0154 BILLINGSLEY, CHRIS 1 June 15, 2012 0154 BILLINGSLEY, CHRIS 1 June...

hi, i want to count how many days employees worked within last 30 days (if they qualify for statutory holiday) but my query gives me empty record set: SELECT Query3A.EMPID, Query3A.FULL_NAME, Count(Query3A.WDAYS) AS WDS FROM Query3A WHERE (((Query3A.WDAYS) Between (Now()-30) And Now())) GROUP...

ok, this Chr$(34) did it.

i am exporting data into a text file with this code: sSQL = "Select [EMPID], [WDATE], [WTYPE], [WHRS], [PCODE], [WRATE] From WHOURS WHERE PAYPER=" & rst.Fields(0).Value & ";" Set rs4 = New adodb.Recordset rs4.Open sSQL, objAccessConnection, adOpenKeyset, adLockPessimistic I =...

hi, i want to make a simple time keeping project - it would calculate worked hours semi-monthly using the following rules: - first 8 hours Mo-Sa as regular time is less than 40 per week, if over 40 hours Saturday is overtime (if there is a statutary holiday 32 hours a week as regular time) - 9...

my mistake, the error was in the form name.

hi, i have two selects which i want disable/enable based on selected value of another select: <tr> <td><b>8. Motor:</b> </td> <td> <select size="1" name="motor" id="motor" onChange="calc2(this.form);"> <?php if($md=='lb'){ echo ' <option selected value="0"> </option>'; echo ' <option...

sorry, my apology. i missed value for 'numbays'

hi, i have this code: ... function calc2(form){ if(form.units[0].checked) { var span=parseFloat(form.span.value); var width=parseFloat(form.width.value); } else { var span=(parseFloat(form.span.value)*2.54)*10; var width=(parseFloat(form.width.value)*2.54)*10; } var...

thanks for the explanation.

thanks you. funny thing is the original code works on some servers even without this line: $id_row=mysql_real_escape_string($_GET['id_row']); maybe different php version? thanks again.

well i was able to pinpoint the problem, value of '$id_row' not passing into update query, but don't know how to fix it.