no update avail for ofc2k3 sp3 on windows 7 ?
windows 7 update find any security update for small business office 2k3 with
is this unseal?
Could you re-write your message in Standard English so that German Swines
can understand you. These groups are read by people for whom English is a
second or even third language. They only understand Standard English or
what we call Queens English!
"GS" <gsmsnews.microsoft.comGS@msnews.Nomail.com> wrote in message
> windows 7 update find any security update for small business office...Error deleting record
I have a form and subform combination for entering two related records, an
Inventory item Master definition and an Inventory item sub definition. The
master information is on the main form and the sub definition is on the
subform. I have coded logic to delete the master record that is
automatically written by Access when the user tabs from the main form into
the subform IN THE EVENT that the user enters no information into the subform
and exits from/closes the main form using the exit button I've provided.
When I test this code, I get error 2046 "The command or action
acCmd...colour cells using VBA
New to VBA so apologies in advance if a dumb question!
I have managed to get to the following which is working well but I now want
corresponding cells in the "k" column to change to specific colours based on
the data in "I" and "J" columns and seem to have put myself in a corner -
what os the best way to write such a request please?
'Convert to FMECA format, and set matrix row
If consequence = "A - Almost Certain" Or LCase(consequence) = "a" Or
LCase(consequence) = "a" Or LCase(consequence) = "...Runtime error while using excel help
I get the below error message
"A Runtime Error has occured.
Do you wish to debug?
Error: Object doesn't support this property or method"
This message comes up when I'm using Excel 2002 help.
However, the message only comes up when I click on the See
Also link. To see this link, type in "LEFT worksheet
function" under type keywords in help and click search.
Any help would be appreciated in trying to solve this.
...Using a text box to enter in a password.
I have created a login form for our users to enter their user ID and
password into two text boxes. The first text box, the users enter in
their employee ID, which is alpha-numeric, and the second text box is
where the user enters in their password, using the input mask of
I am seeing odd behavior in the password section of my form. If a user
has a passowrd called "MYpassword", any leading capitals will be
converted to lowercase and will read "Mypassword". We have had our
users choose another password without any leading capital letters
after...creating and using cell references
I create 2 cell references using ADDRESS() in a column.
How do I use these created cell references to sum the
Appreciate your help. joeZy
Here's an example:
Excel Support Technician
Every member of the CanHelpYou team holds at least a
Microsoft Level 1 Excel certification. In addition, we
have experts in PowerPoint, Word and other products such
as IIS, SQL Server 2000, network connectivity.
>I c...Interrupting long calculations in Excel? Hi all, I am having a very long calculation in Excel using VBA. Of course I know I can hit ESC or CTRL+BREAK to interrupt the VBA program. But I found du
Interrupting long calculations in Excel?
I am having a very long calculation in Excel using VBA.
Of course I know I can hit ESC or CTRL+BREAK to interrupt the VBA
But I found due to too long running process, the Excel window stop to
respond for very long time,
besically it's like "not responding" situation with "not responding"
on the windows title bar...
It doesn't seem to accept any more key strokes, not to say ESC or CTRL
What can I do to rein/stop my program?
Try this to speed up execution
Application.ScreenUpdating = FA...Which Icon should I use?
I want to know what is the dimension and the number of colors of the following icons.
1. Icon shown in the task bar
2. Icon shown in the title bar
3. Icon shown in the Explorer
My C++ and C# ( Traditional Chinese ) Web Site : www.franzwong.com/Home.php
These icons are created for you (IDR_MAINFRAME) by the app wizard. You will
find two sizes of these in resource editor(32x32 and 16x16). I have never
investigated other sizes but I gather that would be OK but MFC may not like
As far as colors are concerened, its number is limited by resource editor
capability. You can use...Using value from 2 tables to fill a cell
Any help would be appreciated, Thanks
I need to know the formula (without using VB) to have the Denta
Premium and Extended Health Premium taking from two charts/tables (
can put these on the same worksheet or different worksheet within th
same workbook, I have no preference)
For example below:
I enter the name (Test in example), Plan (AA in example), and statu
(Family in example). I would like a formula that would fill in th
Dental Premium and Extended Health Premium from the following tw
Dental Premium $47.00
Extended Health Premi...Quantity Requisitioned: where used?
In "Cards > Inventory > Vendor" I see there is a field called
"Requisitioned". I also see a field called "Requisitioned" in "Cards >
Inventory > Quantities/Sites".
If in "Cards > Inventory > Vendor" I enter a quantity of 25 Requisitioned
for an Assigned Vendor ID and close that window. Then I then go to "Cards >
Inventory > Quantities/Sites", select an Assigned Site, I notice that I can
also enter a different quantity for Requisitioned (like 75). In this case, I
see that 75 will be displayed in &q...UML use case text not wrapping
Has anybody find an answer to the problem of the text not wrapping ?
I saw several posts, but no answers, is the answer to obvious to post?
The word "connection" becomes
Not pretty. I cant show this to my team of programmers...Changing the
protection to allow "width and height" changes, does nothing. There
seems to be noway to resize these animals!
You can unprotect the shape and chane the size of the shape, text box or
Protection is on the Format menu, you may have to open the shapesheet for
other protection settings.
John... Visio MVP
Ne...Using XML to serialize a SQL Query
Let me state up front that I know very little about XML. My experience is
pretty much limited using the XML Serializer to serialize a user preferences
class to a file and back again.
I'm writing a rules engine for an application that basically involves
allowing the user to enter the the WHERE clause for a SQL Server query that
becomes the rule. The rules will be stored in a SQL Server database and the
user will be able to make changes to the rules. The rules are entered through
a non-freeform interface, so I don't have to try and parse the rule after the
user enters it. However...Using A Find Result in a Range
I'm trying to search for a word on a spreadsheet, in this case the word
"Label." I then want to copy everything from A1 to the row above that word
"Label" and paste it to a new spreadsheet. I've got everything worked out
except how to use the Find Result address in a new range. I'm sure it's
simple, so simple I can't find it in any tutorial. Currently I have to look
in each spreadsheet for the last row of the range I want to copy and type the
copy range manually into the code for each of the multiple spec sheet
spreadsheets I'm att...Is there a free toolbar button library available anywhere
I am looking for a cataloged of typically 15x16 images for use on
Does a free public collection of these exist?
http://www.glyfx.com/ has free icon set for basic commands. There are quite
a lot of free icons libraries in Inet, but none of them provide professional
looking icons for serious applications. If you are looking for various
'childish' (imho) icons, check these:
For business use, y...SaveAs using two cells for filename
I'm trying to save a file with two cells of data to create the filename. Here
is the code:
fname = .Worksheets(1).Range("B4").Value & .Range("E6") & ".xls"
I'm getting stopped on the fname line. I don't think I have the combination
right. Can you help?
Dim fname as String
fname = .Range("B4").Value & .Range("E6") & ".xls"
You missed the .worksheets(1) in front of E6.
Any chance that one...After using MAPI function in Outlook 2003, Can No Longer Retrieve Mail using Outlook
I am using Outlook 2003 with the Outlook Connector 12.0.6407.1000 to
retrieve my Windows Live Hotmail mail. It has worked fine. However, I lost
my ability to retrieve my WL Hotmail with Outlook ever since, about five
days ago, I used Word 2007 and the MAPI function to try to send a document
That MAPI-sent document got stuck in Outlook's outbox (I just found out). I
have since removed it from Outlook's outbox.
Since that time, I cannot retrieve mail from WL Hotmail using Outlook. I
get this error message:
Time: 11/19/2008 10:45:38 PM
Erro...Memory use for int, long, etc
I have to load some 400,000 (perhaps upto 1,200,000) numbers in memory,
none of them larger than 100. I am looking for ways to reduce the
If I store each as an int, would i use 400,000 bytes of physical mem?
If I store four numbers per long, would i use 100,000 bytes of physical
In other words, what is the most efficient of storing the lot?
> I have to load some 400,000 (perhaps upto 1,200,000) numbers in memory,
> none of them larger than 100. I am looking for ways to reduce the
> memory load.
> If I store each as an int,...Passing parameters using URL in isv.config.xml
I am trying to pass parameters using isv.config.xml's URL and receive
parameters in asp.
I have set the passparams="1" and winmode="0", since I want to open up
Using winmode="1" or "2", I am able to get the guid using windows
dialog arguments, thats not
which will not work on posbacks.
I am having trouble how to pass parameters dynamically using
Part of the isvconfig script:
<Entity name="new_entity"> <Grid> <MenuBar> ...Email report in PDF Format using a Macro
Using a macro I can generate and export files in pdf format. Then I have to
create an email, attach the report and send. Is there a way to email a report
in pdf format directly from Access utilizing a macro?
I don't have an answer for you but a question. I am trying to do what you
have accomplised but don't know how.
> Using a macro I can generate and export files in pdf format. Then I have to
> create an email, attach the report and send. Is there a way to email a report
> in pdf format directly from Access utilizing a macro?
Once ...Forms Buttons for use with macro
Bear with me - haven't been on newsgroups in a while.
Win 2003 XP
Colleague is putting buttons (with macros) into a spreadsheet but would
like to color them. I can't see where you could.
Or can they?
Tell your colleague to use the command button from the Control toolbox toolbar.
Rightclick on it in design mode and show its properties. Change the .backcolor.
Or tell him/her to use a shape from the drawing toolbar and color it anyway
"Ms. Tude" wrote:
> Bear with me - haven't been on newsgroups in a while.
> Win 2003 XP
...how to calculate billable rate using base rate and percentage
I have a billable rate of $70 with a mark up percentage of 17.65%. How do I
calculate the base rate?
70/1.1765 = 59.5
Please click "yes" if this post helped you!
"Felicia Pickett" wrote:
> I have a billable rate of $70 with a mark up percentage of 17.65%. How do I
> calculate the base rate?
"Felicia Pickett" <FeliciaPickett@discussions.microsoft.com> wrote in
message news:FB923CF3-3657-4D7C-8...Help with Formula using Analysis ToolPack Function ISODD #4
Thank you for all your time and help: the formula works perfectly.
Peo Sjoblom Wrote:
> This works for me
> copied down, if you copy accross replace
> ROW(1:1) with COLUMN(A:A)
> Peo Sjoblom
> "Tin�" <Tin.email@example.com> wrote in message
> > Hi Peo,
> > Thank you for assistance. The formula is fine - but is there a wa
> > can avoid manually changing t...What if scenarios using multiple worksheets
Is it possible to have scenarios in XL 2003 across 2 or more worksheets?
Which means, for example, I had some chaging cells in one sheet other cells
in another worksheet and the result in the first one.
I have tried lately but I got an error message. The same problem I have
encountered with the Solver.
How could I overcome this issue?
Thanks in advance,
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
...Contacts not available when making new email
I have 2 computers on a home network. I can get Outlook to work on both of
them (not at the same time) but on one of them the contact list is not
available when I am making a new email. (On the other computer when I make a
new email I can click on the "TO" button and a list of my contacts comes up
for me to select from). It is really handy and I would like it to do the same
on my other computer.
Thanks so much in advance for your help.
Lynn Scott <LynnScott@discussions.microsoft.com> wrote:
> I have 2 computers on a home network. I can get Outlook to ...IT Architecture-2 days hands-on workshop-Group Discounts Available
Realizing Practical vision of the IT systems with Enterprise
Architecture, SOA & MDA.
This is a 2 - day workshop conducted in Seven major cities in India
Architect & C E O, iCMG Mr. Sunil Dutt Jha.
Mumbai(22-23 Dec'08) Bangalore (29-30 Dec'08) Pune (19-20 Jan'09)
Chennai (22- 23 Jan '09)
Hyderabad(27 - 28 Jan '09) Delhi (09 - 10 Feb '09) & Kolkata
As an architecture coach/mentor, have taught enterprise & software
architecture classes to
over 5,000 professionals (cumulative) across the Globe.
It benefits one who want to learn how peer...