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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
how do I edit a < long text > field????
Thanks, James. I'll give it a try.- denright
- Post #7
- Forum: Microsoft SQL Server: Programming
-
how do I edit a < long text > field????
I'm using SQL Server 2000. The data type is ntext, size 16. I've been modifying data in other fields through the Enterprise Manager interface. However, all the fields with a large amount of text are showing only <long text>. I can't even find the data I'm looking for using a query. I've had...- denright
- Post #5
- Forum: Microsoft SQL Server: Programming
-
how do I edit a < long text > field????
I am having the same problem. I'm new to SQL Server and can't seem to find an answer for this one. If anyone can help with information about how to edit the content in these fields, I would be most appreciative.- denright
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Find First Date in Recordset
I have a Report that is based on a Query. I want one field on the Report to show the earliest date in the recordset. I am having a total blank on the best way to achieve this. I'd appreciate any help on this. Thanks!- denright
- Thread
- Replies: 1
- Forum: Microsoft: Access Reports
-
Text box value from SQL statement
DLookup worked perfectly. Thanks!- denright
- Post #4
- Forum: Microsoft: Access Forms
-
Text box value from SQL statement
I have a form that is bound to a table called ContactHistory. For new records, I would like to populate a text box (txtPersonID) on the form using a query that takes data from another table (Person). I tried this: sqlPersonID = "SELECT DISTINCTROW PERSON.PersonID " & _...- denright
- Thread
- Replies: 3
- Forum: Microsoft: Access Forms
-
Multiple TCP/IP Settings with WIn98
I am working with a small peer-to-peer network with all PC's running Win98. They have proprietary software that runs on internal IP settings such as 10.14.19.103 I set up an Internet connection using a DSL gateway/router but obviously, to use it the PC's have to have IP settings compatible to...
