Solved

Problem with Paired MultiPik List Boxes - AccessVBA

Posted on 2008-10-28
11
277 Views
Last Modified: 2013-12-25
Using Access and VBA:
I am working on a new project and have created a UI that needs to facilitate the user selecting from the Available list of Investors and moving the six columns of strdata that each row contains to the Selected list. If they make a mistake, they need to be able to move the row or rows of six columns back to the Available List.
My attempt at this came close, but no cigar.
I have attached detailed information file.
ExpertExchangeQuestion-ListBox.doc
0
Comment
Question by:ajslentz
  • 6
  • 5
11 Comments
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 22828424
ajslentz,

Posting a Word Doc without any explanation does not help us understand what you may have done wrong.
It would be better if you posted a sample of your database.

In any event, ...

See this links for how to move Items from one listbox to another.
http://support.microsoft.com/kb/274809

JeffCoachman
0
 

Author Comment

by:ajslentz
ID: 22830154
Thanks, but I had already looked at that link as well as dozens of others before posting this. I can't seem to find a good example that moves six columns back and forth. Could you not open the word doc? There is a full explanation and my code in it.
0
 

Author Comment

by:ajslentz
ID: 22830582
I have attached a cutdown version of the database to aid in the solution.
PairedListBoxes.mdb
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 22833013
The word doc is meaningles to me, I needed to see the actual Database.
Thanks for submitting it, I will look at this tonight.


:-)

JeffCoachman
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 22847237
ajslentz,

Try this.

You must study it carefully and adapt it to work in your database.

JeffCoachman

Access-EEQ23855959MoveSelectedIt.mdb
0
Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

 

Author Comment

by:ajslentz
ID: 22867596
Would it be possible for you to zip the db so I could download a zip file instead of an .mdb file?   I am unable to open your mdb file due to the network security here. I believe this might work in getting by the security.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 22867798
0
 

Author Comment

by:ajslentz
ID: 22871254
Thanks for that great solution.
I came up with another way to get it done, and it works great, but it's about four times more code than what you used. My colleges and I are truly amazed at what little bit of coding you had to use.

Great Job - Thanks  
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 500 total points
ID: 22873908
ajslentz,

My code could have easily been double the size.
Fortunately the code to move the records on way, was the same for the other way.
So all I had to do is write the code once and swap out all the "Directional" variables.
;-)

JeffCoachman
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 22873911
So is my post acceptable, or do you still need my help?
0
 

Author Comment

by:ajslentz
ID: 22876081
Your solution is very acceptable! I will be replacing my code with it.
I believe that will do it for now.

Again, Thanks for a great job on this.  
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
You can of course define an array to hold data that is of a particular type like an array of Strings to hold customer names or an array of Doubles to hold customer sales, but what do you do if you want to coordinate that data? This article describes…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now