Smart Domain Functions Builder

[Moosak]

Hello every buddy..

This is my first post in here.
My name is Moosa Al-Kalbani and I am an Access database designer.

Today I am pleased to present to you this unique and wonderful gift

(Smart Domain Functions Builder)
Dloockup, DCount, DMax, DMin, Dfirst, DLast , DSum, DAvg

This legend is a tool that I designed in Access (thanks to God) that writes domain functions on your behalf automatically.. and gives you the result directly

No one will go wrong in writing Syntex for these functions anymore

All you have to do is import this tool into your database, then choose the desired table or query and the desired field, and then enjoy

Its advantages:
1 - It is easy for you to write the names of tables and fields (just choose them from the drop-down list).
2- You can make a function with four 4 criteria with ease.
3- It checks the result directly for you to make sure that you will get the data you want.
4 - Easy to use, just follow the steps shown and make sure you choose the right data type.
5 - You can use the equations or variables in the function as sources of criteria.
6 - You can make your own modifications to the function directly and check the result immediately after modifying the final result.
7 - The ability to obtain the formula for the VBA code editor, the formula used in queries, or the expression builder.
8- The ability to use the tool independently without the need to transfer it to your database.
9- As you can notice The interface is designed with two languages Arabic/English in order to be used by more segment of people.
10- And many more that you will have to discover on your own

How to use :
Easy and simple. Just drag the form named "SmartDomainFunctionsBuilder_F" to your database by drag and drop..
Then open the form, and it will automatically identify the tables and queries for your database directly

(With the possibility to use the tool independently without the need to transfer it to your program, but you will lose the advantage of getting the result directly )

A lot of experiments have been done on the tool and many errors have been avoided and fixed, but I still do not dispense with your opinions and feedback through your use of it

For more details (please watch the video):

Finally download the tool from the attachments

 

[isladogs]

Thanks Moosa

 

[Mike Krailo]

That's awesome. Very easy to understand.

 

[Guus2005]

Nice one Moosa!
Perhaps you can also explain how you made that video, the tools you use and how much time it took to complete.
I don't think this was your first time.
Thanks!

 

[Moosak]

hello @Guus2005

I used Camtasia Studio to record and edit videos.

I don't think this was your first time.

No, I'm good in this
Thanks!

 

[mloucel]

Hello every buddy..

This is my first post in here.
My name is Moosa Al-Kalbani and I am an Access database designer.

Today I am pleased to present to you this unique and wonderful gift

(Smart Domain Functions Builder)
Dloockup, DCount, DMax, DMin, Dfirst, DLast , DSum, DAvg

View attachment 100167

This legend is a tool that I designed in Access (thanks to God) that writes domain functions on your behalf automatically.. and gives you the result directly

No one will go wrong in writing Syntex for these functions anymore

All you have to do is import this tool into your database, then choose the desired table or query and the desired field, and then enjoy

Its advantages:
1 - It is easy for you to write the names of tables and fields (just choose them from the drop-down list).
2- You can make a function with four 4 criteria with ease.
3- It checks the result directly for you to make sure that you will get the data you want.
4 - Easy to use, just follow the steps shown and make sure you choose the right data type.
5 - You can use the equations or variables in the function as sources of criteria.
6 - You can make your own modifications to the function directly and check the result immediately after modifying the final result.
7 - The ability to obtain the formula for the VBA code editor, the formula used in queries, or the expression builder.
8- The ability to use the tool independently without the need to transfer it to your database.
9- As you can notice The interface is designed with two languages Arabic/English in order to be used by more segment of people.
10- And many more that you will have to discover on your own

How to use :
Easy and simple. Just drag the form named "SmartDomainFunctionsBuilder_F" to your database by drag and drop..
Then open the form, and it will automatically identify the tables and queries for your database directly
View attachment 100168
(With the possibility to use the tool independently without the need to transfer it to your program, but you will lose the advantage of getting the result directly )

A lot of experiments have been done on the tool and many errors have been avoided and fixed, but I still do not dispense with your opinions and feedback through your use of it

For more details (please watch the video):

Finally download the tool from the attachments

This has saved me a lot of headaches, thanks a lot, makes the understanding on how this D functions work, so much easy.

 

[mloucel]

Hello every buddy..

This is my first post in here.
My name is Moosa Al-Kalbani and I am an Access database designer.

Today I am pleased to present to you this unique and wonderful gift

(Smart Domain Functions Builder)
Dloockup, DCount, DMax, DMin, Dfirst, DLast , DSum, DAvg

View attachment 100167

This legend is a tool that I designed in Access (thanks to God) that writes domain functions on your behalf automatically.. and gives you the result directly

No one will go wrong in writing Syntex for these functions anymore

All you have to do is import this tool into your database, then choose the desired table or query and the desired field, and then enjoy

Its advantages:
1 - It is easy for you to write the names of tables and fields (just choose them from the drop-down list).
2- You can make a function with four 4 criteria with ease.
3- It checks the result directly for you to make sure that you will get the data you want.
4 - Easy to use, just follow the steps shown and make sure you choose the right data type.
5 - You can use the equations or variables in the function as sources of criteria.
6 - You can make your own modifications to the function directly and check the result immediately after modifying the final result.
7 - The ability to obtain the formula for the VBA code editor, the formula used in queries, or the expression builder.
8- The ability to use the tool independently without the need to transfer it to your database.
9- As you can notice The interface is designed with two languages Arabic/English in order to be used by more segment of people.
10- And many more that you will have to discover on your own

How to use :
Easy and simple. Just drag the form named "SmartDomainFunctionsBuilder_F" to your database by drag and drop..
Then open the form, and it will automatically identify the tables and queries for your database directly
View attachment 100168
(With the possibility to use the tool independently without the need to transfer it to your program, but you will lose the advantage of getting the result directly )

A lot of experiments have been done on the tool and many errors have been avoided and fixed, but I still do not dispense with your opinions and feedback through your use of it

For more details (please watch the video):

Finally download the tool from the attachments

Sorry I want to find out if anyone else has the same error I got running in Access 365 64 bit?

 

[isladogs]

Yes - I get the same error in 64-bit Access

I've had a very quick look at the code and there are no APIs needing to be converted.
There is nothing obvious in the Form_Open event that is triggering the error

EDIT:
Just figured out the problem
The Detail section name is in (I assume) Egyptian - a non-Latin character set
Go to Design view, click on the section and rename it to Detail. Save and reopen. Fixed!

However, there is a similar issue when you click the domain combo due to a table with an Egyptian name in the combo value list
I removed that but still get errors.
Hopefully the OP can return and provide a version which works correctly in 64-bit Access

 

[arnelgp]

the startup form has an arabic control name (the detail section of the form).
so you need to rename it to english.

you create new db and copy all objects from the original db.