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

Subscribe Post Reply

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

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

Microsoft Access / VBA

Two multiselect listboxes

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

Microsoft Access / VBA

Appending from 2 multiselect listboxes

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

Microsoft Access / VBA

Multiselect listbox jumps to top on postback

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

ASP.NET

MultiSelect List Boxes

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

Microsoft Access / VBA

MultiSelect on a form to generate different records ?

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

Microsoft Access / VBA

multiselect listbox -> populates subform in a form in a form! ;-)

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

Microsoft Access / VBA

Transferring ID from one Multiselect Listbox to another

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

Microsoft Access / VBA

MultiSelect lstbox data in query

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

Microsoft Access / VBA

Access Europe meeting on Wed 2 August - An Access Developer Guide to creating applications in Blazor

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

Microsoft Access / VBA

How to Use CodiumAI's pr-agent?

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

General

Speedup your spring application

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

General

Steps manually installing IntelliJ IDEA.

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

General

Access Europe meeting on Wed 6 Sept - Database Analyzer and other tools

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

Microsoft Access / VBA

Python code for finding the longest common subsequence

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

Python

To verify entry of a dropdown

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

Microsoft Access / VBA

React to native button blinking effect

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=()=>{

Software Development

Windows 11 and Access Combo Box Issue

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

Microsoft Access / VBA

Multiselect Listboxes

Similar topics