Code:
function onEdit(e){
var sheetName = "Debt"; //name of sheet to adjust formatting on
var
Brilstern
Last Activity: Apr 21 '21, 03:57 PM
Joined: Dec 22 '11
Location:
-
How do you set Accounting format in Google Script App?
In the function below, I am using column H to adjust the format of column F. I would like to adjust this format to an accounting format, but I am struggling to do so. Does anyone know how to convert this string, "USD":"[Red][$$]#,##0.00", to an accounting format in the Google Script App?
... -
Reopening an old thread!
I am having a similar problem to OP and I did not find a solution through the Googles...
I have a form with several tabs, with buttons on each tab. One of my newly created command buttons disappears randomly and comes back when switching from tab to tab. I am not sure what causes it to disappear and come back.
I tried first compacting and repairing. No change.
But,... -
Work Offline "if" SharePoint Connection hangs/fails
Issue: SharePoint hangs (not exactly offline so MS Access does not switch to offline mode) and Access freezes on open.
Details: When my Access DB opens, it is prompted for a user to establish who is using the database to use in emailing/logging. This data is referenced from an online table (SharePoint) that requires authentication.
Check out this link for details on the authentication.
Question: My envisioned... -
Brilstern replied to Can MS Access display the user authentication that its backend SharePoint requires?in AccessHaha, not quite..
So. In the end, for those reading, the solution to the orginial issue of authenticating to SharePoint:
Do this as part of your AutoExec to ensure that the user has authenticated prior to connecting to online datasets.Code:CurrentDb.TableDefs("<TableName>").RefreshLink
To avoid design mode/exclusive access:
...Code:Access Options -> Current Database
Leave a comment:
-
Brilstern replied to Can MS Access display the user authentication that its backend SharePoint requires?in AccessSo... The problem might have been something to do with caching./?
I did this:
Access Options -> Current Database -> Caching Web Service and SharePoint Tables.
Uncheck all.
And the problem no longer exists.
Thoughts?Leave a comment:
-
Brilstern replied to Can MS Access display the user authentication that its backend SharePoint requires?in AccessSo I just educated myself...
using backend... smart; for this effort, does nothing
The SharePoint tables are not "in" the backend caused they are linked to the SharePoint. (Duh, I somehow wasn't thinking about that)
So now I am back to my original problem.
How would I force the front end to refresh the links to the SharePoint tables each time the database is opened to ensure they...Leave a comment:
-
Brilstern replied to Can MS Access display the user authentication that its backend SharePoint requires?in AccessHey twinnyfo,
Update #2
So... I (don't make fun of me) usually avoid splitting my databases... but I decided to for many reasons, to include updating the tables without getting this error.
To address your thoughts.
When a user opens the (now front end) database, it:
opens a flash form for 3 seconds and closes
opens a user access agreement prompt, user clicks ok, prompt...Leave a comment:
-
Brilstern replied to Can MS Access display the user authentication that its backend SharePoint requires?in Accesstwinnyfo,
Revisited this today out of curiosity and made "some" progress. I created a public function that refreshes the linked tables, and ran it as part of my AutoExec.
Exhibit A:
But... this is a design function and opens the database in design mode. So...Code:Public Function TableRelinkSample() CurrentDb.TableDefs("<TableName>").RefreshLink End FunctionLeave a comment:
-
Indeed it is NeoPa. I have done quite a bit of work from excel to access and access to excel. As you stated, not always the most direct method; but it can be much simpler, as temporary content through excel is much easier than access.Leave a comment:
-
Yeah... I am still researching, but it tends to be a common problem when attempting pass-through queries DSN-less. Most (from what I have read) just move to a DSN file based connection and give up... Still looking though.
-BrilLeave a comment:
-
Have you thought about dumping the remote tables into a spreadsheet then importing back into your local DB programmaticall y? Might be a little more code, but it bypasses your credential problem, I believe...
-BrilLeave a comment:
-
Seth,
Do you mind posting the snippet that is causing the error?
-BrilLeave a comment:
-
Brilstern replied to Can MS Access display the user authentication that its backend SharePoint requires?in AccessHaha, well at least I can laugh with you! :)
Got to love it...Leave a comment:
-
"one would think"
#microshaftwind blowsLeave a comment:
-
Brilstern replied to Can MS Access display the user authentication that its backend SharePoint requires?in AccessLol, it is all good.
Unfortunately my situation is even more complex. Although the SP uses the same smart card for creds, it doesn't use the same AD structure or accounts as the domain. It is a multi-domain SP. So I am in the "must open browser" first bucket... I tried programmaticall y opening the SP portal from the first form open in my DB (prior to any forms that query data); but it doesn't authenticate properly, and then...Leave a comment:
-
Hi Seth,
Unfortunately this is a known bug in MS Access. Some of those little bugs are irritating, but at least this one has an easy work around.Leave a comment:
-
Brilstern replied to Can MS Access display the user authentication that its backend SharePoint requires?in AccessHey twinnyfo (hope all is well!)
Yeah, I came to the same conclusion. If the user opens the SP portal via a web browser first, there are no hiccups and the MS Database works as it should, obviously authenticating with the session credentials already initiated by the user. Although slightly annoying, it's not the worst work-around. What I would really like to explore is; force the MS Database to request user authentication in lieu of...Leave a comment:
-
Brilstern started a topic Can MS Access display the user authentication that its backend SharePoint requires?in AccessCan MS Access display the user authentication that its backend SharePoint requires?
This question is similar to @twinnyfo's question here, I am trying to access a database that has some credentials requirements due to the backend SharePoint linked tables.
The database links to 6 tables that sit on SharePoint that uses a smartcard to verify access, specifically the card and pin. After you authenticate, the site becomes available. When you access the database without first logging into the SharePoint site, it freezes,... -
Ok so I implemented your solution and to no avail... same result. It iterates through the code and runs it, but it still doesn't allow me to use the Shortcut Menu. Quite weird.
...Code:Public Function UpdateForms() 'On Error Resume Next Dim FrmName As String Dim Frm As Form Dim i As Integer Select Case strGlobalAccess Case "Administrator",Leave a comment:
-
Thanks for the reply Phil! Checking it now. Any thoughts on why my approach is not working?Leave a comment:
No activity results to display
Leave a comment: