Search results

Thanks for the help guys, much appreciated. I've done what was suggested by JHB and Cronk and now I get an error msg: "Run-time error '3075': Syntax error (missing operator) in query expression 'PROJSTATUSFROM tblProducts WHERE (((tblProducts.[UNIQUEID])=xxxx)) Any ideas?

Thanks for all the replies. Ok so I have the below code behind a button (I've modified code that was already there which worked when the BE was Oracle but not after migration to SQL), but nothing actually happens when I click it. Can anyone see where I'm going wrong?

Great, so I get the theory behind this but do you have an example I can follow? I am good with SQL but am pretty new to VBA and need some guidance.

Hi all, I have an Access front-end app with a SQL Server back-end. One of the forms shows products, displaying fields from three different tables in the database. I need to add a button in that will duplicate the product using the Product ID. So essentially a new record will be created in all...

Hi All, I have a database which is Access FE and SQL Server BE. I am trying to input data into a form and get an MS Access Run-time 3146 ODBC Call Failed Error. The debugger points me to the below, highlighting the 'DoCmd.OpenForm' part. Private Sub cboDelegate_DblClick(Cancel As Integer) Dim...