- Видео 15
- Просмотров 539
Advanced Data Business Systems - Access ADS
Колумбия
Добавлен 19 фев 2023
Welcome to the Advanced Development Shell (ADS) created by Advanced Data Business Systems (ADBS). The ADS is derived from a rapid application development tool started in the 1980s, that stood the test of time in numerous business applications developed for large and small business. This channel is dedicated to demonstrating the ADS as migrated to Microsoft Access, showing users how to use applications developed with ADS and to teaching developers how to quickly implement their particular application needs using a robust and comprehensive shell.
Ads3158
We will debug two problems with the Birth sex combo box in the Entity Form by looking at the Element “helper” table and the Validation tables. This is meant to be a “learn by fixing” video that showcases some basic functions found in these two tables and how they make entry in combo boxes more parameter driven.
⌚ TIMESTAMPS
0:00 Introduction
1:53 Topics covered (the two errors)
3:08 Starting the Entity Form and viewing the two errors in the Birth sex combo box
5:41 Debugging the duplicate values in the combo box
10:28 Debugging the validation error for data in the combo box
15:09 Related videos
⌚ TIMESTAMPS
0:00 Introduction
1:53 Topics covered (the two errors)
3:08 Starting the Entity Form and viewing the two errors in the Birth sex combo box
5:41 Debugging the duplicate values in the combo box
10:28 Debugging the validation error for data in the combo box
15:09 Related videos
Просмотров: 23
Видео
1132 - Understanding the Entity Form
Просмотров 71Месяц назад
For most any person or organization, being a member of some kind of community is the center of a social or commercial activity. As such, keeping track of the members of such a community becomes a central focus. The Entity form provides a way to organize data for people, organizations and even animals. But we aren’t limited to just those types of “things”. Explore the basic concepts behind the E...
2122 - Menu Form: Special commands, jobs and permissions
Просмотров 33Месяц назад
It’s time to dig a little deeper into the menu system of the ADS. Menus are the primary way that users run the different types of jobs like forms, reports, queries and macros. We will cover some of the Menu control entry options as well as some of the permissions that allow or inhibit users from running jobs. (ver. 1_23) ⌚ TIMESTAMPS 0:00 Introduction 0:27 Topics covered 1:12 Laura uses Menu co...
1122 - Menu Form Overview
Просмотров 182 месяца назад
After logging in, the user needs a controlled way to run jobs. The menu system presents menus tailored to each user group in a hierarchical manner. One form, the Menu Form, can display a variety of menus in a consistent and organized manner. (Ver. 1_23) ⌚ TIMESTAMPS 0:00 Introduction 0:28 Prerequisite video 0:49 Fred Flintstone has a very simple menu 2:28 The menus as seen by the built-in guest...
2112 - Using the Login Form
Просмотров 92 месяца назад
A good login system is needed to give authorized users access to run an application module. Basic security is needed for the user, as well as checking that the environment that the user is entering is not corrupted or incorrect for the location or version. (Ver. 1_23) ⌚ TIMESTAMPS 0:00 Introduction 0:43 Video topics 0:51 Login Form design 1:15 Users and Entities 3:35 Configuration errors and wa...
1112 - Login Form Overview
Просмотров 142 месяца назад
When first starting the ADS, most users will be presented with the Login Form. To continue, a user needs a User code and password. The data administrator for the ADS is the person responsible for creating login credentials. (Ver. 1_23) ⌚ TIMESTAMPS 0:00 Introduction 0:45 User code and Password 1:47 Environment Validation 2:58 Related videos
1003 - Installing the ADS demo file
Просмотров 292 месяца назад
People that are interested in investigating the Advanced Development Shell for Microsoft Access can request a demo file. This video shows how the demo file is distributed and how a developer or user can install a copy on their local computer. (Ver. 1_23) ⌚ TIMESTAMPS 0:00 Introduction 0:29 Topics 1:02 Requesting the ADS demo file 1:40 Where to save the demo file 3:18 Saving and extracting the d...
1002 - Fred Flintstone Demo of the ADS Entity Form
Просмотров 642 месяца назад
Come join Fred as we move him from the quarry to the front sales office. He will begin to bungle around inside the Entity Form, viewing his favorite character and relationships. Fred will have an interesting visit from another special character. (Ver. 1_23) ⌚ TIMESTAMPS 0:00 Introduction 0:42 Covered topics 2:27 Entity Form 4:33 Related forms 5:57 A new customer 6:46 Search form 7:21 Adding Ent...
1001 - Introduction to Advanced Development Shell (ADS)
Просмотров 362 месяца назад
ADS is a shell made by Advanced Data Business Systems to wrap around Microsoft Access. The purpose is to provide an easier and more intuitive interface for users. Developers can add enterprise style features to their applications. (Ver. 1_23) ⌚ TIMESTAMPS 0:00 Introduction 1:48 Features 2:02 Login Form 3:20 Menu Form 4:00 Forms 4:38 Search form 4:57 Video modules Note: This and other videos in ...
77 second overview
Просмотров 774 месяца назад
A 77 second overview of the advantages when using the Advanced Development Shell to create organizational applications in Microsoft Access.
2003 - User, User Group, assigning Users to User Groups
Просмотров 116 месяцев назад
Users and User Groups, within the ADS, are modeled on the Microsoft Window’s model. There is a difference in that a user in Windows has access to an account and computer/network resources, whereas in the ADS, users have access to different application modules and jobs. The two are separate security models, common in their naming. However, a system administrator can restrict access to the Access...
2018 - Understanding Application Modules and the associated tables for the ADS core
Просмотров 107 месяцев назад
Application Modules provide a way to organize the different types of applications that an organization might use. For example, a company might have Accounting and Human Resources departments. We might want to create a frontend workstation .accde for each department that insulates one department from the other department’s jobs and data files. Developers organize their different application soft...
Simple Timer form with module procedures you can call from your own VBA code
Просмотров 478 месяцев назад
Advanced Data Business Systems provides this giveaway video and Access Timer.accdb file for people that need a simple timer and new programmers that want to see how to set up and make an API call from within a VBA module. The code can be tested from the immediate window or incorporated into your own routines that need to report time intervals. ⌚ TIMESTAMPS 0:00 Introduction 3:19 Behind the scen...
3013 - Setting locks for records in Forms
Просмотров 599 месяцев назад
Record locks are set automatically in the template forms. Another user can’t edit while a record is locked. Records can be set in other tables for related records that are associated to the record being edited in the form. Forms also check for a table lock. ⌚ TIMESTAMPS 0:00 Introduction 0:28 Topics 0:58 The lock tables 3:52 Demonstrating a table lock for the Entity table 6:06 Locking when a fo...
3011 - Using Status to determine procedure flow in a form
Просмотров 469 месяцев назад
How can we tell what VBA procedures are being called to run from our Access forms? We could create a bunch of stops or breakpoints. Couldn’t there be a better self-documenting way? Yes! ⌚ TIMESTAMPS 0:00 Introduction 1:11 Access startup 2:47 Personal Information related Form 3:18 Setting the form option to allow showing the running procedures in the form 4:43 Watching what happens when changing...