B
Bobbin
I am trying to import data from Excel to Access and to ensure that i've
tested all possible errors before other people use my database. Generally
when i import the data (into an existing table), the records import but any
problematic field is just left blank.
Firstly, there is one field, purchaseOrderNo which has an input mask
masks without adding validation rules to every field? Is there a way of
testing existing data against input masks using VB?
Secondly, I have a form displaying the imported data. Cells on it are blank
if either the Excel field was blank or if the data isn't compatible. However
if i use conditional formating to highlight blank cells, it only picks up
cells that are blank because the Excel field is blank. How do i shade the
other ones aswell?
thanks!
tested all possible errors before other people use my database. Generally
when i import the data (into an existing table), the records import but any
problematic field is just left blank.
Firstly, there is one field, purchaseOrderNo which has an input mask
example. How can I stop it from allowing values that don't fit the inputLL??"-"000 and yet which allows the values dp2600 or dpeee360 in for
masks without adding validation rules to every field? Is there a way of
testing existing data against input masks using VB?
Secondly, I have a form displaying the imported data. Cells on it are blank
if either the Excel field was blank or if the data isn't compatible. However
if i use conditional formating to highlight blank cells, it only picks up
cells that are blank because the Excel field is blank. How do i shade the
other ones aswell?
thanks!