472,805 Members | 951 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,805 software developers and data experts.

Multiselect Listboxes

Hi,

I am working with two listboxes that are initially getting populated from database tables (Access). They basically allow the user to transfer information back and forth from one listbox to the other listbox WITHOUT affecting the database.

My question is this. When the user selects <Save Changes>, I want to be able to update the database table with the information in Listbox1. Basically like a security setup utility. What's my best option?

My solution would be to store the original entries of Listbox1 in Array1, then once the use selects the <Save Changes>, store the new set of Listbox1 entries in Array2. Compare with some sort of looping routine. If more entries exist, do a SQL Insert. If less, do a SQL Delete.

These listboxes are very limited in methods and properties. They are specific to an SAP application software.

Thank you.
Sep 18 '07 #1
1 1670
gits
5,390 Expert Mod 4TB
hi ...

welcome to TSDN ...

could you please post some code you have so far? the idea to link the listboxes with js arrays sounds good ... but you may consider objects ... so you might optimize the runtime behaviour of the list-compare-operation. have a look at this article ...

kind regards
Sep 18 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Alan Lane | last post by:
Hello world: I'm using Access 2003. I have 2 listboxes. One is a single column. The other has two columns. I can use Dev Ashish's code (thanks Dev!) from the Access MVP Website to accumulate...
1
by: cableguy | last post by:
I have a report that gets its criteria from an unbound form. The form has three fields: Month, System, and TechID. I would like to use two mulitselect listboxes to allow the user to select more...
0
by: deejayquai | last post by:
Hi I'm moving forward with a topic I've posted a couple of time before but still haven't cracked it, any further help is much appreciated. In a nutshell, I want to append either 1 or a selection...
3
by: Lenard Gunda | last post by:
Hi, I have the following problem. On a page I have a multiple selection listbox. It contains a lot of items. When items near the bottom are selected, and I do a postback, the control jumpst to...
5
by: doncee | last post by:
Please point me in the direction of some good, free web based resources\ documentation for information on developing the multi select list boxes. Have made extensive use of the non-multi list...
6
by: Dazbear | last post by:
Hi There Have been on a massive learning curve today creating an Access database without having even started the software before this morning! All going well and have learned to create table,...
43
gcoaster
by: gcoaster | last post by:
Hello!! Love this forum. by the way, FishVal and NeoPa are geniuses. I have a question regarding = comboxes to multiple listbox selection populates subform. My goal is NOT to use macros,...
1
by: asharma0001 | last post by:
Hi all, I was wondering whether somebody might be able to help me with a question I have on a MS Access Database I'm building. I have created a search form with a few multiselect listboxes....
4
by: Dan2kx | last post by:
Good eve peeps, got a quicky for ya (hopefully) i have two multiselect listboxes on a form and i would like a query to show all the selected values from both boxes, i tried to sting the data...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 2 August 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
by: erikbower65 | last post by:
Using CodiumAI's pr-agent is simple and powerful. Follow these steps: 1. Install CodiumAI CLI: Ensure Node.js is installed, then run 'npm install -g codiumai' in the terminal. 2. Connect to...
0
linyimin
by: linyimin | last post by:
Spring Startup Analyzer generates an interactive Spring application startup report that lets you understand what contributes to the application startup time and helps to optimize it. Support for...
0
by: erikbower65 | last post by:
Here's a concise step-by-step guide for manually installing IntelliJ IDEA: 1. Download: Visit the official JetBrains website and download the IntelliJ IDEA Community or Ultimate edition based on...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Sept 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
by: Rina0 | last post by:
I am looking for a Python code to find the longest common subsequence of two strings. I found this blog post that describes the length of longest common subsequence problem and provides a solution in...
5
by: DJRhino | last post by:
Private Sub CboDrawingID_BeforeUpdate(Cancel As Integer) If = 310029923 Or 310030138 Or 310030152 Or 310030346 Or 310030348 Or _ 310030356 Or 310030359 Or 310030362 Or...
0
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
2
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.