Search results

Hi guys I have a report Transaction by month (by currency) and it all fine it gives me Accname Amount by month - formated to mm so i get 1 (jan) 2 (Feb) etc by currency ( based on date range ) x to x - all fine but i need it to go left to right currenctly it lists them top to bottom...

make it interesting - bare hands - now that I would call sporting

Hey its not so much the death of the lion - its the deliberately enticing it out of the park -to kill it that's a bit unsporty and yes if the money spent killing the lion went to education it might sit a bit easier on people's moral compass.

I have no issue with hunting - but this does go beyond that and is there not the death penalty for Poaching ... if so let justice do its thing - Hunting should be done for food not sport /entertainment (or pest control)

there are access repair tools out there , that will rip the tables out .. - but its easier to get the back up ... clutching at straws .. make a copy first try zipping the file extract and see what happens rename the file to something else from xxx.mdb to xxxx.tmp then rename back to...

see if this helps http://www.accessdatabaserepair.com/kb/unrecognized-database-format.htm

Hey see if this helps i ruin a statement process - this creates the statement - and sends the statement automatically (statement stored on server) and ".To = rsEmail.Fields(3)" is where my email address is - works a charm (a little clunky on a larger run and i have built in a small pause -...

Its working - I'' tidy up laters . (tonight and see which works quickest ) there should never be more than say 100 statements to go through - as I pre select the ones to create (and email) so GBP may only have 20 EUR may be 50 USD 5 AUD 5 Rands 10 etc I have selected by currency - and...

If rsEmail.Fields(7) = "Broker" Then DoCmd.OpenReport "Statementrptemail", acViewPreview, , "AccountNo = " & rsEmail.Fields(0) & "" '" DoCmd.OutputTo acOutputReport, , acFormatPDF, "S:\Apex Data\ARC INTERNATIONAL\Statements\" & .Fields(6) & ".pdf", False DoCmd.Close acReport...

resolved after some twerking ... - not a pretty sight

did stuff - went pears- shaped .. reviewing - and yes - should of started a new thread...

Ahh - run against a very minor issue .. can i put an if statement in a loop IF rsEmail.Fields(22 ) = "Client " then do DoCmd.OpenReport "Statementrptemail", acViewPreview, , "AccountNo = " & rsEmail.Fields(0) & "" '" esle IF rsEmail.Fields(22 ) = "Broker " then do DoCmd.OpenReport...

I stared at this for a good 45 minutes .. drove me bonkers .. I'll tidy up later Not sure how to mark post as solved ..?

- Solved - had a cup of coffee and DoCmd.OpenReport "Statementrptemail", acViewPreview, , "AccountNo = " & rsEmail.Fields(0) & "" '" -sometimes I am such a plonker G

AccountNo is numberic as is rsEmail.Fields(0

Lots of swearing .. OK I have a report and I intend to email out - (I can handle this ) I want to export Statementrptemail as pdf - (not an issue) however when I run this I get all of the statemetns instead of one AccountNo so Brown Eggs - 1 report Sugar Daddy 1 report currently i am...

Yeap - good practice to do this - (I wish I followed this myself - ) If the poster is hell bent on sticking to having the tax on the show - then Dlookup is the route tax= dlookup xx on show table ... but this just doesn't sound the right way to do stuff Tax is a bitch - easy when you...

Be careful when you do up your zipper ...

Given that you are USA based - is there multi tax or different tax per state So will your "boots " have a federal tax and also a state tax ? - My knowledge on USA tax is zero and does the tax apply to your you are based or where you sell the items Tax is always a bitch to get right are...

Show = main Event Event - is within a Show So Glastonbury is the Show and the circus is an event within the show a show being the main entity and there is only one- events are within that Show Show:- Glastonbury Festival ( the whole ) events:- part of the whole on a...