Search results

I could have lots of sub reports but there must be some way of grouping these Another policy could be type Prize indemnity and re-insured both of these would go above Fred Smith and different text beneath

here goes It is for insurance on one policy you will have Type weather Insurance then insured say Fred Smith Then address then dates Then location then interest OK so the d/b has Fred smith , location and dates another table will have Type and interest i wanted to have Type...

Vague heading .. Hi Guys OK I might be having a moment here What i want to do.. i have a query which sorts set of records ( just plain text) into order so number 1 - test number 2 balloon number 3 - carrot number 4 earwig etc - the list is quite long what I want is for the...

Tried this - and re-tired it but then move the "strBody = strFirstBlock & strSecondBlock" firstblock of text above the code and then it worked sorry for being dim .. working now G

Hey guys - brained fried.. I need to add two/three formatted paragraphs together in the email I can do one - but I have lost te plot to add two Html blocks of text together ... points would be most welcome

Yeap... I thought i was missing a comma or something - that did the trick . big thanks Have a great Christmas break G:o

Hi Guys i am sure this is a quickie but I have a report that i need to pdf - I can export DoCmd.OutputTo acOutputReport, "test Rpt", acFormatPDF, "S:\ZoomData\barking\CLIENTS\21329\ " & QuoteNo & ".PDF", False however I want to export to a folder on the server - when i put in Me.QuoteNo...

yep - that's what i need to do - I tweak it to fit tried to do it with simple queries -failed however this looks the thing:D cheers G

yes its the value on the form - but it will not automatically populate the field Newvalue

no just a blank ... its just getting the "new" number that's a puzzle

I ramble - got to most of this - no problem the new value bit is the one that's thrown me NewValue: "YourNewValueHere" i want the new value to be a field on my current form so New value :=form!formName!Formfield its this bit that i am brain dead on

Hi guys not been around for a while - simple problem I want to append records from one table (A) to table the same table - but... change the one field only So I have quoteno 12345 with say 30 records in a child table (Ac) and I want to create quoteno 45678 and copy those records in...

would it not be easier to transpose the excel sheet so sheet/tab one set up as you have it sheet /tab 2 transpose the data or manual edit the date Sheet 1 column A row 1 = name =Sheet 2 column A row 1 Sheet 1 column A row 2 = nwhateverA =Sheet 2 column B row 1 Sheet 1...

here's a site that might help http://www.vb-helper.com/howto_access_to_word_table.html

coming in on this - can you not add tables via vba? its going to be bucket loads of coding and exporting to word v

are you wanting a mail merge of x records or individual record super easy word merge is ideal for 1 record merging into word create the template and then push the button works a treat ensure you d/b is split

read the instructions - you have to add the fields in as normal

Ahh - right now you are in to If statements are you looking at doing client by client on a batch/mass run ? write it down how you want it to progress amount due = x If USD is < X then .. check CHF if CHF is null or then check .. work out your logic on how you want this to progress...

OK So do you have a currency every client ie client No1 Euro nil ChF 500 GBP 250 USD nil or just Client no 1 CHF 500 GBP 250 not that it makes much difference . assume the top option you will end up with potentially a lot of nil transaction but here we go Euro nil sell...

pad out the enquiry is the default currency going to be always USD or will the currency change ? (Will you sell USd to Euro ?) one would assume you need to have a journal entry of say Sell Euros at 1.2 to USD, you are going to need a history table (to tell you what you have done and when...