NotAnExpert
Registered User.
- Local time
- Today, 15:25
- Joined
- Feb 3, 2017
- Messages
- 43
Good afternoon peeps
A question from someone only just walking into SQL, so please forgive that the question I am asking, might not actually be the right question.
I will explain what I have done previously and am attempting to do now:
Access 2010, ODBC connection to Sage 50, worked very well, queries, dlookup etc all worked perfectly.
Access 2010, ODBC connection to Sage 200c which sits on SQL Server 2016, seems to connect to a linked table (which is actually a SQL View to get around the primary key issue) however dlookup returns no values.
I am positive there is a better way of doing this, but not quite knowing what to ask means I don't know where to look for the answer.
After update event for a textbox (txtJobRef) linked to a field in Access:
Is there anything you can see off the bat that I might be doing wrong?
As always, any help is very gratefully received.
Kindest regards
A question from someone only just walking into SQL, so please forgive that the question I am asking, might not actually be the right question.
I will explain what I have done previously and am attempting to do now:
Access 2010, ODBC connection to Sage 50, worked very well, queries, dlookup etc all worked perfectly.
Access 2010, ODBC connection to Sage 200c which sits on SQL Server 2016, seems to connect to a linked table (which is actually a SQL View to get around the primary key issue) however dlookup returns no values.
I am positive there is a better way of doing this, but not quite knowing what to ask means I don't know where to look for the answer.
After update event for a textbox (txtJobRef) linked to a field in Access:
Code:
Me.txtNewJobRef = DLookup("CustomerAccountName", "dbo_JobView", "DocumentNo = " & [txtJobRef])
Is there anything you can see off the bat that I might be doing wrong?
As always, any help is very gratefully received.
Kindest regards