X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
> User Defined Input Form, Access 2016    
post Jul 11 2019, 11:45 PM

Posts: 532
Joined: 12-October 03
From: Texas

I am trying to make an application to hold lab data to replace what we now do clumsily in Excel.

Samples are routinely collected and analytical tests are run on the samples. The work is mostly repetitive; that is much of the time when a set of samples is collected the same tests are run on that set. So each set of samples typically gets the same tests on some routine basis (daily, weekly, monthly, etc). I want to allow the user to make "working templates" which pair up the sample name with the test name, and then be able to use that "working template" as the basis for a data input form with spreadsheet style rows and columns. Each cell of the spreadsheet would be the data record of "Result" for the intersection of the data pair SampleName and TestParameter.

I have been able to successfully create the forms which will allow the user to create the working templates (and template details) (i.e. which samples are collected and which tests are run on each sample). However, after hours of effort I cannot even come close to figuring out how to make data input forms based on the templates.

I know this may not be a clear explanation, so I created a mock database (attached) and the opening form is a mockup of what I am hoping to be able to have the user create.

Other ideas of efficient data input forms are solicited also. If I am headed in a bad direction please say so. This is just the manner in which we are used to working when using Excel as a flat file data collection tool.
Attached File(s)
Attached File  SampleDataCollectionDemo.zip ( 415.65K )Number of downloads: 11
Go to the top of the page

Posts in this topic
- LagoDavid   User Defined Input Form   Jul 11 2019, 11:45 PM
- - ADezii   It may help to Upload some Sample Data from the Ex...   Jul 12 2019, 07:57 AM
|- - projecttoday   Does this database work now? Which table contains...   Jul 13 2019, 05:27 AM
- - GroverParkGeorge   " I want to allow the user to make "work...   Jul 13 2019, 07:00 AM
|- - LagoDavid   It is not the user that causes the need for varyin...   Jul 13 2019, 08:19 AM
|- - GroverParkGeorge   I see. No two samples are analyzed the same way, e...   Jul 13 2019, 08:36 AM
|- - projecttoday   I think this is doable with a subform.   Jul 13 2019, 08:52 AM
|- - ADezii   IMHO, we need results based on the Sample Data tha...   Jul 13 2019, 09:29 AM
|- - GroverParkGeorge   Yes, I agree. A main form/subform design should su...   Jul 13 2019, 10:27 AM
|- - LagoDavid   Form based on what table and subform based on what...   Jul 13 2019, 11:10 AM
|- - LagoDavid   I will work on getting some example data into the ...   Jul 13 2019, 11:13 AM
|- - projecttoday   I took at look at this db again. I think you need...   Jul 13 2019, 12:47 PM
|- - LagoDavid   Robert, I am not sure what you are seeing as a pro...   Jul 13 2019, 03:09 PM
|- - projecttoday   Maybe I should have said post a database that does...   Jul 13 2019, 03:24 PM
|- - LagoDavid   I apologize for the lack of clarity. "it all...   Jul 13 2019, 04:08 PM
- - tina t   hello, David, i can't justify (to my boss) dow...   Jul 13 2019, 03:17 PM
- - LagoDavid   Hi Crystal See if this helps   Jul 13 2019, 04:13 PM
- - projecttoday   Is it based on SamplePointID? If I'm getting ...   Jul 13 2019, 04:24 PM
- - ADezii   QUOTE "You can see that using the form......   Jul 13 2019, 04:31 PM
- - ADezii   Sorry, got it.   Jul 13 2019, 05:33 PM
|- - ADezii   QUOTE what I cannot figure out how to do is create...   Jul 14 2019, 11:21 AM
|- - LagoDavid   I appreciate your effort, I really do, but it is n...   Jul 14 2019, 06:49 PM
- - LagoDavid   look at the newest upload the first upload did not...   Jul 13 2019, 06:41 PM
- - projecttoday   I don't think my last post was entirely clear....   Jul 13 2019, 08:23 PM
- - LagoDavid   That is not exactly what I am hoping to do, but th...   Jul 14 2019, 07:46 AM
- - projecttoday   You're welcome.   Jul 14 2019, 07:50 AM

Custom Search

RSSSearch   Top   Lo-Fi    20th August 2019 - 11:51 PM