Recent content by rk2002

that is what i am doing first i tried calling the function from a command button and it gave me an error. and when i try running it from a macro it also gives me an error and halts the process

i need help on disabling the main access close button so that the only way a user can close my system is by clicking on my command button i have tried putting the following code in my module: Option Compare Database Option Explicit Public Declare Function apiEnableMenuItem Lib "user32" Alias...

That is what i have done. And i tried calling the code from an autoeec macro with the action set to runcode. and i put the code as following : EnableDisableControlBoxX (False)

i can't get it to work!!! I have as you said put the coding in a module. i am running the command from a comand button from a form. but vba doesn't even get pass Public Function EnableDisableControlBoxX(bEnable As Boolean, Optional ByVal lhWndTarget As Long = 0) As Long it gives me a compile...

I an't get it to work I have as you said put the coding in a module. i am running the command from a comand button from a form. but vba doesn't even get pass Public Function EnableDisableControlBoxX(bEnable As Boolean, Optional ByVal lhWndTarget As Long = 0) As Long it gives me a compile...

Problem solved! Thanks i really needed that mate!!!!!!!!

I am trying to refer to a subform within a subform from my parent form how do i do this? Also i want to refer to my parent form from my subform and the subform within the subform. Any suggestion would help!!!!

I am trying to calculate the sum of two fields multiplied together in my subform and return it to a bound text box in my main form. Any suggestion will help. I have already worked out the way to calculate the sum of the two fields by creating a unbound text box in my subform by placing the...