Cascades And Datasheets, Oh Joy!!!
Jul 6, 2006
Hey ho
I have a table full of dates and each date has multiple time slots, and each time slot has multiple data values.
What I would like to do is have 2 cascading combo boxes (for date and time), so when you click the date it returns only the information for that date in the datasheet, and then click on the time combo box (which displays only time slots for that date) and returns the specific time slots for that date.
Any help with this would be most grateful!!
View Replies
Nov 1, 2007
Access 2007 apparently no longer has the autofill feature with datasheets. This was an option that I used frequently and not having slows down greatly my particular tasks.
Is there some way of activating it?
View 5 Replies
View Related
Sep 3, 2015
I have data sheets as subforms on a Main nav page that show the students and the classes they are enrolled in. I have combo boxes to filter this for individual classes /students. On the Classes By Student DS I have the cost of each class. I want to total these classes per student and start building an accounts system that will show how much they owe and how much they have paid. I just need to start with the totals though.
On the Student by Classes DS I want to generate registers as reports. The only hard this in this is I would like to have a box for each class date on the form. I have put the term dates in a small table and I want a box for each class day from that.
View 3 Replies
View Related
Jun 24, 2015
My goal is to use a combo box on a nav pane to filter the following 5 nav panes with data sheet views on them. The combo shows 'component' and should filter each datasheet to only show records with the same 'component' selected in its respective component column.
What I'm currently dealing with is said component combo disappearing upon nav change, and I can't get it to filter the datasheet..but that is likely due to the fact that I cant get it to hold value on page switch.
View 2 Replies
View Related
Aug 16, 2014
I need to make the text size smaller to fit everything on the screen (users use 17" monitors..). I have gone into each form and subform and changed the text size for each text box to 9, but when I view them in form view the size has not changed ?
Also .. is there any way to make the autocentre option actually work as it's name suggests !! ? it does in most cases centre horizontally, but never vertically, quite often putting the top of the pop up form over the ribbon bar.
I would actually like to be able to totally remove the ribbon bar so that only the database forms are the only thing the user sees.
I vaguely remember being able to do this in Access 97 (Which was the last version I used - a long time ago !) but this seems to be more difficult in 2010 version.
View 5 Replies
View Related
