Recent content by LittleSmudge

Andy & Duane - my grateful thanks to you both. Both approaches work but with only 48 records so far I'm unable to assess any difference is speed. And, as expected - my first reaction was - "Oh yes, nest two queries" You've stirred long dormant memories. Thanks once again. G LS

tblPricing PricingId - Prine Key PropRef - Foreign Key PropPrice - Currency DatePublished - Date For a given [PropRef] there can be none, one or many record in the table. I need a query that will produce one record per [PropRef] with the value in [PropPrice] which is the most recent ( according...

Thanks RivetHed - that'll give me something to work on. G LS

Yes - I'm not talking about password protection of the file, I'm referring to the Cell protection withing the sheet. The top row is protected from user "fiddling" as it is an Export and then after update become a source for data import - so I need to make sure the users cannot change the column...

I have an Access97 database and I'm exporting data using TransferSpreadsheet to a pre-exising excel file. The file needs to have protection on it when users are working on it but, of course, with protection activated I cannot export ( Can't delete the old data before adding the new ). So I...

I just know this has been discussed before - but I'm having no joy with searching for solutions - so here is the problem. tblItem contains records of items which can be parts of Collections >> tblCol. Relationship is many to many so I have tblItemCol ItemRef FK to tblItem.ItemId ColRef FK...

I have a client who still used Access97 ( Due to a compatibility issue with their client ) and I need to send a report as an email attachment which includes images of company log etc. Using :- DoCmd.SendObject acSendReport _ , "rptEmailLetterSingle", acFormatRTF _ ...

Thanks cheerio, We're coming to the same conclusion from other directions too. G LS

smotek You are mixing your terms badly and so what you are asking makes no sense at all. A Table has ROWs ( None, one or more rows ) Each Row consists of a number of Fields Each field has a specific type and at least one Field should be a Primary Key which uniquely defines a particuar Row...

That has given us a great leap towards solving the problems - thanks linney. G LS

I'm an Access database developer and a client has been running my apps on Windoz 2k - 2k3 for years but they can't get 2k3 licences anymore so we need to get them running on Vista Standard structure is Access front ends all resident on user's local machines using ODBC to MySQL BackEnd on the...

I'm an Access database developer and a client has been running my apps on Windoz 2k - 2k3 for years but they can't get 2k3 licences anymore so we need to get them running on Vista Standard structure is Access front ends all resident on user's local machines using ODBC to MySQL BackEnd on the...

THWatson Tom Thanks. I'll have a dig through it. It might even fix another problem too. G LS spsinkNOJUNK@yahoo.co.uk Remove the NOJUNK to use.

Well Ginger I DID search PDF, PDF Writer, PDF convert etc before posting but nothing I could find actually addresses the issue I have raised. So unless your search engine produces different results to mine - then .. .. G LS spsinkNOJUNK@yahoo.co.uk Remove the NOJUNK to use.

Does anyone know of a utility that will convert SNP files to PDFs ? I know SNP is the Microshaft inhouse version of PDF - I was just wondering if someone has written a converter to change the format to the more common reader type. G LS spsinkNOJUNK@yahoo.co.uk Remove the NOJUNK to use.