Recent content by Waffeltje

Now I can: http://stackoverflow.com/questions/21257165/bitwise-how-can-i-check-if-a-binary-number-contains-another

Still can't post any links...

The case is, when multiple (up to hundreds of) carriers transport from one specific country, how can I derive from this one field in the ZonesWorld table which carriers belong to this value. Say; the database stores one hundred carriers and 15 out of these 100 transport from the UK. Each...

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...

Sorry for the bad explanation at first, thought that explanation would make it clearer, guess not...

I'm using a normalised data table, I use it for refering to zones; so columns are numbered Zone 1, Zone 2,....., Zone N. I'll try if "Zone" & zoneno works.

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...

Initially I only changed it into "Country_ID = ". Later on I also removed the single quote in cmbSelectVan &"". It was thanks to you though, so thank you.

Yes it's a combobox. But I've removed the single quote in the combobox and it's working. cmbSelectVan & "" Thanks nevertheless.

When I remove the single quote I get a syntax error in string in query expression ("Country ID")

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"...