UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
2 Pages V < 1 2  (Go to first unread post)
   Reply to this topicStart new topic
> Need Help With Subforms, Access 2016    
 
   
cpsmith58
post Mar 24 2017, 01:50 PM
Post#21



Posts: 74
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: Mar 24 2017, 01:54 PM
Go to the top of the page
 
cheekybuddha
post Mar 25 2017, 02:43 PM
Post#22


UtterAccess VIP
Posts: 8,776
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

thumbup.gif

d

--------------------


Regards,

David Marten
Go to the top of the page
 
2 Pages V < 1 2


Custom Search
RSSSearch   Top   Lo-Fi    27th March 2017 - 05:47 AM