Search results

Thanks but this still would not tell if Susie or Jeff are both logged in or one of them and which one. Wessam

Hi guys, I wonder if some can help. I have a login screen that works fine but I need to lock some part of the system from normal users but I can't figure out how to track if the user who is logged on is security lever is high and can authorise the transaction!!! I have users table and in it...

Thanks CJ_London Thanks seems to supress the error but now when clicking on the button in that forms nothing happens. The Function is in a module and it is a docmd command. Is this right thought! Forms!frm_View_Defects_On_Screen.btn_Back_to_reports.OnClick = "=...

Hi guys, I wonder if someone can help. I am try to open a form from another and set a button's OnClick properties to a function and I keep getting an error message Run-Time Error 2450Cannot find the referenced form ..... And this is the code I am using. Case 113...

Hi CJ_London It was me being an idiot, all working thanks for taking the time to reply. Cheers Wessam

Thanks CJ_London I think the problem maybe with the SQL statement quotation marks etc.. If I append Select qry_Grouped_Subcontractors.Subcontractor from qry_Grouped_Subcontractors union select “(All)” from qry_Grouped_Subcontractors order by qry_Grouped_Subcontractors.Subcontractor...

Hi everyone, I wonder if someone can help. I want to put this code in a VBA and I can’t get it to work i.e.: cmb_Subbie.RowSource = Select qry_Grouped_Subcontractors.Subcontractor from qry_Grouped_Subcontractors union select “(All)” from qry_Grouped_Subcontractors order by...

Hi guys I am not Access pro and I am hoping for some help when I need it. Regards Wessam :)