Search results

Dear Cliff67 This library was selected in the references. I compiled it then run view in form, I was prompted the same error with also error code 2753. I am not so sure what is wrong with the OLE server. I tried researching online for solutions but could not get any.

Hi All Thanks for your inputs.. I have trouble using VBA so i explored possibility of macros instead. I was able to use macro to trigger from clicking a single button to run 2 queries. My queries are already link to respective forms. Thus, I have 2 forms: 1) Valid Visitor 2) Invalid Visitor I...

May i just ask why does the following error keep popping up when i am exploring the codes you all have provided? I replaced with the respective names of forms/queries but this error still pop up. Sorry as I do not know how to code VBA so is trying my best to understand it line by line. ""there...

Hi Cliff67 I am using Microsoft Access 2016.

Hi Ranman256 I tried both codes (replace with relevant query names with mine) but they prompt me the below error. there is an error occurred while Microsoft Access was communicating with OLE server or ActiveX Control. *The expression may not result in the name of a macro, the name of a...

Hi I do not have any knowledge on VBA :( But thanks for the code.. I will look through and understand it. And try it inside my Microsoft Access.

Hi all I am trying to do my final year project on a visitor management system with Microsoft Access. Now I have check in page where i want to click a button to: 1) run valid query [if yes, then open form on valid visitor. if NO, open form on invalid visitor] Is it possible to do the above in...

Hello Everyone I am new to Microsoft Access. I do not have background in VBA. Thanks! Signing off... kekeke