Search results

Hi I am a self-taught beginner VBA scriptor and I am encountering the Run-time error '2465' on a few of my forms with the error occurring on the same line (in bold below). Not sure how to correct it as the reference to the table and field is correct. Private Sub Form_Open(Cancel As Integer)...

Hi Thanks for that. The error has stopped popping up but now nothing happens at all when the button that the VBA associated to is clicked. Macros are enabled and other buttons on the page work fine. Regards Trisha

I am encountering Run-time error 2427 "You entered an expression that has no value". The line in bold below is the line causing the issue. The txtcount field on the form is =Count([tbldetails.CustomerNumber]) there are two identically name fields in two tables, hence why the table name is at...

Hi Carl Copy of the affected forms etc attached. Cheers Trish

Hi I have corrected the sql error, but when I go to login into the database it keeps telling me that the password is incorrect despite being correct. Not sure where to go next.

Hi Carl Thank you for this example it has been most useful. But I have encountered an error (copy attached) with the relevant line. Regards Trisha

Access 2010

Hi Carl I am only just beginning to undertake VBA coding so am still not 100% sure of all of the terminology. Are you able to provide an example. Many thanks Trisha

Dear Carl Thanks for your reply, I did end up identifying an error in the spelling of the form name. Changed the form name and it worked perfectly. But now I have encountered some other issues on the Home form I wish a box to contain the name of the current logged in user, I currently have...

I have designed a user login form in Access 2010 which enables users to enter a password to login into the database. I wish the form to close and go to the default Home page form. I have written the following VBA code under the button to undertake the "OnClick" function of the Login button...