Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 10-08-2019, 02:15 AM   #1
georg7
Newly Registered User
 
Join Date: Sep 2019
Posts: 19
Thanks: 10
Thanked 0 Times in 0 Posts
georg7 is on a distinguished road
automatic data set creation

Hi there,
I've 3 tables (tbl_all, tbl_students, and tbl_tests)
I want a database to check if the students have done their Tests.
The amount in tbl_students shows how often the students have to do their Tests per year.
So my Goal is to create a form where I can select the Student and the test and it's automatic creates as many data sets as the amount is. Like amount(year) it'll create 1 data set. If it's quarter it'll create 4 data sets and if it's Monthly it'll create 12.
The Date should be year(01/01/2019), Quarter(01/01/2019,01/03/2019,01/06/2019,....) and Monthly (01/01/2019,01/02/2019,....).

Is this possible ?

best regards
Georg
Attached Images
File Type: jpg all.JPG (21.7 KB, 16 views)
File Type: jpg student.JPG (18.1 KB, 11 views)
File Type: jpg tests.JPG (16.2 KB, 15 views)

georg7 is offline   Reply With Quote
Old 10-08-2019, 02:46 AM   #2
Ranman256
Newly Registered User
 
Join Date: Apr 2015
Location: KY,USA
Posts: 3,370
Thanks: 0
Thanked 742 Times in 727 Posts
Ranman256 will become famous soon enough Ranman256 will become famous soon enough
Re: automatic data set creation

Make an append query to add the recs to ALL.
In the query ,bring in Students,and Tests and their dates.
Do not join the tables.
Run append.
Ranman256 is offline   Reply With Quote
The Following User Says Thank You to Ranman256 For This Useful Post:
georg7 (10-08-2019)
Old 10-08-2019, 04:14 AM   #3
isladogs
High Noon Moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 11,006
Thanks: 114
Thanked 3,014 Times in 2,741 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: automatic data set creation

Why do you have 5 records for student 1 in the same year when they should be quarterly?

__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin (Mendip Data Systems)
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


"As we know, there are known knowns; there are things we know we know. We also know there are known unknowns; that is to say we know there are some things we do not know. But there are also unknown unknowns the ones we don't know we don't know. It is the latter category that tend to be the difficult ones" Donald Rumsfeld
isladogs is offline   Reply With Quote
The Following User Says Thank You to isladogs For This Useful Post:
georg7 (10-08-2019)
Old 10-08-2019, 04:16 AM   #4
arnelgp
error reading drive A:
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 8,568
Thanks: 68
Thanked 2,744 Times in 2,629 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: automatic data set creation

sample of what your intent.
Attached Files
File Type: accdb studentTest.accdb (548.0 KB, 11 views)
__________________
"Never stop learning, because life never stops teaching"

Last edited by arnelgp; 10-08-2019 at 04:39 AM.
arnelgp is offline   Reply With Quote
The Following User Says Thank You to arnelgp For This Useful Post:
georg7 (10-08-2019)
Old 10-08-2019, 07:17 AM   #5
theDBguy
Im here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 5,866
Thanks: 57
Thanked 1,282 Times in 1,263 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: automatic data set creation

Hi. Just in case it might help, take a look at this blog article on Cartesian Product. Cheers!
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
The Following User Says Thank You to theDBguy For This Useful Post:
georg7 (10-08-2019)
Old 10-08-2019, 12:29 PM   #6
Pat Hartman
Super Moderator
 
Join Date: Feb 2002
Location: Stratford,Ct USA
Posts: 28,253
Thanks: 15
Thanked 1,592 Times in 1,512 Posts
Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all
Re: automatic data set creation

Creating empty records ahead of time isn't likely to be the correct solution. What happens if the frequency of a test changes? Do you delete the unused test records and add new ones or do you just leave the now invalid data hanging out there?

Do the students update this database themselves? If not, how do the tests get logged?

What process in the app looks for missed values?

There are methods to do all of this without pre-inserting records that may never be used.
__________________
Bridge Players Still Know All the Tricks
Pat Hartman is offline   Reply With Quote
The Following User Says Thank You to Pat Hartman For This Useful Post:
georg7 (10-08-2019)
Old 10-08-2019, 11:26 PM   #7
georg7
Newly Registered User
 
Join Date: Sep 2019
Posts: 19
Thanks: 10
Thanked 0 Times in 0 Posts
georg7 is on a distinguished road
Re: automatic data set creation

Thank you all guys!


georg7 is offline   Reply With Quote
Reply

Tags
automatic creation , form , table

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Automatic Report Creation exaccess Reports 1 02-19-2014 07:22 AM
Automatic Folder Creation MG101 Forms 7 05-24-2013 04:58 AM
Automatic creation of textbox elegnor Modules & VBA 7 07-09-2009 01:47 AM
Automatic Page Creation Kempes Forms 3 08-27-2008 10:58 PM
Automatic Column creation livin4rocknroll Forms 2 07-26-2004 11:07 PM




All times are GMT -8. The time now is 07:55 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 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World