var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How to returns records via VBA where <NULL> is stored in SQL table
I added several new columns (nullable) to some existing tables. The new columns now contain <NULL> for the old records.
If I add new records these columns are blank.
The following VBA code only returns the new records with the blanks.
If IsNull(!Work_Mech) Then
frmMain.txtWorkMech = ""
frmMain.txtWorkMech = !Work_Mech
How can I retrieve the old records????
SQL Statement to retrieve records with NULL values
Where newField is null
I can retrieve the records in SQL - I am not getting all the records via VB.
what is the code you are using to retrieve the records?