Access 97 Runtime question
We are using Access 97 runtime for some of our staff.
I noticed today that in reports if they right mouse click, they don't get a
shortcut menu. I want them to be able to Export the report they are viewing.
Would Access 2003 runtime have the shortcut menu?
"Kelvin Beaton" <kelvin dot beaton at mccsa dot c o m> wrote in message
> We are using Access 97 runtime for some of our staff.
> I noticed today that in reports if they right mouse click, they don't get
> a shortcut menu. I want them to be...Optimiztion question
I was looking at MSDN on optimizing queries
(http://msdn.microsoft.com/en-us/library/ms998577.aspx) and am unclear as to
why a foreign key relationship affects the query in this case. At the
beginning of the article it gives an example and starts out by saying:
The sample screen shot in Figure 14.2 shows an execution plan that accesses
only one table, although two tables are included in a join in the query.
Because there is a declared foreign key relationship between the authors
table and the titleauthor table, and the au_id column in the titleauthor
table is not allowed to b...re:Restart remote computer
Try "%windir%\system32\shutdown.exe -r -t 00" (without the Quotes)i"ve never tried it on a remote> but it triggers an immediate reboot on my box...
In news:email@example.com firstname.lastname@example.org
> Try "%windir%\system32\shutdown.exe -r -t 00" (without the Quotes)i"ve
> never tried it on a remote> but it triggers an immediate reboot on my
To reboot a remote machine you need to supply the remote hosts's name:
shutdown -r -m \\hostname
But then you run into user permissions on both th...How to use MSExcel to plot Column A against Col B?
I want to plot col A (x axis) against col B ( y axis). I cant seem to
do it. Can anyone here please give me step by step primer. Thanks in
All I get is the graph of (1,2,............n) (x axis) against the n
values of either col A or B.
i.e 2 graphs instead of one.
(In the old Lotus this was so simple: select the column for the X axis
and then select the col for the Y and press enter, and you'd get the
Why is it so diff in Excel?
Select the entire range you want to graph such as a2:b44>insert>chart>>>>
dguillett1@au...RE: Use that security update
Content-Type: multipart/related; boundary="yzkfzsfqtv";
Content-Type: multipart/alternative; boundary="qeviqcxczwaquy"
this is the latest version of security update, the
"October 2003, Cumulative Patch" update which eliminates
all known security vulnerabilities affecting
MS Internet Explorer, MS Outlook and MS Outlook Express
as well as three newly discovered vulnerabilities.
Install now to hel...For Russ Paul-Jones of Microsoft re the News Headlines
Russ, it has been several days since your post re Microsoft working on the
problem regarding the news headlines on MS Money not opening, and they still
don't open. Just wanted to let you know... Thanks.
Getting back after the long weekend, it looks like it is working now, at
least in Money 2006. Still having trouble?
MS Money Product Unit Manager
"Chuck" <email@example.com> wrote in message
> Russ, it has been several days since your post re Microsoft working on the
> pro...spell check does not visually cycle through cells when run from macro?
I'm trying to recreate the same behavior in a macro that spellcheck has when
the spellcheck button is pressed. The spellcheck does not cycle through the
cells visually when run from a macro, so when there is a misspelled word,
you cannot see the cell it is a part of.
If anyone knows how I can get this behavior to work, it would be GREATLY
I did a record new macro, and got code similar to the following:
Add the fiollowing to your code as shown:
Hope you folks can help me out with a strange one.
I have several worksheets formatted in exactly the same way as follows:
Col A - width 4
Col B - hidden
Col C - width 4
Col D - Width 108
Col E - Width 3
Col F - Width 11
Col G - Hidden
Col H - Width 11 & Empty
My print range should be Cols A:G (I have used page setup to set the
scaling to fit 1 page wide by [blank] pages tall, thus each sheet will
print as many pages as required depending on number of rows]
When I have the print range set to A:G only columns A:E show on the
print preview (and also on the actual print out) and when I m...Re: Function to copy data from a variable range?
I have a sheet with about 20,000 lines of data.
From that sheet I am looking to group the data based on a parameter,
into multiple different sheets. ie: If the category is "1" copy all
that lines data into sheet A, If the category is "2", copy all the
lines into sheet B.
The problem is, the number of lines for each acatgeory type is not
always the same. Some categories may only have 1 or two lines, other
may have 200-300.
Is there any type of function for this?
Doable but why not just use data>filter>autofilter
Microsoft MVP Excel
I've been doing a lot of research and purchased (but haven't completely
read) Sue Mosher's book. However, before I spend much more time I'd like to
find out if my idea is even feasible. The basic idea is to create an
appointment system for multiple therapists that can be used by a
receptionist and other staff. Using Outlook and Exchange is very nice but
the appointment data needs to end up in an Access table immediately.
We can purchase SBS 2003 with Exchange 2003 or we can buy a third party tool
for calendar sharing whichever would be the easiest to use. I currently...cannot view all of text in large cell, even though I have it to w.
I have cell format to wrap text and it works fine to a p[oint then no more
text is displayed....casn increase the size of the cell, but still only so
much will display....rest of the cell show blank.
+the limit is 1024 characters. You can extend this with manually inserting
linebrekas using aLT+ENTER
> I have cell format to wrap text and it works fine to a p[oint then no
> more text is displayed....casn increase the size of the cell, but
> still only so much will display....rest of the cell show blank.
...initial default column width
Is there a way to configure Excel 2000 so that when I create
a new Workbook or add a new Worksheet so that all the columns
have a particular width instead of the default 64 pixels?
Create the workbook exactly the way you want it, then save it as a
template with the name "Book.xlt" (no quotes) in you XLStart directory.
It'll be then used as the template for new workbooks.
Likewise, save a one-sheet workbook as a template, named "Sheet.xlt" for
the template for Insert/Worksheet.
In article <419E181F.6251D20D@nospam.net>, Bruceh <firstname.lastname@example.org&...Windows and Mac have two distinctly different units for column width.
Operating System: Mac OS X 10.5 (Leopard)
I am trying to format columns for some data I am entering in a spreadsheet and when I enter "15.00", which is the required width for these columns given by my professor, I end up with a column 15 inches wide. What I would prefer is for the options to be like the default options in Windows version of Excel. In Windows version of Excel, when you hover over the lines between the columns it gives you two numbers (e.g. 8.43 (64 pixels)). These are the default numbers for column width in Windows Excel....Macros/Signatures Question
I have an Excel Workbook that I created for a PC Order Form. I set it up to
only make certain rows visible based on the Machine Model that they choose.
I digital signed the Worksheets and exported the Digital Signature
Certificate and installed it on the User’s PCs. The code works great. The
user opens the Workbook and it runs the Macros with no problem. The problem
I have is when the user goes to save the Workbook. They get an error that
“Excel can not sign VBA macros when saving to this file format. Do you want
to remove the digital signature and continue saving this workbook?”...How to assign unique number to column duplicates?
I need to assign a unique number to a set of duplicates all in one column in
so columnA will has about 9000 numbers, some of them unique, and others are
duplicates of 2-4 approx.
I used to conditional formatting to show which are duplicates, but need to
be able to assign a unique number to each set duplicates, that will be in
ColumnA ColumnB(unique ID)
Any ideas please? I don't know how to do programming, just form...Recipient Filtering
I would like to enable the "filter recipients who are not in the directory"
option under Global settings/Message Delivery/Recipient Filtering.
However we allow an IIS server in the domain to relay email though the
If the “filter recipients who are not in the directory" option is selected
will this cause e-mail relayed by the IIS server to non AD recipients to fail?
Recipient Filtering and Relaying are separate pieces of functionality and as
such you should not have any problems.
"SuperPlay" <SuperPla...Simple IMAP question
How do I enable shared calendar with free/busy information through IMAP ?
When I add the "calendar" folder in IMAP it displays as a mail folder, not a
Is this calendar a mailbox or public folder?
Why are you using IMAP instead of MAPI? MAPI is much more feature complete
as it applies to this sort of thing.
MVP - Exchange
"Protecting the world from PSTs and brick backups!"
"Pierrot Robert" <email@example.com> wrote in message
> How do I...Exchange 2003 Question??
I would like to know if there is an upgrade path from Exchange 2003 Standard
Edition with SA to Exchange 2003 Enterprise Edition with SA? Thank you.
This might help
"KA Kueh" <firstname.lastname@example.org> wrote in message
> Dear all,
> I would like to know if there is an upgrade path from Exchange 2003
> Edition with SA to Exchange 2003 Enterprise Edition wit...Macro Question #10
I am working with a text file that I imported into Excel.
It is a transactional report of sales by customer. The
data will have the customer number and name spread out
over three cells. What I want to do is to create a macro
that will contatenate all three cell and then perform a
paste special and paste them into another cell in another
column. Since the number of transactions by customer can
vary the customer name and number can appear anywhere on
I created a macro to do this using the first customer
which appears in cell B5 through D5. The next customer
appears...Filter two columns with criterion applying to one or the other?
I am looking for a solution to the following filtering problem:
I have two adjacent columns, so using a filter for both of them is no
problem. But what I want to do and don't know how to do is this:
I want to filter for values greater than x (a certain number, in my
case 5000) in any of the two columns. I can filter both columns for x
greater than 5000 but that filters out more than I want because there
may be some cells with a value greater than 5000 in only one of the
Is there a solution to this problem (using Excel alone or an add-on)?
you can use th...Filtering question
Is there a way to expand the filter option so that it shows 1 row (or more),
both above and below any row that contains the value I am looking for?
Data|filter|autofilter examines each cell/row on its own.
Maybe you can put the key value for each group on the rows you want. Then
filter by that column.
> Is there a way to expand the filter option so that it shows 1 row (or more),
> both above and below any row that contains the value I am looking for?
...Vlookup, multiple times in one column summing corresponding
I have a list that contains common invoice numbers that appear multipl
times in column A and need to use the vlookup function to find and su
the corresponding amounts in column B.
As you would be aware the following vlookup functio
=VLOOKUP(A3,DATA,2,FALSE) will only return the one amount once i
reaches a match and I need it to continue down the column and sum al
matching invoice numbers.
Column A Column B
145880 80.87 *
145880 54.09 *
The answer I�m looking to return is
It has to be a vlookup sty...question about leaving messages on server
My husband and I have 1 POP mail account. I am accessing it from a
computer in Virginia, where I'm staying with relatives. He is accessing
the same account from California. I have my Outlook set up to keep
messages on the server, but to delete them after 1 day (so that he will
still get the messages, but the server won't get clogged). His email
program, Eudora, is set up so the messages will be deleted from the
server after he downloads them.
Is there a chance I won't get some messages because he has his computer
set up that way? (He downloads it 1st, then it gets deleted off serv...Questions on migration from VS2005 to VS2010
As is the case every couple of years, I go through a nerve-wracking
transition to a new development environment. The thing is, I've become
really comfortable with VS2005, and our small team has a very simple and
effective approach to development. I am nervous that VS2010 will negatively
effect our productivity; but don't want to get too "far behind" toolset
So, that being said, I wanted to ask a few questions on what to expect when
moving from VS2005 to VS2010 on an upcoming project. Your feedback is
Question...New to Money 2006
I was using Money 2004 and upgraded it to 2006 last night (God only
knows, why :)).
I started to hate the idea of Passport and Web Publishing my account
details and so did not choose the Passport option.
I was able to install with regular Money stand alone password and still
update all my accounts by downloading them from the respective
financial institutions (as I used to do with 2004).
The problem is with MBNA America. I want to download the credit card
transactions. But the online setup process is asking me for passport
setup. I looked at the description of this bank on Microsoft site...