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!

  • Congratulations bkrike 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 vias

  1. vias

    TIMESTAMP field problem when moving to another server

    vias (Programmer) Mar 7, 2005 I have transfered a database from a server to another. One of the tables contains a timestamp field. The value of one of the timestamp fields was "3/6/2005 3:00:00 PM". After the move the value of the same field is now "06/03/2005 15:00". In my program I...
  2. vias

    Problem getting the correct record

    Roy-Vidar, Thanks for your help....it works now.. Vias
  3. vias

    Search and Display Results on Same Form

    Hi Chaz, I have a similar problem.. How would you implement it with more power? Thanks. Vias
  4. vias

    Problem getting the correct record

    I have a combo box and a button next to it called 'GO'. The combo box gets a list of names from a table. The 'GO' button is to display a form attached to a table TabContact When I click on 'GO' I want the appropriate record from the table TabContact to be displayed depending on the name I...
  5. vias

    The selected file is not a Microsoft Management Console document.

    Hi, SQL Server 2000. I'm logged in as Administrator on W2K server and when I try to launch Enterprise Manager, I get the following error: "The selected file is not a Microsoft Management Console document". Any help would be appreciated. Thanks, Vias.
  6. vias

    Query problem with composed word like 'United Kingdom'

    Bastien, I changed it and it works fine. Thanks for your help. Vias
  7. vias

    Query problem with composed word like 'United Kingdom'

    Hi, I have a simple query: select * from users where country = 'united states' I display 9 records per page using SQL Server and ASP. For example, if the query returns 14 records, I display the first 9 on page 1 and records 10 to 14 on page 2 and so on. If the query doesn't find any...
  8. vias

    How to correctly pass parameters to URLs ?

    daveJam, Thanks for your response. Could you please post your reply again as part of it is missing. Thanks. Viasa
  9. vias

    How to correctly pass parameters to URLs ?

    Hi, This is an example: <A HREF=&quot;http://www.test.com/ sale.asp?ainfo=192&option1=23&option2=&quot; &var1>click here</a> I have 3 parameters : ainfo,option1 and option2, and am passing a variable 'var1' to option2. The first two parameters 'ainfo' and 'option1' are passed correctly but...
  10. vias

    How to avoid pasting into a memo field

    Hi, I have a 256 characters field defined as memo in an ASP-Access web application. I do not want users to paste into that field. I just want them only to type into it. How can this be achieved? Thanks. Vias
  11. vias

    ASP Access towards ASP SQL Server2000

    I need to migrate a web based ASP/ACCESS application towards ASP/SQL server. Do I need to change much of the code? Does DTS handle everything? What is the equivalent of field type MEMO in SQL Server? What are the common problems when moving to SQL Server? Thanks in advance.
  12. vias

    MSDE and SQL SERVER

    Thanks for your info.
  13. vias

    MSDE and SQL SERVER

    What are the main differences between MSDE and SQL Server? I would like to know how many concurrent users can the MSDE engine support on the web? Thanks

Part and Inventory Search

Back
Top