Search results

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

Still is it one tax rate per show ?(per year) if its one tax rate per year then you just need to store the tax rate so in 2014 -2015 year the tax is 6% for 2015-2016 the tax is 10% (if it changes) you could have on your underlying table - taxrate - default amount and then simplies ..- you...

If I read this right create an email - but send it from another account? - that is not the one you are using - that seems a bit weird You can create an email say from Mickey Mouse - and the email trail will show it coming from Mickey Mouse - but you can change the signature - to pretty...

weird Is the tax static - ie - the same say 8 % or does it differ per item Boots @ 8% Shirts @ 15% If its the same - easy peesey - if it floats all over the place then that's a little trickier is it per items per sale or what so in your imaginary shopping basket Boots cost 100 * 5 pairs...

I've bailed out - vbaInet - can run rings round me - I can hack things together picked from various people - but anything creative .... regards G:o

my attachment table Location =S:\folder\sub folder\another subfolder1\filename.pdf Filename = name of the file Attachmenttblatuo= id number Filter = K

See if this helps anything in a [] is a field on the form Quoteform some of the [] i should of named properly anyway the bottom part EmailSend.Attachments.Add (Me.[Attach2a]) Attach2a = a field on my form that is a drop down list from a table that table has a location field on it Drive\...

Brain fried when asking the question.. will let you known how I get on G

Any pointers on how to stop this repeating ? G

Hey - update It pops a html file in to the first email - fine but them duplicates itself 2 - and 3 fold itself on the 3 - so if I send say 50 emails i will get the html in the last email 50 times - I think I need to clear the html.body rather than just the once .. hoep this makes sense G

oops .. I give that a try - might be a couple of days before I can get back to confirm all ok - long weekend - going to Norway ... so thanks in advance .. G

where would I put this ?

Hey everyone - thanks for your help - this works a treat but now I want to enhance it what i want to do is inset a html file into the body of the email I have created a publisher file and saved as html ..say C:\test\pub1.html :banghead: how do I get this in to the body ? code to date...

Well blow me down as simples as Pbaldy said Thanks to you both what i will do is get this tidied up (I putting an email function in as well) and put it up as a sample Big thanks G

cheers I try that - it late here UK time one for Monday G

a very bland heading I know I have this report that needs to be export - 1 report per record the report exports out but its the same record export out each time ( the name changes - but the data doesn't) i am sure it simplies - but not seeing it ? (I have tried the code down - as there was a...

OK Guys i have cocked up (no surprise there) i have a table with 10 records in it and i want the export to do 10 exports of 1 record each currently i am getting 10 exports with 10 records where have i lost it ? (I know the email element will need changing as this doesn't work this way)...

OK guys almost there (I have "borrowed" from all over the place ) my loop names the file - good I have an email sending out its the attachment that got me foxed Private Sub Command0_Click() Dim MyDb As DAO.Database Dim rsEmail As DAO.Recordset Dim sToName As String Dim sSubject As...

I have had a look at my report and it's so simple that there are 22 lines of text of which 11-12 are going to be the merge element DoCmd.OutputTo acOutputReport, "Reportname", acFormatRTF, "S:\Test Data\xxxx\Policy\" & ReferenceNo & ".Doc", False so this will create a RTF file singular...