Recent content by iboumiza

  1. I

    [Access 2k3 + VBA] SQL UPDATE add pk_id instead of customers name

    Hi, I have a product table with a bound combobox to customer name table;, and when I try update: UPDATE product SET customer_name_clone=customer_name; the update function add customer PK_ID instead of customers name!!! How can I fix this, please? Regards
  2. I

    Runtime error 9, Subscript out of Range

    Hi, I have a huge problem: I have an Excel spreadsheet that links to Access database to pull data and use access table to render excel format with the data in it. But, when I hit Add/Modify button I receive this Runtime error 9 and debug mode send me to this code: Private Sub ADDC_Click()...
  3. I

    [VBA+Access 2003] Making search result appear in List Box

    Hi, my search form uses the search query to show result in a new table window with the result! 'Search Query Private Sub btnSearch_Click() On Error GoTo Err_btnSearch_Click Dim stDocName As String stDocName = "SearchQuery" DoCmd.OpenQuery stDocName, acNormal, acEdit...
Back
Top Bottom