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 derfloh 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: *

  • Users: dejanv
  • Content: Threads
  • Order by date
  1. dejanv

    Run-time error 2498 Syntax error in update statement

    In a form I have calculated field called Tax; Tax = (txtQuantity*txtPrice). On change event on txtQuantity (type Number) and txtPrice (type Currency) fields I’m updating column Tax in tblAccouns table using VBA: DoCmd.RunSQL "Update TblAccounts SET Tax = " & Me.Tax & " Where Key = " & Me.Key The...
  2. dejanv

    How to store a file in a database?

    I have SQL Server 2000 and I have to make a table for storing Word, Excel or maybe some other Microsoft Office files. What data type should I use for this? Can I search through the stored files by words in a stored documents using a query and how?
  3. dejanv

    SQL Server Problems with Code Pages

    Hello, Here is my problem: I have two servers, one SQL Server 2000 with 1251 code page and the second SQL Server 6.5 with code page 850.The second server is a remote server on first and the first is remote on second server. On first server I try to execute this query : ----------- INSERT INTO...
  4. dejanv

    Problems with using SQL Server2000 and SQL Server 6.5

    HI, I have a problem using SQL Server 2000 and SQL Server 6.5: I have SQL Server 2000 as a remote server on SQL Server 6.5 and SQL Server 6.5 as a remote server on SQL Server 2000 and a task wich will insert in a table on SQL Server 2000 some records from a table on SQL Server 6.5 and after that...

Part and Inventory Search

Back
Top