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...Limited Password Protection
Is there way to put password protection for preventing modifications
in original file. but still allow copy and paste from the original
file to another?
I'm afraid password protection is ON or OFF there's no limited protection
john ATSIGN PPTAlchemy.co.uk
Free PPT Hints, Tips and Tutorials
> Is there way to put password protection for preventing modifications
> in original file. but still allow copy and paste from the ...Protecting Application by Admin Password.
How I can Protect my Mfc application by asking for Admin Password/
Username? Is there any API to do this?
Any Samples will be of great Help.
Thanks in Advance.
What's the purpose of that? Arbitrary applications should NOT ask for admin
username/password, it's not their business. Only LSA should get them.
<email@example.com> wrote in message
> Hi All,
> How I can Protect my Mfc application by asking for Admin Password/
> Username? Is there any API to do this?
> An...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?”...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" <firstname.lastname@example.org> 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" <email@example.com> 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...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...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...upload form problem / server question
www.icingpictures.co.uk / win xp / frontpage 2003
Want to create a form with upload file form field - i read on this forum
that the server type i use is important - it should be a windows type server
with frontpage extensions - i currently use a linux server with front page
extensions - do i need to change to a windows server?
Thanks for taking a looka t my question.
Yes, you must have a Windows Server, just like you stated you read.
Tom [Pepper] Willett
Microsoft MVP - FrontPage Since 1997
"threademporium" <threademporiu...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?
...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...Printing a worksheet on 11x17 paper
I want to print a worksheet on 11x17 paper. When I try
to change to that paper size in print options, there is
no size like that available. What do I do??? thank you
for your help in this matter.
It's the printer that decides that.. Do you have that option on the printer
it should be available in Excel
"Katie" <firstname.lastname@example.org> wrote in message
> I want to print a worksheet on 11x17 paper. When I try
> to change to that paper size in print options, there is
I'm a professor and use Excel extensively in my classes. I need to be
able to assign Excel projects to my students and have some increased
assurance that the students have submitted their own work. I've tried
my hand at VBA programming and also simply used track changes. None of
these solutions (even the track changes) worked reliably across both
mac and pc platforms.
I would like some advice about whether what I need from Excel is even
I Here's what I need and what I think would work:
1. I'd like to prevent a student from getting someone else's sol...Help Locking Worksheet
I inherited a workbook that has several sheets, have gone thru and mad
changes and now when I lock it I cannot go from the last table cell o
the first row to the second row. Tabbing will just continue you out o
the same row. I want to be on cell BD3, hit tab and go to C5.
Does the fact that I have the to & leftmost cells frozen have anythin
to do with this? How can I fix it
jlabsher's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1556
View this thread: http://www.excelfo...how do I prevent a worksheet from being copied in excel
yet allow users to select values in a defined range
Good evening kensanjose
You really need to supply more information about what you mean - cop
the file/sheets/ranges etc
dominicb's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1893
View this thread: http://www.excelforum.com/showthread.php?threadid=38531
How do I prevent a worksheet from being copied in excel? Can I disable right
click within a file so that the sheet cannot be copied into another file and
manipula...Outlook 2003 question #4
Hi ... I have 4 email accounts with outlook 2003 and they
are all from the same isp provider ... My problem is when
i am going to create an email to someone i can't tell
which email account is sending the email to , its usually
set a default ... What i mean is that when i view my
email accounts they are listed as so and so default , #
1 , # 2 , # 3 , I don't know what 1 or 2 or 3 are ... Is
there a way to notice which email account is which beside
having numbers beside them ... I can't tell which is
which ... It would be better if you could view the actual
name of the ema...Name a worksheet tab with data in a cell
I have Excel 2002 and would like to rename a worksheet tab
with a cell reference. Example, name the tab "John Doe"
his name is located in cell b2. each time I change the
value in b2, the name of the tab will change accordingly.
In the worksheet's module (right-click the sheet's tab | View Code), paste
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Intersect(Target, Range("B2")) Is Nothing Then
Me.Name = Target.Value
"donovan" <anonymous@discussions...Sort a 'Protected' sheet
Using Excel 2002, when I try to sort a protected sheet with a macro, I get a
dialog box with 'Run time error 1004'. I allowed sorting when I set up the
macro. Do I need to 'unprotect' the sheet with the macro and then 'protect'
it again after the macro does its sorting? Any suggestions?
As ALWAYS, post your coding efforts for comments
Don Guillett Excel MVP
"Barney" <email@example.com> wrote in message
> Using Excel ...Tax Collected Question
Is there a report to run that will show the tax that has been paid by the
customer and not on the tax that was collected via a tender? Or is there a
report to run that shows invoices have been paid by check, credit card, or
cash that leaves out those tendered to account?
We would like to be able to pay taxes on what has been paid to us and not
what we are waiting on for payment.
hi send me your email I will forward you some interesting reports for your
> Is there a report to run that will show the tax that has been paid by the
> custome...Questions regarding Data center operation
I have over 8 years of IT experience but very new to the Data Center
space and have 4 questions. If someone can answer, I would really
You can consider these questions more of a brainstorming ideas.
1. If a facilities capacity is re-classified as 5 MW lower than it was
previously, what needs to happen here?
2. We need to expand Network capacity at a facility by 2 times but for
only 20% more money, how can we do it?
3. Where to start if you are responsible for tech refresh in existing
4. During tech refresh planning you find out about a delay in delivery...Excel 2003 Worksheet formatting questions
I have created a simple income daysheet for my medical practice. The idea is
for all money collected and received in a day to be inputted in that day's
day sheet along with the source of the money, why it was received and if
there is a check or statement number associated with the payemnt for it to be
My questions are:
1. Column A is for date - I want to automatically enter the current date in
each cell in column A. So when a new payment is being entered the current
date is automatically entered for the payment clerk. I can get the date in 1
cell using the date functio...question about ICON of frame display?
i use a customized icon for my app. and everthing is ok except that display
in caption bar. i mean that it can be displayed in task bar, but for
caption bar, it always is substituted by default app icon. so, how to
display the customized icon in caption bar just like display in task bar.
ps: there are 3 formats of size images in the customized icon, they are
16*16, 32*32, 48*48. and they are all true color.
| winsays@:-)hotmail:-).com |
Did you create both a 32x32 and 16...Showing argument descriptions as an XLL worksheet function is type
Apologies if this is wrong newsgroup, I wasn't sure if this or
microsoft.public.excel.sdk is better.
We're developing a set of XLL worksheet functions that have 5-8 difficult to
While the argument descriptions passed to the registration function display
properly in the function wizard, they do not appear in the common case of
typing the function in the formula bar.
In addition, I have these related (but lesser) concerns:
- My worksheet function description does not appear when my function
name is being typed in the Formula Bar.