I need a solution similar to the Microsoft Customize Quick Access Toolbar dialog

[NeoPa]

Hi Phil.

Unfortunately your capture is of a small picture in a big screen so cannot easily be seen.

FYI. In order to get a picture to show in a post you can surround the link with [ImgNoThumb]...[/ImgNoThumb] tags.

-Ade.

[PhilOfWalton]

Hi Ade

I knew the image was no good, but as I don't have a web page, I can't see how to use your method.

Anyway I have played with the image, and that should now be easily readable.

Phil
[ImgNoThumb]https://bytes.com/attachments/attachment/8751d1464478341/table5.jpg[/ImgNoThumb]

[Hinson3]

Thank you NeoPa and Phil for the image.

Phil, I am a bit confused again. At the beginning your instructions were

“Now on the form where the 2 list boxes appear, we need to create that users personal list of services. “

I created the form (WrapUp) with 2 list boxes Available Service and Selected Service.

Next, your instructions were

“Now create an unbound form with 2 listboxes on it. I call them ListNotSelected & ListSelected.”

Is this an entirely new form?

[NeoPa]

No worries Phil. You just type it in as you would the text.

If you edit one that has it updated you'll see exactly what I mean.

[Hinson3]

NeoPa, was the previous reply for me? Hinson3?

[NeoPa]

No sir.

The Phil in the address was that of PhilOfWalton. It hadn't occurred to me that you may also be a Phil behind your user name. He'd had trouble getting his picture to show in the thread itself.

I updated his post to show the picture, and tried to explain how he could do the same for himself. He's a friend so I may give him a call to explain it if he continues to struggle.

As far as the question goes I'm happy to leave you in his very capable hands.

[PhilOfWalton]

Confusion, confusion.
Your WrapUp form is the what I an referring to, and what I referred to as "ListNotSelecte d", you have called "ServiceAvailab le" and what I called "ListSelect ed" you called "ServiceSelecte d". We will use your words in future.

So I gave you the code to use on the OnOpen of your WrapUp form to create the portion of the EmpEquip table for that user and computer (you will have to modify the field names to suit your tables) and I also gave you the RowSource for the 2 list boxes.

Let me know when that is working OK.

Phil

[Hinson3]

Hello Phil:-( I’m not as skilled in Access as I thought. I recreated the database with only the two tables. (See attached) I tried everything I could do and research to get the Record Source for the “Service Available” list box to work. I activated the Multi Select to Extended and switched the Row Source Type from Table/query to Value List to Field List. It displayed the field names or #Delete never the table value or content. Normally I create ListBoxes using the wizard however I cannot do that with an unbound listbox nor can I get the checkboxes (on the table) to display in the ListBox.
I updated the code and got rid of the debug prompts and have attached a snapshot of my table and record source for ProdService. I’m stuck.

[PhilOfWalton]

I think you've struggled long enough.

Have a look at the attached.

Phil

[Hinson3]

Mercy! You are a prince, thank you Phil. However, when I opened the DB and double-click the form I got a Run-time error 3022. "The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again. When I click debug "SelectedSet.Up date" is highlighted.

I modified the foreign key in the EmpCardService table to Yes (Duplicates OK) and it worked. Will this come back to bite me later?

[PhilOfWalton]

Sorry, missed that one. Duplicates OK is fine, but you may have to create a combined unique key of ProdServID, User & Computer as some stage.
See how it goes.

Incidentally, you should now see entries from my computer and your computer in the EmpCardService table.

Phil

[Hinson3]

Hello again! I have dropped the selected services list boxes into my database and are mapping the fields. Yayeee! Ran into a Compile error:

"The code in this project must be updated for use on 64-bit systems.
Please review and update Declare statements and then mark them with the PtrSafe attribute. Is there a vba code that test for 32-bit and 64-bit?"

I'm looking for a code that will test for both as some employees now have a 64-bit processor while most are still with the 32-bit.

Hmm, should this be on a separate post?

Hinson3

[PhilOfWalton]

I think start a separate post, as I have limited knowlege on this.

Be aware that windows can be either 32 or 64 bit, and Access can be either 32 bit or 64 bit.

[zmbd]

> Keep in mind, most Office installations are 32bit - The processor type will not matter, it's the office version that may be the issue:
- 32 bit installs are still the recommend default installation
- once a 64bit version of Office touches the file, the 32bit versions will most likely not be able to open the file.

> This article goes into a bit of detail and has an example of how to handle the 32/64 issue:

Compatibility Between the 32-bit and 64-bit Versions of Office 2010
I suspect it's the:

Private Declare Function apiGetComputerName Lib "kernel32" Alias _
     "GetComputerNameA" (ByVal lpBuffer As String, nSize As Long) As Long

giving the compiler heartburn.

and yes, this may be straying a tad from topic so it may be best to start a new thread if the above doesn't solve the issue(s)... just place a link in the new thread to this one for context :)

Choose the 32-bit or 64-bit version of Office (read more?)
(...)Note: The 32-bit version of Office works well with both the 32-bit and the 64-bit versions of Windows. If you are installing the 64-bit version of Office, you need the 64-bit version of Windows. If you’re not installing on Windows, you don’t need to worry about 32-bit or 64-bit options. (...)

[Hinson3]

Thanks guys. I moved my database with the two list boxes back to the laptop with the 32-bit version of Windows. I'm not willing to go there either. I am incorporating the dual listbox selections into the main data. Will keep you posted.