Recent content by ItHurtsWhenIThink

using Trident. So it looks like DataList would only work with Gecko. Thanks for the info. For those that asked, here is the rendering from my script (all fictitious data) <input list="frmUsers"> <datalist id="frmUsers"> <option value="1">Tony Adams</option> <option value="6">Anna...

When I click on the list box it populates the list with the 'FullName' values. But as soon as I start typing a name the list drops off. That's because its auto-filling by UID. If I just go down and select a user from the dropdown list, the box displays the UID value (numeric). I need to pass...

I'm just playing around with new html tags. Here is my first experiment, dynamic list box. Here is my code: <input list="frmUsers"> <datalist id="frmUsers"> <% sql="select FName+ ' ' +LName AS FullName, UID from members" Set rs = Server.CreateObject("ADODB.Recordset") rs.Open sql, conn...

George, Works great. Great points as well.

I hope this helps. I have exported the data from SQL to an MS Access DB. https://www.dropbox.com/s/oyz7ba1caxf0teg/SampleData.accdb

Staffing //this table collect data for each day of staffing -SID - PK -SDate -shiftID -DeptID StaffApps //this table allows me to collect daily staffing based on units (where people are assigned) -SAID - PK -SID -UnitID StaffPersonnel //this table allows me to dump personnel...

OK, I see where I went wrong. Should have used UserID in query. Here is the result I got: Abell Kevin 4512.000000 OD Allum Simona 1128.000000 OD What I need is the ability to group by Last name and WorkName so result would break hour by user and workName... like Abell Kevin 72.000000 OD...

Hoping someone can help. I am trying to create a record set with a list of hours worked. The results should produce a list sorted by last name, first name and total hours worked (by work code) so, I could see same name twice (or more) if they worked say overtime and ExtraDuty. Tables (with...

Got it! thanks for the solution. Both work well and I'll go with the more efficient query. Thanks again.

drlex query works fine. gmmastros, your query produced an error for me: ERROR: Common table expression defined but not used. Error Code: 422 I want to thank both of you very much for helping me out with this solution. Your time and patience is very much appreciated. Have a Merry Christmas...

I assume that each BottleId In SCBABottles can have a different HydroInterval. Yes that is correct. I assume that the Max HydroDate from SCBAHydro can be different for each BottleId as well Yes, that is correct as well The SCBAHydro table may contain many rows with the same BottleID, since...

I get: ERROR: The multi-part identifier "SCBAHydro.HydroDate" could not be bound. ?? looks right. checked the spelling

That worked. Now I have an issue with the results. I tried to change the INNER join to Left but got the same results. I have a table with all the air bottles (SCBABottles). My second table contains all the hydro testing for each bottle. In the query I thought the Max(SCBAHydro.HydroDate) would...

I can't seem to be able to evaluate an alias. I get the following error: ERROR: Invalid column name 'HydroDue'. Error Code: 207 I want to be able to get recordset of all bottle that have past their hydro date. I take the hydro date (last hydro) and then add the interval 'HydroInterval' and...

Theoretically no, because each 'frmLeaveCode' should have the 'intCount' value concatenated to it. So it might look like: if (window.document.form1.1frmLeaveCode.value==window.document2form1.2frmLeaveCode.value) OR if...