Pass Through to SQL Server Optimization Questions
On an autoexec function several recordsets are opened. Some are
queries to local tables, some are to sql server tables.
I have been trying to optimize performance but I haven't seen much
difference in speed between queries run directly against linked SQL
Server tables vs pass through queries. Here is my code for creating
the pass throughs (I have another function OpenRecordSetLocal that
handles queries to tables within the frontend. The ODBC connection
string resides in the query Q_PassThrough.
Am I missing something key? Is there a better way to do this?
Function OpenRecord...Help with a formula..
I am trying to create a formula that will take information from a cell on one
sheet and combine it with text on another sheet. I know how to get the two
together. My problem is that I want the part that is brought in to be bolded
type. Here is what I have in the formula. ="we are pleased to submit our
quotation for "&(cell reference)&" according to the following
specifications." What I want to do is have the cell reference part be bold
type. Is there a way to do that? It doesnt work if I bold the cell.. already
tried it.. Any suggestions?
You'...Help needed urgently
Im trying to check that one row of data satifies a criteria, then if it does
it counts an entry in another column adjescent to it.
Column A - Column B
Blay - Y
Blay - N
Blay - Y
Chop - N
Chop - N
High - Y
What i would be asking (of a much bigger table) is If Column A = Blaydon and
then column B (same row) = Y, then count. In this example I would want 2
returned as the answer.
Is this possible?
Try one of these...
Use cells to hold the criteria:
D2 = Blaydon
E2 = Y
If you're using Excel 2007 or later:
=COUNTIFS(A2:A7,...help with dynamic tables
This is a bit complicated to explain but I'll try my best. In columns A, B,
C I have different drop down lists. Column A has Store1, Store2, Store3,
etc. Column B has Dept1, Dept2, Dep3, etc. Column C has ProductA, ProductB,
ProductC. As of right now, these lists are not dependent on each other, I
can choose anything from any list regardless of the previous category. Also,
the length of these lists is undefined, meaning I will constantly be adding
to them in sequential rows below. And then columns D and beyond have data
such as Sales, Profits, # of items, etc.
What I...Help! Problem Referencing Excel 2003 in VB.NET
I am using Visual Studio 2008 Express Edition to develop some VB.NET
code that manipulates Excel files. I am developing on a Vista/Excel
2007 machine, but I need the code to work on an XP/2003 machine as
I initially set a reference to the Microsoft Excel 12.0 Object Library
and imported the Microsoft.Office.Interop.Excel namespace. This works
great on the VIsta/Excel 2007 machine, but it does not work on 2003,
which needs the 11.0 library. I get an error that says "Unhandled
Exception . . . Could not file or assembly
'Microsoft.Office.Interop.Excel, Version 12.0.0....Chart "Benchmark" Line Graph Question
I am generating a graph of many team's monthly audit productivity percentages
(bar graph) with a "benchmark" (line graph) at 95% (y axis) across 6 month
period (x axis).
The problem is that the line graph appears on the graph but the ends of the
line are centered in the end columns (left & right). Is there as simple way
to extend the benchmark line out to the edges of the graph?
Have a great day and live life with passion!
...Need Help with drop down list with conditions...
I need help.
I'm having a very difficult time creating a sequence of list which change based on the item selected on the main list, lets call it the index:
The Index list, the first list, would define vendors. In this case Hotel Companies (e.g Hilton, Marriott, Sheraton).
The following list, the 2nd list, would define properties, but the properties would vary based on which hotel company is selected (e.g. If Hilton, then "The Plaza, the Waldorf Astoria. If Marriott, then Marriott Marquis, Marriott Convention Center etc etc...) on list #1.
And Last but not least, the 3rd list would...Excel 2002 converts 'S' to 0 when pasting from Clipboard
I came across the following problem:
I copied some tabular data from IBM Personal Communications into the
clipboard (yes, I am still a user of good old 3270 applications). Then
I pasted the data into Microsoft Excel 2002 and all cells containing a
'S' became a '0' (number zero).
Next I did some tests and found out that every single uppercase 'S'
that is transferred to Excel using copy/paste is translated to '0'.
This would not happen with other letters or with words containing an
Using 'Paste special' I can choose to insert my Clipboard a...Macro Help #18
Well I think this is a macro. I have searched my excel book and i can not
seem to figure out what to do.
I want to write something that if this statement is true, then the font
color changes. But here is the potential problem. THe location of the text
will change. So i need it to search for this text and then change the color.
Does that make sense? Is this possible? If this can be done it will really
help me. Thanks in advance.
This is exactly what i am trying to do.
You type in a persons name into cell a1. you also type a name into cell a2.
These names will transfer over ...Newbie needs help with new Exchange 2003 installation
I am TOTALLY new to Exchange. We just installed Exchange Server 2003
on a Windows 2003 domain.
I have one (test) account set up and it appears to work OK but I keep
getting an error message that says "Task "Microsoft Exchange Server"
reported error (0x8004010F): 'The operation failed. An object could
not be found.'
I know, I know...How could I possibly not understand THIS message?
I appear to be getting mail but I' can't be sure. How can I check to
see what's causing this (and more important...what object it's looking
Thanks for any help!
I tried to work on Word today for first time on newish Mac and
realized none of my Office applications work.
When I double click on Word I can see something happening as I get the
circle of colours twirling, but half an hour later it still hadn't
opened. I just have to do this as quickly as possible as I have a
deadline for what I have to do Monday at 12.
I've tried reinstalling the software, but that didn't do anything for
me. Mind you I know absolutely nothing about installing anything on
Mac computers so I could be doing it all wrong.
Do any of you have any idea what c...Macro help with saving a spreadsheet with date and time in it
Can someone help me with some code that would save a file name as
Alan, how about something like this
ActiveWorkbook.SaveAs Filename:="Schedule " & Format(Now,
"mm-dd-yyyy-hh-mm") & ".xls", FileFormat:= _
xlNormal, Password:="", WriteResPassword:="",
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
We went live with 4 decimals on our functional currency and we now want to
reduce them to 2 decimals. All of our transactions so far are in 4 decimals.
Can anyone guide me into doing this? thank you
Use the Change Decimal Places window to change the number of decimal places
used for keeping quantity or currency amounts for items. You might need to
complete this procedure if an item was set up improperly, or if you’re
changing the units of measurement for an item.
NOTE: If an item is on an unposted transaction, you can’t change its decimal
place settings. Ensure you have a complete ba...Area Chart Question
I am graphing an area chart off a table of numbers. Is there a way to show
the summary totals in the data table that I am showing on the graph without
having the totals appear on the area graph itself?
Unfortunately the data tables are not going to give you a lot of
flexibility. Whatever is in the chart is going to show up on the data table.
To get around this restriction, I would suggest creating a data table made
of worksheet cells as opposed to using the standard data table. The link
below describes the process:
http://www.pdbook.com/index.php/excel/a_simple...Payment on Account receipt question
When I apply a payment to customer's account, a receipt prints with an entire
history of the customer's purchases. Is there a way to limit this
information, as some of my customer's history is quite extensive. Thank you
in advance for your help.
I would go into the xml for the receipt you are looking forward. You should
be able to add another <for> loop in the section that writes out your history
to have it stop at an arbitrary number. I haven't tried it, but something
like the following, right inside your for loop for history, should work
<set name="Hi...OWA Setup Questions #2
I am attempting to install the newly released owaadmin tool. My IIS server
currently hosts 3 websites all of which are published to their own urls via
host headers all of the sites are using ssl. When Installing the owaadmin
tool, it creates a new "Default Web Site" as the orginal "Default Web Site"
has been renamed.
The new "Default Web Site" contains only the files and path names pointing
to "%systemroot%\Program Files\Outlook Web Access Administration" what I am
doing is removing this new "Default Web Site" site using the I...Please help a exchange newbie.. Message filtering
I have a contact set up on Exchange 2003 that forwards to a cell phone
for alerts generated in our environment. This contact is setup to get
notice of several events, all events have separate email address as the
"sender" one of the events gets allot of notices. I would like to
have this contact not receive mail from the one email address that
generated allot of events. I have set up the properties under the
exchange general > messaging restrictions, and have authenticated users
only and from everyone except the email account I don't want to
receive alerts from, BUT when anyon...Paste Special, Values, Transpose
Is there a way in Access 2007 to use the paste special features available in
Excel? I have data in Excel that I will be copying and pasting into a form
in Access. Importing would be tricky because not all tickets on the
spreadsheet need to be copied.
The issue is I receive the spreadsheet from another workgroup and they've
merged cells and have the data going down one column, 19 rows. I can copy,
paste special within Excel to get the data formatted right, then copy it into
Access. I'm hoping there's an easier way.
...Recipient Policy Question #6
My company is changing its name and obviously wants to reflect this
with their email addresses.
They want to use email@example.com format. Currently,
there are a lot of bespoke email addresses with multiple domain names
being used. The management would like to change this from the 1st of
January for everyone at the same time. There are over 1000 users and
manually changing each address is not viable (so I hope!)
The vast majority of users have the "Automatically update e-mail
addresses based on recipient policy" under AD Users and Computers
I have already ...Do until Loop question
I have 2 fields in a table - a station and a use checkbox. This is only used
for set-up purposes... but I'd like the user to check boxes on the subform
and have a sentence show up on the main form in a field.
Sentence would look like: Cheese, Chips
My programming works, except I get an error because it can't go to specified
record when I am on the last record. For some reason - .movefirst and
..movenext don't want to work.
Here is my code. Thank you for any help! Tammy
Private Sub use_AfterUp...Help me do this
I need some help. I want to use Windows Live mail without signing in or
having a hotmail or live account. I use gmail and it works fine. I have
exported all my contacts from my live.com email and imported all of my
contacts so that is not the problem. I want to import my calendar from my
live account. I can't find anyway to do this. If I stop signing in of course
my calendar is gone. How can I export my live.com email calendar into
windows live desktop client so I don't have to sign in anymore? Thx
"T-Man" <firstname.lastname@example.org> wrote in message...Help?
Ok this is for all the formulae gurus out there.
I have a list in a particular column, lets say column A
This is a list of dates
I have another cell which uses data validation to reference this list. Say
In cell B1 the only acceptable entries are that which are in column A
Can anyone supply me with a formula for my data validation which will only
allow 8 entries.
These 8 entries....appearing in the list in B1 will be 8 weeks in advance of
the current date.
I am currently using the following formula
=OFFSET(O2,MATCH(YEAR(NOW()),YEAR(O2:O200),0)-1,,SUMPRODUCT(--(YEAR(O2:O200)=YE...Copy/Past Conditional Format
Good morning board ... :)
Presently, I have approx 15 rows by 100 columns loaded
with Conditional formatting ... working ok so far.
Now I need to extend this same pattern down ... maybe
skipping a couple of rows between each pattern.
Issue ... Conditional format formulas are not changing
when I do copy/paste due to $ locking the cell positions.
And if I take the $ out ... then Conditional format
appears to fail where they already exist.
I am certain this can't be unique, but I do not know the
fix or work around ... Therefore, I am coming to the many
Magicians of this board ... ...Need help installing Office 2007
I'm trying to install Office 2007 on my Vista PC. A short way through the
installation I get this message: " Cannot Find Proofing.en-us”....
I've searched around:
but I can't get anything to work.
Any help or suggestions would be very much appreciated.
What version of Office 2007. Did you have a Trial version already installed on your
PC and did you remove it
I need to create a data input screen on excel where multiple users
at the same time will use them & input data.
This data then needs to be stored as a database as well, where i can
use it to understand trends
and the question is ...?
<email@example.com> wrote in message
>I need to create a data input screen on excel where multiple users
> at the same time will use them & input data.
> This data then needs to be stored as a database as well, where i can
> use it to understand trends