How would I....
I have a query which produces a list like so:
REP Customer Date sold
--------------------------------
John S Ajax 1/1/05
John S Comet 1/5/05
John S Hotel 1/17/05
John s Miami 1/29/05
.....
John s San jose 3/14/05
John...
I am stumped. I need to upgrade my 40gig to 100gig using a 2.5 laptop drive. I have a PCIMCIA device that allows me to access a second drive on the system. In the past I have been able to use this (and its software) to make a perfect image or bit copy to the new larger drive which then boots...
After setting up W2k pro, I can't seem to get the machine to see the Domain. There is one and I can ping all of the dhcp addresses and the gateway, plus I can get to msn.com. I just can add the new system to the domain and then see the domain. This has happened before, though it is rare.
Any...
Thanks! I figured it out. What had happened was, that under XP Pro, Windows updates had loaded a driver for my system's Video card. This "updated" drive somehow check the box in the settings to allow you to run over the edge of the screen. MP was going full screen in a "virtual" screen that...
Hi,
We have a wired problem here. There are two tables A and B, the primary key (see CID) of table A is the foreign key of table B. Table A is in SQL 2000, table B is in Access 97. When two table join in Access 97, the records will not be returned in the result if CID > 999. We didn't have...
I have a similar problem. In the list box showing the file types, I have a (None) for the extension. This is on several dozen entries. Is there any type of repair process or tool to fix this?
Thanks
Thanks. I understand the principles of the passthrough queries, I don't quite understand the actually mechanical use of them. The description of the query above is this. The query in question is a Make Table query. It contains 11 tables 4 querys that are joined in various ways, all indexed...
Interesting Threads. I am having a similar problem. I have a small desktop, running MSSQL 2000 and Access 97! Yest Access 97. I have a very complex query running in 97 with linked tables to SQL. The query takes about 7 - 10 mins. Not to bad for what it has to do.
I purchased a much more...
Thank you for reply.
The reason is because this kid of queries are in my VBA code bound with forms. User may a value for ID or they may leave this field blank. If they put 10 in ID, the query will be "INSERT INTO TestTable (Name, ID) VALUES ('userName, '10')", if the user leavs this field blank...
I have a system which Access 97 is front end, and SQL server 2000 is back end. Currently, I am upgrading my Access 97 front end to Access 2000 front end. Some query don't work after the upgrade. There is an example:
Table Name: TestTable (in SQL Server 2000)
Fields: Name (varchar)...
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.