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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. NHorley

    Formatting results field

    Hi I have a field in my table of Access 2000 which is set to be a %. However when the data comes through to the web page the field has lost it's format and is displayed as 0.675689786453431 instead 67%. Is there anyway to format the field in Frontpage (or a calcualtion of x100) to give the...
  2. NHorley

    hyperlink type

    Hi To control the colour for when visitors have clicked on your link you need to go into Page properties and in the Background tab there is a section half way down called Colors. Here you can set the colour of hyperlinks, visited hyperlinks and Active hyperlinks. Alternatively you can set this...
  3. NHorley

    Parameters in Hyperlinks

    Hi ya It's not the current date and time I need. I'm trying to set up a realtime update for on call rotas. I have it set to bring through the oncall persons name and details through to a form where they can select who is replacing that session but I need the date and time of their rota sessions...
  4. NHorley

    Date and Time as Parameters in Frontpage

    Hi I'm using Frontpage 2000 and using the parameters in the hyperlink to bring forward data to populate certain fields in the following page. However date and time are not options as parameters but I need to be able use them. Any ideas?? Thanks
  5. NHorley

    Parameters in Hyperlinks

    Hi I'm using Frontpage 2000 and using the parameters in the hyperlink to bring forward data to populate certain fields in the following page. However date and time are not options as parameters but I need to be able use them. Any ideas?? Thanks
  6. NHorley

    Create a search form to look up a table?? Please Help :(

    Hi I would use an ASP page (as I don't know CF). It's quite easy to set up insert your database connection and put in the following SQL: SELECT * FROM Table name WHERE Field_Name='::Field_Name::' This will produce the text box in a form for you with the database results appearing underneath...
  7. NHorley

    Using SQL to update database

    Sorry scrap that last one it is working now and updating the database just not pulling through all the results onto the web page. thanks anyway
  8. NHorley

    Using SQL to update database

    Hi I'm using Access 2000 DB. It's when I try use date or/and time fields as paramaters it ignores them! This is the statment I'm using: UPDATE OOH_Rota SET Update_OnCallName='::Update_OnCallName::', Your_Name='::Your_Name::', Date_Time='::Date_Time::' WHERE Number_Me='::Number_Me::' This...
  9. NHorley

    Using SQL to update database

    Hi I am trying to update a table in my database using the WHERE clause in SQL. This is successful for all fields apart from date and time. It seems to ignore these or create an error on my web page. I need this as sort of timestamp logged in the database everytime an update is made. Any...

Part and Inventory Search

Back
Top