I declare User Level as Integer in Code.
Then control jump to admin form by if statement.
If UserLevel = 1 Then
'MsgBox " Login as Member"
DoCmd.OpenForm "MyTask"
Else
'MsgBox " Login as Admin"
DoCmd.OpenForm "Admin"
End If
2015年9月26日土曜日
2015年9月25日金曜日
Login
I made basically function of Login system.
If user success to login, the user jump to my Task form.
And I add Status( user or admin) on the Member table.
It can jump User or Administrator.
If user success to login, the user jump to my Task form.
And I add Status( user or admin) on the Member table.
It can jump User or Administrator.
2015年9月22日火曜日
2015年9月21日月曜日
Make Tables
I set tables and relationship in Access 2010.
And also I thought need Login ID and Password each member, so I add those in member table.
I used DLook Function
And also I thought need Login ID and Password each member, so I add those in member table.
I used DLook Function
DLookup("[LastName]", "Employees", "[EmployeeID] = 1")
It can look for data. It is used to make Login Form.
2015年9月19日土曜日
Drawing Tables
My Task - Individual's page. Individual member can manage own tasks
Public Task-Every member can see the others task.
I need to make 4 tables
Task, Member, My_task, and Public_task table.
2015年9月18日金曜日
Start project
Project : Software Task management for programmer.
I decide to make task management for programmer.
I will use Database to manage tasks, and it work on web.
It can use for organization. For example, organization do manage all task collectedly.
So I focus on interface to easy to use.
And I will make divide two main forms
My task and Public task.
My task is for individual staff, and there are orders for the person.
Public task is other tasks that others work.
At the first I try to use Access 2010.
I decide to make task management for programmer.
I will use Database to manage tasks, and it work on web.
It can use for organization. For example, organization do manage all task collectedly.
So I focus on interface to easy to use.
And I will make divide two main forms
My task and Public task.
My task is for individual staff, and there are orders for the person.
Public task is other tasks that others work.
At the first I try to use Access 2010.
登録:
投稿 (Atom)