Search results
-
W
uniquely identifying sum of values
Hi, I'm designing a database which is used for calculating prices per transporter. Each transporter is assigned a unique code (in table tblCarriers) and can transport from a specific country. When a transporter can transport from country, this country has to be linked to this specific...- Waffeltje
- Thread
- Replies: 8
- Forum: Theory and practice of database design
-
W
Variable as FieldName in DLookup
Hi All, I want to use a variable as FieldName in the DLookup function. Normal DLookup: DLookup("FieldName" , "TableName" , "Criteria= 'string'") I want to use: DLookup(variable, "TableName", "Criteria= 'string'") Where variable is an integer, which represents the column number in the... -
W
data type mismatch in criteria expression in vba
Hi, I'm getting the error when I run this code Private Sub cmbSelectVan_AfterUpdate() Dim DHLDepAllowed As Variant Dim FedExDepAllowed As Variant DHLDepAllowed = DLookup("DHL_from", "Zones_World", "Country_ID = '" & cmbSelectVan & "'") If (DHLDepAllowed < 1) Then MsgBox "blabla"...