Is It Possible To Pass Parameters to A Pass Through Query
My assumption is that's it's not. At work I use ODBC to connect to our
oracle database with Access 2003. There are cases where using a pass through
query runs much much faster and I then use it in a make table query to make
a local table. In access you can use brackets  to have it ask for input.
May I assume there is no way to do anything like that in a pass through
Create a PassThrough query and use code to assign the SQL to this query
filtering it with a parameter, and then run it
Dim MyVariable As Integer
MyVariable = InputBox("Please select a Number&quo...Avoid drawing blank values
Can you tell me if there is a way to plot only non-blanked values from
Y=10, ,10,10 (so no value for x=2)
I want to obtain a continuous line going from the first point (1,10) to
the third point (3,10) and then of course to (4,10).
Thanks in advance for your help,
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/
On Mon, 10 Nov 2003 10:52:34 -0500, ivarela1 =
> Can you t...Excel VBA Macro executing half-way
I have a macro which I run regularly and successfully until last couple
days when it stopped executing half-way. This also happened to other
macros as well. I debugged the macro and it stopped at certain line but
gave no error, then started from the beginning of the code.
Thank you for any comment.
...How to count an age group
I am trying to do this operation:
in cell F7 I have the following datas corresponding to peoples age
how can I count the numbers of time its ocurrs eg. of 50-<70
I also need to know the percentage of each of them, how often they have been
in that cell.
I appreciate if any good soul can help me.
Hazarding a guess that a pivot table is quite ideal
for what you seek to do. It's easy n fast to set-up
Here's the play to tinker with (steps in xl2003):
Presume that you have age data (as posted) i...PivotTable buttons remembers old unactual values
I have discovered that buttons in the row area remembers old values not
longer existing in the data.
Ex: I have 4 persons with initials "aaa", "bbb", "ccc" and "ddd"
I have the Initial button in the row area.
When I click on the arrow of the "Initial"-button, it gives me the
possibilities: "(Show all)", "aaa", "bbb", "ccc" and "ddd".
If I change initial "ddd" to "xxx", refresh the pivot table and again
click on the arrow of the "Initial"-button,
it gives me the p...Do not display Value label if value = zero
I am putting together a pie chart, where values for some slices is 'zero'.
The zero slice is not visible, but the label still appears '0%'. Is there
any way of suppressing this label for the zero slice only (so the other
slices still have value labels appearing) ?
Many thanks for any help
Format label, custom format:
"LFNFan" <LFNFan@discussions.microsoft.com> wrote in message
> I am putting together a pie chart, where values ...Updating Links Option
When I get the message "This workbook contains links to other data sources"
I can't imagine what "other data" they are referring to. How can I find out
the source of this "other data"
Thanks in advance
When I can't find links, I'll use Bill Manville's FindLink program:
It does a much better job searching for them than I can do.
> When I get the message "This workbook contains links to other data sources"
> I can't imagine what "other data" they are...'Email via Mail Merge' option missing -again, please, help
No 'Mail Merge' options (email, Letter) in the Create Quick Campaign Wizard
I am using the Outlook client, the option 'Enable Direct E-mail via Mail
Merge' is selected in System settings, approptiate roles are assigned.
Outlook and web client use differenet URL, they are not running at the same
time (just Outlook is running). I deleted all cookies and closed all Explorer
windows - nothing helps :-((
Is your Outlook and Word the same release? ie. You have both Outlook 2003 and
> No 'Mail Merge' options (email, L...Org Chart Function -- Static or Dynamic?
This is a multi-part message in MIME format.
It seems to me that if I create an Org Chart using the wizard in the =
system and get the data from a database, then the created chart is =
static in nature with no way to automatically update the structure as =
items in the database change.
Is this correct?
If not, how do I get it to do a refresh?
If so, is there anyway to create a dynamics Org Chart that can be =
refreshed as the data in the un...Pass multiple selected values from list box to table
How do I pass multiple selected values from a list box to a table?
I've found code to use the values as criteria in a query but would now
like to store the values in a table (at least temporarily)
thanks in advance.
Pass selected values from a list box to a table? I don't really think you
want to do this. Can you describe more about what you are trying to
You just store raw data in a table. You don't store manipulated data in a
table. Maybe you need a query to do what you want to do...
If this information was helpful, please indi...create new mailbox storage group on additional volume
I want to create new mailbox storage group on Exchange 2003.I added new
My question is What path I can put to store my new sorage group.is it has to
drive:\Program Files\Exchsrv\... or i can create any path for new database.
you can place the log files for the storage wherever you like, and you can
place the mailbox store database wherever you like...just specify the
"Vlad" <Vlad@discussions.microsoft.com> wrote in message
> I want to create new mailbox storage group ...Flexibility in Line Item options
I am preparing a construction budget for some condos and I'd like to
have a simple way to choose between different options for some of the
line items (i.e. granite countertops instead of tile)... each would
have its own cost implication and affect the bottom line. Any ideas?
Equity Directions, Inc.
If you make a data array with options and price as:
You could use a validation list on the first column to make a dropdown
menu and then a VLOOKUP() on the table array to change the price on the
bo...Setting a value on a main form from a subform
Am I correct in assuming the way to set the value of a control on the main form from a subform is:
Me.Parent.ControlName.Value = "XXX"
Obviously it isn't because I continue to receive errors when I try to access the control.
Thanks in advance. - CES
> Am I correct in assuming the way to set the value of a control on the
> main form from a subform is:
> Me.Parent.ControlName.Value = "XXX"
> Obviously it isn't because I continue to receive errors when I try to
> access the control.
> Thanks in advance...Formula to determine row of hi value filtered column
Trying to see if its possible for a formula to return the row # of the
highest or lowest visible value in an autofiltered range.
rgarber50's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=11350
View this thread: http://www.excelforum.com/showthread.php?threadid=401821
...How to pass an object from C++
We have a C# asp.net web application that is using a COM dll
We use the tlbimp to be able to use the COM dll from C# asp.net web
The method InitRules shown below is located in the COM dll.
It can be seen below the text Original.
Method InitRules below is called from C# but we want to pass an object of
type Handle_DS in addition
to all the other parameters. You can see the modified InitRules below marked
Note the object of type Handle_DS is a C++ object that is created from C#
asp.net application and pass
into the InitRules
I have also copied the whole idl fil...Help with Date Function
I have tried, and I can't figure out if this is possible. I'm trying to have
dates autofill into a row of columns (C5 to V5 to be specific). I don't want
week-end days to be a part of the autofill, and I can't figure out the
formula. Any suggestions?
Enter the first date in C5 which must be a weekday then put the formula
below in D5 and drag right
When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
questio...Can't Install News Group Reader in Outlook 2003?
I follow the instructions for adding the news reader when you customize tool
bar in Outlook 2003. When I click Go in the Commands tab there is nothing
that indicates News!
I have tried following the help section step by step and STILL NO News to
drag to the Go section on the tool bar!
I need my News Groups!
To get the News command back, go back to the Programs tab in Control Panel |
Internet Options and change the default newsreader to Outlook Express. If
OE prompts you to make it your default newsreader the next time you lau...Send options for one receipent
I'd like to set one email receipent's send options to be different from
others. When I start an email for this user I can go into options and set
it's priority, a different reply address, etc. I want this to be the same
for the receipent all the time. Is there away I can set a default for this?
TOOLS | EMAIL ACCOUNTS | View or change existing Accounts |
There you can change the default account.
Is this what you asking for?
Ich habe nichts gemacht, gestern gings noch!
Bitte in den Newsgroup antworten damit jeder etwas davon hat.
I have an MFC application with a TreeView and a CDockablePane
When I select a tree item - I display its properties in the properties
window. That works.
But I don't know how to change the tree item properties when I change
the values in the properties window. My problem is in getting the
values from the properties grid.
I tried to override EndEditItem method like this:
BOOL CMyMFCPropertyGridCtrl::EndEditItem(BOOL bUpdateData)
CMFCPropertyGridProperty* currProperty = GetCurSel();
//I don't like this implementa...groupmethod options
When designing reports (.qrp files), what can you set GroupMethod to besides
groupmethodNone or groupmethodSum?
...100% Passing Guaranteed in All I.T. Exams/Certifications at 1st Attempt Hi Friends, To pass all types of I.T Exams/Certifications with mind blowing results in 1st attempt just visit http://www.itreal
100% Passing Guaranteed in All I.T. Exams/Certifications at 1st
To pass all types of I.T Exams/Certifications with mind blowing
results in 1st attempt just visit
http://www.itrealexams.com/ and get real time Q&As, Brain Dumps, Real
Exams, Study material, E-Books, Video Exams and Labs for your all type
of I.T Certification Exams.
...static member variable not working with static member functions
think its a lack of knowledge, but I have problem to realize the
I have a class C. I have 2 member function F1 and F2. F1 is static F2
not. I would like to access a static private member variable V1 from F1
and F2, so in principle both are working on the same memory-physical
variable. I don't get it work.
What is the right way to realize this?
Something else must be at work here. Both F1 and F2 should be able to
access the static member variable.
"ZZT" <email@example.com> wrote in message news:firstname.lastname@example.org...
> H...PDF option
I have acrobat reader 6.0 loaded on my machine. However, I
do not get pdf as one of the options in my reports
printing file type.
I am on Great Plains 8.0
You need the full Adobe to write files. Just the _reader_ won't work. Of
course I expect a great many to reply to this as well and tell you there are
some free and other inexpensive PDF writers out there but only Adobe will
work as you are expecting it here.
<email@example.com> wrote in message
> I have acrobat reader 6.0 loaded on my machine. However, I
&...This group has cooled down
Interesting how this group has cooled down. Nothing seems resolved so the
cycle just starts over again for 06.
This group has cooled down. I guess they just got tired of M05 not working
and not getting any help from MS. Maybe they switched to Quicken.
> Interesting how this group has cooled down. Nothing seems resolved so the
> cycle just starts over again for 06.
Flyfishing Fool wrote:
> This group has cooled down. I guess they just got tired of M05 not working
> and not getting any help from MS. Maybe they switched to...IT CertificationzzzZ.....100% GUARANTEED PASS.......!!!@!!!
IT CertificationzzzZ.....100% GUARANTEED PASS.......!!!@!!!
If you are serious about your professional career and pass IT
Certification exam in first attempt then Visit http://www.FreeExamKing.com
and get latest Questions And Answers Dumps for Microsoft, Oracle,
Cisco, CompTIA and many more, i have used and found it very helpful.