Hey Folks:
Long time no see! Hope everyone is well.
I have an old mdb I'm upsizing to an adp. There is a button on a form
which executes code similar to the following (this is a search form
where sql is dynamically generated based on 1-7 criteria fields chosen
by the user):
strSQL = strSQLBase & strWhere & strOrder
Set db = CurrentDb()
Set qdf = db.QueryDefs(st rMasterQuery)
qdf.SQL = strSQL
docmd.openquery strMasterQuery
The idea here is that the user can then dump the results from their
parameter query to excel (tools>office links>analyze with excel) from
the query result window that's brought up by the openquery method.
Been racking the brain, so if anyone knows how to do this kinda thing
in an Access 2000 adp, I'd be eternally grateful.
(I would guess it's probably easier in Access 2K2-3, cause aren't
there 'extended properties' that sorta 'emulate' Jet? I actually do
have AK3 on this machine, but my users don't. If anyone could explain
how to do it in AK3, with the extended properties, that would be
helpful too, but the A2K solution is really the one I need for now...)
TIA,
brett 7 2335
"brett valjalo" <bv******@sfhp. org> wrote... Long time no see! Hope everyone is well.
Hi Brett!
I have an old mdb I'm upsizing to an adp. There is a button on a form which executes code similar to the following (this is a search form where sql is dynamically generated based on 1-7 criteria fields chosen by the user):
strSQL = strSQLBase & strWhere & strOrder Set db = CurrentDb() Set qdf = db.QueryDefs(st rMasterQuery) qdf.SQL = strSQL docmd.openquery strMasterQuery
The idea here is that the user can then dump the results from their parameter query to excel (tools>office links>analyze with excel) from the query result window that's brought up by the openquery method.
Been racking the brain, so if anyone knows how to do this kinda thing in an Access 2000 adp, I'd be eternally grateful.
Well, the key is that there is no CurrentDb, and no local queries, and not
DAO access to server side objects.
(I would guess it's probably easier in Access 2K2-3, cause aren't there 'extended properties' that sorta 'emulate' Jet? I actually do have AK3 on this machine, but my users don't. If anyone could explain how to do it in AK3, with the extended properties, that would be helpful too, but the A2K solution is really the one I need for now...)
I am not sure how they would specifically help here -- but to open an object
in the UI I think it has to exist (so you would have to open an existing
view, wouldn't you?).
--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies
This posting is provided "AS IS" with
no warranties, and confers no rights.
Hi Michael:
Still around I see? Good deal. I've been pretty scarce as I've been
doing vb.net and sql server work of late. Went to vbits two weeks
ago, can't wait for Whidbey, man! It looks friggin SWEET ... You
still working at MS? Working on that project at all?
Anyway, yeah, I mean, you've basically stated why it is that I have
the problem. I was just looking for a workaround, & knew this would
be the place to come if there was ;)
I just decided to assign my dynamically-built SQL to the recordsource
of a report in it's Open event, and have the user export to Excel from
the report instead of a query. I knew I could do that all along, but
I wondered if there was anything possessing props remotely like the
ol' querydef object in a .adp - suspected there was not, but it never
hurts to ask. Never know what you might learn about at CDMS, ya know?
Take Care,
Brett
"Michael \(michka\) Kaplan [MS]" <mi*****@online .microsoft.com> wrote in message news:<40******* *@news.microsof t.com>... "brett valjalo" <bv******@sfhp. org> wrote...
Long time no see! Hope everyone is well.
Hi Brett!
I have an old mdb I'm upsizing to an adp. There is a button on a form which executes code similar to the following (this is a search form where sql is dynamically generated based on 1-7 criteria fields chosen by the user):
strSQL = strSQLBase & strWhere & strOrder Set db = CurrentDb() Set qdf = db.QueryDefs(st rMasterQuery) qdf.SQL = strSQL docmd.openquery strMasterQuery
The idea here is that the user can then dump the results from their parameter query to excel (tools>office links>analyze with excel) from the query result window that's brought up by the openquery method.
Been racking the brain, so if anyone knows how to do this kinda thing in an Access 2000 adp, I'd be eternally grateful.
Well, the key is that there is no CurrentDb, and no local queries, and not DAO access to server side objects.
(I would guess it's probably easier in Access 2K2-3, cause aren't there 'extended properties' that sorta 'emulate' Jet? I actually do have AK3 on this machine, but my users don't. If anyone could explain how to do it in AK3, with the extended properties, that would be helpful too, but the A2K solution is really the one I need for now...)
I am not sure how they would specifically help here -- but to open an object in the UI I think it has to exist (so you would have to open an existing view, wouldn't you?).
Thanks, Ted. Figured a workaround using a report instead. At least
you can still dynamically assign SQL to the recordsource of a report
in an .adp, my saving grace in this problem...
Peace,
Brett te********@yaho o.com (Ted Theodoropoulos) wrote in message news:<f5******* *************** ***@posting.goo gle.com>... little things like this can sometimes be a pain in the ass even though they are seemingly simple. i posted some code to the ng on how to do something similar a few months ago. have a look. hope it helps...
http://groups.google.com/groups?hl=e...ing.google.com
"brett valjalo" <bv******@sfhp. org> wrote... Still around I see?
Yep.
Good deal. I've been pretty scarce as I've been doing vb.net and sql server work of late. Went to vbits two weeks ago, can't wait for Whidbey, man! It looks friggin SWEET ... You still working at MS?
Yes.
Working on that project at all?
Yes, my group owns large parts of the System.Globaliz ation and System.Text
classes in the framework. I personally own collation (Compare/Sort keys) and
am anowner emeritus and part time bug fixer (wants fries with that?) for
locales and such.
--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies
This posting is provided "AS IS" with
no warranties, and confers no rights.
So why do you need this in a querydef, rather than just in an ADO recordset?
AFAIK, the immensely useful recordsetcopy command works only with a DAO
recordset (I'd love to learn I'm wrong on that), but even with an ADO
recordset, you can loop through the records and fields and copy them into an
Excel spreadsheet with automation.
You could even use an Excel template to pre-format your output.
HTH
- Turtle
"brett valjalo" <bv******@sfhp. org> wrote in message
news:1f******** *************** ***@posting.goo gle.com... Hey Folks:
Long time no see! Hope everyone is well.
I have an old mdb I'm upsizing to an adp. There is a button on a form which executes code similar to the following (this is a search form where sql is dynamically generated based on 1-7 criteria fields chosen by the user):
strSQL = strSQLBase & strWhere & strOrder Set db = CurrentDb() Set qdf = db.QueryDefs(st rMasterQuery) qdf.SQL = strSQL docmd.openquery strMasterQuery
The idea here is that the user can then dump the results from their parameter query to excel (tools>office links>analyze with excel) from the query result window that's brought up by the openquery method.
Been racking the brain, so if anyone knows how to do this kinda thing in an Access 2000 adp, I'd be eternally grateful.
(I would guess it's probably easier in Access 2K2-3, cause aren't there 'extended properties' that sorta 'emulate' Jet? I actually do have AK3 on this machine, but my users don't. If anyone could explain how to do it in AK3, with the extended properties, that would be helpful too, but the A2K solution is really the one I need for now...)
TIA, brett
Sure, I certainly could do as you suggest, and it did cross my mind.
However, I don't have the time to write and thoroughly test that
automation code, and the users are used to the app (it's production
and created by someone else, and my piece is just the upsizing to
SS2K/.adp), so I was hoping for an easier solution with the exact same
look and feel that they are used to. Making a report as I described
in another post was close enough (they are used to hitting
Tools>office links>analyze w/Excel once the query is opened) to not
confuse them at all, so that's where I went with it. Thanks, though :)
"MacDermott " <ma********@nos pam.com> wrote in message news:<l7******* *********@newsr ead3.news.atl.e arthlink.net>.. . So why do you need this in a querydef, rather than just in an ADO recordset?
AFAIK, the immensely useful recordsetcopy command works only with a DAO recordset (I'd love to learn I'm wrong on that), but even with an ADO recordset, you can loop through the records and fields and copy them into an Excel spreadsheet with automation. You could even use an Excel template to pre-format your output.
HTH - Turtle
"brett valjalo" <bv******@sfhp. org> wrote in message news:1f******** *************** ***@posting.goo gle.com... Hey Folks:
Long time no see! Hope everyone is well.
I have an old mdb I'm upsizing to an adp. There is a button on a form which executes code similar to the following (this is a search form where sql is dynamically generated based on 1-7 criteria fields chosen by the user):
strSQL = strSQLBase & strWhere & strOrder Set db = CurrentDb() Set qdf = db.QueryDefs(st rMasterQuery) qdf.SQL = strSQL docmd.openquery strMasterQuery
The idea here is that the user can then dump the results from their parameter query to excel (tools>office links>analyze with excel) from the query result window that's brought up by the openquery method.
Been racking the brain, so if anyone knows how to do this kinda thing in an Access 2000 adp, I'd be eternally grateful.
(I would guess it's probably easier in Access 2K2-3, cause aren't there 'extended properties' that sorta 'emulate' Jet? I actually do have AK3 on this machine, but my users don't. If anyone could explain how to do it in AK3, with the extended properties, that would be helpful too, but the A2K solution is really the one I need for now...)
TIA, brett This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Jegger |
last post by:
Hello!
We have following situation;
network with 100 users, aplication developed in Access, user DB
deployed on SQL Server.
Is it better to create query inside aplication (with code) and then pass
it to SQL Server for execution or is it better to have all these queries
saved like stored procedures and then called from aplication?
|
by: brett valjalo |
last post by:
Hey Folks:
Long time no see! Hope everyone is well.
I have an old mdb I'm upsizing to an adp. There is a button on a form
which executes code similar to the following (this is a search form
where sql is dynamically generated based on 1-7 criteria fields chosen
by the user):
strSQL = strSQLBase & strWhere & strOrder
|
by: Beowulf |
last post by:
I have a report laid out in Design View as shown at the end of this message.
I have code that performs the following steps:
1. In main report's Report_Open(), DELETE any old rows in tblTOC for
this username.
2. In main report's CategoryHeader_Format(), add a row to tblTOC with
the current category name and the current page number.
3. In the table of contents subreport, Cancel if NoData event fires.
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| |
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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 then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |