Recent content by staticxxx

I am trying to use a form as a calculator to show distances between different stores. The table looks like this only larger: Store | 1 | 2 | 3 | 4 | 5 | 1 | 23 | 43 | 34 | 65 | 14 | 2 | 34 | 23 | 54 | 72 | 38 | 3 | 41 | 45 | 54 | 76 | 44 | 4 | 35 | 85 |...

Apologies.

This is the exact code. =DLookUp("[= & store2]","store to store distance","[store] = Form![store1]") I get #Error in the box in which this is the source code. If i replace = & store2 with the name of the field I get the desired value. I would however like for the user to enter the field...

Hello, Ive been scratching my head for days now on what I thought was a simple expression. =Dlookup ( [FieldName], "Table", "Criteria = & Form!Form1[textbox1]) Is it possible to have [FieldName] = textbox2 some how? Or am I in over my head? Appreciate any feedback!

Hello, Ive been scratching my head for days now on what I thought was a simple expression. =Dlookup ( [FieldName], "Table", "Criteria = & Form!Form1[textbox1]) Is it possible to have [FieldName] = textbox2 some how? Or am I in over my head? Appreciate any feedback!

Hello, I've got an access 07 form based on a table like this: Store 1 2 3 4 1 27 23 54 67 2 43 56 21 78 3 76 65 23 87 4 56 23 87 54 Except the table has hundreds of stores. The data is the number of...

Hello, I'm trying to advance my beginner Access skills and this looked like a great site! Looking forward to learning from everyone :) Static