Can you insert a picture into a specific cell?
Or do they only "float" on the page.
They float over the worksheet, but you can adjust the size so that it seems to
fit a cell exactly.
If you insert a picture, you can hold the alt-key down while you move/resize the
picture. When it gets close to the edge of a cell, it'll snap-to that edge.
> Or do they only "float" on the page.
...Business Portal Error-SQL server does not exist or access denied
We are running business portal 4.0 for one of our customer. It was running
correctly, however, they have changed the SQL server port (previously it was
set as default 1433). After that the business portal becomes very slow and
while creating a new request (purchase requisition) if we open the item pop
up; it is showing exception
"SQL Server does not exist or access denied...."
Can any body tell me how can I provide the new port number to business
portal connection to the database.
Thanks and Regards,
Thanks for using the newsgroups. I have a...Can't insert Char(1) into SQL Server from Stored Procedure
I am trying to insert a char(1) field into a table from an ASP.Net/C#
At first I was inserting rows into the table but none of the columns that I
was inserting the rows into were char(1) columns, they were mostly int and
Then I found out that there was one column in the list that was not supposed
to be an int column but instead it was supposed to be one of the char(1)
columns into the table.
So I replaced the int column in the list with the char(1) column and since
the value of the char(1) column resulted from a CheckBox ('Y...Summing Alternate Rows
We have spreadsheets with many rows and need to sum alternate rows. Is
there a way to do this without entering a formula using the number of
KarenQ's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=19608
View this thread: http://www.excelforum.com/showthread.php?threadid=395115
That formula sums odd-row values in the range A1:A18.
To sum even-row values the formula is:
I trying to retrieve values from a table to calculate the 14days average
value of a stock closing price. However, i encounter some problem as stated
beside the code as follows:
'Calculate the average value of a given value.
Dim db As DAO.Database
Dim rst As DAO.Recordset
Dim varBookmark As Variant
Dim numAve, numDaysAvg As Double
Dim intA, intB, lngCount As Integer
Set db = CurrentDb
Set rst = db.OpenRecordset("SGX Individual Historical", dbOpenTable)
Do While Not rst.EOF
intA = 1
intB = 0
varBookmark = rst.Bookmark
n...crm 3.0 error 03-01-06
I'me getting this error while installing crm3.0 for SBS:
"error writing to file microsoft.mshtml.dll verify that you have access to
That file is in the C:\Program Files\Microsoft.NET\Primary Interop
I (and 'everyone') has full access to that dir.
What can I do about this??
...Global Column Row Preview Font Size
I know I can change the column, row and preview font size for the current
email folder's view, but how do I do it for all of the email folders? I have
loads of email addresses each with lots of folders. I don't want to have to
do each one at a time. Surely there must be a default font setting (even if
it's only in the registry)?
Thanks in advance,
I too would love an answer to this.
"Timie Milie" <firstname.lastname@example.org> wrote in message
>I know I can change the column, row and preview font ...IsOutLookClient() returns wrong value
IsOutLookClient() returns wrong value when both web client of crm and outlook
client are running on the same workstation
It looks like the same cookie(used for determining what client is running)
is used by the sessions of each client.
Look for "LightClient" in IsOutlookWorkstationClient() in global.js
Oeps...I seem to have made a wrong assumption...
Between the to clients IsOutlookClient() seems to work ok...
But in outlook client the IsOutlookClient() function gives false for
me...after I have opened a page from the Microsoft Crm folder structure...
On another workstation it...Error in Outlook Today
Whenever I go to Outlook Today, I get a runtime error,
line: 297 Error: Class Not Registered. Then I get the
error two more times when I click 'Customize Outlook
Today...' and the list 'Show Outlook Today In This Style'
is empty, and the box under it has a broken image icon.
What could be the cause of this?
Sorry...forgot to say...I'm using Outlook 2003 Student
and Teacher Edition on Windows XP.
>Whenever I go to Outlook Today, I get a runtime error,
>line: 297 Error: Class Not Registered. Then I get the
>error two more time...changing values of one field based on another
How can I best change the values of one field in a table based on
values of another field of the same table. We have an existing table
of thousands of entries and I would like to use the following logic to
populate a new boolean field.
If field1 = "Done" Then BooleanFieldCompleted = True
I have some Excel VBA experience but limited Access. I dont want to
do this manually! Any assistance appreciated.
In general, you'd use an Update query. However, in this case I don't see why
you'd need such a field.
Why not just create a query with a computed field that returns True...Re: 'Uknown Error 0x800CCC97'
I just heard back from the folks with whom I filed this bug. They say the
bug is fixed in cppop 5.4 - request that your ISP upgrade to that.
This posting is provided "AS IS" with no warranties, and confers no rights
"Jeff Stephenson [MSFT]" <email@example.com> wrote in message
> See the attached reply to another similar question. Your ISP's POP3
> has a bug, and they should get a fixed version of the server.
> Jeff Stephenson
> Outlook Development
> This posting...stop error defeating me
XP Pro PC. When I start the computer I can start in safe mode but when I try
to start in normal mode it loads to the log on screen. I type the username
and password in then it starts to load but stops after a few moments with a
blue screen. The error is Stop: c000021a (fatal system error)
The windows subsystem system process terminated unexpectedly with a status
of 0xc0000005 (0x7c9106c3 0x0055f36c).
Begininning dump of physical memory.
I have uninstalled AVG, also taken out the graphics card and uninstalled all
the drivers for it. I have also changed the RAM. I have also d...Error in database....
A user posted a batch in payables management. After posting, there was an
error encountered. It displays that the table updating was interrupted, use
batch recovery to continue the posting. But when I used the batch recovery,
it was not successful to continue the update process. When I click the "More
Details" button it displays, A save operation on table 'PM_Transaction_WORK'
caused a sharing error.
How can I resolve this issue?
John, it is a db sharing violation.
Have all users logout
DELETE dynami...Shortcut for inserting names?
I am building many formulas, each with many named cells as part of it.
Currently I have to go to Insert | Name | Paste with the mouse each time I
want to insert a name. I looked in Walkenbach's Excel Bible but couldn't
find any mention of a keyboard shortcut or other shortcut. Is there one I
could take advantage of?
I've got Excel 2002.
...How to add a button to restore all altered cells original values?
I want to add a reset button to an excel spreadsheet that will restore the
values of all changed cells to the original saved ones.
Any help would be appreciated.
this would require quite some VBA code as you somehow have to store the
original values for example on a separate hidden sheet
"Dawnybros" <Dawnybros@discussions.microsoft.com> schrieb im
> I want to add a reset button to an excel spreadsheet that will
> values of all ...How do I insert space between 2 consecutive columns of an XL Shee.
I want to have space between two consecutive columns of a worksheet (of
course, without having inserted another column between the two) in order to
have separated the Border Lines of the adjacent cells/columns. Please guide
me if it can be done in XL.
Can you achieve the effect that you're looking for by using a double
vertical border down the right side of the left column and having no
border down the left side of the right column?
"Shamshad Butt" <Shamshad Butt@discussions.microsoft.com> wrote in
message news:1222EE13-11A9-4354-9F12-D1F1155D3902@microsof...error 553
The following error occurs when sending email from my
business domain. It does not occur when sending through
my roadrunner account.
The following recipient(s) could not be reached:
on 10/22/2003 2:05 PM
553 sorry, that domain isn't in my list of
allowed rcpthosts (#5.7.1)
What does this mean and how can it be fixed?
...80070005 error #2
I am getting this error when trying to view public folder
property from system manager. My issue is same as what
you can find out from
Anyone has a clue?
...How do I convert a concatenated value into a know value
I am trying to get the results of a multiple input table, which get
concatenated, read out as usable values
eg. If the concatenated values are for example *llbbt* , I need this t
be read as Simon, or *lbttd* must result in Fred etc...
I will attact the spreadsheet.
Attachment filename: book3.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=54116
Message posted from http://www.ExcelForum.com
You are probably better off by describing your problem, most regulars won't
Peo Sjoblo...Value is BLANK
In a form i'm working on i've asked this question before and i'm unable to
locate the replies, but in one cell I have a date to be enter and in the
other cell it takes that date and add 5 days to the date to give me a due
date. But if no date is enter then I want to to remain blank insted giving me
Say that the date is to be entered into A1, then enter this formula into the
Please keep all correspondence within the Group, so all may benefit!
==================...Adding blank "separator" Rows in a Pivot Table
Does anyone know how to insert blank rows into a pivot table (say,
between groupings, etc.)? There has to be a way, since some of the
various table formats that come with Excel include blank rows.
Double-click the field button that you want to format
Add a checkmark to Insert blank line after each item
Click OK, twice
> Does anyone know how to insert blank rows into a pivot table (say,
> between groupings, etc.)? There has to be a way, since some of the
> various table formats that come with Excel include blank rows.
http...Null value in form not trapped by beforeupdate event
I have a form in Access 2003 linked to a SQL Server 2005 table. When
I clear the value in a textbox (bound field is varchar and is
required), I want the before update event to run to tell the user the
value cannot be null.
When I press the tab button to move to the next field after clearing
the texbox, the before update event is not triggering and instead I'm
getting the following error:
You tried to assign the Null value to a variable that is not a Variant
data type. (Error 3162)
How can I prevent nulls before and this error from triggering?
...How to place a stable title row?
For a scientific analyse I need to create an Excel table with more than
1.000 rows content. Now, how can I create a title row that doesn't scroll
with the rest of the content, so one that is always visible at the top, while
you scroll up and down the rest of the content.
I hope that's possible like this! Otherwise, it will be pretty difficult to
enter the data into the correct (of about 15) column.
Thanks for your help in advance!
Assuming headers are in row1,
Select A2. Click Window > Freeze pane
This freezes the 1st row, so it always remains in view
w...copy values generated by conditional formula in one sheet to the other work sheet as values
I have data generated by conditional formulae in work sheet1 in
columns A to J. If the condition is satisfied the cell will display a
realnumber, if the condition doesn't satisfied the cell will display
Now I wanted to copy the cells which have the real numbers in
sheet1 to sheet2 as values(as we do with paste special and paste the
values) Do we have any formula or other method to copy the cells in
sheet1 to sheet2. can anybody helpme out in this issue.
Thanks and Regards
Select your range to copy
edit|goto|special|c...y value vs x
In an xy scatter plot one can choose the type of line connecting the data
points (smooth, straight, etc.). Once this is done, Is there a simple way of
determining the y value of graph for a specific x value without doing
successive approximations with 0 shifts. I'd rather not purchase a graphing
program just for this simple task.
You could find an equation that fits the data (see trendline)
Bernard V Liengme
remove caps from email
"ralph" <firstname.lastname@example.org> wrote in message