Looking for Unbound Form Examples

[Fran Lombard]

Where is this tread going? I most definitely have interest. I have 1 prettly large access application ive been working over the past 10 years an ERP system to manage my Home Improvement business and am always looking for reusable code. Big believer in creating repeatable processes and this goes for code as well.

I didnt notice an attached file - did I miss something.

 

[MajP]

So I did not get real far, because I got distracted on other interesting things. I did develop some interesting concepts using something I called an unbound control class and unbound control collection. By assigning controls to this collection you are able to populate and update the controls very easily regardless of the number and types of data.

Advanced Class Concepts

Advanced Class Concepts I have posted several threads on using custom classes to extend the capabilities of controls and make pseudo "user controls". https://www.access-programmers.co.uk/forums/threads/developing-custom-classes-to-simulate-user-controls.309080/ This thread has additional concepts.

www.access-programmers.co.uk

However I think that the discussion on custom classes is very good and better than anything I have found on the internet. But that is just my opinion.

So I think I got a very good idea here for loading and updating, but adding get very problematic. In loading and updating you can work with a single control at a time. Deleting should also be easy. Adding is hard because you often have required fields that all have to be added together. You add complete records not individual fields.

 

[Fran Lombard]

Allrighty then, ill download this and check it out

Looks like I'm doing some of the same stuff with the initialize and terminate as well as the _Enum

Good stuff.

Have you played at all with the "Implements" and "Interface" Found it to be a bit of a brain tease and buggy, but i think that was my own inexperience coming through.

 

[MajP]

I discuss interfaces here and provide a link and some "so what."

https://www.access-programmers.co.uk/forums/posts/1652256/bookmark

 

[zeroaccess]

When I think of unbound forms I think of commercial applications, like those made for data entry. You enter all fields and hit SAVE. If you do not hit SAVE, everything exists only in memory and can be cancelled.

This can be important depending on the business. For example, a notice may be generated, printed, and mailed x minutes or days after saving, to allow time for corrections to be made. Cancel can also help a user "back out" of changes that they made that they no longer want or, "just in case" they bumped anything while looking through a record containing personal or application information.

Since this functionality is so prolific, I'd almost say standard, when using Access, users are confused as to why there is no save button. That is why on my form I include a label that says Autosave: ON so they know what is going on.

I think for the most part the pros of autosave in Access outweigh the cons and most of these things can be dealt with via smart design and user training. Just some food for thought.

 

[Fran Lombard]

I work with a Sql back-end.
The one unbound form i can think of which would be very helpful, Is a "Generic search for Code".

This would used to replace a drop down combo when searching for a primary key value in another table when that table has many rows and potentially multiple fields you would like to use as a filter to find your desired record.

While this may already exist and maybe not complicate enough to warrant a class, it's a Ubound Form I've been thinking about making.

 

[MajP]

@Fran Lombard
Take a look at the FindAsYouTypeListBox class, might be what you are talking about. This turns any listbox into a find as you type with a single line of code. It can filter on a given field or all fields.

https://www.access-programmers.co.uk/forums/posts/1663788

 

[AccessBlaster]

https://www.access-programmers.co.uk/forums/posts/1663788/bookmark

Should this link be: https://www.access-programmers.co.uk/forums/posts/1663788 without the word bookmark? because I get this>>

 

[MajP]

@AccessBlaster,

Should this link be: https://www.access-programmers.co.uk/forums/posts/1663788 without the word bookmark? because I get this>>

Thanks. I fixed it. I got to play with this more. I now have a pretty extensive collection of bookmarks that I have done or other people. It is a super nice feature IMO. It use to be so hard to find a link to an existing thread and then paste it as a link. Now you can store and tag them to quickly find them. Easy to enter, find, and paste. I have made this mistake a few times of trying to paste and save as BK at the same time.