Replies

Thanks Bruce, the suggestion of setting the property in a template worked great
especially as I was already using a template in my export routine

Thanks for the response
I went to Tools / Email Accounts,
selected View or change existing directories or address books
then for the item Outlook Address Book selected Change and clicked Remove Address Book
then back to the Contact folder and right click on its Properties, select the Outlook Address Book tab and tick the box Show this folder as an e-mail Address Book
That did it

Nope, the reason for the error was the fields had changed in size alright, but someone had put an index on the field. Oracle can cope with the indexing of a >255 character field, but Access can’t

Best way I’ve found is to use the TweakUI powertool from the Microsoft XP site

This seems to have worked, part of the problems were down to one of the ports in my hub having an intermittent fault
I have ipx/spx and tcp/ip protocol installed, seems the Client for Microsoft and File Sharing for Microsoft won’t work with the Netgear TCP/IP, but they work fine with ipx, so this gives me the workgroup capability in the home network
Just to confuse me though, I can still ping each machine, either wired or wireless, and the laptops can reach the Internet via the PC with the ISDN modem installed

Thanks, had a look but couldn’t find anything on the Netgear and Windows XP drivers
– got a response the Netgear tech. support suggesting
Resolution:
Please try the steps below:
Please try selecting the ipx/spx first and then select client for MS networks or file and print sharing.
You may also find some winXP related information at wown.com
I’ll give this a go tonight when I get home

Oh blast, I’ve been doing some more digging on the net and spotted an article on this and found this
http://www.zdnet.com/anchordesk/stories/st…2832183,00.html%5B/url%5D

Seems that Netgear is labelled “Works with Windows XP” – this is not the proper Microsoft compatability, they’ve been using a loophole to get their wireless card to work with XP.
This loophole has since been closed by one of Microsoft’s update patches
So until Netgear (and it seems other cards using the Intersil chip set) get their proper XP compatible drivers out, I’m back to using wires

Oops, should have said, by disappearing, I mean the other PC’s have disappeared from the workgroup
– just to really confuse things, I tried linking a laptop up via a real wire to the hub and it works ???

Weird, I dragged them, tried to look at one on the Start panel, got an error, but phone rang, so I got delayed. Tried the other an it worked! Went back and the first one works
– seems there’s a time delay

Leif,
sorry, the Knowledge Base article details changing My Documents target, but the My Music and My Pictures don’t have the same Target option
Done some more poking around and found this reference on a couple of techy sites, tried it, but it doesn’t work – the site “Paul Thurrott’s SuperSite for Windows” only had it on the rc1 page, not the actual release, so maybe the features been pulled
In Windows 2000, Microsoft added the ability to right-click the My Documents folder and choose a new location for that folder in the shell. With Windows XP, Microsoft has elevated the My Music and My Pictures folders to the same “special shell folder” status of My Documents, but they never added a similar (and simple) method for changing those folder’s locations. However, it is actually pretty easy to change the location of these folders, using the following method.
Open a My Computer window and navigate to the location where you’d like My Music (or My Pictures) to reside. Then, open the My Documents folder in a different window. Drag the My Music (or My Pictures) folder to the other window, and Windows XP will update all of the references to that folder to the new location, including the Start menu.

Glad to hear sorted Andrew
– I still find ‘features’ with connecting via ODBC, e.g. with our Oracle tables, why do I get an error using the Oracle ODBC driver when some of the records have a Null value in the field used in a join to a local Access table ??

Well I’d try both
SELECT Count(*)
FROM DB2PROD_HLT_REPORT_VIEW
GROUP BY DB2PROD_HLT_REPORT_VIEW.[DTL DEPT CD];
and
SELECT DB2PROD_HLT_REPORT_VIEW.[DTL DEPT CD], Count(Distinct DB2PROD_HLT_REPORT_VIEW.[CTC CONTACT ID]) AS [CountOfCTC CONTACT ID]
FROM DB2PROD_HLT_REPORT_VIEW
GROUP BY DB2PROD_HLT_REPORT_VIEW.[DTL DEPT CD];
to see if they work, but I can’t see what’s wrong with your original query

Does that mean they will still be supporting Jet / ODBC, and that bugs will be fixed ?

This is listed as the cause for that error message
SQL0409N The operand of a COUNT function is not valid.
Cause: As specified in the SQL statement, the operand of the COUNT function does not conform to the rules of SQL syntax. Only COUNT(*) and COUNT(DISTINCT column) are allowed.
The statement cannot be processed.
Action: Specify COUNT(*) or COUNT(DISTINCT column).
NOTE: This message is only applicable to versions of DB2 prior to Version 2.
sqlcode: -409
sqlstate: 42607

Can you check your Count statement

Charlotte,
I’ve checked the XP and original 97 version. Both have got the same tab order, the Dummy control first, then the user data field controls
Also checked the events, the subform only has the one GotFocus on the dummy, the main form has various Click events on the command button controls, plus an initialise on the Form_Open
By default the user controls are all disabled, only the dummy is enabled.
Selection of a report from a list box on the main form enables any of the data fields which are applicable to that report, but even setting the dummys tab order to last, the user controls are still not selectable, so I presume the dummys GotFocus is still firing first

Thanks for all the responses, much appreciated, especially as this difference in XP has sure got me baffled