Go Back   Access World Forums > Microsoft Access Discussion > Tables

 
 
 
Thread Tools Rate Thread Display Modes
Prev Previous Post   Next Post Next
Old 06-26-2019, 03:24 AM   #1
Chumpalot
Newly Registered User
 
Join Date: Mar 2015
Posts: 68
Thanks: 28
Thanked 7 Times in 7 Posts
Chumpalot is on a distinguished road
Dynamic toggle buttons to control values in a single table

Hi all,

I will try and keep this as succinct and to the point as I can, more for my own sanity and to save me getting confused and ultimately rambling.

I am trying to create what is essentially a sort of diary system in Access (2016). I know this isn't ideal and I should probably explore some sort of integration with Outlook but for now I'd like to contain it all within Access.

There are 230 countries attending a single event taking place across one day. There are timeslots within this single day that any country can attend from 0600 to midnight. The timeslots are 10 minutes each and a maximum of three countries can attend any one slot.

I have a form that records other ancillary information that isn't important here. This form is dynamic in that it pulls the country value through from a previous selection screen. I am trying to build an Open Table type timeslot selection screen which is essentially a grid with toggle buttons to represent times. These go green when they're clicked and the county value is stored into a textbox which I was going to link back to the timeslot table.

From here I am a little stuck. I am not sure how I should go about recording this in the table. Could it be that the toggle looks for the stored country value and then scans the table for the matching country value and then enters a value into the correct timeslot?

Table design
tbl_timeslots
CountryID
0600
0610
0620
0630
0640
0650
0700
etc
etc

Another issue is then how the timeslots look when opening the form. The ones that have been pressed will need to stay pressed (and green). I guess first things first though (code a little, test a lot etc).

Thank you for any and all help on this.

Regards
David

Chumpalot is offline   Reply With Quote
 

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] Toggle buttons Sway2119 Modules & VBA 2 03-11-2014 09:34 AM
Form control to combine multiple field values into a single text box brharrii General 2 05-13-2013 06:22 AM
Getting multiple values into a single field by using radio buttons/check boxes Sasith Priyankara Forms 1 09-07-2012 05:39 PM
use of toggle buttons... zym1ne Forms 2 07-25-2003 09:55 PM
Toggle Buttons tnago Forms 7 05-28-2003 04:41 PM




All times are GMT -8. The time now is 01:15 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World