change fonts for specific fields in a report
A Great Plains report prints checks. The check amount field is too
small and needs to be increased. How does one change the font of a
particular field in a Great Plains report?
If the report is a text report, you can't change the font. If it's a
graphical report, click on the field and press <Ctrl-D>.
> A Great Plains report prints checks. The check amount field is too
> small and needs to be increased. How does one change the font of a
> particular field in a Great Plains report?
If it is a text report, you...link to specific sheet in excel file which contains points and spaces
I am trying to make a link in Acces to an Excel file.
This excel file contains several sheet with different names.
My form in Access has a field that corresponds to the name of the
excel sheets (Formname in script).
When the name in the form contains points or spaces my link to the
sheet with the same name does not work.
I tried to put brackets  on either side of the name, but then
linking does not work at all.
Please let me know if you have any suggestions.
Code (works when Formname.Value does not contain spaces or points
Private Sub CommandActionRegister3_Click()
Dim Locatio...Where to change my own internet adress in "FROM:" field?
I am using Outlook 2003 with Exchange server.
My own eMail address is presented to recipients as
Note: mixing of capital and lower letters
I want my email address completely changed to lower letters:
Where in Outlook can I change this?
or is this a setting in Exchange Server ?
This is a setting in ADUC/Exchange. I would guess that everyone is set up
with the same format throughout the company.
Kathleen Orland - MVP Outlook
Outlook Tips: http://www.outlook-tips.net/
"Joe deAngelo" wr...Changing menu bar height
is there a way to change the menu bar height of an application?
I dont see how that can be done without replacing the whole menu mechanism. You can do
that if you want by putting in a toolbar/rebar which acts as a menu. Example MFCIE shows
how to make a toolbar as a menu. YOu can change the height of the toolbar/rebar to what
Ajay Kalra [MVP - VC++]
"Nicolas Bonamy" <firstname.lastname@example.org> wrote in message
| is there a way to change the menu bar height of an appl...Forward misspelled names to user account if doman is correct.
Is it possible to catch for instance a misspelled name like email@example.com
that should be firstname.lastname@example.org and forward it to another account? It should
be able to pick up anything (like *@domain.com) and forward it to
Thanks in advance.
Are you really sure that you want to do this? If so, you can take a look at
the methods listed here.
"pakitloss" <email@example.com> wrote in message
news:24DB863D-49F5-457A-BA47-B7D26F422...Named as rlbook1, re-open? How?
....during library internet sesion this occurred.
I don't understand your question. Please put the entire question in the
body of the message. It's rather cryptic now.
"rlscreen001" <firstname.lastname@example.org> wrote in message
> ...during library internet sesion this occurred.
...User folder on desktop has a bad name
My name is Matteo (like User Name). Hence I had a User Folder on
desktop named Matteo. Now it has a different name, but files inside
are C:\Users\Matteo The wrong name is visible only on desktop
How can I restore the correct name?
"Allamarein" <email@example.com> wrote in message
> My name is Matteo (like User Name). Hence I had a User Folder on
> desktop named Matteo. Now it has a different name, but files inside
> are C:\Users\Matteo The wrong name is visible only on deskto...Changing positive values to negative
I’m using excel 2007with windows xp pro. I use excel very infreuently and
not since upgrading to 2007.
I have a long column of dollar values that I need to change from positive to
negative values such as:
I can accomplish the feat manually over many hours by F2>.HOME>- > ENTER>
DOWN ARROW and repeat and repeat and repeat. Or I can use a macro. But
using a macro has changed from years ago. When I tried the macro inserted a
specific value of cell rather than the value of the selected cell. So that
didn’t work. What can make this conversion easier?
If t...Exchane 5.5 IMC Naming
I need to change the FQDN display name on a 5.5 Exchange
IMC. Currently the server displays
netbiosname.localdomain, where it should read the FQDN of
the server. I've searched the registry and misc. config
files in the Exchange directory to no avail. In Exchange
2K + you can set this in the server SMTP config. However
there is no place to set this in 5.5.
Any ideas? Thanks for the help.
We ran into a similar issue. We found our options to be either configure
our reverse lookup records to our internal namespace or change the domain
suffix of the smtp machine. We ended up changing ...need registration name and key for reinstall
I purchased Money 2007 Premium in August, 2006, via Digital River download
and I also ordered a backup CD. Everything worked fine until my computer
died. Now I am trying to install Money on a new computer using the same
backup CD. But it pops up a window entitled "Key Expired". It appears that
I need a "registration name and key", "exactly as given to you". Perhaps I
did receive this information before but it would now be lost on my dead
Is there a way to retrieve the requisite magic cookies from someone's web
site? And what credentials...Pink Sheet stocks
I am using MS Money 2005 Premium, Version 188.8.131.525 and have
recently had a need for Portfolio Manager to list and update the
price on a stock that slipped into the Pink Sheets. I can not get
Money to recognize this stock symbol, although it is valid in
Yahoo. What do I need to do, or does Money not stoop to that
This stock ABRXQ.PK is one I made the bad judjement of keeping
when it fell from grace. It opened this morning in the Pink
Sheets. This was ABRX a few days ago, then it was delisted from
the Nas and became ABRXQ. This morning it was handed off to the
pink sheets and acquir...Formula auditing on protected sheets
Simple question: is there a easy (or difficult?) way to track precedent and
dependent cells on sheets which are protected?
...Check Name returns No Suggestions
To the group:
Outlook 2003, Windows XP
I type in a name in the To: box and click the Check Names icon and it
returns 'No Suggestions'
The Order of Check Names Address Lists is set to Contacts first (Address
Book > Tools > Options) - kb296948
I have reset the nickname and automatic completion cache - kb287623
I have even deleted some of the auto-complete names - kb292928
Still I get 'No Suggestions' when I type in a name I have in my Contacts.
Any assistance or suggestions most welcome.
Can you give an example of what you're typing in and wh...Get/change operation on Table
I am trying to set up the transit numbers in the bank Maintenance screen
(View>>Financial Lists>>Checkbooks ->under the Bank ID link). When I try to
save the changes made to the Bank Maintenance screen I get the error a
get/change operation on table 'ME_Pay_Check_Setup' cannot find the table. If
I press ok, I get another error stating that I "Cannot run the trigger
script." If I Press More Info I get a SQL error stating that it is an
invalid object name. Any suggestions on how to fix this would be greatly
You have the Mekorma MICR Check...Adding data from another sheet.
I hope I can find some help on this one. I have a spreadsheet that
consists of two sheets. The first is a form. The second is a list of
questions. I have added a checkbox next to each question on sheet 2 to
select the question and add it to the form on sheet 1. The problem:
when you select a question on sheet 2 it will only add it to a specific
cell on sheet 1. So if I select question 15 it will go in a position
like it is the 15th question when actually I would like it to be the
first question. The question: Is there a way to make the questions
start adding to the top cell on sheet 1...Password Change
I am using Money 2007 Deluxe and want change my password at a financial
institution. The change at the bank works fine, but Money keeps reverting to
Hee's is how I try to make change.
From the account register, I go to "Change account settings"
then "Change bank or brokerage passwords"
then "Edit user ID or password"
I then type, not copy and paste, my new password and "Save Changes"
I then try to update online and am told password and or user id, incorrect.
When I go back to "Edit user ID or password" my old password i...How to change owner (From:) of a public folder, newsgroup post
How do I change the Owner or From: for a newsgroup post. This is a post in
an Exchange 2003 public folder of type newsgroup. The posts in question are
from a generic user account and I need to change it to the specific user.
I tried by opening the post, choosing Edit menu -> Revise Contents, and
changing the From: to the new person. But it would not save, and if I
reposted it would keep the original user (poster) in the From: field (and of
course it also changed the post to the current date/time). I have tried this
method, to no avail, using the original user, and two different a...No name with Contacts
I'm using Outlook 2002. When I save a new contact, it appears blank in my
contacts. The phone number will show but that is the only way I can
identify the contact. Sometimes I get a message that the "File As" field is
blank, although it isn't. Not sure what made this start happening. Those
that appear in my contact list with names are fine. I can make
modifications and the name still appears in the list of contacts. Only new
contacts are saved with blank names, even though their File As field has a
name in it.
I've tried repairs, uninstall/reinstall, MS KB but not...named range scope...
i get confused...
a named range can have:
a global level (to the entire workbook),
a worksheet level (to the active worksheet),
also, i've really looked, but can't find good information on how to define 1
level name vs. the other... (any direction on this ?)
Just the two.
A workbook name is created by just inserting a name in the Names box, such
A worksheet name is created by adding the sheet name to the name in the
Names box, such as Sheet1!myRange. You can then also create Sheet2!myRange.
You can only add a worksheet name if ...Excel 2007
We have a spreadsheet that was set up to link to a database via a
system DSN. To simplify deployment of this, I'd like to change this
to connect via the connection string below:
I've done this for another spreadsheet, and it was easy (Data tab-
>Connections->Properties), but in this next spreadsheet the Connection
Properties for one connection are greyed out/disabled, so I can't
change the string.
Does anyone have any ideas how to enable these values again so I can
change the connection string?
...Passing control name to sub
I'm having trouble passing a MSFlexGrid control to a sub. The control name
is "flxGalleries". The error is "Type Mismatch. Error '13'". I have the
Private Sub Form_Open (Cancel as Integer)
... do stuff ...
GridSetup flxGalleries 'Call the Sub and pass the Control
... do more stuff ...
Public Sub GridSetup (ByRef flxGrid As MSFlexGrid)
... do stuff ...
What have I done wrong?
Call GridSetup(flxGalleries) 'Call the Sub and ...Change reference in formula from cell address to name
I'm fairly sure I saw this yesterday somewhere in this forum, but after
almost two hours of searching, and not finding, I figure I've earned
the right to ask - if only because someone should feel sorry for my
pathetic search skills (or bad memory).
Example: say I have a formula =$A$1+$B$2. Later, I name cell A1
"start" and B2 "finish". The original formula above still has the cell
references and not the cell names (it does not change to
How can I get the formulae created prior to naming cells to change and
reflect the cell names?
Secondly, give...change cell values from an edit box
Is there any way to change a cell's value with an edit box? I've used
drop down lists to change/update values, but I have no experience at
all with edit boxes. Any help would be greatly appreciated.
...File Name Length
Does anyone know if filenames can be longer than 31 characters in Office
In article <firstname.lastname@example.org>,
"JM" <email@example.com> wrote:
> Does anyone know if filenames can be longer than 31 characters in Office
> 2004? Thanks.
FIrst, you *can* have filenames longer than 31 characters in Office v.X
already - you just can't generate them. While v.X apps display a hash at
the end of a long filename, it keeps the filename intact when you save.
MS hasn't announced anything regarding long file names in 2004 ye...GAL display name
How do I change a user's display name in the global address list? I already
changed it in active directtory users and computers. It still shows up as :
bill smith instead of wsmith. I need it to be wsmith
You can right click on it in ADSU and choose rename, it will then bring up a
dialog box, and you can change the display name there. -Drew
"Eddie" <Eddie@discussions.microsoft.com> wrote in message
> How do I change a user's display name in the global address list? I
> changed it in ac...