Subdatasheets on tables (1 Viewer)

G

George-Bowyer

Registered User.

Local time

Today, 15:14

Joined

Dec 21, 2012

Messages

177

• Dec 26, 2018

• #1

Subdatasheets on tables have sort of passed me by. I bumped into one the other day whilst mooching through someone else's database, having a looksee for interesting things.

I have never used one and now can think of no reason why I would - I never let end-users anywhere near my tables …

What are they for and why would you use one?

 

Ranman256

Well-known member

Local time

Today, 10:14

Joined

Apr 9, 2015

Messages

4,339

• Dec 26, 2018

• #2

nope. I never let users see them either.
They are more for the admin it view and see sub data.

 

Uncle Gizmo

Nifty Access Guy

Staff member

Local time

Today, 15:14

Joined

Jul 9, 2003

Messages

16,271

• Dec 26, 2018

• #3

>>>I have never used one and now can think of no reason why I would - I never let end-users anywhere near my tables … <<<

You are spot on!

They can be confusing even if you know what you are doing.

I suspect it's a feature for people who are used to excel, and are developing their own database for their own use.

As you quite rightly say you should never let your users near your tables.

Sent from my SM-G925F using Tapatalk

 

isladogs

MVP / VIP

Local time

Today, 15:14

Joined

Jan 14, 2017

Messages

18,209

• Dec 26, 2018

• #4

Whilst I'm not a fan either you can also set up Subdatasheets on forms.

When I used to teach Access at GCSE and A level, beginners often really liked them.
More experienced users, less so.

 

P

Pat Hartman

Super Moderator

Staff member

Local time

Today, 10:14

Joined

Feb 19, 2002

Messages

43,224

• Dec 30, 2018

• #5

I only used them on one application because I wanted to create a continuous form that contained a continuous form. I thought the effect was confusing so I never used it again. For the sake of efficiency, you should set subdatasheets to none unless you actually want to use them.