Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by dinster

  1. dinster

    convert c to vb

    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...
  2. dinster

    Not a valid file name.

    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 :)
  3. dinster

    Not a valid file name.

    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...
  4. dinster

    session login

    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...
  5. dinster

    date time field show only time

    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...
  6. dinster

    dcount with date not working

    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
  7. dinster

    Separing the yes and no to separate columns

    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...
  8. dinster

    Separing the yes and no to separate columns

    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...
  9. dinster

    percentage query

    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...
  10. dinster

    percentage query

    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...
  11. dinster

    group by null

    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...
  12. dinster

    Not sure how to do this?

    Cheer Remou thats exactly i was looking for :)
  13. dinster

    Not sure how to do this?

    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]...
  14. dinster

    retrieve fields from database

    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...
  15. dinster

    retrieve fields from database

    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
See more

Part and Inventory Search

Back
Top