In Progress

Microsoft Access MultiSelect Table Interface

The basic idea behind this project is to move data between three

tables using three listboxes on a form with buttons that when clicked moves the data between the tables and listboxes and does specific things.

Please see attached mockups

[url removed, login to view]

this shows the All table with multiple selections and the WIP table as blank.

[url removed, login to view] this shows what happens when the user has multi selected data from

listbox All and clicked the

1 -> button, the data is moved to both the WIP table and the WIP listbox.

Three tables one called:

Table1 Entitled: All

With the fields:


Table 2 is called WIP

and contains the fields:





Table 3 is called:


and contains the fields







The three tables will interact with each other like this.

In the All table there is a list of all departments for a store.

On the ChooseDepartments form the first listbox is multiselect enabled

and when the user makes a selection and then clicks on the button 1 ->

the selected department names are moved from table1 named All and moved to the

table entitled WIP, when being moved to the WIP table three fields are auto created.




department is formed by taking the DepartmentKeyword field and appending -Dept to it.

username is a random mix of characters autogenerated by clicking the 1 - > button.

password is a random mix of characters autogenerated by clicking the 1 - > button.

Table 2 caled wIP is multiselect as well.

Clicking the number 2 button will simply move all the selected items from WIP table

over to the Chosen table.

Clicking number 4<- button will simply move all the selected items from Chosen table

over to the WIP table.

Skills: Visual Basic

See more: microsoft access wip table, access multiselect table, access multi select, access multiselect, microsoft access table interface, microsoft access multi select list box table, microsoft access multiselect, simply well, microsoft number, data access interface, access listbox multiselect, microsoft access multiselect list box, listbox access, vba access search items multiselection listbox, access multi select query, access form multi select, access form query multi select listbox, multiselect list box access example, access multi select table, multiselect table, multi select access, mive selected access listbox table, multiselect access, multiselect append access, access listbox table

About the Employer:
( 2 reviews ) Austin, United States

Project ID: #48551

Awarded to:


Hello Please see PMB for details of my bid. Regards

$50 USD in 2 days
(55 Reviews)

4 freelancers are bidding on average $54 for this job


hi, i am interested in doing any kind part time work, i am basically software eng. with 5yrs [login to view URL] vb java .net i will deliver the project in time or even b4, with quality u expect. thanks gmh

$100 USD in 1 day
(2 Reviews)

Please see Private Message Board

$35 USD in 3 days
(0 Reviews)

connect us ASAP

$30 USD in 2 days
(0 Reviews)