Search results
-
E
Fetch specific value from table
Hi, I am trying to acomplish the following using VB (rather unsuccessfully at present I might add!) I have a combobox on a form that fetches values from the 'SalesCode' field of a lookup table. This lookup table also contains a 'Description' field. What I am after is when I select a value... -
E
Expressions In Access forms
Ahhh, Wonderful It now works like a charm with just the simple addition of a macro! I have learnt a lot from this. Thanks very much for your efforts. -
E
Expressions In Access forms
Hi again, Everything seems fine (syntax etc). I opened my form, right clicked on the 'Priority' Field and clicked Build Event> Expression Pasted the following command in (updated with my table field values) =IIf([StatusOfQuery]="Open",IIf(([DateDue]-Date())>5,"Priority 2","Priority 1"),"")... -
E
Expressions In Access forms
Wow! Thanks very much for the speedy reply :) I shall try it at once -
E
Expressions In Access forms
Hi, I have been stuck messing with IIf expressions for the past week with no success. Wonder if anyone can help me out! I have been given the onerous task of converting many of the spreadsheets we hold here at work to a database format (Access 2007). Therein I have encountered a problem! I...