Recent content by Roscoe24

They say perseverance doesn't pay! It does - plus the help of complete strangers who make you think ... Solved! I built up the line of code bit by bit - and rechecked at every stage to find variations from my old fashioned calculator. From this one line of code (which now works thanks to...

Thanks to all who have felt my pain and replied. I appreciate your help. All number fields in table set to Double, 2 dps, #.## All currency fields in table set to Auto, 2 dps I've even recreated the form from the main table instead of the temporary one - and done away with the temp...

Have already spent 5 hours on web - no answer. Can you help? Have a temporary table being fed from VBA E.g. ((Field A - Field B) / 100) * Field C Math = (£925,000 - £250001) / 100) * 8 = £53,999.92 Answer presented = £54,000 All table fields at Currency / Currency / 2 decimals All fields on...

I've found someone who knows how to do this thanks. PPH. People Per Hour.

Hi, The user has opened a Word document in c:\Documents\Folder\Name of Document. He will then use Save As to name it and add an addendum to the default "Name of Document" so it is called "Name of Document 2015". The format he selects is pdf. How do I pick up this so it populates a field...

Hi Paul, On a local drive I have a suite of diverse documents which are "master documents". This folder contains some 150 different "letters", which are contained in the one top level folder but may be in one of several sub-folders. Each standard "letter" contains mail merge fields. At the...

Desperate for help! Days 'n days searching forums - still no clue! - I store folder names in a txtbox against the client e.g. c:\Client Files\Client123 - Having Mail Merged to Word/pdf or Excel I need to save that document to a hyperlink or txtbox so I can 'shell' to the specified Document...

Hi, Having slept on the problem - again - I've decided to be a lot less clever and copy the standard letters into each user folder. From here, each time a user goes to a letter for the first time, they can reset the source to their copy of the front end table. The downside is that it may time...

Not really because I've not set any yet. What I've got is bits of code in my "Favourites" box - some from you, BTW! I recognised your User Name. e.g. <MailMergeObject>.OpenDataSource Name:="C:\MyDB.mdb", _ SQLStatement:="SELECT * FROM [MyTable]" The users are using common letters...

Hi I know this is possible (e.g. opendatasource) but search as I might I can't get the exact code. Can anyone help please? Scenario: Multiple front ends, in different folders, linked to single back end. When mail merging, a temp table is created in FE - thereby different source for each...

Advice please! I have a MSAccess 2010 db with tables on Terminal Server and Progs on 10 TS Profiles. Now wish to move to Cloud environment. What is involved? e.g. Do tables need to be in SQL? Do forms etc need redefining? Where can I look for "simple" help?

Thanks for your trouble, GypsyFish. - Mail Merge (outbound data) working perfectly from Temp table of captured data. - Email (outbound data) working perfectly with Hyperlink - Attachment Field certainly set me up in the right area. Not used them before - will now. - Anyone else used...

I have a small application, in which is a tblClient, indexed ClientID. Each ClientID wants to send out various pre-set MS Word documents using Mail Merge. These specific documents need saving against that Client so that they can be accessed from the form frmClient. Likewise, each ClientID...

Uuuuummmmm ... sorry .... need a bit more ...... I want to specify how many months to calculate eg 6 months or 12 months or 5 years etc. Can someone give me the whole code for this recordset question - with regard to the EOF element particularly. What I'm up to, in case it helps, is...

You're a star! Thanks so much. Perfect.