Find Jobs
Hire Freelancers

Microsoft Access Database Expert must know Forms, VBA or Scripting

$30-250 USD

Selesai
Disiarkan lebih dari 5 tahun yang lalu

$30-250 USD

Dibayar semasa penghantaran
Microsoft Access Database Expert must know Forms, VBA or Scripting I am looking for 4 tasks that will help me automate my work load. Each task will create a new form that will execute what I rewquested. I need an expert who know how to do this quickly and finds this work easy. I need this done on Microsoft Access Database extended by Scripting 1) Update Fields: RoomID, CategoryID, FunitureTypeID - Via Text Search Phrases - Example: SELECT [login to view URL], [login to view URL], [login to view URL] FROM Product WHERE ((([login to view URL]) Like "*Bar*" Or ([login to view URL]) Like "*Barstool*" Or ([login to view URL]) Like "*Wine*" Or ([login to view URL]) Like "*Game*")); - I do not want this hard coded but to have the search phrases in a table - Make a simple form that we only click a button to execute each 2) Update CrossSellIDs Field - This will be a string of ProductIDs separated by comma - You will build the string of products that match the same: RoomID,BrandID,CollectionName - If colorid id present then by collorid - Make a simple form that we only click a button to execute 3) Update ProductSetID Field and Add a Product Record - Make a simple form with a text field bix abd button to execute a) Update ProductSetID Field - Upate products that match the same: RoomID,BrandID,CollectionName - If colorid id present then by collorid - I do not want this hard coded but to only do it only for FurnitureTypes entered in a table - Update ProductSetID on all products that match RoomID,BrandID,CollectionName and FurnitureTypes entered in a table b) Add a Product Record - Enter a new product record for each product set -- Copy all the same data from selected FurnitureType -- Be able to build a name by formula builder --- Selecting and arranging datafields and hard text --- Example: BRAND COLLECTION COLOR FURNITURETYPE -- Update FurnitureType to Furniture Set in that room -- Update CategoryID to Furniture Set in that room 4) Update Fields: Name, Description, SKU by formula builder - Selecting and arranging datafields and hard text - Example: BRAND COLLECTION COLOR FURNITURETYPE - Make a simple form with a text field bix and button to execute
ID Projek: 17954477

Tentang projek

1 cadangan
Projek jarak jauh
Aktif 6 tahun yang lalu

Ingin menjana wang?

Faedah membida di Freelancer

Tetapkan bajet dan garis masa anda
Dapatkan bayaran untuk kerja anda
Tuliskan cadangan anda
Ianya percuma untuk mendaftar dan membida pekerjaan
Dianugerahkan kepada:
Avatar Pengguna
Respected Sir/Madam, I am ready to finish all these 4 tasks Kind Regards, Pankaj Garg Profile Page: https://www.freelancer.com/u/WebInfoSolutions UserName: WebInfoSolutions
$300 USD dalam 5 hari
5.0 (21 ulasan)
6.3
6.3

Tentang klien

Bendera UNITED STATES
New York, United States
0.0
0
Kaedah pembayaran disahkan
Ahli sejak Okt 13, 2018

Pengesahan Klien

Terima kasih! Kami telah menghantar pautan melalui e-mel kepada anda untuk menuntut kredit percuma anda.
Sesuatu telah berlaku semasa menghantar e-mel anda. Sila cuba lagi.
Pengguna Berdaftar Jumlah Pekerjaan Disiarkan
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuatkan pratonton
Kebenaran diberikan untuk Geolocation.
Sesi log masuk anda telah luput dan telah dilog keluar. Sila log masuk sekali lagi.