So my solution is actually going to be to step back and actually use the ActiveX TreeView control with a recordset to populate it. Duh. Ah well, learning and I learned how to write on in C# with VS2010 using Access table OLE as a dataset.
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Thursday, January 22, 2015 8:02 AM
To: 'MS_Access_Professionals@yahoogroups.com'
Subject: RE: [MS_AccessPros] dll in c# for activex control
Thanks all for the help.
Steve, yes, I'm going to want to see the visual that is the tree structure created in the code using a windows form and the treeview control.
Steep curve, but with friends like you, it makes the journey a little lighter and definitely more fun!
Geez – wouldn't it be fun to have a reunion at a resort somewhere?
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Wednesday, January 21, 2015 9:50 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] dll in c# for activex control
Hi Liz,
Tom van Stiphout has an example DLL that can be used in an Access database here:
it does need ActiveX, only a reference to the DLL in the code. Look for --> Using Simil from a pure Access application
Warm Regards,
Crystal
Tool: Document Query Calculated Fields: Access to Excel. Music by JD Live (cc)
https://www.youtube.com/watch?v=vS8KfHU6L90
- SQL to show calculated fields in queries, use CopyFromRecordset to put in Excel and then format
*
(: have an awesome day :)
*
On Wednesday, January 21, 2015 7:30 PM, "Stephen Conklin StephenMConklin@hotmail.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:
Liz ..
PS – I didn't see that you had tried to create an OCX; if you are trying to do something visible in the UI, then I need more information on versions you are using; compiling homegrown OCX in VB6 and using in older versions of Access was a bear, in Visual Studio 20xx it's even more trouble.
Steve
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Wednesday, January 21, 2015 9:07 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] dll in c# for activex control
Liz, I think your best bet is to treat it as a late-bound; it will not give you intellisense but since you are the author, you don't need it. I have done this in the past to get VBS to recognize my Dll's.
Dim new obj as object , set obj =CreateObject("MyDLL"); then call obj("my function") or "my method" etc.
Hth
Steve Conklin
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Wednesday, January 21, 2015 6:14 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] dll in c# for activex control
Pros, I've written a dll in c# and now want to use this in my Access database. This is really new to me, and since I couldn't set a reference through browse to the dll I added a bit of code to declare the function lib for it. However, now I understand that to expose the methods I need to use ActiveX and I confess I'm new there too. When I go to insert the activex control, I'm thinking I'm looking for the project id that was specified in my external code, but it doesn't show up. So then I guess I need to figure out how to register this dll or something –and then there is some file called ocx that is an active control but my visual studio compiler didn't build anything like that, just a dll.
Anyone have any help?
Respectfully,
Liz Ravenwood
Programmer / Analyst
B/E Aerospace | Super First Class Environments
1851 S Pantano Road | Tucson, Arizona 85710
Office +1.520.239.4808 |
beaerospace.com
Passion to Innovate. Power to Deliver
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Posted by: Liz Ravenwood <Liz_Ravenwood@beaerospace.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (6) |
Tidak ada komentar:
Posting Komentar