Series Dml
|
|
Dremel 300-1/24 300 Series Variable-Speed Rotary Tool Kit $47.88 Includes:⢠300 Series Variable Speed Rotary Tool ⢠Circle Cutter Attachment ⢠191 High Speed Cutter ⢠401 Mandrel ⢠402 Mandrel ⢠403 Bristle Brush ⢠407 Coarse 1/2″ Sanding Drum ⢠414 Small Felt Wheels (2) ⢠420 Heavy Duty Emery Cut-Off Wheel (2) ⢠421 Polishing Compound ⢠422 Cone… |
|
|
Greenlee 07755 NA RS-232 RS-232 Interface Software for DM-800 Series and DML-Series Digital Multimet Connects to a PC serial port for data storage and retrieval from Greenlee digital multimeters. Allows retrieval of stored data and real-time data logging and graphing. Retrieve stored data log from DML-series. Export data to disk for analysis with any spreadsheet. Requires Windows ME/98/95 or Windows XP/2000/NT4 Operating Systems…. |
|
|
Ni-MH 18.00V 3000mAh 1823,1833,1834,1835,1835F,192828-1,192829-9,193061-8,193102-0,193140-2,193159-1,193783-0 Replacement for MAKITA UB181D,ML180,SC190DWDE/4334,5000,6300,8400,JR,LS Series Power Tools Battery Compatible Part Numbers: 1823, 1833, 1834, 1835, 1835F, 192828-1, 192829-9, 193061-8, 193102-0, 193140-2, 193159-1, 193783-0 fit models: MAKITA Makita UB181D, Makita ML180, Makita SC190DWDE Makita 4334 Series Makita 5000 Series |
|
|
Mighty Beanz Flip Track – Orange (Styles May Vary) $5.00 Only Mighty Beanz Flip track offers unique tricks for your favorite beanz with ‘on the go’ play…. |
|
|
Dragon Models 1/6 Eugene Brecht (Jäger) – Mediterranean FJ Sniper, III.Fallschirmjäger-Regiment 3, Sicily 1943 Gear Plus Series $64.95 Features:Uniform: – M38 Helmet – Tropical Field Shirt – Fallschirmjager Jump Smock, 3rd Pattern – LW Tropical Trousers – Neck Scarf – Motorcyclist Goggles – Fallschirmjager Boots (Front-Laced) Equipment: – Sniper Scope Case – Maschinenpistole 739 Ammo Pouch – Kar98k Ammunition Bandolier – M31 Breadbag – Luftwaffe Tropical Equipment Belt – M38 Gasmask Canister – Water Bottle (DAK Tropical) – M31 Me… |
|
|
1/6 Gustav Bayer (Jäger) – German Fallschirmjäger 1/Fallschirmjäger-Division, Monte Cassino 1944 Gear Plus Series $58.49 … |
|
|
The SQL Starter Book 1 – SQL DML (The SQL Starter Series) $14.95 Vendor agnostic, no nonsense, no fluff! This book offers a solid foundation in SQL DML. Intended for anyone who wants to start using SQL databases, with this book you can take that first step. This is an invaluable reference for any user of any SQL database. With this book, you will learn: * How to write SELECT statements, including sub-queries * Understand Transaction Control Commands * Sele… |
|
|
How to Study the Bible (Christian Life Series, Course 2 Unit 2) $12.00 Would You Like To Know… What the Bible can do for you? If so, “How to Study the Bible” was written especially for you. The basic Bible information and pointers on how to study will get you started on studies of your own. You can build a sure foundation on God’s Word. This book uses an interesting self-teaching method that makes it eas… |
VB/VBA/DML for MS Access ?
I have a MS Access 2000 database with a date field that has been populated with non-friendly dates as follows … 9/22/05AH, 5/3/02A, 10/23/01ALC, 3/3-12/05A, 3/3-15/05
My problem is that I need to add a new field for the alpha characters (that represent codes), populate the new field with the alpha characters, and delete the alpha characters from the date field. In addition, I need change the date series to the first date in the series and change the dates to the same format.
How can I use either VB, VBA, or DML (SQL) to accomplish this? Does anyone have a code that would work for this function?
Thank you very much.
Also, if you would like more information, please feel free to send me an e-mail at steinmancloud9@yahoo.com –Thanks again.
I don’t have a VBA reference handy, but that’s the way I’d go. The script would process something like this:
1) Backup database (always when doing major changes like this!)
2) ALTER TABLE to add new_alpha (as CHAR or VARCHAR) and new_date (as DATE) columns.
3) Define and open cursor to retrieve the table.
4) Loop to fetch rows sequentially. For each row:
a) Move old_date to work_date. Evaluate and modify work_date field by:
i) Strip off rightmost alpha characters and store in work_alpha
ii) Check whether remaining field contains a ‘-’. If so, eliminate it and all characters until next-occuring ‘/’.
b) INSERT new_alpha, new_date INTO your_table VALUES (:work_alpha, DATE):work_date) WHERE CURRENT OF cursor
5) Close cursor
6) ALTER TABLE to drop old_date column
7) ALTER TABLE to rename new_date column old_date
Video & lighting showcase at Barco Customer days 2009