Need Help With Subforms, Access 2016
Yesterday, 01:50 PM
Joined: 22-February 17
OK, I have finally had time to look at this and other than the somewhat nasty listbox SQL, it's somewhat straightforward? As in, you are literally putting everything on the screen. I like it.
I will begin the process of ripping the guts out of my app and moving it to this, I think it's a step up. I will plug route into this also.
Thanks for the not insubstantial effort you put into this!
The union stuff is cool, never done that, just inner joins.
This post has been edited by cpsmith58: Yesterday, 01:54 PM
Today, 02:43 PM
Joined: 6-December 03
From: Telegraph Hill
>> I will plug route into this also <<
How do you mean?
Notice that the main form is based on routes. You can navigate through them suing the navigation buttons at the bottom of the form.
If you are ripping guts out then I also suggest you separate conceptual entities out of your routes/counties/cities/locations. Contacts should be in a separate table and joined where appropriate. Same for companies, payment info etc.
It just helps to get things in order!
See here on The Access Web re. adding 'All' to a combo/listbox
|Search Top Lo-Fi||25th March 2017 - 06:34 PM|