Default Word 2007 to "No Spacing"?
Is there a setting to make Word 2007 default to use "No Spacing" under the
Styles of the Home Tab?
It's very annoying that it defaults to normal. I never use it!!! It's
especially when doing a Mail Merge and I have to put Name, Name2, Contact,
Address, Address2, etc.. all on one tiny label. Can't do that with the
spacing it does by normal. Each time I have to change it to no spacing.
Apply the Word 2003 style set. (Change Styles on the Home Tab)
<>>< ><<> ><<> <>>< ><<> <>>< ...print a record in form view
I am building a form and have inserted an event procedure to have the form
print one record at a time and it will only print a blank piece of paper.
This is my code, can anyone tell me what they think is wrong? Any help is
rivate Sub cmdPrint_Click()
On Error GoTo Err_cmdPrint_Click
DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
Assuming that the line
rivate Sub cmdPrint_Click()
is only missi...What is Piggy Bank in MS 2007 Outlook?
Our company just got Microsoft 2007 Office and one of my team members has a
button in his Outlook entitled "Piggy Bank", however we're unable to find any
information about what it is. Can anyone help explain this? No one else has
this on their computers and we can't find out how to add it or remove it. Any
help would be appreciated. Thanks!
He has some addin installed that added it. Look in Tools, trust center,
I assume its this thing:
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook &a...CRM 3.0 on Outlook 2007
Hello, I installed the spanish version of CRM Client on my Outlook 2007.
I noticed the user interface has changed. With this version any time I click
on a CRM entity it pops up an Internet Explorer window. Is this normal or
should I still be seing the data On oultook application (that was the case
of CRM for Outlook 2003)?
Nothing changed (assuming you are reffering to the v3c update) in this
regard. The CRM for Outlook client has typically opened browser pages. The
only exception was if you double clicked on the core Outlook items.
Basically, if you click from an O...Access 2000 Package and Deployment Wizard problem!
I have created an Access 2000 application that I now wish to distribute to
users as an MDE file. The Access 2000 Package and Deployment Wizard does a
fine job of storing the relevant installation files on a CD, exploiting A2K
However, I would prefer to let users download my application from a website.
The Package and Deployment Wizard offers a 'Web Publishing' deployment option
that appears to address this need. My only problem is that it doesn't work
for me. I get the following error message,
Unexpected error number 48 has occurred: File not found: WebPost.dll
I...Preventing Recipient Names from Showing
I have a long list of people I am addressing a message
to. I want the recipient to see that it is coming to
them, but not be able to see anyone else's name/address
that it's being sent to.
I've tried the BCC field but then even the recipient does
not see that it was sent to them. I'm afraid they will
think it is junk mail if they don't see it addresses to
for other options
PATRICK REED [Outlook - MVP]~~~~~~
-Microsoft Certified Professional (MCP)
-Have you checked http://www.slipstick...How to filter to show only one message from a specific sender/subject
I would like to filter out all but one email with the same subject
line from a specific sender.
I subscribe to a message board that sends an email every time a
posting is made to a thread, instead of just the first posting after I
have read the thread. Is there a way for filter out the duplicate
messages and just keep the oldest email?
...SQL Back-end / Access Front-end using linked tables????
I have a backend that contains tables that I pull Driver information,
Customer information , etc. (these are MAS 200 accounting software
tables that are exported nightly to the SQL backend). I also have on
the backend tables that I push information to; information that we
enter on the forms located on the front end. I might not have this
up correctly, but I'm linking all tables on the back end to the
database on the front end. When trying to set up an Auto Lookup off
a query I've created in Access it says I need to go into the table
change Data Type to the Lookup wizard,...autocomplete (like Access)
I'm trying to restrict the entry of data into cells based on values in a
What I need is similar to Data Validation but I want Excel to complete
the entry after the user has entered just the first character.
For example, In Microsoft Access, when creating a new table in Design
view, first you enter the field name, then tab across to Data Type.
Entering a "c" and then tab automatically enters "Currency" as the data
type. Similar for "d", DateTime; "t", Text etc.
So, in Excel, if I have a list, say, New York, London, Sydney, Tokyo.
Typi...show tasks on the calendar
I would like to see tasks on the calendar in both weekly and monthly view -it
gives you a sense of those "things to do" items that are coming up.
I tried it with due dates and start dates, clicked "show tasks without due
dates", clicked show all tasks, consulted Help and my copy of Outlook for
dummies. It seems so basic but I HAVN'T BEEN ABLE TO GET IT TO DO IT!!!
Related question -why is it that Microsoft software NEVER behaves as you
would reasonably expect? -e.g we all write "to do" type items in our paper
diarys for certain days -without a fixed time...Can not install Office Ultimate 2007 because of a setup error mess
I have a desktop with no Office Suite which I built with Windows XP Pro SP2
(Version 2002), from a WGA Kit. I ordered the back-up discs (2 pcs) Office
Ultimate 2007 from digital river.com store and tried installing in this
machine but I get this message: "Setup error: The language of this
installation package is not supported by your system." I tried it on the 2nd
DVD drive of the same machine but same result. I tried installing the Office
software in a Sony Vaio laptop and it seems it will install properly and I
discontinued the setup. Any information/ass...Data from Access query to Excel
To pull data from an Access 2003 database, I have created
the queries in Access, then import into Excel. The
problem is that all the numbers that are pulled into
Excel are text and need to convert them into numbers to
run formulas on. I have converted a few sheets by hand,
but, some have will over 50,000 rows. Is there a
function to select all number colums (the colums are the
same through out the sheets) and convert?
There are instructions here for converting text to numbers:
You can select all the columns, and only the num...outlook 2007 monthly calendar six column?
Just converted to Outlook 2007 from 2003, where I could print a monthly
calendar with 6 columns: Mon Tue Wed Th Fri Sat/Sun. This freed up some
width per column, b/c the weekend days were consolidated. Can't seem to do
this with '07. The columns are too skinny (even on landscape) and I can't
read appts. Advice? Thx
Try the calendar printing assistant or word template- see
http://slipstick.me/calprint for links.
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com/
...Custom Menus in Access 2007
I know in VB 6 you can create custom pop-up menu. Is there a way to do this
in Access 2007? Active X? DLL? Hidden command that I can't find? Any
tutorials or direction? Any help or direction that anyone can provide would
In earlier versions, called "shortcut" menus. Right click on menu bar,
customise, show "shortcut menus" tollbar, select "custom".
don't know if that tollbar has changed in 2007.
"Jerry Sheldon" <JerrySheldon@discussions.microsoft.com> wrote in message
news:7431915F-33FF-4534-B5B4-C5E6F...Access 2007 Runtime 10-30-07
1. Can I distribute Accees 2003 applications using Access 2007 runtime?
2. Do I also need the runtime extensions?
3. Will installing the Access 2007 runtime and extensions affect my current
Access 2003 (full version) software, already installed?
...Automatically generate a new record
Can I autumatically generate a new record adding information (future date)
from a current record?
Yes. In your form have Double-click event call an append query that pull
data from your form fields to append one record.
INSERT INTO [YourTableToAppendInto] ( Field1, Field2, Field3, Field4 )
SELECT TOP 1 [Forms]![YourForm]![1stField] AS [X],
[Forms]![YourForm]![2ndtField] AS [Y], [Forms]![YourForm]![2rdtField] AS [Z],
[Forms]![YourForm]![4thtField] AS [A];
Build a little - Test a little
"Crown Jenny" wrote:
> Can I autumatically generate a new record addin...Works in 2003 but not 2007
When I reference the below function in 2003 I get function displayed... now
in 2007 I get
Any idea what I need to change/set in 2007 so it will run this function?
Function formulaText(x As Range)
'returns the text equivalent of formula in upper left cell in range x
'example: =formulatext(a1) returns the formula found in cell a1 of
'example: =formulatext(a1:b5) returns the formula found in cell a1 of
formulaText = x.Cells(1, 1).Formula
It works fine for me. Are you stored in a stan...Open web page from Word 2007
I have the following code to open a web page:
Set IE = CreateObject("internetexplorer.application")
mySTR = "http://MyWebPage"
The code works if I run it from vba - it opens the page on top of Word. But
if I assign it to a QAT or Ribbon button, it opens the page but leaves it
How can I get it to open on top of Word?
...Send button not showing after updating to SP3
I have updated the office 2002's .msi file with SP3 for
network distribution. After redeploying the updated file
I few users do not have a send button when the try to
send a message. I have tried to delete their accounts and
set them up form scratch with no luck. My only work
around was to install office from CD. I need to resolve
this problem. The installation from the network is a
...What program is trying to access e-mail address information stored in outlook?
I have one user (Vista Business, Outlook 2007 connected to Exchange 2003)
who has today started to see a pop-up from Outlook saying:
"A program is trying to access e-mail address information stored in
Outlook. If this is unexpected, click Deny and verify your antivirus
software is up-to-date."
Anti-virus (McAfee) is up todate, and I'm doing a scan now and afterwards
will do a separate scan for malware. This user tells me that he hasn't
knowingly installed anything recently.
My question is: is there any way to determine what the program is which is
try...using program to record audio comment and compress audio to MP3
I can use VBA to record an audio comment into a Word file using
Selection.InlineShapes.AddOLEObject ClassType:="SoundRec", FileName:="", _
LinkToFile:=False, DisplayAsIcon:=True, IconFileName:= _
"C:\WINDOWS\system32\sndrec32.exe", IconIndex:=0, IconLabel:="Wave Sound"
BUT but by default the file is stored as a PCM at 44kHz and 16 bit stereo
whcih is about 200kB per second
Sound recorder (which is used to do the recording) allows me to manually
convert this to a MP3 and a much smaller file e.g. 3kB per second
Is there any way I can aut...Excel (Office Home & Student 2007)
Question 1. Can I have an Excel Spreadsheet sort alphabetically? How?
Question 2. Does anyone know where the updates are for Office?
Thanks in advance.
__________ Information from ESET NOD32 Antivirus, version of virus signature database 5046 (20100421) __________
The message was checked by ESET NOD32 Antivirus.
Please see "Sort" and "Updates" in Excel Help. Either press F1 or click
on the little white and blue question mark in the upper right corner.
David Dyke wrote:
> Question 1. Can I have an Excel Spr...recording keystrokes
How do I record keystrokes and then evoke a command to repeat those
keystrokes? For instances; I want to change the first word in a numbered
list in the document all the way through the document.
You cannot record loops with the macro recorder.
The following will replace the first word in each paragraph in the selected
text with the word(s) defines in sText
Dim oPara As Paragraph
Dim sText As String
sText = "Replacement Text"
For Each oPara In Selection.Range.Paragraphs
oPara.Range.Words(1).Text = sText & Chr(32)
End ...Import Customer Records
I am trying to import customer records and I am running into the following
DOC 1 ERROR: Are you sure you want to delete this customer record?
Ln 810 Col 2, Update module, Last CBOM field read was root.'Customer ID',
Last window field visited was 'Clear Button' of window
'RM_Customer_Maintenance' of form 'RM_Customer_Maintenance'
Are you on the latest integration manager service pack?
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
The Dynamics GP Blogster at h...Can I use oulook from home and have access at work?
When I set up my outlook I lose all my inbox messages online and would not be
able to read my email from work. Is there a way to have my inbox available on
outlook and remain online?
Just to clarify, are you asking how to set up Outlook at home to receive
email from work? If that's your question, you need to ask your IT Admin or
Exchange Admin if you can use OWA and how that's done. That wouldn't have
email coming into your Outlook account but it is a form of Outlook, Outlook
This may or may not be allowed. Your IT staff would of course have all kinds