How do I represent data in a cell as hexadecimal without converti.
I have a worksheet with hexadecimal data. I am trying to create a chart but
the chart will not interpret hex numbers correctly. I know I can convert to
decimal and do it that way. Is there a way I can tell Excel that the numbers
in the cells are hex and have it plot it correctly?
AFAIK you have to convert them first to numerics before plotting them
> I have a worksheet with hexadecimal data. I am trying to create a
> chart but the chart will not interpret hex numbers correctly. I know
> I can convert to decimal and do ...cancel parameter without error?
I cannot suppress the 2501 error message when cancelling the parameter input.
Here is my code:
Private Sub Command88_Click()
On Error GoTo Err_Command88_Click
Dim stDocName As String
stDocName = "rptPrint_F_RecRpt_TransCksSingleCk"
DoCmd.OpenReport stDocName, acViewPreview, , , acWindowNormal
If Err.Number = 2501 Then
Else: MsgBox Err.Description
What is the recordsouce for the report? Is it a sav...Excel Line Feed Character
imported Text in cells are formatted with 3 line feed characters. If you
use clean it deletes the characters
and puts the text into one line. I need to be able to delete the Chr(10)
and keep the formatting by a macro if possible.
This file is needed to be uploaded into SAP which doesn't like CHR(10).
Presently the only way to do this is to go to the end of each line and
manually delete the three CHR(10) and all works well as
the formatting stays the same.
I have tried Substitute and Find and replace but it always ends up in single
Hope someone can help....
...Document library without top link bar and quick launch menu: how?
is it possible to create a link to a document library that is going to
show just the document library without the "master page" border???
I mean without quick launch menu and top link bar.....
I'm working with MOSS 2007 and 2010 beta...
any suggestion will be good ;)
Using SharePoint Designer you can attach a specific master page to it and
disable the navigation elements you don't want. Be advised, however, that
you now will be taking your users to a place they can't navigate out of.
Would you be better served placing a list v...Can I automatically resize all controls in a Dialog without adding user codes
Can I design a Dialog that automatically resizes all controls when the
Dialog is being resized?
Yes. You can resize or move them as you wish by handling OnSize of the
dialog. SetWindowPos can be used to change the size and/or position.
Here is a helpful link:
No. You must explicitly take action on the OnSize handler to resize them. Sometimes,
there are packages called "geometry managers" that make this fairly straightforward (check
www.codeproject.com and www.codeguru.com for examples)...Help with tracking user without enforcing security
I know that the best way to track who is in the db is to enforce security.
However, I am in a situation where the client does not want the security to
be enforced at least right now. since we will have to keep another file
(.mdw) on the network. Is there a way to track few users (5 max) in access
through code? I have a login form that has 2 text boxes, one for the user ID
and the other for the password. I have a table called tblUserLog that every
time a user logsin, a new record is created in that table keeping the login
ID and date/time. The login form fires the code in the after updat...Can we use ReportServerCredentials without passing domain name
I am using ReportingService2005 web service through my asp.net application.
It is running fine at my machine but when using this web service through
remote server it is giving error "An error has occurred during report
processing. The data source 'Live_DB_VAR' cannot be found. ". However, I am
passing credentials only user name and password but the problem is that
remote machine does not come under any domain. So any body could help me that
how can I pass ReportServerCredentials without domain.
Report Data Sources can be configured with ...Changing User Information without SA
We're currently using GP 9.0 where I work (I'm the DBA) and we want to
migrate these databases to a SQL 2005 cluster (these databases currently sit
on a SQL 2000 stand-alone). These databases will be moving to cluster nodes
that have other databases that are critical to our environment and we would
like to limit the use of SA to strictly IT internally.
In PDK is there any way to allow GP users (employees) to modify other user
information within the System -> User screen. For example: Someone logs in
with their own GP account and wants to change tha...sum doesn't update total without double-click of cell
In a spreadsheet, using formula like "A1 + B1" to get the
sum of values in cells A1 and B1 to show in a third cell.
The total in the third cell does not update automatically
after changing the value in one of the two cells (e.g., A1).
Only after double-clicking the third cell, is the proper total
Any ideas why this is happening?
Set your calculations to automatic under tools>options>calculations
(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
"David E. Gross" <David E. Gro...putting a picture onto a userform without using the vba window.
I have userforms which I activate to show text information.
I would like to be able to paste a picture from the clipboard onto an opened
userform so that there is a picture as well as text.
The picture would be a copied picture from the web or a copied wmf from
Traditionally the way to do this is through the vba window by using the
image control and navigating it to a saved image or alternatively pasting the
image into the picture line of the Image Properties box.
This is too complicated for a user of my spreadsheet to do so I am looking
for alternativ...Pivot Table update without opening the Excel file.
I have a spreadsheet saved as an xlt.
It has three pivot tables which connect to CSV data files using Microsoft
The CSV files are updated overnight by an external application.
The Excel file is in \\Server\Viewers
The Data files are in \\Server\Data
Local users use a shortcut to open the Excel file on \\Server\Viewers which
the does an auto-update from the CSV files.
The pivot table data is updated.
All that has been working perfectly for years, internally.
Now I need to send the same excel file to another company by email.
I have succeeded in writing a vbscript that creates...Compress excel without using additional software
Is it possible to compress Excel without installing any additional
software or writing any programs?
Thanks for your help!
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/
"nylecaj" <email@example.com> wrote...
>Is it possible to compress Excel without installing any additional
>software or writing any programs?
The compression capabilities built into NTFS file systems are adequate for
Direct answer: no.
...DPM 2010 RC grows disk allocation without 'auto grow'
I backup a Hyper-V (R2) VM with 65GB fixed size hard disk in a protection
group without 'auto grow'; i reserved 75GB for Replica Volume and 5GB for
Recovery point; after synchronisation DPM automatically grows the reservered
space to 99,75GB for replica and 48,12B for recovery points. How can i
prevent the growth?
You can modify the protection to group to achieve, in the modification flow
you will be given option to select/un select the auto grow feature.
Praveen D [MSFT]
This posting is provided "AS IS" with no warranties, and confers no rights.
&...How do I convert works file to excel without works software?
I received a copy of information needed in microsoft works file. Microsoft
works is not in my computer and I'd like to open in excel rather than having
to manually put data into my system. Under excel help it seems you have to
open in works and then save as excel file. Since works is not on my
computer, I can't open the file.
You need to get a hold of someone who has works and can save it in the
correct format or get a commercial converter
> I received a copy of information needed in microsoft works file. Microsoft
> wo...Sending an email from another mailbox WITHOUT the "sent on behalf
Our Library has a mailbox and the administrators in the library have their
own mailbox. I have Outlook 2003 on their PCs setup to access the Library
mailbox with owner rights from their mailboxes. When the send email from the
Library mailbox, the email header says 'username ON BEHALF OF LIBRARY." They
do not want that. They just want it to say LIBRARY. How can I get this
result? We have Exchange 2003. Thanks.
they also need to have the "Send as" permission...on the security tab...
Susan Conkey [MVP]
"Saucer Man" <SaucerMan@discussions.micros...How do I add 12 out of 18 numbers without using sort to get them .
The list are scores that need to be kept in order. I need to be able to add
the best 12 numbers to provide a score at the end of the year.
Can anyone help?
Checkout =LARGE in help.
That may give you a clue.
North Yorkshire UK
"Tas" <Tas@discussions.microsoft.com> wrote in message
> The list are scores that need to be kept in order. I need to be able to
> the best 12 numbers to provide a score at the end of the year.
> Can anyone help?
On Fri, 17 Sep 2004 02:25:07 -0700, Ta...filter a form without opeing it
is it possible to edit a record with the event procedure of a control on a
form that is completely seperate from the source of the record if the source
of the record is not open?
for example, I have a form with only a textbox where I scan a barcode
(Tracking number). On enter it should filter another form, which is not open,
for that tracking number.
I was thinking about making the form a subform in the form where I scan the
barcode, but if I can do it without having to open the form I would rather do
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.asp...How to not see "on behalf of" in Outlook 2002 without Exchange
I have multiple email accounts in my Outlook 2002 setup. When I send email
from an account that is not the default account the From field shows "From
firstname.lastname@example.org on behalf of email@example.com". I there a way that all email
accounts send using their own name and not the name of the default account?
I do not use MS Exchange.
You shouldn't see that behavior if you use the Accounts button on the toolbar
to choose the sending mail account instead of the From field on the new
MVP - Outlook
*** Messages sent to my e-mail address wil...Change Header on Multiple Sheets without Changing Other Formatting
I have a file with sheets that have the same header. Each tab has specific
page setup formatting that I need to keep intact. I tried highlighting all
tabs and changing the header via page setup but the other page setup
formatting changed to the formatting of the first sheet.
Is there a way to add the header I would like to put on all tabs to the
header drop down menu on header/footer tab in page setup.
Only through VBA.
Dim WS As Worksheet
For Each WS In ActiveWorkbook.Sheets
WS.PageSetup.CenterHeader = "Some te...Scatter chart without connecting lines?
Could someone please help me out with my XY (Scatter) Chart? I've use
the wizard (want to get it right then make a macro) and chosen the dat
points connected by a smoothed line type.
Using the data below with the Perc on the Y axis and the Dates acros
the bottom, I can plot the data points correctly for each series bu
they do not show the connecting line. Can someone please tell me ho
to make these lines connected? Or even how I go about using a lin
graph to display the data below?
Thanks greatly in advance :)
Perc Series1 Series2
0 1/11/2004 11/11/2004
1...How to Save Email, without extra folder being created
Whenever I try to save an email in Outlook 2007 to a customer file, an
additional folder gets created. Is there a way around this. It looks like
saving it as an .mht file, but is there a way to have outlook 2007
automatically default to this save as type?
No, you cant pick a default save as type, but you might be able to use VBA
to automate it.
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Outlook Tips by email:
EMO - a weekly newsle...Inbound Email Tracking without Token?
This is a multi-part message in MIME format.
Is this possible? Have a client who is very sensitive about the =
appearance of the e-mails and does not like the token. All clients have =
an e-mail and they only send to clients so there is always a e-mail on =
record for inbound e-mails to resolve against.
Content-Transfer-Encoding: quoted-pri...Reporting on Custom Fields without Crystal Enterprise
I would like to know if it is possible to report on custom MSCRM fields
without Crystal Enterprise? Reading the Microsoft Reports FAQ says to log
onto Crystal Enterprise and update the available fields by verifying the
database. I do not have Crystal Enterprise on my computer so verifying the
database throws errors. I have been modifying the standard MSCRM Crystal
reports and then importing them using MSCRM Report Manager. This has worked
fine but doesn’t allow me to report on custom fields. Is there a work around
for reporting custom fields if you do not have Crystal Enterprise?
...How get to end of document without scrolling?
How get to end of document without scrolling quickly?
Ctrl + End
"cb" <firstname.lastname@example.org> wrote in message
> How get to end of document without scrolling quickly?
THANKS IT TAKES ME TO THE RIGHT i NEED TO GO TO THE BOTTOM OF LIKE 600 ROWS
"Peo Sjoblom" wrote:
> Ctrl + End
> Peo Sjoblom
> "cb" <email@example.com> wrote in message
> news:71E71871-C...Logon to OWA without domain name
Is there a way to setup my OWA so that I can type just the username, instead
"Tim Kowal" <firstname.lastname@example.org> wrote in message
> Is there a way to setup my OWA so that I can type just the username,
> of domain\username?
You need to set the Default Authentication Domain (click the button next to
'Basic Authentication') for the 'Exchange' Virtual Directory in IIS Manager.
Outlook Web Access For PDA , OWA For WAP: