Filter Your Data with Access 2013

re: Filter Your Data with Access 2013

Alan Cossey — Mon, 24 Dec 2012 20:39:28 GMT

Question no. 2. I am trying out my Access 2013 web database and using it on my Android 4.0 tablet. No matter whether I use the built-in web browser, Google Chrome or Firefox, there are no scrollbars appearing in the browser. thus I can't use my app.

Is it my tablet (with all three apps not working properly) or is there something wrong with the way Access creates the pages?

re: Filter Your Data with Access 2013

Alan Cossey — Mon, 24 Dec 2012 18:47:20 GMT

To clarify my question on Rich Text, I realise that Access 2010 web databases stored the text as, well, text, and it was the UI which did the magic showing and editing colours, underlining, bold and so on, but this does not appear to be possible with an Access 2013 web database.

re: Filter Your Data with Access 2013

Alan Cossey — Mon, 24 Dec 2012 18:41:13 GMT

In Access 2010 web databases, one of the really good points was the ability to use Rich Text. Is this possible with Access 2013 web databases, please, or has this been removed?

re: Filter Your Data with Access 2013

Andrew Stegmaier — Tue, 04 Dec 2012 00:10:08 GMT

Eric,

Sorry to hear you're having trouble--can you tell me more about what error you're seeing and what the UI macro is that you're trying to write? One tip that might help: the UserEmailAddress() function is only available in UI macros (not data macros).

-Andrew

re: Filter Your Data with Access 2013

Andrew Stegmaier — Tue, 04 Dec 2012 00:08:11 GMT

One idea to make this work would be to create a "users" table where you would store the email addresses and data on the level of permissions assigned to each user. Then, you could access this table with a Data Macro from the On Load UI macro. That way, each page could simply check if the logged-in user had the appropriate permissions--in a general way--rather than typing each email address into the macro.

re: Filter Your Data with Access 2013

Eric Harness — Sat, 01 Dec 2012 00:12:40 GMT

Andrew

I am officially lost on how to properly use the UserEmailAddress() expression. I keep getting a parsing error...

Help...

re: Filter Your Data with Access 2013

Eric Harness — Fri, 30 Nov 2012 23:24:29 GMT

Andrew

After some more digging I found the "On Load" UI selection. Would I have to enter every single email address seperately, or is it possible to restict the view based on the email extension ex: @hotmail.com or @gmail.com

Thx

re: Filter Your Data with Access 2013

Andrew Stegmaier — Fri, 30 Nov 2012 02:42:03 GMT

Eric,

One way to do this would be to add an OnLoad UI macro for the forms you want to restrict. You can use the UserEmailAddress() expression to check the current user and allow or restrict the view as appropriate.

-Andrew

re: Filter Your Data with Access 2013

Eric Harness — Fri, 30 Nov 2012 01:55:46 GMT

Is it possible to restrict a web app user's interaction/view? For example: what if I wanted to restrict "Dave" to only viewing/interacting with the database through the "Research Projects" view, but still allow other users full access....is this possible?

Thx

re: Filter Your Data with Access 2013

Thorsten Hindermann — Tue, 27 Nov 2012 09:55:33 GMT

That's a god HowTo creating a view for growing amounts of data.