Recent content by apprentice

I am doing an aviation database and i will like to convert local time to GMT. For instance, i want the date and time a record is save to reflect GMT in the table field.

Yes it is working.

I got throught using this code; Forms.Navigation.NavigationSubform1.Form.Command297.Enabled = False

The name of the subform is [Inspec]

If user level is 1 i want to disable a command button in the navigation button (sub form) and not the navigation button itself.

Understood. the issue i am having restricting access to controls in a sub-form. Example, in the navigation form i have several sub-forms within those buttons on the main form which i can use to disable access to certain sub forms. Example; If user access = 1 then DoCmd.Open form "Navigation"...

I have a security access table with two fields; "Admin" and "User" Also a table with login data My login form works perfectly... when an end user log in the codes look up to see if its admin access or user access then opens a navigation form with many sub forms - access are given to some forms...

I finally got through. On the open form event i set the focus to another field and on the current event i let the codes check to see if the check box (completed) is checked then disable the command button.... Thank you everyone for your time and effort!

Can i get some help anyone?

Below is the codes i have for my post/submit command button: Private Sub Command297_Click() On Error GoTo err_handler 'Check completed check box If Me.chkCompleted Then SetButtonState DoCmd.RunCommand acCmdSaveRecord DoCmd.SetWarnings (False) 'runs append query to post data...

I did tailored it to reflect my DB. I am not sure why i am getting that error message.

private sub Form_Current() SetButtonState End Sub

Markk, I am getting an error for the On_Current event: "Identifies under cursor is nor recognized"

Markk, On what event do i have to insert the last trunk of codes?

Is it possible to allow the command button to be clicked once and anytime the form is reopened and the user click the button again it prompts the user that the button has been clicked already. example, this record have been submitted already.