Find Jobs
Hire Freelancers

Microsoft Access Database Expert must know Forms, VBA or Scripting

$30-250 USD

Completed
Posted over 5 years ago

$30-250 USD

Paid on delivery
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
Project ID: 17954477

About the project

1 proposal
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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 in 5 days
5.0 (21 reviews)
6.3
6.3

About the client

Flag of UNITED STATES
New York, United States
0.0
0
Payment method verified
Member since Oct 13, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.