Search results

Colin, May be another cul-de-sac, but this link claims to download a file bypassing Internet Explorer. Admittedly it's a CSV file with Excel, but grist to the mill? https://stackoverflow.com/questions/17877389/how-do-i-download-a-file-using-vba-without-internet-explorer

Never tried it Colin, but there is acCmdPreviewOnePage https://msdn.microsoft.com/en-us/vba/access-vba/articles/accommand-enumeration-access

There's also this link, which looks simpler: https://msdn.microsoft.com/en-us/vba/access-vba/articles/additionaldata-object-access But before that, did you copy the code direct from your sub? In which case: DataTarget:=" C: \Documents\rayBuild\EmployeeData.xml" contains a space after C:

Sorry yes the "End If" is about a mile further down the sub! Mine is designed for the user to browse to a folder then click a button to copy and save the file they require to a location and in a filename format that the database can use to open it via hyperlinks. You could simplify further...

Sorry arnelgp but that doesn't work with the Val function. When I tested your code I found that val(var1 & "") where var1 is a variant taking data from a date, the Val function takes the first numeric portion of the date and turns it to a number, ignoring the rest. In my case 10/04/18 became...

There's a bit more meat for you to chew on in this article: https://msdn.microsoft.com/en-us/vba/access-vba/articles/docmd-sendobject-method-access

OK it's a while since I did this and my code is set up with API Late Binding, but the parts that might help you are: Dim fDialog As Object, BaseSearchPath As String 'the path to start the search Set fDialog = Application.FileDialog(msoFileDialogFilePicker) BaseSearchPath = "X:\XXX\XXX" 'the...

Here's some bedtime reading: http://analystcave.com/vba-application-filedialog-select-file/ I've used it successfully, but not in a restrictive way, although the text explains how to set up filters. The downside is that filedialog requires Microsoft Office 11.0 Object Library, which is not...

So using the Outlook 2016/Access 2016 combination, the SaveAs part of your sub works on your personal machine but not on the network. And it's not a folder permission problem on the network because your sub can even create a new network folder. Assuming the Access 2016 database is identical...

Forgive me if this is stating the obvious, but do you have read/write permission to the folder you are trying to save in? Probably best to check with your IT. .Display would not be affected by this of course.

v-Tools is a useful add-in for Access that includes global find and replace. See this thread: https://access-programmers.co.uk/forums/showthread.php?t=171921 If you can't use the carriage return in the Replace part, you could use: Option Compare Database: Option Explicit The colon (":") with a...

Your attachment doesn't include the Outlook object library. I've attached mine for comparison.

The global replace suggested by Minty will set all your code to Option Explicit. This will then of course throw up a multitude of errors if / when you compile the database. I suggest you only hit the compile button when you have several hours to spare to fix all the errors! Alternatively you...

I agree with Mark and Colin, but to address your original question (numbers over 100), I think your "numbers" are being evaluated as text strings. For example, Access will evaluate "1000000" as less than "2". Since you haven't declared valkpi as a number, Access has made it a Variant and in...

If you haven't changed your VBA code, then it doesn't sound like an Access problem. When Outlook was upgraded to 2016, perhaps some settings were changed at the same time. There are some tips here: https://appuals.com/fix-outlook-2016-slow-windows-10/ Otherwise you are way out of my league...

I agree with pbaldy / Allen Browne. You are trying to add to / subtract from your inventory list on the fly - for each transaction you make at the time you make it. This is very prone to error. Even if the coding is right, what happens when the connection is interrupted or the computer shuts...

It was very disturbing to me as an adult. But sometimes it's right and necessary to be disturbed.

Good one CJ!

Hi NT100, If I read your question right, I am not sure it was answered by the other threads (correct me if I'm wrong Ridders, Gasman, Mark). You seem to be asking how to add different attachments to the email depending on who the recipient is, right? But to answer this, please first tell us...

Sorry that wasn't much help. Compatibility issues have been the bugbear of developers from the word go. I have no more suggestions, other than the nuclear option of going back to the earlier versions of Access and Sharepoint, or upgrading Office in that other location.