Search results

Colin, The subscript error is a bug that I dont believe can be fixed with my current code. This is related to an array assignment as you probably know but occurs (for me) rarely. A few comments on the code: Columns are designated in textbox name by a letter, where rows are by a number. It's a...

Sonic, awesome! Will look into that information. Thanks

Yes I saw... Here is my listbox drag n drop solution which should not be corrupt, again, no code notes.

Like I said, i can't post a link because the permissions of this forum and I currently am not at my workstation to provide you the code. His website has an example showing multiple listbox functions for various tasks. One of them is highlighting listbox selection via mouseover, which contains...

I haven't looked at this code yet. I will in a few hours. The height of a listbox row is a topic that Collin and I worked on about 6 months ago. If you're bored you can sift through how we arrived at our solution: Or you can visit his website where he has the solution: My solution is...

Its MUCH simpler. But not faster. Moving an item say, 5 rows with buttons, will cause the underlying change event to fire 5 times. Thats 4 more times than needed.

Hello, Returning with more information. The control in question is a custom listbox control that allows for drag-n-drop re-order functionality. I have developed this already and have been using it for quite some time in VBA using a crude subform with textbox objects arranged in column/row...

Hi all, great input! MajP: That's an awesome link. I'll return in about 6 hours with a more detailed explanation of my control and what I have developed so far. Looking forward to seeing how others have approached similar scenarios! Regards

theDBguy, Ahh, the "ActiveX" term eluded me. I'll do some research with that keyword... curious to see if anyone has any hands on experience with this and has an idea if the difficulty. Thanks for your input!

Hi, I have a need for a specific control to be built for an Access application. I have built this control in a rather crude way with the existing built in controls using VBA. But performance is rather poor due to lots of looping. Some of the performance can be improved with some code...

Hi PLOG, Here is the info you request: The project's current context is a non-commerical personal project that has been in development for about 14 months now. This application is being pre-developed by myself for use in a small manufacturing business that currently does not exist. The...

PLOG, Great tips and advise. Thanks a lot for your help.. In regards to item #1 of your comments, can i interpret your words as if I do not need the Primary Key (ID) in my data, there is absolutely no reason to use the JOIN query? I do not need the primary key (ID). Just associated data with...

Hi, I am experimenting with a query over the network for an in-development application. FE is access and BE is access. With a test of 100,000 records, this query is very slow. Fields of concern are: PK autonumber, OperationID, and version. OperationID can be duplicative. Each record with a...