Search results

I think the OP was asking to send via email using VBA. The print drivers I've tried won't allow you to programically save the file in a location of your choice (you may know better) therefore I discounted this option. PDF came in in 2007 but if you were going to upgrade now surely it would be...

John I'm afraid it's the dll method described or upgrade to version 2010. The 2010 built in version creates the PDF's alot quicker than the other method, but both work consistently well.

Glad it works for you. Either that sites got the extensions wrong or Microsoft have missed it off the list. Wonder if it would work if you went to all files and then selected it. Not 100% sure but i don't think functionallity is compromised by changing a .accdb to .accda, it maybe just to help...

.accda by the looks of it. http://www.file-extensions.org/filetype/extension/name/microsoft-office-files

In access 97 to 2003 you can put all of your user defined functions in a database .mdb or compile to .mde if you want to prevent any changes. Then change the file extension to .mda. In your working db you can open a vba window go to references where you can browse and select your .mda file. I...

To use Docmd.sendobject you need to have a MAPI compliant email program installed and configured on your PC such as Outlook or Outlook Express (if your using Windows XP). You can't use a browser based webmail for this.

Ditto thanks Jon.

I note that when I clear my browser history on my phone and come to AWF on it I get a message saying that tapatalk is available for this forum, however when I go in to tapatalk I can't find it. I'm relatively new to tapatalk so wondering if its me, not configured properly at AWF, or at tapatalk?

That seems to work, though the data in the list box is out of sync, but if you are going to assign each element of the address to different variables and or form fields you should be able to pick them up from this. There may well be a more elegant way of acheiving, but it works (with limited...

Why not go all the way to 2010. Check your code and make sure you remove any depreciated features, make your own ribbon(s). The runtime package is free to download and you should be future proofed for longer

Try saving this to a module Option Compare Database Option Explicit Global Const SW_HIDE = 0 Global Const SW_SHOWNORMAL = 1 Global Const SW_SHOWMINIMIZED = 2 Global Const SW_SHOWMAXIMIZED = 3 Private Declare Function apiShowWindow Lib "user32" _ Alias "ShowWindow" (ByVal hwnd As Long, _ ByVal...

I have had this error on my remote server. It came and went by its self. I put it down to the connection from the remote server to the smtp server not being available. May be on the domain the smtp server is not available due to security settings, IP or port?... may be?

I think its your source defaults. The 2nd one "someipaddress" unless you've removed the correct info, but other info is needed as well. Below is the config I use. '==This section provides the configuration information for the remote SMTP server. objMessage.Configuration.Fields.Item _...

Run the function which disables the allowbypasskey and see if that frees things up.

Under the Active Directory users, go to the properties of a user, then the Enviroment tab and tick 'Start the following program at log on', then specify the shortcut link underneath. This automatically starts the db when they log in and avoids them getting to a desktop on the terminal server...

Google up the mysql odbc connector, they give instructions to install setting the tcpip server to your server computer where the data is, then in access Get External Data - Link Tables and in files of type select odbc databases, select your connection, or create a new one here and then you can...

You could use the Docmd.outputTo command to create the pdf giving a folder and name, then use the Outlook object to create your email and attach the pdf. HTH

I think the problem is deeper than that. Look at this post http://www.access-programmers.co.uk/forums/showthread.php?t=205800&highlight=windows+7+sp1 If you compile the db on a Windows 7 PC with sp1 it won't run on Win XP. Sorry :confused: And here is some more...

You may need to set the references to the default location before you package the db for runtime, or use some code to set them when the db is opened. Something like Dim Ref As Reference Set Ref = References.AddFromFile("C:\Program Files\Microsoft Outlook\Office11\msoutl.olb") Modify the path...

If you need to store the amended flow rate in access for future reference then you need to modify your data in access, if not then you can do a calculation on the way to Excel. Depending on the complexities you could use a query or VB for either senario.