Recent content by AndyWilcock

Hi Isaac, Thank you so much for your support in this. Sorry about the delay in responding. So I created a Sharepoint list - as you said. Then in Access I clicked on the Sharepoint button. It opened up the "Export Tables to Sharepoint Wizard" box But behind this i got "Security...

Thank you for this. I have now go so far, and it looked like it was transferring all the tables. But then it said there was an error, and it a report has been stored in a log. But it doesn't say where the log can be found...... Also a Security warning popped up behind the window but I...

How do I link Access to Sharepoint? I have my database - I have a "SharePoint Group" But access is asking for a Sharepoint Site ?? - What is it wanting? How do I get the Data-file on to Sharepoint? - Where do I put it? How do I link Access on the different desktops to the file on Sharepoint...

Oooo, I didn't know about CDO - Looks interesting! I'm off to do some reading.

No they were just two different options I've tried from a Google Search Sorry the Forum stripped all my formating??

Yep I'm using BCC - One concern though is that this still transfers all these emails from the Database to Outlook/gmail depending on how Mailto: is set up. So the Admin staff sending the emails still now has the complete list of emails from the original email. which could be a Data Protection...

So I use this code below to call up a Contacts Form and by filter!! But the once in Form_Contacts, I can't clear the filter using a macro or VBA to search (using a ComboBox) for another contact. I've tried Private Sub Search_Contact_BeforeUpdate(Cancel As Integer) Me.Filter =...

Thank you so much guys - went with Mailto: with a long string of emails. Seems to be working!!

My previously Contact DB in Access xp (haha) is used mailto: BUT the string length restricted it from sending more than 200 ish chrs of Email Addresses: So I ended up creating 3 - 4 emails with a batch of email addresses in each one. Our admin then had to copy the email text to each email. My...

Ah yes - thank you for your welcome and answer!! thank makes so much sense now!!

Set rstGroups = dbs.OpenRecordset(Name:="Group_T", Type:=RecordsetTypeEnum.dbOpenDynaset) MsgBox Me.Group ' This shows 340 on the screen which is the group i want from rstGroups rstGroups.FindFirst "GrpID = Me.Group" ' But this line finds the first group in the...