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 dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Query Does Not Have
Hi I have a table that contains different transaction types for customers and I am looking for a list of customers that does not have a particular transaction type. What I have and it works, is one query that gives me all the customers from that table that have that transaction type and then I...- doquigley
- Thread
- Replies: 5
- Forum: Microsoft: Access Queries and JET SQL
-
update a single table within a multiple table recordset
MS Access does it VBA does it VB6? I am linked to a MS SQL Server Database and my vba knowledge is of no use. I try the 2 following methods but neither work An update recordset which has more than one table linked but only updating a single field does not work Set objRs = New...- doquigley
- Thread
- Replies: 2
- Forum: Visual Basic (Classic)
-
access 2000 adp file won`t work in access 2007
I have an access adp project file that I created on access 2000, when I try to run it in access 2007 it just doesn`t recognise the sql cmd instructions and I get the error "the text, ntext, and image data types cannot be compared or sorted except when using IS NULL or Like Operator, which makes...- doquigley
- Thread
- Replies: 0
- Forum: Microsoft: Access Project (ADP)
