Replies

Edited by DaveA on 31-Oct-01 11:07.

Added hot link code
Go to this Ms link http://www.microsoft.com/windowsxp/home/ho…ding/compat.asp and you can as I did see if the software/hardwaere is compatible.

The is also a downloadable Upgrade Adviser BUT this is 50Mb! No good for my ol’ cable modem

Just been reading through a lot more posts re. this OS.

O.k. Is there a site that lists hardware compatibility? Viz. I want to find out if both my modems will continue to work – the manufacturer went bust some 18 months ago – Pace 56kVoD

Thanks for the link = very useful.

Re. the Supersite article – I quote:Networking features
The following networking features are not included in Home Edition:
The user interface for IPSecurity (IPSec)
SNMP
Simple TCP/IP services
SAP Agent
Client Service for NetWare
Network Monitor
Multiple Roaming feature

unquote; and here’s the bit that confuses me from Which Edition Is Right for You?
http://www.microsoft.com/windowsxp/whichxp.asp

New visual design makes it easier to do common tasks efficiently.
Digital photo features let you acquire, organize, and share pictures.
All-in-one music tool for discovering, downloading, storing, and playback of the highest-quality digital music.
Everything you need to create, share, and enjoy videos on your computer.
Easy computer sharing and home networking. !!!!!

Is it me? Either WXPHE suipports a home network – or it doesn’t.

Charlotte, many thanks indeed for your cogent advice – the unchecking of the missing file name has worked and I can now manipulate text.

On a subsidiary note – the text is brought in to a table via a macro using transfertext function and works OK on the local Pc: D:DATABASEPAYE_ImportPSLA.CSV. However on Pc2 with its own copy of Access2K – reading the database from Pc1 we cannot use the path above and so have to substitute: STEPHEND_DataDatabasePAYE_ImportPSLA.CSV. This works but of course when this change is made to the macro we find that it wont work on Pc1! Can you shed some light on this please?

Thank you Charlotte, the missing link is hrtbeat.ocx – this I understand to be an active x file. However how this impacts on Access I am completely unclear but, in searching (my installation cd’s W98 and Office 2k) for this I could not any reference to this file on the web. So, if I remove this reference what could be the impact on access please?

I think I am getting closer to the problem – although not the solution. I imported data to a table, all ok.
The query reads the table data perfectly – there are no calculated or coded fields whatsoever.
Field5 data look like this: JR995906C A
I want to be able to separate this text to individual characters so I created a new field called Test and used the expression builder thus: Test: = Left ( [Field5] , 1)
Saved the Query an on trying to open it the message “Undefined function ‘Left’ in expression” appears. This seems to me that something is not right with my Access installation? Help please!

Herewith the underlying SQL for the query. It takes three similar sources and combines them to one listing. The query shows the data perfectly until I try to include a text based funtion to extract and parse text.
SELECT [CODCode] as [Code] ,[CODName] as [Client Name],[CodClientStatus] as [Status],[CODPayeRef] as [PAYE Ref],[CODPayeCollRef] as [PAYE Coll Ref],[CodAddress1] as [Address1],[CodAddress2] as [Address2],[CodAddress3] as [Address3],[CodAddress4] as [Address4],[CodAddress5] as [Address5],[CodAddress6] as [Address6],[CodPostCode] as [PostCode],[IndClientName] as [Contact]
FROM [QryCompanyData]
WHERE [CODPayeReg]=True

UNION SELECT [SECode] as [Code],[SEName] as [Client Name],[SEBusStatus] as [Status],[SEPayeRef] as [PAYE Ref],[SEPPayeCollRef] as [PAYE Coll Ref],[SEBusinessAddress1] as [Address1],[SEBusinessAddress2] as [Address2],[SEBusinessAddress3] as [Address3],[SEBusinessAddress4] as [Address4],[SEBusinessAddress5] as [Address5],[SEBusinessAddress6] as [Address6],[SEBusinessPostCode] as [PostCode],[IndClientName] as [Contact]
FROM [QrySelfEmployment]
WHERE [SEPayeReg]=True

UNION SELECT [PSHIPClientCode] as [Code],[PSHIPName] as [Client Name],[PshipStatus] as [Status],[PSHIPPayeRef] as [PAYE Ref],[PSHIPCollRef] as [PAYE Coll Ref],[PSHIPAdd1] as [Address1],[PSHIPAdd2] as [Address2],[PSHIPAdd3] as [Address3],[PSHIPAdd4] as [Address4],[PSHIPAdd5] as [Address5],[PSHIPAdd6] as [Address6],[PSHIPAddPoCo] as [PostCode],[IndClientName] as [Contact]
FROM [QryPartnershipData]
WHERE [PSHIPPayeReg]=True;

Oops – sorry for the lack of info. The functions are placed in text boxes in the report itself. After finding that they, now, do not work I tried the same function in the underlying query. Couldn’t open the query! This appears to happen with text functions rather than arithmetical functions.

Mark, many thanks for the questions, the answers are:
Does this abnormality occur for same report on both PC’s? YES
Is this one database or does it have a split frontend/backend? ONE Db
Is the recordsource for the report a table or query? A QUERY – BASED ON A TABLE, TO WHICH DATA IS IMPORTED.
can you open it separately to see if it has data? BOTH Pc’s can open the table and the query and see the imported data.
Have you tried repairing the database? YES – still no joy

You also might want to try decompiling then recompiling the database Please tell me how to do that

I’m not the most Access-wise of people but I’d suggest that a field name in a table that is being read by the query may have changed; or that a field name referenced by an expression in that query has changed.

Many thanks for that Mark – excellent help.

I believe that this expression will work:
Date of Birth:
=IIf(DatePart(“m”,Now())>=DatePart(“m”,[DoB]),DateDiff(“yyyy”,[dob],Now()),DateDiff(“yyyy”,[dob],Now())-1)

The where condition is in the macro action column of the OpenReport Action.

The Where condition reads: =[please enter clients code] and [Year]=[Please enter Year ending]

When this macro is run the Enter Parameter Value box pops up and requests client's code then another EPV box requests for a style, lastly the 3rd EPV box states (where it should request a Year & here's the error message) Please enter clients code], 3 unknown=

Ooops, sorry Charlotte, I will clarify:
The report is based on a query, the query has no filters whatsoever. The macro calls the report and in the macro where condition is [Code]=[Please enter client’s code]and [Year]=Please enter Year ending].

After reading your reply, I tried to enter these two criteria into the query and got the same result as from the macros. Incidentally, the field {code] is alphabetic and [Year] numeric.