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
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