Going through various junk just to publish at this time I noticed a massive amount cool things out there. The following write-up is actually simply just one of many I will be writing about auto detailing within the next 3 days. I am trying to get the weblog current more regularly than I have already been up to now. Tell me what you consider in regards to this write-up along with what you would like to discover regarding auto detailing later on.
Black & Decker, Haier Chest Freezers Recalled
Get Business Mobile Text Alerts : Text BIZ To 37798 The U.S. Consumer Product Safety Commission has announced the recall of 67,500 Black & Decker and Haier chest freezers because of a fire hazard caused by overheating.
Read more on Hartford Courant
Final Touch Tv is provided by Final touch detailing service in Maryland. That services the DC Metro area. Greg’s topic in this episode is engine detailing or how to clean your car engine. www.finaltouchdetailing.net -How To Clean Your Engine Cleaning your engine does bring value to your car, it lowers your gas mileage by keeping the engine running like the day you bought it. car care detailing auto cleaning engine in laurel maryland washington dc wash, How To Clean Your Engine, laurel, bowie, largo, bethesda, baltimore, washington dc, silver spring, burtonsville
Q&A:
Question by dee: ms access validation rules?
i have created tables and a form where you have to enter “customer details”.
the first text boe is for the “customerID” and the second is customerName.
a value has to be auto generated in the “customerID” text box wen the user enters the customerName.
the “customerID” value has to be made of the 3 first letters taken from the customer name plus 4 numbers.
example: name: alex
should be generated in the ID box: ale1234
how do i do this
please help
Best answer:
Answer by mark r
This sounds like you will need some VBA code.
You need to use the left() function to get the relevant part of the name.
The number is probably best generated using some kind of coding e.g. calculate the letter’s position in the alphabet.
I’m assuming you will want to ensure that a person will always get the same ID (initially) although you will need to work out how to handle clashes e.g. two alex’s.
An index could be used to ensure that the values were unique
Give your answer to this question below!