Suoritettu

Access VBA Module

Module required to split UK postcode (zip codes) as per attached spreadsheet. The table on left is an Access table. The yellow table on right will be the resulting query,

The module needs to b run to create a query as per the yellow table.

So the new row is created after each space and then at the end of the cell. Unless there is a space the group will remain together e.g. BD1-22,97-99

1 B, BB, BD1-22,97-99, BL, CH, CV, CW, DE, DN1-12,16-17,21-22,31-35,40-41,55, DY, EN6-8, GL1-4,7,14,16-20,50-56, HD, HR1,4,6-9, HX, L, LE, LN1,5-6, LS, LU, M, MK, NG, NN, OL, PE1-11,13-16,19,26-30,38,99, PR, S,SK, SN1-7,25-26, ST, SY1-4,99, TF, WA, WF, WN,

The project needs to be uploaded in Access.

Taidot: Tietokantaohjelmointi, Excel, Microsoft Access, Visual Basic, Visual Basic for Apps

Näytä lisää: how to call a module in access, ms access modules collection, ms access module example, ms access vba module, creating modules in access, access vba open module, how to create a module in access 2010, what is a module in access, access vba work required, access vba convert currency, input form access vba, access vba printer settings dialog, access vba create pdf, access vba outlook automation, processor access vba code, print pdf access vba, excel vba module, convert sql access vba, converting access vba, copy subform access vba

Tietoa työnantajasta:
( 4 arvostelua ) Alrewas, United Kingdom

Projektin tunnus: #17199041

Myönnetty käyttäjälle:

sourabhg98

Hello! This is Sourabh Gupta from New Delhi. I am an advanced Excel VBA programmer currently at the post of Forum Expert at [login to view URL] (username - sourabhg98) with over 400 questions answered and 1100 rep Lisää

£20 GBP 1 päivässä
(44 Arvostelua)
4.6

14 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

£50 GBP 10 päivässä
(3 arvostelua)
7.7
NourElDeen

Dear Sir, I'm expert at access and ready to help you on doing your requirements. Kind Regards, NourElDeen

£20 GBP 2 päivässä
(58 arvostelua)
5.8
£18 GBP 1 päivässä
(7 arvostelua)
4.2
coderX15

I have been working in the Analytics field for 2 years and also completed my MBA from a very reputed MBA college. This has helped me have a lot of experience in the field of analytics. Currently I am working on utilizi Lisää

£18 GBP 1 päivässä
(11 arvostelua)
3.9
£55 GBP 1 päivässä
(3 arvostelua)
3.2
vijayvizzu7

I read your description and saw your attachment. I have years of experience in MS Access development, i am sure i can handle your request

£18 GBP 1 päivässä
(2 arvostelua)
1.3
Echecsxn

As an: 1- Bachelor of Applied Mathematics 2- Engineer in Statistics and Applied Economics 3- Microsoft Office Technician (Microsoft Graduate: MOS Diploma), I am able, available and ready to do this kind of work in Lisää

£16 GBP 2 päivässä
(0 arvostelua)
0.0
passionateK7

Hi I am fast typist. I have a good time management skill. I have many years of work experiences in data entry. I have a very good knowledge of microsoft word. I will try to do your project as soon as possible. Best Lisää

£19 GBP 2 päivässä
(0 arvostelua)
0.0
£18 GBP 1 päivässä
(0 arvostelua)
0.0
ananthgadag

Hi, I will be able to get a working macro as per your requirement within a day if you can kindly allocate the project to me. Thank you.

£13 GBP 1 päivässä
(0 arvostelua)
0.0
£10 GBP 1 päivässä
(0 arvostelua)
0.0
£18 GBP 1 päivässä
(0 arvostelua)
0.0
seenivasan11

I have knowledge in email & excel and macro. I will try to complete this task as per your requirement. Relevant Skills and Experience Excel macro and vb

£18 GBP 1 päivässä
(0 arvostelua)
0.0