Search results for query: *

Hi all, i found this script from the adobe website and is it possible for some1 to convert this to vb....am not having much luck? <script runat="server"> protected void dg_employees_SortCommand(Object sender, DataGridSortCommandEventArgs e) { // This function allows us to sort on the...

hi guys thankx for the reply....it was the reference to my database in the web.config file. Slight correction of that made it work... cheers guys :)

Hi all i have tested my webstie in asp.net and it works on my pc well. When i upload it to the server and test it...it allows me to login and takes me to the insert record page. Which it should do. But when i want to view records (view_records.aspx). Which has datagrid all the patients. I get...

Hi guys, I have question and not sure how to approach this. Well i'll start with the question. (Q) i have session id's...if user doesn't finish the form after 30 mins then i want it to log them off. But still have the session id enabled and when they login...the information they left is still...

Hi all i have access database connected to myp aspx webpage. I used dreamweaver. When i store the time through an aspx form. It saves it in access database table field. I set the field to show short time field. How ever when i retrieve the record through my aspx form it shows the date and time...

Hi all, Am trying to use this code in the control source of a textbox and i get an error msg. Am not sure where i gone wrong :s =DCount("[ID]","sheet4","dateadded BETWEEN #" & 1/11/2007 & "# AND #" & 30/11/2007 & "#") many thanks

I've done it like this eventually.... :) I never heard of transform....something to read on ... But thanks guys... SELECT Format([dateadded],"dddd") AS Days, Sum(IIf([ReferralAppropriate]=Yes,1,0)) AS YesA, Sum(IIf([ReferralAppropriate]=No,1,0)) AS NoA FROM Sheet4 GROUP BY...

Hi all, I have query which counts the number of records on monday, tuesday, wednesday etc depending on whether it is true or false. e.g Monday 18 yes Monday 3 no Tuesday 9 yes Tuesday 8 no etc... the code for...

oh i sussed it out...eventually :) SELECT (Sum(IIf(Format([DateAdded],"dddd")="Monday",1,0))/DCount("[ID]","sheet4"))*100 AS Monday, (Sum(IIf(Format([DateAdded],"dddd")="Tuesday",1,0))/DCount("[ID]","sheet4"))*100 AS Tuesday...

Hi all, I have query which shows number of records for each day. How do i go about changing this so that it can give me the percentage of each. This what i got so far... SELECT Sum(IIf(Format([DateAdded],"dddd")="Monday",1,0)) AS Monday, Sum(IIf(Format([DateAdded],"dddd")="Tuesday",1,0)) AS...

Hi all, i want to count the records and group them. But this doesnt work if there's empty records in location. SELECT Sheet4.Location, Count(Sheet4.Location) AS CountOfLocation FROM Sheet4 GROUP BY Sheet4.Location; e.g Location count test1 5 test2 7 empty...

Cheer Remou thats exactly i was looking for :)

Hi all i have query which am trying to show from table "sheet" the field am using is hr what i would like to do is count then number of records who have results below: <50 between 51 and 100 >100 this is what i got but am not sure its right? SELECT Count(Sheet4.HR) AS [HR<51]...

this is what i got so far.... dim conn as New OleDbConnection(application("dblocation")) 'create a new connection to database dim cmd as New OleDbCommand(sql,conn) ' create a new command to send to database dim adapt as New OleDbDataAdapter(cmd) ' create a new adapater to process command dim...

thankyou for replying.... The hospitalno is unique so it will only return one record. Could you show me quick same or link somewhere this has been done? cheers

Hi all, Am knew to all the aspx stuff. Currently am creating an intranet and am tryin to search for hospno and then fill the firstname and surname into webpage form fields. Am not entirely sure how to go bout this.... i've started off..... Sub GetHospitalNoButtonClick(Source as Object, E as...

Hi everyone am trying to create a search query but using 2 parameters....surname or hospital no.... How do i tell it to ignore one of the fields if its empty? What i mean is if enter the surname ....then i only want to filter it by surname and not hospital no...if nothing is written in...

cheers guys...you made that look so simple! lol

Hi all am currently saving data using an aspx webpage. I can store textbox values but having trouble getting the syntax right for a checkbox value.... could any1 have look at this code and see where am going wrong? cmd.Parameters.Add(New OleDbParameter("@Location", txt_Location.text))...

Hi found the solution.... It was permissions on the folder where the database is held. It didnt have any read or write permissions..