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...
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 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 doesn't work and it should. Any idea why?
xlApp.Range("A2").CopyFromRecordset (rs)
It tells me that the object is not automatable?
Thanks
Rusty
PS: here is all of the code
Public Sub ExportToExcel(strSQL As String)
On Error GoTo HandleErrors
Dim response As String...
I have a report with two groups.
Group0 Header
Group1 Header
Detail
Group1 Footer
Group0 Footer
All groups(0 and 1) contain "Totals" for the report.
Each Group Footer is the same, and I do need both. What I would like to do is suppress the Group1 footer if there is actually no...
Prior to 3 days ago, IIS/ASP was talking fine with SQL 2000. Now it takes an eternity to talk and get any data, or time out.
Any ideas? I have check pretty much everything.
Thanks
Prior to 3 days ago, IIS/ASP was talking fine with SQL 2000. Now it takes an eternity to talk and get any data, or time out.
Any ideas? I have check pretty much everything.
Thanks
Has anyone seen this before, or am I really out of it? :)
Why on some '97 systems (not all?) does this happen
from a QBE in the criteria section why are the two statements different.
1.) <>4 or Is null (produces 51 lines)
2.) <>4 or IsNull([FieldName]) (produces 26)
Conversely, why...
Same applications, two different systems. Both running Access 97 with SR2
On both systems/Applications , a combo box with dates created by code using the Date() function turns out different results.
On the first computer - the data is as designed. Date() = todays date, date()-1, yesterday...
While attempting to install drivers for a USB camera, my USB controller was wipe out. I can't seem to get the Hardware wizzard to install the correct drivers, even when using the proper .inf file(for the chipset of my laptop). W2k always wants to install the generic driver, which then causes...
While attempting to install drivers for a USB camera, my USB controller was wipe out. I can't seem to get the Hardware wizzard to install the correct drivers, even when using the proper .inf file(for the chipset of my laptop). W2k always wants to install the generic driver, which then causes...
How do you....
I have a letter.htm file. I want send this as an email but have the HTML file open up and not be an attachment. I have to do this in code using an Outlook Object.
I am currently using the following snippit:
Const olMailItem = 0
Set objOutlook =...
Does anyone know why the address bar would lag. I open IE and click the arrow on the Address combo box. It sits there for minutes. What is it try to do? Why doesn't the list just pop down right away?
thanks,
\Rusty
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.