Search results

HI - thanks for all the advice - very much taken onboard!!

Hi there experts.... I'm after a little advice regarding the below if someone can give me a steer please? I deploy my MS 2010 Access DB's via terminal services, and a few of my clients would now like to send emails from my DB. If this was a local app, I'd just use Outlook, but with it being on...

Bingo!! Perfect and thank you

Hi, I'm wondering if someone can help me please? I have a field: [Total_Paid] which contains a currency value. What I need to do is work out what VAT was added to the net amount to get the [Total_Paid] through VBA So, if £300 was in the field [Total_Paid], I need some code that would put £50...

Hi, Quitting to doc as suggested put's us back in the "Machine Not Available" error code. Really doesn't want to release this doc :banghead: thanks again

Hi pr2-eugin - thanks for the help. Yes that lets me cycle through the mail merges without the error. I do have a new promblem though (scream!!) As I'm no longer closing the docs after printing (it errors if I try) - the second batch of code (same as the first but pointing to a different word...

Hi, Thanks for your help. The word doc now asks me if I want to save changes (which I'd need to stop as there are a few merges to run, one after another). When I manually click "Dont Save" - I get an access error: "Runtime Error 5861 'Name' is Read Only Property" This was for both lines of...

Hi, I'm hoping someone can help me please? I have a word doc (2010) which is connected to an access DB (2010) for a mail merge. The mail merge has already been done from word to access, then I'm just using a vba call from access to open the word doc. When I run the command the first time...

Hi, I'm hoping someone might be able to help me please? I'm trying to use an API to send an SMS. I've already got the SMS supplier etc etc - but when I run the code, I get a "Object Required" - "Runtime Error 424" at the following line: Set oXMLHTTP = Server.CreateObject("Microsoft.XMLHTTP")...

Hi experts, I'm hoping someone could help me please? I currently deploy MS 2010 DB's to end users from a 2008 Windows Terminal Server. Does anyone know how / if I can get the DB to open outlook on the users local system? Traditional Outlook calls just try to launch from the server (which is a...

.oApp.Quit nailed it - thanks for all the help that's really great!! I finally a fully working mail merge - only taken me 3 weeks to figure out!! :p

Have a login form right at the begging of the DB so users must go to this and enter their username before they can go elsewhere. When they progress from thism you can either minimize the login form or just hide it - either way leave it open. You can then do one of two things: On any form where...

Is your DB on a network, or another shared area?

Hi experts, I have the below code which is opening a word doc and merging it. The last two lines of the proceedure are really killing me now oApp.ActiveDocument.Close oApp.ActiveDocument.Quit The first will close the document, but the second errors and says there is no...

Hello experts, I'm trying to get a word document which has already been merge into an MS Access 2010 DB to open, merge and print with VBA. The code I have is Private Sub Command2_Click() Dim oMainDoc As Word.Application Dim oSel As Word.Selection Dim sDBPath As String Set...

Hi, I'm hoping someone can help with what has been a long standing issue. I have a multi user database which is deployed over terminal services to end users - all is well on this front. The issue is, I need my database to run a macro (with a couple of queries in) every two minutes. I can...

A before update which is possibly the issue. The double if is because I need the code to behave differently for each answer in the combo box (this bit works)

Hi - I'm hoping someone can help me please? :banghead: I have a combobox which is bound to a table from which it get's its text values. When a user changes the value of the combobox, they are promoted with a vbYesNo - do you want to make a change. If Yes - stuff happens / If No - it doesn't...

Hi David, Thank you again for replying. I'm not an expert when it comes to VBA by any stretch :o > below is the code I am using. Would you be able to show me what and where to put in the lines you are talking about please? Thank you so much for your help - I've lost days on this!!! :banghead...

Hi David, Thank you for replying to my post. Unfortunately the Word dialogue box that appears when you open word directly does not appear when you open it with VBA. Thanks for trying to help though.