Search results

After various searches (when working) to no avail resorting to new post. apologies if answered elsewhere. Short Backstory. MS Access 2016 32bit. Lots of DB's happily emailing in the background using vba code. Company decides to finally upgrade to win10 and fully adopt 365. Great. Although that...

wish access let me copy/paste the error description as is rather lengthy

i didnt think that at all - and i stated which lines fail. that was in response to the debug.print request.

top notch idea that - could use a flag - see how on off is interpreted by access and code accordingly. thanks for that - will update on my progress. if anyone else knows of the VBA code solution - feel free to respond.

ok - so linking folders worked but as you say i would need a mechanism to know when an email has been dealt with - might have some code that can shift the email out of the folder when 'imported'. As for whether other users can make use of the linked folder remains to be seen (awaiting their...

cant do debug.print on this because i get error 287 when trying to run this code on access365/win10 first 2 lines work fine in both 2016 and 365 but then the senderemail and body refuse to run in 365/10 going to try linking the folder though and see if any benefit from that..

the lines in question - within the ELSE part of the statement three = MsgBox(OutlookMail.Sender.GetExchangeUser().PrimarySmtpAddress, vbOKOnly, "3") four = MsgBox(OutlookMail.Body, vbOKOnly, "4") linking the folder - would this link work for other users - i wondered...

Morning All I have been everywhere for months and cannot get to the bottom of the following problem Scenrio: Currently get requirements from the business via a request in the shape of a table (excel) that is imported into an Access DB. Our company is currently moving to win10/office 365 and i...

no matter which credentials are provided - login is not possible unless its me and i never get the login request they can open the DB just cant view any shared list whether linked or created/linked we have no access to internet options so cant changed preffered sites both .. Ribbon > Create...

multiple different ways 1. i create access DB, i create sharepoint list from access to our sharepoint site(of which we are all full permissions), other users cannot open list from within Access - asks for domain log on 2. i create list on SP site, i link to it in a new Access DB, nobody can...

online. we use citrix but dont think its used for that

You have got it. On the SharePoint site .. anyone i have setup as a at least a contributor or higher can create a list, modify it etc When i create or they create a database that then either links to an existing list on the SP site or creates a list on the SP site from access.... cannot access...

update: other users can create a list on the site trying to link to the site from access - still wont allow i linked the list to the DB but then it refused to let anyone else into the list from Access.. i'm convinced its a setting in Sharepoint that Access is getting confused over but no idea...

ok - good plan - so frustrated that didnt think of that - will try and advise

i haven't tried - is the thinking that it may force the DB to start recognising them as well? even if that works i cant get everyone that uses my front ends to do that...

Afternoon - its has been a long while since i have been asked to do anything that required any outside help but this task is drivign me up the wall and wondering if anyone has any insight. Setting: Access 2016 as a front end using sharepoint lists as tables. Nothing to crazy so well within...

Doc Man: All valid points - did wonder if I was gonna achieve it through standard controls etc. I have it working with 7 lists but the software I am trying to replace looks like its been custom written in C+ or similar (very old bit of software). Our IT doesn't allow much to happen without...

Background. I am coding a simple database that tracks jobs and which vehicle they are allocated to for delivery on a given day. the team that schedule the jobs need a weekly clickable plan that shows the vehicles as the rows and the days of the week as the columns. the jobs showing need to...

Hey all. Been using access for basic to mid level requirements since mid 90's and now beginning to struggle as my current workplace are actually using my training :) thought it was about time I joined - and you never know - I may be able to help someone in return :) Dave