Search results

Hello Isaac. Thanks issue resolved.

Hello Isaac, This code has been working before. The @BordNo in the stored procedure has the datatype Nvarchar(50).

Hi All, Please help . I received the errors below when i call a stored procedure with input parameters. Error 3001 Arguments are of the wrong type, are out of acceptable range , or are in conflict with one another The error occured at line Set prm = cmd.CreateParameter("@BordNo", adVarChar...

I have fixed the error by rewriting the line below. 'Configure the command Dim cmd As New ADODB.Command cmd.ActiveConnection = cn cmd.CommandTimeout = cn.CommandTimeout cmd.CommandText = "spRefreshReissuePaymentData" cmd.CommandType = adCmdStoredProc Dim prm As ADODB.Parameter Set prm =...

Hello All, Thanks for your suggestions. I applied the code suggestion from Arnelgp, and the error was 3705 Operation not allowed when the object is open.

Hello All, Please help I received the above error when calling a stored procedure in Access VBA. The error occurred at the rs.open line. Please find below the code. Regards and thanks Private Sub RefreshValidationReason() On Error GoTo RefreshValReason_ERR Dim strBordVal As String Dim...

Hello All. I get Access validation error message when validation rule is invalid. How do i suppress this message please? Regards

Thanks all for the suggestions. It now works ok. IsNull(Textbox) and Me.Combo.ListIndex = -1 applied. Many thanks.

Hello All, My validation code in the before_update event is not activated on click of the save button on my form. Please help. My code is below. Private Sub Form_BeforeUpdate(Cancel As Integer) If Me.cboReissueReason.Value = "" Then MsgBox "This is mandatory. Please Select a Reissue...

Thanks for the advice. I figured it out. I placed the Me.Dirty = False at the start of the form and it fixed it. Many thanks for your efforts.

Dear All, Could you please help. I ran the below code which ran okay but displays a pop up windows on Write Conflict issue. Please help. Th UpdateReissueStgData was ran okay. Private Sub cmdSave_Click() On Error GoTo Save_Error 'Update reissue data and Set ReissueFlg in dbo.Ledger table...

Thank you for your advice. I have since fixed the issue.

Hello All, Please help. Below is my code on click it produced the Error message Error 3367 Object already in collection. Cannot append. Private Sub cmdSave_Click() 'Dim strNewBordNo As String 'Dim strMsg As String On Error GoTo Save_Error 'Dim StrBordNo As...

Hello Arnelgp Sorry am not updating. Am selecting a value from a combo box. The value clicked on is not responding to click (not selected). How do i fix this pls.

Hello Arnelp. No PK in my combo box.

Apologies please.

Hello The_Doc_Man, These combo boxes are bound to a SQL Server. On click of the combo i see the available values but not able to select any. No error is displayed either. Am i suppose to write a code on Combo_Change_Event or Combo_Click_Event Please help. Regards

Hello The_Doc_Man, The form_Load event of the subform(frmReissueDataSheet) has the code Me.AllowEdits = True The Sub form is called from the main form with the below code: rs.Open cmd, , adOpenKeyset, adLockReadOnly Set Me.frmReissueDataSheet.Form.Recordset = rs The check box is located on...

Hello All, I have couple of combo boxes on my form. On click they show the selected values, however they do not allow a value to be selected. Please help. Am a SQL developer. Regards

Hello All. I have a checkbox on my form but after checking the box it says the form is read-only. I have placed the below code Me.AllowEdits in the subform Load event, however it did not fix it. Regards