Can't get bar code font to work in EXCEL 2003
I have a simple formula that converts a part number to a 3 of 9 bar code font
in Excel 2003. Works great on my computer but a co-worker, who also has
Excel 2003, can't get this to work. On her PC it show the 3 of 9 font in
the drop down box but in the cell it is not converting it to a bar code
Most likely the font is not installed properly...
She needs to reinstall the font. It can be done through Control Panel ->
Fonts if you have the font available.
> I have a simple formula that conve...Business Type Code Vs Industry
Can someone explain the difference between Business Type Code & Industry?
What is the role or purpose of Business Type code. If anyone knows of any
resources that could explain the intended purpose of this and some of the
other fields on the account object such as Classification, and Category that
would be great.
It totally depends upon your business requirments. If you think some field
is not required then just remove it or modify it to suit your requirments.
There are many attributes of Account which are not even shown on Account Form
by default but they are there in ...Code Comment Web Report,
I have enabled VC++ XML comments in Visual Studio 2005. However, I do not
see the "Build Comment Web Pages" under the Tools file menu (which my book
says should be there--but the book was written for VS02). Did they get rid
of Build Comment Web Pages in VS05, or simply move it?
> I have enabled VC++ XML comments in Visual Studio 2005. However, I do not
> see the "Build Comment Web Pages" under the Tools file menu (which my book
> says should be there--but the book was written for VS02). Did they get rid
> of Build Comment Web Pages in VS05, or simply ...output to
I created a button to save a report in a designated folder. The date
parameter is a box on the form the query for the report runs off of. I want
to include that date field in my report so I know what parameters I ran the
report on by looking at the contents of the folder. I tried to code the
start date into my stOuputFile portion but didn't do it correctly. Here's my
code so far for the button. Let me know if anything should be cleaned up as
Private Sub Cmd_MailEngineerRpt_Click()
On Error GoTo Err_Cmd_MailEngineerRpt_Click
Dim stDocName As String
I am trying to create a macro using VB. Here is what I want my macro to do :
I have file1 and file 2 saved in each monthly folder like
I have a spreadsheet like this
A B C D E
Date Unit No. Sale Amt Source1 Source2
9/4/2005 UN01 $2.00
6/8/2004 UN02 $3.00
10/5/2004 UN03 $5.00
My file1 like this
colum A colum B
Unit No Source1
Now I need go to file1 to find data for Colum D(Source1) by using vlookup
based on the unit number then extrive the data to colum D and times 50%.
So after I run the ma...Change background / color of chart worksheet?
Need steps to change the color or backgound of the worksheet that is a chart.
Have multiple tabs in workbook that are just the charts. Only option for
background is to use Format-Sheet-Background. That changes background of
chart, but not the grey areas around the chart on the chart tab.
You need to select the Chart Area (what you call the, "grey areas around the
chart") and format that.
There are 2 separate, "parts" to a chart:-
1. The Plot Area (which you seem to have formatted OK) and the
2. Chart Area.
You need to select each of them to format th...Printing without certain text (i.e., answers, notes)
Does anyone know an easy way to print two versions of a document? For
example, I need to print a student version without answers and instructor's
One way would be to use a style (call it Answers for example), when you want
to print out the students copies change the color of the style Answers to
white. That should do it.
"TM" <firstname.lastname@example.org> wrote in message
> Does anyone know an easy way to print two versions of a document? For
> example, I need to print a student version without answers an...Color Break in Line Charts?
I have a cash projection spreadsheet with a linked line chart. In the
projection sheet, the font goes from black to green when the data goes from
actual to projected.
Is there a way to make the line or the x-axis change colors at the point
that the date does so (i.e., have the line turn green halfway through the
Thank you in advance.
On Oct 23, 8:39=A0am, Mr. Platypus
> I have a cash projection spreadsheet with a linked line chart. =A0In the
> projection sheet, the font goes from black to green when the data goes fr=
om...How do you control the color/pattern of a pie chart?
I need help with my pie charts. I need to create pie charts that are easily
understood in B&W. How do I set the color or pattern for each portion of my
To format a slice you need to select it first. Click the pie once to
select all slices. Click again to select individual slice.
You can use the Fill Effects > Patterns to fill with b/w patterns.
Also in print preview the Setup dialog has a Print Black & White option
on the Chart Tab. Note this is only visible if you have a chart sheet or
select the chartobject before print preview.
If you are printing chartobje...Send to and Lotus Notes
I am using Excel 2002 under Windows 2000 and LOtus NOtes
as the e-mail software. Once I changed the e-mail program
(under internet options-programs tab) to Lotus Notes,
the "send to" submenu under Excel and Word disappear, but
it remain in Powerpoint. I have forced it to appear again
(customization of bars and menus) but not all the
capabilities are posible. First everytime I press "mail
recipient for review" excel stops me to save it as a
shared file, the it works. Is there any way it can work as
if I had outlook in the e-mail program?
...Outlook 2003 bug -can't insert note as text
When creating a mail message, choose Item from the Insert menu, then try to
insert a note as text. All that is inserted into the mail is the date and
time the note was last modified. Outlook XP and Outlook 2000 don't have this
bug - they correctly insert the text of the note into the body of the mail.
I use the Outlook Notes program quite a bit. But, there are two problems I
have with it:
1. It sorts most recent to oldest -- is there any way to change the sort
order to alphabetical?
2. I'd like the default "note" size to be a little larger? Is this
I can answer part of this one. To make the note a little larger - Tools,
Options, Note Options, Size.
<EHPorter> wrote in message
> I use the Outlook Notes program quite a bit. But, there are two problems
> have wit...Does any have any sample code for Store Manager Addins
I'd like to jump start some development efforts and would like to see some
examples of how ADDINs have been used. Anything that hits the PurchaseOrder
Table would be perfect....
My understanding is that samples are availble to certified partners at the
PartnerSource web site:
It is not clear to me if customers have direct access to it or not.
> I'd like to jump start some development efforts and would like to see some
> examples of how ADDINs have been used...On error displayes default error code instead of the specifyed one
I have added error handling code to my combo box.
Private Sub searchName_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object
On Error GoTo ERR_Handler
Set rs = Me.Recordset.Clone
rs.FindFirst "[sdutentId] = " & Str(Nz(Me![searchName], 0))
On Error GoTo 0
MsgBox "Please empty search box before continuing!"
But it doesn't display the message in msgbox, it displayed default ms access
error code. which is "The text you have entered isn't an item in the ...delete rows when any cells in column A is filled in RED color
I need your help for a VB code that can delete the rows with any cells
in column A being filled in RED color ?
Alternatively, it will be fine for me if you have the code that can
move the rows to the top when there are cells being filled in RED color
in column A .
Thanks in advance for help.
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/
~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements
If the colors are ...Escape codes embedded in XML
I have built an XMLDocument object instance and I get the following string
when I examine the InnerXml property:
<?xml version=\"1.0\"?><ROOT><UserData UserID=\"2282\"><Tag1
QID=\"55111\"><Tag2 AID=\"5511101\"></Tag2></Tag1><Tag1 QID=\"55112\"><Tag2
I'm looking for an autopublish product for a customer of mine. I know of
one, but I'm trying to create a list of options for my customer, so if you
know of one, can you please reply to this post with details.
I've seen a couple folks develop macros to publish all projects. Not sure
if that's what you're looking for....
- Andrew Lavinsky
> Hi, I'm looking for an autopublish product for a customer of mine. I
> know of one, but I'm trying to create a list of options for m...code to change a form's allows?
I am wondering what the code syntax is to tweak a form's allows? Allows
deletions? Allows Adds? etc I know how to do it in the right-clicked form
properties manually, but I need it to be based on conditions.
Reason I need this is because I have one form that all users open.
Depending on their window's username, I have a security table that tells me
what role I want them to have in the database. Depending on their role, some
users have more rights than others on this form. I want to adjust the form
to allow additions for some users, but not others.
Me.AllowAdditions = Fals...Set the color of grid depend on variable
I'd like to set the color of cells (sheet1)
[A1...A8] -> Red
[A9...A28] -> Green
[A29...A44] -> Blue
[A45...A54] -> Red
based on data from sheet2
Start Stop Color
1 8 Red
9 28 Green
29 44 Blue
45 54 Red
How to do it ?
Radoslaw Krzyzan , pl.communicator@radek
http://www.communicator.pl , ICQ 4336523
for only three colors have a look at 'format - conditional Format'. For
more than 3 conditions you need VBA
...how do i delete blank space on one note pages
Once I've added something on to a one note page and then delete it, its not
always possible to delete the blank space.
Not a big problem in one note, until you come to print and then you get
blank pages which is not good for the planet !!
Ive tried using the Insert Extra Writing Space in reverse, which sometimes
works but not consistently.
Im using OneNote 2007 in XP environment
-------- Original-Nachricht --------
> Once I've added something on to a one note page and then delete it, its not
> always possible to delete the blank space.
> Not ...Modify Appointment Status Code attribute
Does anyone know how I can modify the pick list values that is for the
Status Code attribute in the Appointment Entity. This is the pick list that
appears when a user clicks on Actions->Close Appointment. All I can use is
Completed or Canceled. However, I would like to add more to the list. When I
open the attribute, everything is greyed out and I cannot modify this.
this field is locked because it is a system attribute, and i do not know of
any supported ways to customize/change values in this attribute.
"daryl&...Turning a row color to "yellow" if one date field is greater than another.
I would like to automatically turn a row color to yellow if the current date
is greater than a "needed by" date column. What is the best way to do this?
Select the rows necessary and then go to Format/Conditional Formatting. If
your 'needed by' date is in column D use 'Formula Is' and then in the box
Hope this helps.
"Ray Stevens" <email@example.com> wrote in message
>I would like to automatically turn a row color to yellow if the current
>date is greater than a &q...Credit Card Approval Code
I am using IcVerify 3.1.6 to process credit card transactions and it is
working fine. But, the approval code printed on the receipt shows bunch of
numbers and letters (usually two lines long), instead of 6 digit approval
When I test the transaction using IcVerify program (not RMS software with
multi-user enviorment), the approval code shows only 6 digits.
Is there any way to correct this problem? Please advise.
Turn on the short answer file. In your ICV multi-user screen, type in a /O
(that's an O not a zero) on the initialization string line.
&quo...New HP Color LaserJet
Our company is looking to purchase a new HP Color LaserJet for use with
Dynamics GP 9.0 and later (when they are released). However, the GP
compatibility list does not include any current model HP color laserjets.
This will be a workgroup printer and color is necessary. I would like to
stick with HP's since we have had good luck with them in the past.
I was looking at maybe the 4700dn, 3800dn, or the 3600dn. Has anyone been
using any of these models?
We don't have anyone using the models you listed, we do have one customer
using the HP 2840 Color LaserJet with no pro...Rotate Label Code
Is it possible to get the details (with the rotated label control) to
display the results left to right rather than top to bottom?
I have the following now:
If Me.Left < (2 * 1440) Then
Me![Label0].Visible = True
Me![Label1].Visible = True
Me![Label2].Visible = True
Me![CheckNo].Visible = False
Me![CustNo].Visible = False
Me![PostingAmt].Visible = False
Me.NextRecord = False
Me![Label0].Visible = False
Me![Label1].Visible = False
Me![Label2].Visible = False
Me![CheckNo].Visible = True
Me![CustNo].Visible = True
Me![PostingAmt].Visible = True