Search results for query: *

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.

No Ace I don't actually see your point. ( Don't understand the 'skinny' reference either ) BECAUSE Dim intA As Integer intA = 42 If intA Then ' This WILL run Else ' This will only run if intA = 0 EndIf Whilst I fully accept that the True keyword = -1 ( Only those with a 'classical'...

How many users ? How many entries ? Ie. Whats the chance of two people making entries at the same time and getting the wrong ( duplicate ) number from the Index table ? G LS spsinkNOJUNK@yahoo.co.uk Remove the NOJUNK to use.

Cheers AceMan - doing okay, keeping ( very ) busy. Pressure of work has mean little time for surfing T-T recently. Fully understand where you're coming from on that. ( DAO3.6 already loaded ) As for the Function's return type - it is literally a copy from the Access Help file and they always...

Thanks Ed - I've kind of come to a similar solution I change the Dim prp line to Dim prp as Object Late typing allowed it to get through the Set prp = line and then dbs.Properties.Append prp sorted it all out. Now I've done the "Create" I can't test your solution but I've a good idea that...

I'm following the code supplied in the help file that has worked on many other dbs, but I can't get it to work on this one ( Access 2002 is it matters ) ... ChangeProperty "AllowBypassKey", dbBoolean, False ... Function ChangeProperty(strPropName As String, varPropType As Variant...