ياليت تشوفون هالكود وش مشكلته

السلام عليكم ورحمة الله وبركاته

الله يسعد ظهيرتكم جميع

اخواني اخواتي لاهنتم هذا كود للـ switchboard لبرنامج عليه حماية ومادري الحماية في الكود او لا

انا ماعندي خبرة في الاكواد لكني اجتهدت واتوقع ان الحماية في الكود المحصور بين النجمات "حطيت لون اخضر بس الظاهر مابيبين" ... طبعا البرنامج ذا مصمم باكسس 2000 وانا الي عندي 2007 وعند التحويل تصير اخطاء فما قدرت اتأكد من صحة كلامي ... اعذروني لاني ماقدر ارفق الملف

Option Compare Database
Option Explicit

Private Sub Form_Open(Cancel As Integer)
' Minimize the database window and initialize the form.

	' Move to the switchboard page that is marked as the default.
	Me.Filter = "[ItemNumber] = 0 AND [Argument] = 'Default' "
	Me.FilterOn = True

End Sub

Private Sub Form_Current()
' Update the caption and fill in the list of options.

	Me.Caption = Nz(Me![ItemText], "")
	FillOptions

End Sub

Private Sub FillOptions()
' Fill in the options for this switchboard page.

	' The number of buttons on the form.
	Const conNumButtons = 8

	Dim dbs As Database
	Dim rst As Recordset
	Dim strSQL As String
	Dim intOption As Integer

	' Set the focus to the first button on the form,
	' and then hide all of the buttons on the form
	' but the first.  You can't hide the field with the focus.
	Me![Option1].SetFocus
	For intOption = 2 To conNumButtons
		Me("Option" & intOption).Visible = False
		Me("OptionLabel" & intOption).Visible = False
	Next intOption

	' Open the table of Switchboard Items, and find
	' the first item for this Switchboard Page.
	Set dbs = CurrentDb()
	strSQL = "SELECT * FROM [Switchboard Items]"
	strSQL = strSQL & " WHERE [ItemNumber] > 0 AND [SwitchboardID]=" & Me![SwitchboardID]
	strSQL = strSQL & " ORDER BY [ItemNumber];"
	Set rst = dbs.OpenRecordset(strSQL)

	' If there are no options for this Switchboard Page,
	' display a message.  Otherwise, fill the page with the items.
	If (rst.EOF) Then
		Me![OptionLabel1].Caption = "There are no items for this switchboard page"
	Else
		While (Not (rst.EOF))
			Me("Option" & rst![ItemNumber]).Visible = True
			Me("OptionLabel" & rst![ItemNumber]).Visible = True
			Me("OptionLabel" & rst![ItemNumber]).Caption = rst![ItemText]
			rst.MoveNext
		Wend
	End If

	' Close the recordset and the database.
	rst.Close
	dbs.Close

End Sub

Private Function HandleButtonClick(intBtn As Integer)
' This function is called when a button is clicked.
' intBtn indicates which button was clicked.

	' Constants for the commands that can be executed.
	Const conCmdGotoSwitchboard = 1
	Const conCmdOpenFormAdd = 2
	Const conCmdOpenFormBrowse = 3
	Const conCmdOpenReport = 4
	Const conCmdCustomizeSwitchboard = 5
	Const conCmdExitApplication = 6
	Const conCmdRunMacro = 7
	Const conCmdRunCode = 8

	' An error that is special cased.
	Const conErrDoCmdCancelled = 2501

	Dim dbs As Database
	Dim rst As Recordset

On Error GoTo HandleButtonClick_Err

	' Find the item in the Switchboard Items table
	' that corresponds to the button that was clicked.
	Set dbs = CurrentDb()
	Set rst = dbs.OpenRecordset("Switchboard Items", dbOpenDynaset)
	rst.FindFirst "[SwitchboardID]=" & Me![SwitchboardID] & " AND [ItemNumber]=" & intBtn

	' If no item matches, report the error and exit the function.
	If (rst.NoMatch) Then
		MsgBox "There was an error reading the Switchboard Items table."
		rst.Close
		dbs.Close
		Exit Function
	End If

	Select Case rst![Command]

		' Go to another switchboard.
		Case conCmdGotoSwitchboard
			Me.Filter = "[ItemNumber] = 0 AND [SwitchboardID]=" & rst![Argument]

		' Open a form in Add mode.
		Case conCmdOpenFormAdd
			DoCmd.OpenForm rst![Argument], , , , acAdd

		' Open a form.
		Case conCmdOpenFormBrowse
			DoCmd.OpenForm rst![Argument]

		' Open a report.
		Case conCmdOpenReport
			DoCmd.OpenReport rst![Argument], acPreview



****************************************************
		' Customize the Switchboard.
		Case conCmdCustomizeSwitchboard
			On Error Resume Next
			Application.Run "WZMAIN80.sbm_Entry"
			If (Err <> 0) Then MsgBox "Command not available."
			On Error GoTo 0
			' Update the form.
			Me.Filter = "[ItemNumber] = 0 AND [Argument] = 'Default' "
			Me.Caption = Nz(Me![ItemText], "")
			FillOptions
******************************************************



		' Exit the application.
		Case conCmdExitApplication
			CloseCurrentDatabase

		' Run a macro.
		Case conCmdRunMacro
			DoCmd.RunMacro rst![Argument]

		' Run code.
		Case conCmdRunCode
			Application.Run rst![Argument]

		' Any other command is unrecognized.
		Case Else
			MsgBox "Unknown option."

	End Select

	' Close the recordset and the database.
	rst.Close
	dbs.Close

HandleButtonClick_Exit:
	Exit Function

HandleButtonClick_Err:
	' If the action was cancelled by the user for
	' some reason, don't display an error message.
	' Instead, resume on the next line.
	If (Err = conErrDoCmdCancelled) Then
		Resume Next
	Else
		MsgBox "There was an error executing the command.", vbCritical
		Resume HandleButtonClick_Exit
	End If

End Function

ولكم خالص تقديري

باختصار .....

' Customize the Switchboard.

Case conCmdCustomizeSwitchboard

On Error Resume Next

Application.Run "WZMAIN80.sbm_Entry"

If (Err <> 0) Then MsgBox "Command not available."

On Error GoTo 0

' Update the form.

Me.Filter = "[itemNumber] = 0 AND [Argument] = 'Default' "

Me.Caption = Nz(Me![itemText], "")

FillOptions