BBlu
asked on
Trying to hide columns in subform datasheet
I downloaded a Microsoft Template Access DB for Task Management:
http://office.microsoft.com/en-us/templates/task-management-database-TC001225356.aspx
I did it just to learn more about forms and subforms.
Now, I have a question. I created a new query that added three fields (PastDue, DueToday, and DueThisWeek). With that query as the record source, I created three forms (used as subforms) that each filter for one of those three criteria. I then have a main form that has these three as subforms.
But since I copied and pasted one of the default views, [Open Tasks], and did the same for the subforms, the subform has a lot of fields that I don't wish to show in the subforms. I could delete them from the forms I assume, but I'm wondering why just checking the visible property on those fields to "No" doesn't work.
http://office.microsoft.com/en-us/templates/task-management-database-TC001225356.aspx
I did it just to learn more about forms and subforms.
Now, I have a question. I created a new query that added three fields (PastDue, DueToday, and DueThisWeek). With that query as the record source, I created three forms (used as subforms) that each filter for one of those three criteria. I then have a main form that has these three as subforms.
But since I copied and pasted one of the default views, [Open Tasks], and did the same for the subforms, the subform has a lot of fields that I don't wish to show in the subforms. I could delete them from the forms I assume, but I'm wondering why just checking the visible property on those fields to "No" doesn't work.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Oh for goodness' sake - just delete the columns. Why make something trivial so complicated?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Why so judgmental, Badotz. I'm actually a VP of Finance with a nerdy developer side. I did google and I have tried to research. I've always had success on EE and thought, as if often the case, that I was beating my head against the wall on something that might be easy that I'm overlooking. No need to be harsh. I'm just trying to learn here, man.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
you can also use the Format > hide columns for this purposes
ASKER
Thanks, Capricorn. It just turned out that I couldn't do it at the source level. I can hide them when the main form is in Form view, but setting the field view property to 'no' in design view of the subforms wasn't working. And I was just trying to figure out why. Thanks to everyone.
Huh? I never mentioned any names - which in my case usually means I'm the subject ;-)
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Sorry, Badotz. I guess I took it personally. A finance guy like myself can get pretty intimidated- or at least extremely impressed- inside this forum. I continue to learn and grow from you all. You all have a great rest of your weekend.
ASKER
Thanks to all of you
No worries.
ASKER