Search results

Hi I get the error when opening one of my forms "Application-Defined or Object-Defined error". Below is the current VBA that I have on the On Current Event on my form. Any suggestions on what I need to do to correct this error would be greatly appreciated. I am working in Access 2010...

When trying to enter a Customer ID into a form field it doesn't allow entry. I have checked all the settings and it is enabled and unlocked and all other fields on the form accept entry okay. This still happens when I remove and then readd the field, or add it as a combo box using the design...

I created a form and subform based on a query but when I try to open the form it asks for the parameters of three fields. All of which are in the query. I am not sure what is wrong but think it may be something to do with the calculated fied "GST Calculated" within the query. A copy of the...

Hi I have created a continuous subform to enable users to enter sale transactions on a line by line basis. I want to create a calculated field showing the subtotal of the line this would comprise of the quantity shipped field multiplied by the product list price less the percentage discount...

I am encountering a Run-Time Error 3127, when closing a form within my database the Run-Time error states: "The INSERT INTO statement contains the following unknown field name: 'ref_GP_Name'. Make sure you have typed the name correctly and try the operation again" I have checked the...

Hi I have button on one of my forms to enable users to send an email. I have the following code on the On Click command. Nothing happens when I click on the button on the form and no errors pop up. Private Sub btnsendemail_Click() If IsNull(Me.txtcount) Then MsgBox "There are no appointments...

Hi I am trying to write coding to enable the user to click on a button to send an email including fields from the active record. I am currently experiencing issues with the lines highlighted in bold. It is coming up with the following error: Compile Error Expected: Line number or label...

Hi I have created a form for users to enter details about customers. I want the form to search the tblcustomerdetails table upon entry of the customer number into the first field and populate the first name, surname and date of birth fields if there is a value in that table that matches...

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)...

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...

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...