Recent content by najorth

  1. N

    Access VBA to update Access table from SQL server table source

    Hi pr2-eugin thank you for your reply. I think it's almost there :). I'm still having a run-time error # 3061 "Too few parameters. Expected 2.". You might know the solution ;)
  2. N

    Access VBA to update Access table from SQL server table source

    Hello Billmeye thank you for your help and clarification. basically I would like to update a table in the Access file from an SQL Server. But I need to run a query first from SQL Server. Lets say I have a huge data table in SQL Server. I need to run a query "SELECT DISTINCT Location FROM...
  3. N

    Access VBA to update Access table from SQL server table source

    I would like to consult my problem... I hope you could help me. I have created a code below to test whether I can run a query and retrieve a data from an SQL server table. And so far I can return the result using a messagebox. but somehow I just don't know how to use this connection to update...
  4. N

    Newbie

    Hello experts. beginner in access programming, had high hopes to learn alot in this site.
See more
Top Bottom