K krc547 Member Local time Today, 13:12 Joined Sep 1, 2023 Messages 38 Sep 27, 2023 #1 Is there a way to create a form to allow a user to select a date and it will show the data input for that day and change the data if incorrect?
Is there a way to create a form to allow a user to select a date and it will show the data input for that day and change the data if incorrect?
C CJ_London Super Moderator Staff member Local time Today, 19:12 Joined Feb 19, 2013 Messages 17,535 Sep 27, 2023 #2 krc547 said: a form to allow a user to select a date and it will show the data input for that day Click to expand... Certainly possible, use the where parameter of docmd.openform krc547 said: change the data if incorrect? Click to expand... User could change the data, but it won’t happen automatically
krc547 said: a form to allow a user to select a date and it will show the data input for that day Click to expand... Certainly possible, use the where parameter of docmd.openform krc547 said: change the data if incorrect? Click to expand... User could change the data, but it won’t happen automatically
K krc547 Member Local time Today, 13:12 Joined Sep 1, 2023 Messages 38 Sep 27, 2023 #3 I have a form that shows all the data in that table, but I can't get the select a date field to work to show just that date from the table.
I have a form that shows all the data in that table, but I can't get the select a date field to work to show just that date from the table.
jdraw Super Moderator Staff member Local time Today, 14:12 Joined Jan 23, 2006 Messages 15,565 Sep 27, 2023 #4 Show us some sample data.
K krc547 Member Local time Today, 13:12 Joined Sep 1, 2023 Messages 38 Sep 27, 2023 #5 So the highlighted yellow field won't let me select just a single date to see instead of looking through the whole database.
So the highlighted yellow field won't let me select just a single date to see instead of looking through the whole database.
mike60smart Registered User. Local time Today, 19:12 Joined Aug 6, 2017 Messages 2,177 Sep 27, 2023 #6 You normally have a table that Contains a list of Dates and a table that contains details of the various Routes You can then create Min Form based on the Dates Table With a Subform based on the Routes table. You can then put a Search Combobbox in the Header of the Main Form that allows you to select a specific Date The subform would then display the various Routes for the Date Selected
You normally have a table that Contains a list of Dates and a table that contains details of the various Routes You can then create Min Form based on the Dates Table With a Subform based on the Routes table. You can then put a Search Combobbox in the Header of the Main Form that allows you to select a specific Date The subform would then display the various Routes for the Date Selected
K krc547 Member Local time Today, 13:12 Joined Sep 1, 2023 Messages 38 Sep 27, 2023 #7 OK I think I am tracking now. Thank you.
theDBguy I’m here to help Staff member Local time Today, 11:12 Joined Oct 29, 2018 Messages 22,621 Sep 27, 2023 #8 krc547 said: So the highlighted yellow field won't let me select just a single date to see instead of looking through the whole database. Click to expand... Can you show us the Row Source query for that combobox? Try adding DISTINCT to it.
krc547 said: So the highlighted yellow field won't let me select just a single date to see instead of looking through the whole database. Click to expand... Can you show us the Row Source query for that combobox? Try adding DISTINCT to it.
MajP You've got your good things, and you've got mine. Local time Today, 14:12 Joined May 21, 2018 Messages 9,620 Sep 27, 2023 #9 If you want to make this filter more robust, here is a low code option The Most Powerful form Filter and Requires almost No Code NOTE: See updated code below. I recommend using the updated class module that @arnelgp modified. It further simplifies building a search form and addresses some bugs... www.access-programmers.co.uk
If you want to make this filter more robust, here is a low code option The Most Powerful form Filter and Requires almost No Code NOTE: See updated code below. I recommend using the updated class module that @arnelgp modified. It further simplifies building a search form and addresses some bugs... www.access-programmers.co.uk