Insert a Row
How do you insert a new row imbetween rows
without bringing down the Color of the above
It always happen's
Any suggestions would be appreciated.
The only thing would possibly be a Macro with cleanup
I found a solution.
Copy a Blank row,
Then use copy insert
I would welcome other solutions
Tools>Options>Edit. Uncheck "extend data range formats and formulas"
Gord Dibben MS Excel MVP
On 6 Jan 2007 07:07:00 -0800, "smandula" <email@example.com> wrote:
>I found a solution.
>Copy a Blank row,
>Then use copy inse...Removing Display of cost fields
We use manufacturing and SOP.
I have a request by the owner to remove the display of the current and
standard cost fields for all but a select few users. The users would still
need to be able to see the price lists.
Is this possible?
You could use Modifier to create copies of the existing forms, hide
the cost fields, and grant security to the modified forms to the users
you don't want viewing the cost data. Grant security to the
unmodified forms to those users you do want to see the cost data. It
would be nice if you could do this in Field Level Security but
unfortun...Zero Placeholders in number cell
Hi: Is it possible to have zero (0) placeholders in an excel 2003 cell. For
example I have a column with number cells which calculate sequentially. I
have a need for the first and subsequent numbers to have four digits (ex.
0001, 0002 etc.). The zero's of course do not show when they are entered.
Is there a way to do this and still have it calculate??? Thanks in advance.
It's called leading zeroes. See:
"B. Parizo" <BPariz...Number of licenses
Does anyone know on how many computers I am allowed to
install one copy of Money 2005 Deluxe? For instance, in
my family we have three computers and I would like to
install it on all of them. Is this allowed with the
license? What is the limit? Thanks!
In microsoft.public.money, Jesse wrote:
>Does anyone know on how many computers I am allowed to
>install one copy of Money 2005 Deluxe? For instance, in
>my family we have three computers and I would like to
>install it on all of them. Is this allowed with the
>license? What is the limit?
In Money, look at Help-&...Insert Into works... how about Remove From?
I know the command "CurrentDb.Execute "INSERT INTO [Input] ([Loc_Desc])
VALUES (""" & Me.List12 & """)", dbFailOnError" works. I now need a way to
delete a value from a table using a similar command. I am wandering if there
is a "REMOVE FROM" or something similar that will take an option from List12
out of a Table named "Input". Thanks again for your help!
Message posted via AccessMonster.com
You can DELETE a record (or many records if t...Negative Number Formats
Can anyone help? I have Excel 2003 and despite setting=20
all regional options correctly and specifying number=20
formats as (99), (=A399) etc I still can't get Excel to=20
display them in parentheses. I seem to remember from=20
Excel XP that you have to install/uninstall=20
certain "foreign" language options but can't remember=20
what. Please e-mail if you have the key!
I'd double check that windows setting:
Windows Start button|settings|control panel|Regional Settings
Currency Tab|Negative Number Format
(that was the path I used in Win98.)
Paul Handley wro...Odd Looking Number
I am using a spreadsheet in Excel 2002 on Windows XP, for some reason the
account numbers (which someone input, along with addresses) have a little
green mark in the corner of the cell. I thought it was to show that there is
a comment, but it is not. When you click on the cell, a little warning sign
shows, saying ERROR - number in this cell formatted as text or preceded by an
apostrophe. When I click on the arrow by the warning sign, it says
Number stored as text
Convert to number
Edit in formula bar
Error checking options
Show formula in audinting toolbar
Now I l...Matrix fields
We only need one matrix field - size. Is there any way to get rid of the
other two so that the item number does not include the extra 0101. Example,
item number is 1234. RMS automatically crestes the numbers as 1234010101.
Would be much easier if the item would just be 123401.
I just installed Office mac 2004 student teacher edition on my brand new MacBook. I can't seem to use equation editor. Since I am a math teacher, that sucks - to say the least! Error message says somethng like - make sure it has been installed, or maybe it has been renamed etc. All I did was install. Short of using my 2nd product key to fix the problem what can I check. Find brings up no info on equation editor.
I don't think Eq Ed is automatically installed with a standard installation
of Office 2004 - it needs to be included in a custom install or added later.
You can install it no...2 variables in 2 quadratic equations in excel
Dear ms excel user/programmers:
I hope this question is not repeated before. But anyway
highly appreciate anyone can tell me how (or hint) to use ms excell
and/or visual c/c++, basic, or octave(emulate matlab) to solve:
(12-x)^2 + y^2 =15^2,
(by programming or using its built in function)?
that ^2 mean square.
looking to any excel user, mathmatician, and/or programmer's help,
The brute force way (requiring the least mathematical analysis) is to
calculate the left hand side as functions of two reasonable first guess x
and y inputs...HELP!! Trying to convert numbers.
Here is my problem.
i have a series of 3 digit numbers that
need to be cinverted to a series of 4 digit
numbers using this following
722 needs to read as 5622 and in the next collum SV-7822
in the collum's to the right.
what type of formula is this and how can i do it?
The above is an example, i have a whole range of 3 digit numbers
that need the exact. rules applied to all numbers.
which is why i need a formula to do it.
Help someone please!!!!
I'm not completely clear on what your looking for but if 722 was in A1
in B1: = A1 + 4900
in B2: = ="SV-" & A1 + 7100...What is the max number of...
What is the max number of records that can be put into a table in Microsoft
Access? Does it vary from version to version? Thanks in advance.
"Mike C" <MikeC@discussions.microsoft.com> wrote in message
> What is the max number of records that can be put into a table in
> Access? Does it vary from version to version? Thanks in advance.
Google or the online help would be your friend on this one. There's no
fixed limit, there's only the limit on the overall size of the database
file...Insert Picture and resize
I am a bit of a newbie when it comes to VBA programming, but I try.
I am trying to find a way to resize a JPG picture when I insert on to a
cell. I have created an XL sheet with some VB to insert a whole lot of
pictures down a column, to fix on a temporary basis I resized all my
pictures. But in the future that may be difficult to do.
So what I want to do is work out the size "x" & "y" and then somehow scale
the picture down to a standard size. I have the inserting and moving down
the sheet worked out.
Thanks for reading and even more thanks if you can help
Rega...error RC2144 : PRIMARY LANGUAGE ID not a number
When I build a project in VC6, I got errors below:
D:\Program\XXXX.rc (25): error RC2144 : PRIMARY LANGUAGE ID not a number
D:\Program\XXXX.rc (34): error RC2135 : file not found: 653
The project could be built successfully before I re-install my VC6.
What's the matter with my VC6? Or is there any wrong with my setting?
Why do you assume that VC6 is wrong?
What does line 25 in XXXX.rc say?
http://www.apptranslator.com - Localization tool for your MFC applications
"Chen" <firstname.lastname@example.org> wrote in message
news:eyuxKoDXJHA.1532@TK2MSFTNGP03.phx.gbl...MS Word equation editor won't open when double-clicking on an equation
Operating System: Mac OS X 10.6 (Snow Leopard)
I created a document (.docx) using the Office 2008 version of MS Word some time ago (2 months or so). Recently I wanted to correct an equation in that document and re-opened the document (on the same system and with the "same" copy of Word) and attempted to double-click the equation to edit it. Instead of the equation editor I get the "Format Picture" dialog box. In the interim I did install an update (I tend to try to stay up to date) and am at 12.2.4 (100205). <br><...Linear trendline:wrong equation
I created a bar chart in Excel from the following data:
The SLOPE and the INTERCEPT functions returned -0.136 and 16.4448
respectively. The resulting equation is Y = -0.136X + 16.448 which seems good
enough to me.
Then I added a linear trendline to the chart. Excel displayed the following
equation: Y = -0.9X + 7.5, R ^2 =1 which is way off (and it's not a rounding
The data seemed farly linear to me, how come Excel can't come up with the
Use an "XY (Scatter)" chart.
When you...how to draw a number with DrawString?
In GDI+, this works fine:
WCHAR* labelSouth( L"�S");
g.DrawString( labelSouth, -1, &latLabelFont, pointF, &latLabelBrush);
but I cannot get it to draw an int or double. What I need is this
WCHAR* labelSouth( // missing conversion from int to WCHAR* here
g.DrawString( labelSouth, -1, &latLabelFont, pointF, &latLabelBrush);
I tried various things but I can't figure it out. I'm sure I'm missing
Thanks for any suggestion.
Use swprintf Function to format string and use this string=20
into DrawString Fun...Insert pictures from the Internet
How can I insert pictures from the Internet into my brochure or leaflet?
Right-click the image, copy, paste into Publisher. Or save the image and insert into
If your cache is full, you will not be able to copy from the Internet, in IE, tools,
Internet Options, delete files.
Mary Sauer MS MVP
"Suzanne" <email@example.com> wrote in message
> How can I insert pictures from the Internet into my brochure...Insert picture from file default view
Looking for a way to change the default "Insert Picture
From File" view. Currently, when I click on the IPFF
icon, the view is in "thumbnail" form. Is there a way of
changing this to default to "list" format? The thumbnails
take quite a long time to load when there are numerous
pics in that file.
...Use VBA to Autopopulate a date field
I have a form which contains a field called IncidentAmendDate. I would like
that field to automatically be populated with the current date whenever a
change is made to the record.
I made a few attempts to write this in VBA myself, but experienced problems;
Private Sub Form_AfterUpdate
Me.IncidentAmendDate = Date
Whilst the above procedure gets the system date and populates the field on
the form, I then cannot move from the record or save the information. I tried
something similar to populate the underlying table instead, but had a problem;
Private ...serial number #2
I need to delet hundereds of old sold serial number because I need to shrink
my DB. Is there way I can get
script ? All the serials are under one item.
Harjit SherGill /DBA
324 South Main st po box 370
Altaville CA 95221
Tel : 209-729-1410
Hi Gill - first confirm your item id by typing your serial item
itemlookupcode in XXX below (keep the single quotes)
select id from item where itemlookupcode = 'XXX'
-- confirm and jot down the id assigned to the item - let's say its ID is123
The status field gets flagged with a &quo...Setting the focus to a field on a subform within a tab control
I have a form called frmMain with a tab control called TabCtl0 and a subform
within the tab control called frmScreening. I would like to set the focus to
a field called txtserial when a new record is added. I have tried the
following 2 lines, but neither work:
Would you know the proper syntax. Thanks.
>I have a form called frmMain with a tab control called TabCtl0 and a subform
>within the tab control called frmScreening. I would like to set the ...Want the customer Number.
I have added a hook when adding new customers. I want to get the customer
number when I save the customer. My code is as follows:-
Public Function Process(mySession As QSRules.SessionClass) As Boolean
Dim StrSql As String
Dim ConConnection As New ADODB.Connection
Dim rstRecordSet As New ADODB.Recordset
Dim QsCustomer1 As QSRules.Customer
'Need to populate referralcode and age group
MsgBox mySession.Transaction.Customer.AccountNumber, vbInformation, "test"
Process = True
When I run the function the customer.accountnumber is blank and
customer.loaded returns...Trendline equation not giving correct results
I was trying to form a trendline with following data :
After plotting the chart, I added trendline (Polynominal
with order 6) alongwith its equation which read as below :
y = 6E-07x6 - 3E-05x5 + 0.0006x4 - 0.0057x3 + 0.0215x2 -
0.0318x + 1.1429 and R2 = 0.9998
The trendline in the chart neatly fitted over the curve.
However, when I used above equation and fed in same values
of X as shown above the computed results are entirley
different fro...Look-up number in one sheet
I am back with yet another question. I have two sheets in my exce
file. The first contains a ToC (Column A). After each heading, I lis
1-9 numbers each in a column by itself.
1 Introduction 34 31 425 213 54
1.2 NNNNNN 23 32 51 21 214 341