Hi,
On the project I am working on we need to encapsulate all data and business
logic in an activex dll. My question is: How do I do this? How can I
access the form objects ie text boxes, buttons with a dll?
Thanks. 4 2684
"rufus" <he***@online.de> wrote in message news:ch**********@online.de... Hi,
On the project I am working on we need to encapsulate all data and
business logic in an activex dll. My question is: How do I do this? How can I access the form objects ie text boxes, buttons with a dll?
Thanks.
Or to put this another way, how can I move the code from my class modules
into an Activex object OR export it as an activex dll?
Hi, Rufus. On the project I am working on we need to encapsulate all data and business logic in an activex dll. My question is: How do I do this? How can I access the form objects ie text boxes, buttons with a dll?
Don't try to do this. It's like pushing on a string. Microsoft Access
database applications are not designed to be accessed _from_ *.DLL's.
Microsoft Access database applications are designed to _use_ these
libraries, instead. Access objects, even if they have the same name as VB
objects, such as "Form," are different objects, often with different
Properties, methods and behaviors.
For example, the "only" control on an open Form is the ActiveControl, which
is the control with the focus. All other controls are "painted on" the form
with pixels in order to save memory. It's pretty hard for an exterior
process to access the other controls on the Form when there's no Windows
handle to reach them.
how can I move the code from my class modules into an Activex object OR export it as an activex dll?
You can encapsulate code from your class modules in a *.DLL that your
database application can call at run-time. Just open the modules and export
them as text files to be imported into a VB project and compiled with your
Visual Basic compiler. You may need to modify some of the code, because VB
is not identical to VBA, but they are pretty close. If you use any other
programming language for your *.DLL, then you will have to do a major
rewrite of your code.
HTH.
Gunny
See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.
(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
"rufus" <he***@online.de> wrote in message news:ch**********@online.de... "rufus" <he***@online.de> wrote in message news:ch**********@online.de... Hi,
On the project I am working on we need to encapsulate all data and business logic in an activex dll. My question is: How do I do this? How can I access the form objects ie text boxes, buttons with a dll?
Thanks.
Or to put this another way, how can I move the code from my class modules into an Activex object OR export it as an activex dll?
"'69 Camaro" <Fo**************************@Spameater.orgZERO_SP AM> wrote in
message news:dmK_c.2256$x12.1040@trnddc05... Hi, Rufus.
On the project I am working on we need to encapsulate all data and business logic in an activex dll. My question is: How do I do this? How can
I access the form objects ie text boxes, buttons with a dll?
Don't try to do this. It's like pushing on a string. Microsoft Access database applications are not designed to be accessed _from_ *.DLL's. Microsoft Access database applications are designed to _use_ these libraries, instead. Access objects, even if they have the same name as VB objects, such as "Form," are different objects, often with different Properties, methods and behaviors.
For example, the "only" control on an open Form is the ActiveControl,
which is the control with the focus. All other controls are "painted on" the
form with pixels in order to save memory. It's pretty hard for an exterior process to access the other controls on the Form when there's no Windows handle to reach them.
That is what I was afraid of. 'The project I am working on requires a
'controller' to sit between andMS Access application, vb.net application and
the database. The idea is that the vb.net application and the MS Access
application send the same calls to the controller and then the controller
reacts depending on whether Access or VB.NET are calling the functions. I
am beginning to think this is impossible because of the different
programming interface inherent in both.
Thanks for your help anyway.
"rufus" <he***@online.de> wrote: That is what I was afraid of. 'The project I am working on requires a 'controller' to sit between andMS Access application, vb.net application and the database. The idea is that the vb.net application and the MS Access application send the same calls to the controller and then the controller reacts depending on whether Access or VB.NET are calling the functions. I am beginning to think this is impossible because of the different programming interface inherent in both.
You can do this. But you are not using the full power of bound forms, subforms and
continuous forms. As this then is going to be more work anyhow you might as well
write the GUI in VB or VB.Net.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Stan |
last post by:
Hallo,
I have developed an application in MS Access 2000 (Polish version) under MS
Windows XP prof (also Polish).
Now I would like to run this code on MS Windows XP EN and MS Access XP EN.
I have...
|
by: Norman Fritag |
last post by:
Hi there
I have avoided to use active x controls because I thought they are causing
more problems then they are doing any good.
I a new application I would want to use the tree and list view...
|
by: WindAndWaves |
last post by:
Hi Gurus
I have recently discovered references in the VB section of MS Access,
however, when choosing references, I noticed that there are more than who
knows how many options. How and/or where...
|
by: Tony Lee |
last post by:
Some time a ago, on this newsgroup the following comments were made in
recommending
good references for Access (2003)
>I used to recommend Dr. Rick Dobson's, "Programming Access <version>" for...
|
by: denelson |
last post by:
Does anyone know what might cause netscape not to open Data Access
Pages from Microsoft Access 2000? I can open them fine with internet
explorer, but not netscape.
|
by: mikez |
last post by:
Hi,
We recently built a very basic file management system for a client in
Access 2003 (to use with incoming tif scans). In it we used
Microsoft's Document Imaging activex viewer (from Office...
|
by: Neil |
last post by:
I posted a few days ago that it seems to me that the Access 2007 rich text
feature does not support: a) full text justification; b) programmatic
manipulation.
I was hoping that someone might...
|
by: StinkyDuck |
last post by:
I'm trying to determine if it is possible to create a ActiveX control which
would be deployed through IE that would provide access to the client
resources to control devices like barcode readers,...
|
by: =?Utf-8?B?QmlsbHkgWmhhbmc=?= |
last post by:
I have a asp.net app, in the page there is a scan activex which could scan
and save a jpg file in client harddisk.
How could we access and display this jpg file on the fly using js in the
client...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
| |