Search results

Solved! Thanks so much!

Hi, Returning with more information. Thanks for your replies. I left out a key point: the data is not well inputted, meaning the IDs do not necessarily scale with the time order of the data. Therefore, arnelgp's query will not work. This is also a problem I ran into. However, On that...

HI, I need to write a query that finds the "closest" account balance to a specified date for each account in the system. I've tried this for hours. I'm done messing around and getting nowhere. There are 2 tables: Accounts & Transactions. I need to group the Transactions by each Account in...

Thanks DbGuy, Update on this little issue: This really isn't a good approach still for a multi-line rich textbox. Reason being, if the user changes the cursor position vertically via arrows or enter or any other means OTHER than the mouse (paste, cut), the position is not captured in the...

Hi all, The solution provided doesn't meet requirements because it does not insert text at the cursor position. I've solved this in the attached example. The confusion was in the fact that the value of .SelStart was returning 0 unconditionally. Reason being, the cmdbutton gets focus and...

Hi, The preferred method of inserting text at a cursor position in a textbox appears to be setting the Textbox.SelText property.... This doesn't work for me under any circumstances (RTF or Plain format). It simply erases the entire text box. See attached. Thanks for any help. Regards

I find it peculiar that v4.0 and v4.1 do not return any errors for me. There are two separates issues here. One is 6015 that allegedly occurs when the listbox has no scrolls bars and item is dragged from top to bottom. The second issue in question has to do when scrollbars are present which I...

The entire basis of this project relies on the ability to retrieve the LB index when the mouse is moved over the row. That is derrived from the GetListIndex function, thus the GetLRBH function, thus the Wizhooks function. The UpdateRecordset failed for that exact reason - the index was...

It looks a lot like this is stemming from Wizhooks and consequently producing unreliable behavior in GetLBRH. I still cannot produce the issue no matter what happens. My system is executing this 100% reliably - with a fresh re-download of v4.0 from this forum, compact/repair, reboot - nothing...

Unsure what you mean

Tera, Thanks for testing. I still cannot reproduce the issue. I even tried compact & repair with no chance of an error. Hmm. See attached video. 2019 x64 Pro Plus

Colin, I have received this error in my main project once or twice when testing and was unsure exactly what the issue was because i couldn't reproduce it. I have just tested again with your description and received the first time i tried, but every subsequent time after i couldn't reproduce...

Hello All, Returning with some final followups for the thread. Attached is my final revision for the ListBox drag-drop class. Some quick comments on changes/improvements: - Fixed TableFromSQL bugs. Should now return the table name accurately from any SQL statement passed to it...

Following up with some comments/questions. MajP: Thanks for the class examples. I will provide my updated code within a few days. Currently implementing the class into my main project to test what its practical uses are and how it might be improved. So far, so great. Also, to the group: I am...

RecordsetUpdating does not work with a querydef name. When the rowsource is set to a querydef name AND RecordsetUpdating = True, it will fail on re-order. The reason it will fail is because the TableFromSQL func only supports a rowsource of either a discrete tabledef name or a SQL statement...

Hi, It shouldn't work with a query def because the proc to get the table name verifies the rowsource table exists in db.tabledefs and throws an error if not found. I rarely use qdfs and prefer sql string. The rowsource is already being grabbed in initialize and set to the "ListSource" module...

It appears we have a wonderful solution with MajP's code. Excellent work! Your work here has further extended the capabilities of Access for many, myself included. I made some modifications/improvements to the code. Besides putting my own twist on things (we all have a style), there are a few...

Colin, My intentions with this project are not to import data with a drag - only to reorder via mouse. The code i purchased from Peters Software has that "import" functionality, but i don't require it. I think maybe I could solve that using your work with list box row heights. Not sure, I don't...

Hi all, About Colin's example: I'm not sure why there would be a need to move multiple items in a listbox But to each their own. With your example, there is no change event code happening, therefore its going to be fast -- no functional code is being executed when a listbox item is moved...

The screen will not update with your assumed method UNTIL event code has finished execution--making for a laggy experience. This is why its faster: --Drag N Drop method = 1900 lines of code --Arrow method = ~25 lines of code (arbitrary) --Change Event Code = ~1000 lines of code (arbitrary and...