The idea that many almost agree on
The role of programmers has changed forever. Instead of writing code and taking a very long time, the new programmer's role is that of an orchestra leader and AI team. This team handles everything from writing code and connecting and preparing the database to...
Regarding the coloring, here's the link.
https://www.access-programmers.co.uk/forums/threads/tip-add-colour-to-queries-listboxes-comboboxes.297923/
As for the icons and formats, I think they can be done; see the attachment.
The idea is to use AI and simplify things.
I apologize for your previous question;
perhaps I did not quite understand what you meant. However, when you selected the father, it should be administration buildings
Regarding your second question, I used mcp server to explain the problem, and it solved it. See the attached file.
I encourage...
how to build a fully functional Tree of Accounts (Chart of Accounts) in Microsoft Access using a modern, native approach—completely avoiding legacy ActiveX controls.
Traditional TreeViews in Access are often broken by Windows updates or bit-version (32-bit vs 64-bit) conflicts. By leveraging the...
**This is actually MORE secure** than table-level validation because:
✅ Validation logic is centralized in code (not scattered across tables)
✅ Cannot be bypassed by linked table attacks
✅ More flexible rules (regex, external API validation, complex business logic)
✅ Tamper detection through...
i asked chatgpt about A crazy idea for protecting sensitive data such as bank card numbers
I would like your suggestions and opinions on the solution proposed by chatgpt.
test app
i attached database before converting it to ACCDE.
open immediate windows
to fill sample data
TestCompleteSystem...
I share this project for development from members so that the process of
creating databases, tables and complex queries is faster and easier.
A powerful Model Context Protocol (MCP) server that provides seamless
integration with Microsoft Access databases.
This MCP server enables you to...
No🤔 .
i have tables .
But there is no need to attach my tables and my question about one table
If you want help me thats right
If not l have no any problems
my question about one table. Why do you want me to attach my database? I dont want total hours. This is easy . I want to show detail idle hours for employee as shown in the attached picture?
This is not my homework. It is a new database that I want to design, but it is the first time I was faced with such a problem, and I did not find a solution to it and how to create its query.i have tried unmatched query but i failed😅
I have a staff of employees working hours from 8:0 to 16:00 Each employee is given tasks, each task has a specific duration of one or two hours ..., and the employee may be given more than one task per day. I want to know which hours of the employees spend it without task
As below