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