Đã Đóng

vb/vba procedures to generate 2 letter code and update recordsets

Access 2013 (32 bit)/Win10

Job012: Write Access VBA procedures to:

A) Create a procedure/function to loop through each field in ttblHd that begins with "col" and write the value in the field to the tlkpHdPr, field strHdPrK.

For example, there are 2632 records in ttblHd with 79 columns beginning with "col". The values in those fields when appended [url removed, login to view] yield 133 records. While there are currently 79 fields beginnning with 'col', but that number may go up or down over time.

Table tlkpHdPr shows the desired output.

B) Create another procedure/function to again loop through each field in ttblHd that begins with "col" only this time write 3 values to another table, ttblCldPrFld:

value 1 is from the 'col' field

value 2 is from a second field, strFlNmK, and

value 3 is the numeric part of 'col' field name.

See ttblCldPrFld for the desired output.

Requirements:

1) Create procedures/functions in the attached Access database, dbJob012

2) Process should execute from the command button cmdTest on frmTest

3) Code should be commented with explainations of how it works

Attached:

::dbJob013

::tlkpHdPr

::ttblCltPrFld

::ttblHd

::frmTest

Job013: Write Access VBA procedures to:

A) Create a procedure/function to increment a two letter code.

B) Create a procedure/function to loop thru the recordset definited by qrstPrLy4AaK assigning the next code generated by the above procedure to the field, strAaK

For example, if qrsstPrLy4Aa has 10 records, after the procedure is run:

Record 1 now has AA in strAaK

Record 2 now has AB in strAaK

Record 3 now has AC in strAaK

Record 4 now has AD in strAaK

Record 5 now has AE in strAaK

Record 6 now has AF in strAaK

Record 7 now has AG in strAaK

Record 8 now has AH in strAaK

Record 9 now has AI in strAaK

Record 10 now has AJ in strAaK

Requirements:

1) Create procedures/functions in the attached Access database, dbJob013

2) Process should execute from the command button cmdTest on frmTest

3) The recordset above, qrstPrLy4aaK is defined by a select query of the same name in dbJob013

4) Each time the code is executed, the letter code should increment from the last value used, i.e. using the example above, if the next execution started with record 11, the code assigned should be AK.

5) The procedure/function should generate a user message if when it is within 10 records of exhausting all available codes, i.e. there are 650 possible 2 letter combinations, when 640 have been used, the user message should fire.

6) Code should be commented with explainations of how it works

Attached:

::dbJob013

::tlkpPrHd

::tlkpPrLy

::qrstPrLy4Aa

::frmTest

Kĩ năng: Visual Basic, Visual Basic cho Ứng dụng

Xem nhiều hơn: vba code update powerpivot pivot table, vba code update data powerpivot table, share vba code update excel, vba code update data excel, sample code update sql excel vba, code voor add ins excel vba, update user account excel vba active directory, vba code update vba, visual basic code update excel shared workbook, php code update mysql database, vba code update sheets excel, excel vba code update, update cover letter, code update sheet excel, code extract view source data vba

Về Bên Thuê:
( 150 nhận xét ) Faridabad, India

ID dự án: #11369059

14 freelancer đang chào giá trung bình $74 cho công việc này

$40 AUD trong 1 ngày
(28 Nhận xét)
5.2
abhinovpankaj

Hello, I have been working as freelancer since last ~ 3 years,prior to this was working with a MNC as an Sr. Software Professional. The project is Product based development and integration of the product with vari Thêm

$88 AUD trong 2 ngày
(25 Nhận xét)
5.0
kolosibalint

$30? Are you serious? It's not worth $30 reading the description. ______________________________________

$500 AUD trong 10 ngày
(26 Nhận xét)
4.5
$35 AUD trong 1 ngày
(10 Nhận xét)
3.8
Mufaddalsaifee

Hi There, First of all i want to thank you for inviting me to bid on your project. I have checked the details and will be able to help in Access. I have 5+ years of experience in Microsoft technologies (EXCEL, Thêm

$35 AUD trong 1 ngày
(8 Nhận xét)
3.6
MohsanEijaz

I have experience in MS Office, VBA Programming, XML, MS Work, Google Docs, SEO, Google Spreadsheet, Data Entry in Odoo, Google Document and other related applications. I believe my capabilities would be perfect for y Thêm

$55 AUD trong 1 ngày
(3 Nhận xét)
3.6
morrisstarling

Thanks for inviting me to bid on this project. I am ready to work this weekend and deliver by Monday. I'm happy to discuss any additional comments over the chat best regards Morris

$70 AUD trong 1 ngày
(6 Nhận xét)
3.3
parama4u

Hi, I am working with Visual Basic, and developing VBA scripts since 2007 for corparate Clients. Please check my profile and let me know your questions if any. Regards, Param

$30 AUD trong 3 ngày
(1 Nhận xét)
1.4
TulyakovN

Understand, how to do this job. Skills in VBA, experiance of working in word, excel, access. No problem with this job and those tasks from discription.

$30 AUD trong 3 ngày
(1 Nhận xét)
1.0
$30 AUD trong 1 ngày
(1 Nhận xét)
1.0
sahumk2000

I am interested in this task, here is my profile Education- Masters in Computers Skills - VBA, ASP.NET, MVC, EF, C#, VB.NET, SQL Server, WCF, WPF, WebAPI, AngularJS, Jquery, XML, Cr Reports Experience- 12 Yrs as D Thêm

$30 AUD trong 1 ngày
(0 Nhận xét)
1.3
mstphly

passion to do these little things

$40 AUD trong 1 ngày
(0 Nhận xét)
0.0
kevindelhi

Developed many applications using access. I ensure that u will get desired solution in scheduled time period.

$25 AUD trong 1 ngày
(0 Nhận xét)
0.0
willycamps

Hello, I will leave my information here in my profile. I have time to support you Let's talk about your needs in detail I hope, I will hear from you soon, Best regards

$25 AUD trong 1 ngày
(0 Nhận xét)
0.0