Recent content by poohbear2012

Issue resolved thank you for pointing me in the right direction.

I have tried this without success, still encountering the same error

No error number comes up just a message box with only an OK button. When I select the OK button it takes me to the active form, without showing the VBA.

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

CustomerID

Attached is a copy of the form and associated tables and query's.

The record source for the field is coming from a query which includes the CustomerID from the tblsalesorders table. The field has worked in other forms, so not sure if it could be the set up of the customerID in this particular table.

No it is a Text field with an Input mask.

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

Thank you for pointing me in the right direction. Have resolved the issue by pointing towards the originating tables instead of the query.

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

I have since reviewed my entire syntax and have managed to correct the errors. Thank you for your assistance in pointing me in the right direction. Regards Trisha