Search results

Hi Thanks for reply, Im getting a little lost I have amended my code to include the code you suggested which now looks like the following below. Im just getting an error message when I open my form reading 'Loop without Do' As a beginner im struggling to work out what has changed from my code...

Thanks Paul Not sure what CDO is so will do some research.

Hi Everyone Not sure if this is possible I use the code below to send an email when a status of a drop down box has been changed, all works great but is it possible to have that email sent without opening Outlook so in other words it runs sending the email in silence? Thank you for any help...

Thanks I completely understand and agree with you however in this instance I have a login system so before the db even opens onto the Nav form any saftey checks that are due pop up as a reminder, we then immediately action that reminder. Due to the nature of the safetycheck for example fire...

Hi I have a db for some property maintenance. I have some code on the 'on open' function on my Nav form which checks some safety check dates within a safety check table and if a check is due within 30 days a simple alert pops up to remind me. I now want the code to check the dates in two...

Thanks still get message saying I dont have exclusive access, sharepoint lists cannot be taken offline all db killed and pc restarted. Have tested the built in button on the ribbon and that lets me go offline and disconnect sharepoint lists no problem the only time ive been able to do it was...

sorry and how am I trying to run this now, by clicking the cmd button on main db or opening the new db with the autoexec? thanks

Just a little help in summary so main db had a cmd button with on click event with code updated below new db has the module with updated code below then i have to create a macro in the new db autoexec (not sure how to create a macro to the toggle function only ever use whats available in the...

I have re run that post 14 test from a cmd button on a single form in the new db and it works ok toggles between online and offline the main database. Yes always start with main db online. thanks

Hi No I just wanted my own cmd button on my nav form to toggle online status. When i click the built in button in the ribbon it immediately starts connecting or disconnecting sharepoint files then shows as online or offline with sharepoint button works really well just a pain its not within...

Yes lol thats the button i am trying to get onto my Nav form as my db loads full screen with any of the access commands or toolbars. This is because other people use my database so don't want any back office MS Access on show. So at the moment I have to keep minimizing everything down to get to...

oh dear not actually sure cant remember what i did when i set this up is that easy to check. All my tables are linked to my sharepoint site so i can save and change data from several locations. When i make alterations to the database like forms etc i simply upload the db to my sharepoint...

Cleared everything still same message and I notice that the new db seems to have a second icon appear with a padlock on it on the database which just seems to remain on desktop. I really appreciate your help, sorry my knowledge is so basic.

same error message on debug highlights following: .RunCommand acCmdToggleOffline

So It appeared at a quick flash as if the database was closed and reopened then a pop up message saying: runtime 31652 you do not have exclusive access to the database. Your sharepoint lists can not be taken offline or cached at this time no other databases open restarted my pc to check...

the message returns saying its the path of my main database

No basicallywhen I click the cmd button on my Nav Page it immediately loads that error message that the database is already open

Ok thats done when I click button error message 7867 Database already open when I hit debug, highlights. OpenCurrentDatabase AccAppPath in yellow???

Hi yes this is related to our current request for help Thanks

I know if I create a macro and save it autoexec that should run that particular macro on the db startup. I did look through the macro list in the hope there was a simple toggle offline option. sadly not lol jon