Search results

Hi Guys - having a a minor moment .. ok I have a continous form and on each "record" is a country Germany/France/ Ireland/USA states .50 of them ...) and i select one from a drop down list (no problem) OK I want to have a list (showing on the record /form) of all the other records...

Hi guys - long time no speak i have a report that that i need to be a bit dynamic If quoteslip = q basically the report does nothing other than how i have already set it up however if quoteslip w then do stuff "w" does what i want however "q" doesn't I have tired we me. etc the...

Hi guys been a while and before i go down this route I have thought of - thought it worth asking the question .. Product A = a form with 8 buttons on them - each button opens up a form /table and I do stuff in each of these of these 8 forms tables - each doing something different...

OK I store emails in folders ( network drive ) so S drive then client then ref so S\ client\ 12345 and I store outlook emails in these folders so s\ client\12345\ quote.msg is there a way of getting Access to list *.msg files (this bit is easy) and then preview the...

I have copied and pasted - is there a way round this from access ? - (I don't really want to tinker with outlook setting unless i have to ) I have one environment where it all works fine - but when login onto a remote session (ctrix) the antivirus is unavailable The Outlook Trust Center...

Odd one background I report on multi currency mutli tax and I have to do a "report" on each so i have created a list box that shows excatly what I want (on the form) Example) EURO Dutch Tax EURO Germany Tax etc.. USD Dutch Tax etc..... ok- Now I want to select any one of them...

ok this a bit of ponder I have a file save as for Outlook messages (works pretty well) 1 user has had a gremlin and I thinkj I have tracked it down the file save as takes the subject of the email and makes it part of the "save as name" if I do Dave as the subject - no problem if...

Hi Guys - this is a continuation but seperate from a previous post My users have two accounts and I have email automation to copy rename and file emails (working like a charm-code pinched from somewhere) The issue is that it worksw on default email account - - OK so temporary I...

Access 2010 .. ok guys when I type the following 4it spanners out on top line on Application.sessions.accounts (its the sessions - its not seeing - ) what/where have I goofed ? (the intention is to set the getdefaultfolder to the account I need as I have two accounts and this looks...

Hello everybody.. I have what is probably gong to be very simple .. on my start up form "Welcome" a timer event (interval 1000) If (Time() >= "04:20" And Time() <= "04:22") Then Quit acQuitSaveAll End If - all well and good and does the job I want (to kick all users out at x time )...

Hello people I am sure that I am just missing the plot on this one ok - 2 queries excatly same field names (keep it simple) I get all the data I want - great - but cannot get it to sort (Numerically ) the first field is numeric and is numbered 1-999 (with gaps ) 1-199 is x and...

Hi Guys I have had a stab at this and i seem to fall over .. Is there a way (VBA) to change the default outlook profile from 1 (default) to 2 - I can send an email and get Access 2010 to know which account to send from but after I have sent an email the D/b then checks sent items...

Hi Guys I am sure this is a quickie I am passing through from access to outlook ( I can get it to send from default and also send from an alterntive account (2) but the filing system looks at the default "get Default" how do I get it to look at the sent account (2) profile ?? Dim olkns...

Hi Guys I have a minor issue and I am simplify the problem as much as I can OK - I need to use a different profile (?) account when I am doing busines/emails in the EU I already have a trigger that I can use (EU yes/no) tick box what i am after is somehow if EU (true/ticked etc) then...

https://stackoverflow.com/questions/25999201/add-signature-with-images-to-the-mail ok the above states that you can edit your html signature to insert a picture .. - i must be doing somthing wrong ... <xml xmlns:o="urn:schemas-microsoft-com:office:office"> <o:MainFile...

OK I have an number of records (transaction) in different currencies (and different tax rates just to make it interesting ) so lets assume I have 20 USD transactions and 3 tax rates Great I can group and summerise 10 at tax rate 5% 5 at 12% rate and 5 at 21.25% tax rate 3 lines...

Hello the world - hope all is well (It has been some time since I have been on this forum) - Straight to it . I have "pinched/borrowed " some coding to open outlook and then file the sent email - however its being "awkward" and I am not seeing the issue...

Left this one a little vague.. If I explain what I kinda want (which may be too much ).. I want to file emails in and sent - in a folder per records so record number 12345 will have a folder on the server "12345" is there a way of selecting the email and copying it from the inbox/sentbox...

Hi everyone I have data coming in via a csv file - no problems - want to import into table - I can work this one out no problem - however the csv file will come in three different layouts column 1 name standard etc... version 1 will have x number of fields that are not in 2 or 3 and...

Hi Guys I am embarking on a new database I have a main form and a subform/child form that is different for each type of business (see below) form filter is on main... If Me.FormFilter = "0" Then Me.FormLoadX.SourceObject = "NoSchemeSelectedfrm" End If If Me.FormFilter = "1" Then...