Search results

I have a Sharepoint365 list which I can link to from Access 2010. Unfortunately - no matter what I do I cannot seem to edit the list and it remains read only. I can see that I can set permissions on the Sharepoint365 backend but when Access 2010 connects it never asks for any credentials. I am...

Thanks Steve. I was trying the Access angle first just to see if anyone else had any experience with this. I'll give it a go.

No-one? In this Internet age I would thought there must be some ways to speed this up.

What is the fastest way to query a MySQL database over the web? I currently use the latest MySQL ODBC drivers which work perfectly - but everything is very slow. Even simple queries over tables just doing a simple join can take an age to download the data. Ignoring the speed of the internet...

Pleasure. Just hope it saves some of you guys some time. In the end I went down the KB install route. Not ideal for people distributing apps but really - as far as I can see - it is your only sensible option.

Known workarounds: 1. Request a package of KB983246 and install it on your customers' machines. Re-compiled application should work after the package is installed. 2. Re-write your application to use later binding to ADO, or use interfaces with name xxx_deprecated. 3. Keep an old version of...

Re: WARNING - AVOID Windows 7 SP1 Yes - it is this problem - but there appears to be some workarounds. 'Just to make this clear: this is not a VB6 only issue. Any programming language using MDAC COM classes with more specific interfaces than IDispatch will break due to the changed IIDs.'...

And lo and behold... http://social.msdn.microsoft.com/Forums/eu/windowscompatibility/thread/186656cb-4e85-440c-be5f-1feea726c467 Someone else with potentially the same problem - although not Access - this would cause my issue. Microsoft - don't you test things anymore? First the WinPhone 7...

WARNING! AVOID Windows 7 SP1 Really weird. I have installed Win 7 SP1 and since doing so whenever I compile an app and accde it it now no longer runs on my target machines. The targets being Windows XP. I didn't understand it at first but I have done lots of testing and found that old...

Nothing? I kind of hoped that someone here would be XML savy.

I am about to start work on creating an XML feed form my Access app. Is my general understanding of how this works (below) correct?: 1. Create an XML file from Access - essentially a text file with XML fields etc. 2. Append or upload this to a web server. 3. Refresh after some pre determined...

Thanks - but I think I'm going to stick with vbSendMail and do a similar thing to yourself and keep the address book in the app.

Thanks for that idea Boyd - the BCC tip is really quite neat.:)

What is the best way to email from Access? I have used many different systems but they all have some drawback. I want a system that works with Outlook and Thunderbird, has the option for bringing up the email program screen incase a user wants to edit the email and also supports multiple...

# Where did you get it from? Sorry I didn't see any company link in your post. Thanks.

I know - it is quite a neat trick - but unfortunately it has limitations and doesn't work on all calculations. I forget the exact limitation... Just checking now and I can get it to work in the query but as soon as I transpose it to a list box on a form the colour formatting is lost. If it did...

That's a good point - I had forgotten about them. They still do ActiveX controls. Does anyone know if Access will always be stuck with VBA or will there be some wrench away to .Net? (not sure how they would make such a migration - but it would be A Good Thing™ IMHO).

Hello. Can anyone recommend a good list box control for MSAccess 2010 please? I have been using eXList from eXontrol which is okay but has some speed limitations. I need to be able colour individual rows/columns and allow using sorting on each column. Any suggestions would be great thanks.

I have just moved to Access 2007 from 2003 so I am currently going through the 'ribbon pain'. I have a custom ribbon that shows all of my existing menu options from my old, easy to use and edit, commandbar but it doesn't currently load any forms. I am guessing that I need to write a callback...