Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 30
Search took 0.00 seconds.
Search: Posts Made By: ironfelix717
Forum: Forms 11-21-2019, 08:10 AM
Replies: 6
Views: 167
Posted By ironfelix717
Re: MS Access - Insert Text at cursor with SelText

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...
Forum: Forms 11-20-2019, 10:00 PM
Replies: 6
Views: 167
Posted By ironfelix717
Re: MS Access - Insert Text at cursor with SelText

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...
Forum: Forms 11-20-2019, 08:58 AM
Replies: 6
Views: 167
Posted By ironfelix717
MS Access - Insert Text at cursor with SelText

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...
Forum: Forms 10-28-2019, 12:35 PM
Replies: 83
Views: 1,786
Posted By ironfelix717
Re: MS Access: custom control built in another language

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...
Forum: Forms 10-28-2019, 08:33 AM
Replies: 83
Views: 1,786
Posted By ironfelix717
Re: MS Access: custom control built in another language

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...
Forum: Forms 10-28-2019, 07:57 AM
Replies: 83
Views: 1,786
Posted By ironfelix717
Re: MS Access: custom control built in another language

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...
Forum: Forms 10-27-2019, 09:28 PM
Replies: 83
Views: 1,786
Posted By ironfelix717
Forum: Forms 10-27-2019, 07:04 PM
Replies: 83
Views: 1,786
Posted By ironfelix717
Re: MS Access: custom control built in another language

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
Forum: Forms 10-27-2019, 05:27 PM
Replies: 83
Views: 1,786
Posted By ironfelix717
Re: MS Access: custom control built in another language

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...
Forum: Forms 10-27-2019, 03:59 PM
Replies: 83
Views: 1,786
Posted By ironfelix717
Re: MS Access: custom control built in another language

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...
Forum: Forms 10-23-2019, 09:42 AM
Replies: 83
Views: 1,786
Posted By ironfelix717
Re: MS Access: custom control built in another language

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...
Forum: Forms 10-21-2019, 02:01 AM
Replies: 83
Views: 1,786
Posted By ironfelix717
Re: MS Access: custom control built in another language

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...
Forum: Forms 10-20-2019, 08:48 PM
Replies: 83
Views: 1,786
Posted By ironfelix717
Re: MS Access: custom control built in another language

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...
Forum: Forms 10-20-2019, 02:58 AM
Replies: 83
Views: 1,786
Posted By ironfelix717
Re: MS Access: custom control built in another language

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...
Forum: Forms 10-19-2019, 08:19 AM
Replies: 83
Views: 1,786
Posted By ironfelix717
Re: MS Access: custom control built in another language

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...
Forum: Forms 10-19-2019, 06:47 AM
Replies: 83
Views: 1,786
Posted By ironfelix717
Re: MS Access: custom control built in another language

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,...
Forum: Forms 10-18-2019, 08:56 PM
Replies: 83
Views: 1,786
Posted By ironfelix717
Re: MS Access: custom control built in another language

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...
Forum: Forms 10-18-2019, 01:25 PM
Replies: 83
Views: 1,786
Posted By ironfelix717
Re: MS Access: custom control built in another language

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...
Forum: Forms 10-18-2019, 12:35 PM
Replies: 83
Views: 1,786
Posted By ironfelix717
Re: MS Access: custom control built in another language

Sonic, awesome! Will look into that information.
Thanks
Forum: Forms 10-18-2019, 12:28 PM
Replies: 83
Views: 1,786
Posted By ironfelix717
Re: MS Access: custom control built in another language

Yes I saw...

Here is my listbox drag n drop solution which should not be corrupt, again, no code notes.
Forum: Forms 10-18-2019, 12:18 PM
Replies: 83
Views: 1,786
Posted By ironfelix717
Re: MS Access: custom control built in another language

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...
Forum: Forms 10-18-2019, 10:31 AM
Replies: 83
Views: 1,786
Posted By ironfelix717
Re: MS Access: custom control built in another language

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...
Forum: Forms 10-18-2019, 06:55 AM
Replies: 83
Views: 1,786
Posted By ironfelix717
Re: MS Access: custom control built in another language

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.
Forum: Forms 10-17-2019, 09:29 PM
Replies: 83
Views: 1,786
Posted By ironfelix717
Re: MS Access: custom control built in another language

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...
Forum: Forms 10-17-2019, 03:46 PM
Replies: 83
Views: 1,786
Posted By ironfelix717
Re: MS Access: custom control built in another language

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...
Showing results 1 to 25 of 30

 
Forum Jump



All times are GMT -8. The time now is 03:36 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World