Search results

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...

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 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?

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...

I need to calc (using AddDate - which works fine) a new date for each month after [DtEntered] for up to 5yrs ahead. (Can use BETWEEN statement OK). Each date then to be entered as a NEW record in a table with a unique ID. (i.e. 60 unique records) I don't mind if I use form, qry or VBA to do...

I've read so many topics on the forum about this I've got myself going in circles... (3 days of searching) I have a FormA with 8 possible unrelated combo's (cmb1, cmb2, etc) populated. I now need to set the criteria in my qry (qry1) based on any combination of combo's having something in -...

I have a form (A) from qry A, with calc unbound txtboxes on of (Sum) (Avg). Form (B) from qry B, needs same calc fields. I've tried Copy/Paste which has copied the fields OK but on Form B they are calc [#Error]. Any clues anyone please?