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 Gixonita

  1. Gixonita

    Menus And Roles Question

    Hello All, The roles were working perfectly, my CSS was the one on the fritz, had to move the <ul>s outside of the logingview declaration. Thanks :)
  2. Gixonita

    Menus And Roles Question

    Hello All, I have a menu in which items within it should display depending on the role assigned. In the code below all roles should see the "Forms" option, and then, depending on the role, they should see "Admission", "Service", "Treatment", or "Discharge", only the Administrator should see ALL...
  3. Gixonita

    Group By (on Change) Qustion

    Oops, sorry, didn't see the second home grouping, that will teach me to read more carefully before I post.
  4. Gixonita

    Group By (on Change) Qustion

    Hello SELECT MIN (Date) AS StartDate, MAX (Date) AS EndDate, Place FROM YOURTABLE GROUP BY Place Hope this helps :)
  5. Gixonita

    Licensing for Access through Website

    Thanks for your input, I will look into your suggestions :) Luis Torres
  6. Gixonita

    Licensing for Access through Website

    Hi All, We have installed Sql Server 2005 with a 5 CAL user licenses (we are a relatively small company). We are developing a website that will allow users to query one of our databases. The website uses in it's connection string only one User Name that was specifically created in SQL Server...
  7. Gixonita

    select record when based on previous records

    Here is an idea of how to do it, every query could be run as a sub query of the next one, but I kind of wanted you to see what is going on on the process. Hope this helps SELECT id AS Last_ID, MAX (record_date) AS Last_Date INTO #TEMPO FROM Your_Table GROUP...
  8. Gixonita

    show Vacant when 1

    SELECT Address, KepMap, CASE VACANT WHEN 1 THEN 'VACANT' ELSE 'OCCUPIED' END FROM PROPERTY WHERE CITY = 'Dallas'
  9. Gixonita

    Table Dinamically Created

    Thanks for the suggestions :)
  10. Gixonita

    Table Dinamically Created

    Hi experts :) I'm creating a little website to train our employees, it goes a little like this: - Employee logs in (Done) - A list of available presentations is shown (Done) - Employee selects presentation and goes through it (Done) - Employee takes a test and gets scored (Partly Done...
  11. Gixonita

    How to control movie files in web form?

    Thanks for the suggestions :)
  12. Gixonita

    How to control movie files in web form?

    Hi all, I've been requested to develop an intranet training web site in which the employees: Step 1.- Log into main page and get a list of training videos they have access to. (Done) Step 2.- Choose video, play to completion, print certificate. (Incomplete) Step 3.- Update...
  13. Gixonita

    Update Query

    No prob, glad I could help :)
  14. Gixonita

    Update Query

    How about this? UPDATE Master_Data_Vehicle SET Actual_Annual_KM = (MilageTemp.Mileage / (DATEDIFF (day, First_Registration, MilageTemp.RepairDate) / 365.0)) FROM MileageTemp INNER JOIN Master_Data_Vehicle ON Master_Data_Vehicle.Chassis_Number = MileageTemp.ChassisNo WHERE...
  15. Gixonita

    Calling a newer version of excel

    thanks for your response :)
See more

Part and Inventory Search

Back
Top