Faormat a MS Access database field


We have a database under MS Access with a single table. We would like to have a specific format for a given field.

The "Card_No" field contains the card number. This number must have the following characteristics:

1. Being unique

2. Composed of 9 digits

3. The format "XXXXXXXAA" where AA represents the value of the field "ID_Ville" (If ID_Ville = 1 then AA = 01, if ID_Ville = 11, then AA = 11). X represents a number between 0 and 9)

4. Generate automatically

The "No_Carte_Print" field contains the value of the "No_Carte" field in the format: "X XXX XXX AA".

The first line of the table illustrates the need.

In French language:


Nous avons une base données sous MS Acces avec un seule table. Nous aimerons avoir un format spécifique pour un champ donné.

Le champ "No_Carte" contient le numéro de carte. Ce numéro doit avoir les caractéristique suivantes:

1. Etre unique

2. Composé de 9 chiffres

3. Le format "XXXXXXXAA" où AA représente le la valeur du champs "ID_Ville" (Si ID_Ville = 1 alors AA = 01, si ID_Ville = 11, alors AA = 11). X représente un chiffre compris entre 0 et 9)

4. Générer automatiquement

Le champs "No_Carte_Print" contient la valeur du champs "No_Carte" dans le format : "X XXX XXX AA".

La première ligne de la table illustre le besoin.

Compétences : Saisie de Données, Excel, Microsoft Access, Visual Basic

En voir plus : override access database field size, access ms access database manually, attendance ms access database, format field in access query, tabular format in access, access field format property, format uppercase in access, access textbox format, format field as currency in access query, ms access format number no decimal, access decimal places not working, backup restore ms access database vb net windows application, cheap ms access database design, code store text form vb project ms access database, connect google map ms access database vb, convert ms access database exe, convert ms access database program, convert ms access database standalone software, convert ms access database stand application, convert ms access database work web server service

Concernant l'employeur :
( 2 commentaires ) OUAGADOUGOU, Burkina Faso

Nº du projet : #18690150

Décerné à:


Hello, dear sir! I registered at the forum not so long ago, but I already have several completed projects on www.freelancer.com. I am ready to carry out your project in the reasonable price and in the shortest possibl Plus

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 0 jours
(138 Commentaires)

12 freelances font une offre moyenne de 28 $ pour ce travail


I am an Access, Excel and VBA specialist with a lot of experience in creating complex formulas and macros. You may check some of my projects here: [login to view URL] Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(86 Commentaires)

Hi, I am a professional Access developer I have done many projects in Access have a look at my profile. I have a very good command over SQL and user interface desgin. Send me more details about the work

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(5 Commentaires)

Hello. This task can be completed using one additional Access query, which will contain new field No_Carte_Print in required format. Task can be completed during 1 hour after arrangement.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(9 Commentaires)

Hi! this logic is hard to apply directly to the table by data macro. But it is easy to apply to the form used to manage data. Can you please send me the form you use to manage data? Or do you manage data directly Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(7 Commentaires)

I can do this

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(2 Commentaires)

Hi, my name is Esteban Salpeter and I'm an expert MS Access developer, with many years of experience on that platform. You can check out my portfolio to view some of my work. Your requirement is very clear, so the mo Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(1 Évaluation)

I am expert in Ms Access, Oracle SQL, Oracle PLSQL, Oracle DB admin and I can deliver you as soons as you request.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)

I saw your opening, and I hope to be invited for an interview. My background includes serving as a customer service associate within both call-center and administrative environments. I have worked on the customer serv Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)

Hello, I have gone through your job posting and become very much interested to work with you. I speak both French and English I am a hard worker, productive and worthy of your attention I hope. I would be the ri Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)

Bonjour, J'ai 10 d’expérience dans le domaine IT ,J'ai le plaisir de de vous servir pour finir cette tache dans un bref délai . Merci

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(0 Commentaires)

Bonjour, je suis à l'attention de votre service, en faite je suis un jeune marocain licencié, ayant une certificat de langue de test de connaissance française avec niveau B2, je pourrai vous aider a compléter vos tâche Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(0 Commentaires)