Search results

Try this syntax : DLookUp("AnswerNumber","tblAnswers","QuestionID=" & [ResponseTracker]![QuestionID])

The query says : make a field named "Buy_Sell" with a value based on the value of "Net Position" parameter. So if [Net position] is not defined somewhere it will ask you for it as you got. Usually, It must be a field of the table your query based on. I guess you have miss-typed its name, so use...

First I read that I've to have the ODBC driver installed Which is not supported anymore. I found it here : topol.eu/files/download/other/VFPODBC.msi Then I use the following steps from : tek-tips.com/viewthread.cfm?qid=262341 I then got "Reserved error (-7778)" from access.. Then I solved it...

Hi again This to tell that I've solved my problem very well. I used the ODBC data source. I'll give more details later and explain the solution. Thanks all.

I Guess you have to change the field name above, from : Expr1: [Buy_Sell] with your criteria to : Bus_Sell: IIF([Net Position]<0,"S","B") without any criteria. that's if I understood your post well.

First, thanks for you all for your response. Second, W.r.t. my problem, the network speed is very normal , and transferring the table to local access will sure solve the speed problem, but this's out of this post as the linked table is appended continuously from another (not opened) FoxPro...

Hi every body, This's my first post here, as I thought it's better to be a member of your support forum. I've created a new database, and needed to create a link for Foxpro table from another database over network. It worked fine, but I read that access will ask for a link for the index of the...