Facebook Linkedin Youtube Twitter

Forms

TEST123

by






Nifty Search Form – Nifty Access Reproduction


Nifty Search Form

This Advanced but simple to use Search Form is unbelievably easy to set-up. Just create a query and a subform. Following the comprehensive Video Instructions you can integrate the Search Form into your own database. The Nifty Search Form is one of my “Nifty Access Drop in ‘Nifty Components'” – use it to elevate yourself to “Power User Level” in your organisation!

Video 1 (1:03)

Demonstrates the search form’s features, specifically the option to search for text formatting characters at the beginning, middle, and end.

Video 2 (8:30)

Shows how to change the form to display products or customers, including steps and potential pitfalls.

Video 3 (3:58)

Explains how to search another field (e.g., customer reference). Notes that the form is designed only for text searches, not numbers or dates.

Video 4 (4:12)

Provides a quick setup demonstration of the “Nifty Search Form” from scratch, with minimal narration except for mouse clicks.

Video 5 (00:57)

Demonstrates solving a search problem from Access World Forums using the Nifty Search Form. References a forum thread and includes a YouTube video answer.

Video 6 (2:42)

Examines the code behind the Search Form, focusing on modifications for exact matches and null values. Intended for users who want to alter the code.

Video 7 (4:12)

Continues the code discussion from Video 6, covering updates for exact matches and null values in response to a customer request.



Nifty Container

by

Nifty Container

The “Nifty Container” offers you a graphical way of managing the controls on your form. All you do is surround a group of controls with a box, choose one of the coding examples, or write your own, and there you go, you have a simple and easy-to-use method, which avoids using your Control(s) Tag Property, (the usual method of doing this) which you might well want to use for something else. There are many ways to identify controls on your form for particular attention. This “Nifty Container” idea I have developed is unique, I haven’t come across it anywhere else. All you do is draw a box around the group of controls you want to handle. You might want to make sure that the controls have text entries, you might want to make sure that at least one of the controls has an entry, anything you want to do to a group of controls can be done with the “Nifty Container” system, and at the same time avoids using the controls Tag property…

Nifty Container - Demo

Nifty Container - Demo

Video 1 (5:08)

Well here it is! Another drop in component from Nifty Access. The “Nifty Container” provides an alternative way to handle a “Block of Controls” on your form. Instead of using the “Tag Property”. This method utilizes a simple rectangle as a Container to surround a bunch of controls. Call the code and it will cycle through the objects within the rectangle and alter them to your specific programming requirements.

Product Details and Download

Video 1 (5:08)

Nifty Access YouTube Thumb Nail

… …

More Useful Stuff HERE:-

Sign Up to Get Nifty News

Nifty Help System

by

Nifty Help System

There are many ingenious ways to offer help to your MS Access Application user. One of the simplest ways is to store the help information in the table. But it’s not so simple because every place that you want to provide help, you will have to add the code to open the help form, and also provide the individual ID reference to the help record associated with the control/place on your form that your user will benefit from some help. It’s a nightmare to run a help system like this, and if you have several forms, switching back and to, to the table to find out which is the next available help ID number, well it gets a bit tiresome. However this here is an easy solution to the problem.

Help System For MS Access

Help System For MS Access

Video 1 (3:25)

Here is a run through of the Help System in operation. the “Nifty Access Help System” uses an MS Access Table, an MS Access Form and utilises the “Nifty CallCalled Class Module” to extract information from the Calling Form.


Product Details and Download

Video 1 (3:25)

https://www.youtube.com/watch?v=RU4qsMFDFr0

… …

Wire Up Multipe Controls to a Function

Wire Up Multipe Controls to a Function

Video 2 (3:21)

In this video I demonstrate a useful trick where you can Call the same Function from lots of controls in your MS Access Database. The beauty of this method is you can wire up numerous controls within seconds. It’s a very useful – Nifty – MS Access technique…

Video 2 (3:21)

https://www.youtube.com/watch?v=3FdRkYuUsxU

… …

Access Help System – SETUP!

Nifty Access Help System – SETUP!

Video 3 (7:45)

A matter of “10-minutes” – that’s all it takes to setup this “Nifty Help System!” Now, you’ve got to enter in all the help information – that’s not going to take 10 minutes is it! Best of Luck!

Video 3 (7:45)

https://www.youtube.com/watch?v=4Y4NaFLzcY4

… …

MS Access HELP – PopUp on MouseOver

Help System – PopUp on MouseOver

Video 4 (1:38)

FarZ recently made an excellent observation about the Nifty Access – Help System. The problem for FarZ was that he already uses the double click event for something else. He wondered if it would be possible to pop-up the help with a hotkey and and MouseOver… I searched the internet for ideas and I found these two blogs which provided some excellent information:-
How to code “Mouse Over” effects for MS Access <<< And >>> Form.KeyDown event (Access) With this information I was able to to create a solution for FarZ. I have Incorporated the solution into the the Nifty Access – Help System… Which can be downloaded HERE:- Help System for MS Access If you prefer the free option, then the above links should give you enough information for you to be able to recreate this solution for yourself.


Product Details and Download

Video 4 (1:38)

https://www.youtube.com/watch?v=VJoFMs9WDU4

… …

More Useful Stuff HERE:-

Sign Up to Get Nifty News

Subform – Time Management Matrix Example

by

Time Management Matrix

This example demonstrates how you can can use “Instances” of a Form multiple times. You place the copies on the main form as “Sub-Forms” It’s an interesting way of programming, and with this technique you can quickly develop Forms with exceptional properties and uses with very little coding…

Subform Example

Subform Example

Video 1 (3:50)

Regarding multiple copies of the same form, I do understand this method of building databases, that is creating duplicates of the same form with minor alterations to serve a slightly different functions. And it is probably an acceptable process when you are designing, however you should endeavour to use the same form many times. Instead of creating multiple duplicates with slightly different functionality, what you do is add the different functionality with VBA code. This is demonstrated in the video on Subforms. The video shows a main form that appears to have 4 subforms on it, however it only has one subform modified with VBA code to perform four slightly different functions. This idea is demonstrated in the form of a Time Management Matrix. I give a brief explanation of the Time Management Matrix. I show how to add a new task. I also demonstrate how to move tasks between the different sections. I give a quick review of the VBA code in the module behind the form. 

The “Time Management Matrix” sample dB used in this Video is available for Download Here:-

Product Details and Download
VBA Beginner (Mentioned in the Video)

Video 1 (3:50)

Nifty Access YouTube Thumb Nail

… …

More Useful Stuff HERE:-

Sign Up to Get Nifty News

Control Records Displayed in a Subform

by

Control Records Displayed in Subform

There are various ways you can display how records are sorted in a Form. I’m fond of directly accessing a forms record source with an SQL Statement, an alternative would be to use the filter property.

I have done a few videos on the filter property which you could probably find by searching my YouTube channel.

This blog would benefit from a duplicate example, an example, basically the same as this SQL – RecordSource method, but instead use a Filter.

If you want to see such an example then please add a message in the YouTube Comments. If I get enough interest I’ll get I’ll get and make one! Don’t forget to sign up up to receive news and updates from me over on the right.>

Control Records - In Answer to AWF OP

Control Records - In Answer to AWF OP

Video 1 (5:18)

Klingest Asked — What I want to do is, that when you select a record in the subform showing “tblCalculation”, the related values from “tblSubCalculation” shall be displayed in the other subform. 

How can I do that?

In this video I answer Klingest’s question. I demonstrate how to capture the record selected (with VBA) in the first subform, extract the record’s ID, then insert the ID into an SQL Statement, again, with VBA Coding.

Next I show how to insert the SQL Statement into the Recordsource of the Form contained in the subform. (Subform Window)… You can see in the YouTube Video that the second subform now displays the related records, the records that match the selected record ID number in the first subform…

The VBA code used in the video is available:- Click on the button below:-

Details and Download (Buy Me a Coffee!!!)

I'm always grateful for any contribution, what better way to tell me that what I'm doing is worthwhile. As an alternative, you could sign up to my YouTube channel.  Signing up to my YouTube channel  helped me immensely because when I get to 1000 users I get an upgrade in my YouTube account!

Video 1 (5:18)

Nifty Access YouTube Thumb Nail

… …

More Useful Stuff HERE:-

Sign Up to Get Nifty News

Open one Form from Another and transfer Data

by

Passing Form Values

A common requirement is to pass values from one form to another. In these videos I demonstrate some problems you might face, and demonstrate a good and robust way of doing it.

Open One Form From Another

Open One Form From Another

Video 1 (3:15)

I have used the technique shown here, for many years. I find it is very flexible, also, quick and easy to copy from one Form to another.

In the sample database I use this code:-

				
					Private Sub btnOpenForm2_Click()
Dim strFrmName As String
strFrmName = "Form2"
    
    DoCmd.OpenForm strFrmName
        With Forms(strFrmName)
           '.btnOnForm2.Enabled = True
           '.fSetUp ("Sample Parameter")
           '.Caption = "I CAN CHANGE THE CAPTION"
        End With

End Sub

… to open the form and directly and access the properties of the command button.

I have deliberately left items (the commented out lines) in the code so you can get an idea of what’s possible by using this method.

For example this line here ‘.fSetUp  calls the function “fSetUp” which is a public function within the form you are opening.  If you un comment that line it will calls a function and you can see how it works.

This is a very powerful way of controlling what happens when you open another form….

You can also provide function parameters which provide one method of Passing values through to the form you are opening…

Video 1 (3:15)

Nifty Access YouTube Thumb Nail

Related Links:-

Tags to help me find this piece of code:-

#With End With #Open Form #OpenForm #fSetUp

… …

Form Load, Activate, Open, Issue 

Form Load, Activate, Open, Issue 

Video 2  (3:58)

Video 2  (3:58)

Nifty Access YouTube Thumb Nail

… …

Form Values passed to Controls 

Form Values passed to Controls 

Video 3 (1:22)

Video 3  (1:22)

Nifty Access YouTube Thumb Nail

… …

MORE - On the Form Load Issue 

The Form Load Issue  

Video 4 (2:00) Approx!

This video, from my YouTube Playlist:-

Object Oriented – Nifty Access

Explores creating a Class Module and how to use it with Allen Browne’s Calendar Form… However Allen Browne’s Calendar Form can be set up and used as is, you don’t need the Class Module, unless you want access to the advanced features the Class Module provides.

Follow the instructions on Allen Browne’s website – Popup Calendar HERE:-

http://allenbrowne.com/ser-51.html

I have created my own Calendar Control/Form, The:-

Nifty Date Picker

The NIFTY DATE PICKER has the distinct advantage that it’s very customisable. More Here:- 

Nifty Date Picker for ALL Versions of Access – Nifty Access

Colin’s Date Picker which in my opinion is very slick looking, (I’m jealous!) is HERE:-

A better Date Picker

Video 4 (2:00) Approx!

Nifty Access YouTube Thumb Nail

… …

PopUp Form - Pass Data Back

PopUp Form - Pass Data Back

Video 4 (7:57)

In this video I demonstrate calling a pop-up form, extracting a row number from a subform in datasheet view on the form. I demonstrate how to extract text from the same subform. I suggest t’s a good idea to start using the “Value” of property. I explained how to pass the value by making a copy of the textbox. I passed that to the Pop-Up form. Then, add a custom property and pass the data into the custom property. I use the “With” – “End With” Block to bracket the code that operates on the form.

Video 4 (7:57)

Nifty Access YouTube Thumb Nail

… …

Call Called Class

Call Called Class

Video 5 (9:44)

This was one of my early videos on “Call Calling” Class. As with most projects your code starts out with the goal of solving one particular problem. As you progress, you realise your idea can be applied more generally. I recently updated this Class Module . It was originally based on the Microsoft active X calendar control.

See YouTube playlist here:- Object Oriented – Nifty Access

Video 5 (9:44)

Nifty Access YouTube Thumb Nail

… …

More Useful Stuff HERE:-

Sign Up to Get Nifty News

Easily Apply Filters

by

Filtering - MS Access Forms

This video should be of interest to anyone who wants to easily apply filters to an MS Access form in datasheet view or continuous form view. In this demonstration I show how you can apply filters in a Form presented in Continuous view and also in Datasheet view. When you apply the filters, they are actually added to the forms properties. By opening the Forms property sheet you can view the filter you have just created. The filter appears as a text string added to the filter property of the Form. Once you are aware of this nifty little trick that MS Access automatically does for you, then you can leverage it by copying the text version of the filter and use it in VBA code! It’s not 100-percent straightforward, and I show you one Gotcha and the solution… The solution is to change the double quotes within the filter to single quotes. You can use this filter string created by MS Access in your VBA code. Calling the VBA code which sets the filter from the onClick event of the label above the column. With this information you now have the ability to level up your display to something nice and professional looking. Got to be good for your kudos in your company!

ApplyFilter to Sub-Form

ApplyFilter to Sub-Form

Video 1  (5:31)

You will find more information related to this video in this thread on Access World Forums (AWF) here:- ApplyFilter to subform

Video 1  (5:31)

Nifty Access YouTube Thumb Nail

… …

More Useful Stuff HERE:-

Sign Up to Get Nifty News

Find a Form Name

by

Find a Form Name

Find a Form Name

Video 1  (1:03)

Can’t remember the name of the Form you want? Quickly and easily access the list of forms in MS Access when you are entering code into a code window.

Type in “form”, then hold down the Ctrl key and press space. This should show you a list of Forms. Look for the form you want. Look for the form name, (the form with the name you gave it) but it will be prefixed with “Form_” so if your form is named “frmYourForm” then look for “Form_frmYourForm” … Now delete the prefixing characters Form_ and you will have a reference to your form in your code.

Video 1  (1:03)

Nifty Access YouTube Thumb Nail

… …

More Useful Stuff HERE:-

Sign Up to Get Nifty News

This website uses third-party software - WordPress Add-Ins to be exact. I don't know what any individual add-in does, but I'm sure that many of them collect information about you. So be aware, if you continue using this site, then you are likely to be sharing your information. I don't know how to disable this sharing for any, or all of the plugins for individual users. So I can't stop the sharing of information. If this worries you then please do not use this site... If you continue to use this site I will assume that you are happy with it.

Accept & Close
Decline

Do you need a hand in the right direction?

You are in the right place.

Take me home!
go to projects