Recent content by odadgari

Thanks a lot! It seems it's solved.

No. All the values in field [Code] are 10 character (digit) text type!

I have an update query: Query: DateExtractor -------------------------------- Type: update query Field: ProductionDate Table: Production Update To: DateSerial("2000"+Val(Mid([Code];1;2));"Mid([Code];3;2)";"Mid([Code];5;2)") Field [Code] is a Text field...

I have a combo box named Color which may has values "Color-Matched", "Black" and "Natural". I want to make another fields (ColorLabel, ColorL, Colorb, Colora) visibe, if "Color-Matched" is selected in Color. I wrote this code but it gives Run-time error '13': Type mismatch at second line...

I'm not a programmer but a polymer engineer with an everlasting enthusiasm to deal with every software helpful to accomplish my projects. These softwares include Office (and of course Access), Adobe Ps, Ai, Id, ... HTML encoding, etc. I'm currently working on an Access project for gathering...