I have a table called tblFinalGMan and a field called [up] of type text.
character length must be 9. After update of this field I want to check field for length and add leading zero's to make up t...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_10234720.html
Zones:
MS AccessDate Answered: 11/17/1999 Grade: A Views: 5
I don't know java, but am using a popup calendar function to select dates. I need to have the date formated as MM/DD/YY instead of MM/DD/YYYY. Also, the month and day must have leading zeros when...
http://www.experts-exchange.com/Programming/Misc/Q_20603019.html
My company's database stores 18-digit product serial numbers (in a text field) despite the fact we rarely make more than a couple thousand of anything.
I want to find a simple expression that I ...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20846148.html
Zones:
MS AccessDate Answered: 01/09/2004 Grade: A Views: 0
My CD writer ejects CD-Rs with a message "lead out error". I have tried it in both XP as well as Win 98. I have also taken the CD Writer (Samsung) to the service centre but no use. Advice me wha...
http://www.experts-exchange.com/Hardware/Misc/Q_20948669.html
Zones:
HardwareDate Answered: 04/15/2004 Grade: B Views: 0
I am currently working on taking data in SQL tables and by using Access, creating a text file to be sent to a vendor. The text file is a fixed width file with all numbers being padded with 0's. I...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_21082629.html
Zones:
MS AccessDate Answered: 08/05/2004 Grade: A Views: 0
How do I delete leading spaces in the FNM field?
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_21093432.html
Zones:
MS AccessDate Answered: 08/13/2004 Grade: A Views: 0
I figure out work arounds and then run into a wall again.
I have a column of data that may be SSN or another numeric id of some sort.
When I select the cell, the number displays in the work are...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 09/23/2005 Grade: A Views: 0
I don't want to change the cell, I just want to know if it has a leading quote.
.formula and .value and .length all fail
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 12/17/2005 Grade: B Views: 0
I need to update a table named Keynotes with a field named Keys. The problem is I need to add or insert a leading zero in the each record that has the following condition - 12345.A1 - that is I n...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_21832793.html
Zones:
MS AccessDate Answered: 04/30/2006 Grade: A Views: 0
I want to replace LEADING (and only leading) spaces in a field I am retrieving in a SELECT statement with another value in a procedure. There can be from 0 to n number of spaces preceding the actua...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22135643.html
