Yeah, hate to admit it, but I'm still sometimes more comfortable in dBASE than Access.
I wonder if anyone can show me how the following dBASE code can be written in VBA or VB for changing the dates in a field (DATE)from 020603 to 06/03/02 in a new field(DATE1)
In dBASE it's:
replace all DATE1 with subs(DATE,3,2) + "/" + subs(DATE,5,2) + "/" + subs(DATE,1,2)
Also, if anyone knows of a book I can buy with dBASE to Access info, I'd appreciate finding out about it. I've been converting Access tables to dBASE doing the changes, and conveting them back to Access. I'd like to just work with VB and VBA with Access.
Thanks
I wonder if anyone can show me how the following dBASE code can be written in VBA or VB for changing the dates in a field (DATE)from 020603 to 06/03/02 in a new field(DATE1)
In dBASE it's:
replace all DATE1 with subs(DATE,3,2) + "/" + subs(DATE,5,2) + "/" + subs(DATE,1,2)
Also, if anyone knows of a book I can buy with dBASE to Access info, I'd appreciate finding out about it. I've been converting Access tables to dBASE doing the changes, and conveting them back to Access. I'd like to just work with VB and VBA with Access.
Thanks