I gang

ACCESS form and VBA expert

I have a t-shirt business where I list products on a variety of marketplaces. Usually there is a parent sku and child skus for each design, color, size, style. I want an ACCESS form that can make creation of the necessary information for listing on marketplaces easier.

First it needs to build the skus from some input and some selections. The total sku length can be no more than 30 characters. The user should input the design name on the form. Then select the gender, brand, style of shirt, colors it will be offered on from a drop down/check boxes/etc based on the style selected, and size range.

Example: Design=FavPeople_Daddy ; Gender=Men, Manufacturer=Gildan Style=Short Sleeve; Colors=Black, Gray, Heather Red, Heather Military Green; Size Range= S-3X

These selections would create 24 child skus.

FavPeople_Daddy_MGS_BK_S

FavPeople_Daddy_MGS_BK_M

FavPeople_Daddy_MGS_BK_L

You get the idea.

On the same form I want the user to be able to select the event that the applies to the shirts. This can have multiple choices. Father's Day, Christmas, Birthday, Retirement, Pregnancy Announcement, Sibling Shirts etc. Some events may need further refinement of choices for maybe a 60th birthday or a specific year. Each of these event would have tables associated with them, or perhaps it is one table and each event represents a field. The tables or fields would have numerous search terms and phrases associated with each that are frequently used on marketplaces (we can provide a list of the terms).

When my employee selects the events for the shirt design, the selection should result in a random selection of words/phrases from the chosen event tables/fields which are concatenated with a space between each where the final length is close to but not exceeding 250 characters to go in a field for search terms on EACH child sku. Each child sku search terms should be different and randomly generated.

In addition, each child sku needs to have a title generated randomly. The title must not exceed 80 characters. The first certain number of records for each event table should probably consist of simple descriptive nouns that could easily be used for titles so that randomly selection within this record range would result in an acceptable title consistently. The employee should enter the actual name of the design ... like My Favorite People Call Me Daddy. Then the titles can be something like below.

Father's Day Gift, My Favorite People Call Me Daddy, T-shirt for Daddy, Black L.

The design name should not be used in every title. Maybe just put it in 25% of the titles with the others have just random search phrases associated with the events selected. Some marketplaces allow for more characters in the title so I may want multiple fields created for the title on each sku with the character limits different. The same goes for the search term field.

The form will need to allow us to enter the path for the images for each sku. It would be great if most of the path is there for the url image path with us just entering in the folder. The filename can be created from the main sku name, like FavPeople_Daddy_MGS_BK.jpg. All the child skus for each color will have the same main image since we do have different pictures for each size.

The employee also needs to enter the Design name group for EACH COLOR set. Example: Daddy Black or it could be Favorite People Daddy Black

I have a t-shirt business where I list products on a variety of marketplaces. Usually there is a parent sku and child skus for each design, color, size, style. I want an ACCESS form that can make creation of the necessary information for listing on marketplaces easier.

First it needs to build the skus from some input and some selections. The total sku length can be no more than 30 characters. The user should input the design name on the form. Then select the gender, brand, style of shirt, colors it will be offered on from a drop down/check boxes/etc based on the style selected, and size range.
Example: Design=FavPeople_Daddy ; Gender=Men, Manufacturer=Gildan Style=Short Sleeve; Colors=Black, Gray, Heather Red, Heather Military Green; Size Range= S-3X

These selections would create 24 child skus.
FavPeople_Daddy_MGS_BK_S
FavPeople_Daddy_MGS_BK_M
FavPeople_Daddy_MGS_BK_L
You get the idea.

On the same form I want the user to be able to select the event that the applies to the shirts. This can have multiple choices. Father's Day, Christmas, Birthday, Retirement, Pregnancy Announcement, Sibling Shirts etc. Some events may need further refinement of choices for maybe a 60th birthday or a specific year. Each of these event would have tables associated with them, or perhaps it is one table and each event represents a field. The tables or fields would have numerous search terms and phrases associated with each that are frequently used on marketplaces (we can provide a list of the terms).

When my employee selects the events for the shirt design, the selection should result in a random selection of words/phrases from the chosen event tables/fields which are concatenated with a space between each where the final length is close to but not exceeding 250 characters to go in a field for search terms on EACH child sku. Each child sku search terms should be different and randomly generated.

In addition, each child sku needs to have a title generated randomly. The title must not exceed 80 characters. The first certain number of records for each event table should probably consist of simple descriptive nouns that could easily be used for titles so that randomly selection within this record range would result in an acceptable title consistently. The employee should enter the actual name of the design ... like My Favorite People Call Me Daddy. Then the titles can be something like below.
Father's Day Gift, My Favorite People Call Me Daddy, T-shirt for Daddy, Black L.

The design name should not be used in every title. Maybe just put it in 25% of the titles with the others have just random search phrases associated with the events selected. Some marketplaces allow for more characters in the title so I may want multiple fields created for the title on each sku with the character limits different. The same goes for the search term field.

The form will need to allow us to enter the path for the images for each sku. It would be great if most of the path is there for the url image path with us just entering in the folder. The filename can be created from the main sku name, like FavPeople_Daddy_MGS_BK.jpg. All the child skus for each color will have the same main image since we do have different pictures for each size.

The employee also needs to enter the Design name group for EACH COLOR set. Example: Daddy Black or it could be Favorite People Daddy Black

Evner: Databehandling, Microsoft Access, Visual Basic, Visual Basic for Apps

Se mere: access vba examples pdf, access vba code examples download, access 2016 vba tutorial, ms access 2007 sample projects, access 2016 vba examples, access vba tutorial for beginners, vba access projects free download, ms access application examples download, access copy address info form vba, api google map access form vba, access copy form vba, paste access form vba, webbrowser vba access form, access order form vba, save access form pdf using vba, access form vba cut paste, convert vba access form excutable file, scroll access window form vba, access close form vba, access hidden vba form

Om arbejdsgiveren:
( 0 bedømmelser ) McKinney, United States

Projekt ID: #19246789

Tildelt til:

markpashalis

Hi, my name is Mark. I have 20+ years of expertise with MS Access, Excel, VBA and SQL Server and will be happy to work on your project. I've designed, developed and maintained many Access applications and am well-verse Flere

$50 USD / time
(14 bedømmelser)
5.3

14 freelancere byder i gennemsnit $34/time for dette job

schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Flere

$30 USD / time
(218 bedømmelser)
7.6
bmartynvw

Hi, My name is Benjamin. I'm a VBA and MS-Access expert with over 14 years of experience. I have read the project description and understand what you are trying to get done. Would love to discuss further. T Flere

$50 USD / time
(8 bedømmelser)
6.4
VladimirLilenko

Hello, dear sir! I registered at the forum not so long ago, but I already have several completed projects on www.freelancer.com. I am ready to carry out your project in the reasonable price and in the shortest possibl Flere

$25 USD / time
(143 bedømmelser)
6.4
alaeddindhahri

Hi, I'm a senior databases developer. I have developed multiple CRMs, Inventories and Information Systems from scratch using Ms Access, SQL and VBA. I have read your project description and I'd like to help you devel Flere

$30 USD / time
(72 bedømmelser)
5.8
zu02

Hi, there I hope all's well with you. I see you'r looking for a developer proficient in Ms Access/VB. I can build very friendly ms Access app for your "business " project. I'm Ms Access/VB/SQL/Excel program Flere

$25 USD / time
(50 bedømmelser)
6.1
dvcontact

Hi, Would you like to see a quick demo of your project on creating an Access form that makes it easy to create and list necessary information into marketplace completed before you award the project? You can consider i Flere

$25 USD / time
(23 bedømmelser)
5.4
olaideejiwole

Hello sir/ma, I'm interested in taking this task up for you. I'm a professional and also have good command over MS Excel especially pivot table, charts, advanced formulas, formatting, Excel VBA, R Programming Language Flere

$25 USD / time
(12 bedømmelser)
4.7
KozlouAlex

Hello. Please check below similar Access jobs completed by me: https://www.freelancer.com/projects/excel/create-complex-report-from-table/?w=f https://www.freelancer.com/projects/visual-basic/need-import-xml-from-url Flere

$30 USD / time
(14 bedømmelser)
3.9
fanninson45

SHOWCASE I have done a similar Access projects before with 5* ratings: • https://www.freelancer.com/projects/php/build-ACCESS-Database-with-external/ • https://www.freelancer.com/projects/excel/Access-Database-desig Flere

$25 USD / time
(2 bedømmelser)
3.3
bluesea1990

I read through the job post carefully. Absolutely sure that I can do the project perfectly. Please, if you hire me for the post, you will obtain everything what you want.

$44 USD / time
(2 bedømmelser)
2.5
pnjadhav

Please review my profile I am working with skills that you required for this job from 16 years. I am working with MS Access,Excel,MS SQL and VBA from long time. I can definitely help you in this job, to make your d Flere

$30 USD / time
(4 bedømmelser)
2.5
bluestar1027

Hi Dear. Don't worry for your project, i can do your project completely. Because of i'm dedicated and created developer for project and love to develop for you. if you don't satisfy my result, i will return your mon Flere

$41 USD / time
(1 bedømmelse)
1.8
sagom

I'm a software engineer with a postgraduate in software development and I have extensive experience in the development of web and mobile software, I have worked with business intelligence projects based on Microsoft te Flere

$50 USD / time
(0 bedømmelser)
0.0