Search results

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.

Thank you for the reply but i am a bit new to access programming and i am lost.

I have a form that are filled by end users and the supervisor verifies the data by ticking a "Completed" checkbox then click on a command button (Post) to post the data into another table. However, i would like the Post button to be disable after each record is posted and remains disabled. My...

when the purchase order form in filled out i will like to have a command button to post the information into the "Diesel" table, updating the previous quantities. i will also like the average price to be calculated when the cost is updated.

I need help with codes that will allow me to post selective data from a purchase received form to the inventory using a command button. this command should also add to the existing quantity in the inventory.

here is a similar database i am trying to build. its basically recording the issuance of gasoline from a bulk tank and keeping in mind the fluctuating cost per gallon over time. table examples; CUSTOMERS id name SALES id meter_reading quantity price_per_gallon Total BULK TANK id P_Date...