IIF Statement referencing a Table - social.msdn.microsoft.com
Aug 1, 2013 · If the report's RecordSource includes tblProduct can't you simply return the DrmStrChrg and PltStrChrg columns in the query? You can then call the IIf function in a …
Updating Record After Using DLOOKUP to find data
Apr 26, 2016 · And for better readability: Separate the UI from the logic. Create separate methods to validate and update the credentials, e.g. something like: Private Sub …
Requery not working on form - social.msdn.microsoft.com
Jul 26, 2011 · When the form opens, the code does a Dlookup, then Inserts the Dlookup results into the table.
VBA doesn't recognize data in text box separated by commas
Oct 1, 2015 · I have a text box that we enter an application code into. I have set my form up so that it will compare this field to data in a table and then if it's in the table it comes back and …
Case sensative UserID and Password for Login form
Jun 21, 2013 · I have a log in screen for my application that works just fine "As Is", but I would like to enhance it a bit and make it so that BOTH the UserID and Password are case sensitive and …