Have no idea how to get started

Xaverria

Registered User.
Local time
Tomorrow, 00:10
Joined
Nov 29, 2004
Messages
17
:confused: I learnt very basic MS Access in school.
Currently I have a project that states the following:

It started off with a main menu where user will enter their id number while administrator will enter their id(known as admin).

For user, according to their id number, the database will search through using a query and display the record in form view. It only allow the user to view.
For this, i have created a query that display the information if the id is equal to variable "a".

(Completed)For administrator, they are allow to alter, delete and add new record. They are also allow to print out a report. For this, i have created a query to display all record.

Question 1:Now the problem is that I don't know how to do the main menu? How should i be able to read the input from the textbox and place it into variable "a"?

Question 2: How do I set all textbox to read-only when loaded. And when the user click a button, the entries in the textbox is allow to be altered?

Please help me. :confused:
 
This is a little vague. First I am not sure what you mean by "main menu", are you talking about the Switchboard? Then you say you don't know how to do the main menu, but eariler you stated you had users login into the main menu, it is vague. First I would not use the Access Switchboard, I would create a form, call it frmSwitchboard, and put cmdButtons on it, like could look exactly like the Access Switchboard, but this is much more stable and you can enter code into this one, but you better never ever try and enter code into the Access Switchboard. Next the "a", you are again very vague on what it is and where it comes from, is it entered when the record is created? NextQ2. The read only is not that hard, but I don't know what you have done, so I figured I would give you what I did in a form in the forms On Open event. I work with a table of users and a function which retrieves the logon for me. So here is the procedure:
If DCount("[LogOn]", "tblAuthorizedUsers", "[LogOn]='" & MyCurrentUser() & "' And [ACForm] = True") = 0 Then
Response = MsgBox("You Are Not Authorized to Approve This Form." & vbCrLf & "Would You Like to View it Read Only?.", vbYesNo + vbDefaultButton2, "Yes?")
If Response = vbYes Then
Forms!frmCreditAction.AllowEdits = No
Forms!frmCreditAction.AllowAdditions = No
Forms!frmCreditAction.AllowDeletions = No
DoCmd.Maximize
ElseIf Response = vbNo Then
DoCmd.Close ACForm, "frmCreditAction"
End If
This is one way, there are others, like users when they login, would get bue BackGRound colos and Administrators, would get Green and then all you hae to do is check the color. There are as many ways as you can imagine. hth.
 

Users who are viewing this thread

Back
Top Bottom