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...
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?
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.