Word merged with Access
I am using both Word and Access 2003.
When I merge a Word Letter with Access, sometimes not all of the queries
show up, in the drop down box, to link the letter with. Does anyone have any
ideas of why this happens? Is there a way to make all of the queries show
up? Are the queries limited to a certain number? I would appreciate any
help or ideas that you can give me.
Without more information, I can only guess...
Any chance any of those queries that are not showing up are NOT "select"
queries (i.e., they are Make Table, or Delete or Insert queri...Too many problems while updating information online
Several of my accounts are unable to update information online using MS Money
- ING Direct
- Bestbuy Card (HSBC)
- Bank of America
This is frustrating!! Anyone else with the same problems?
Just keep trying, eventually it will work. If you're in a bind, download the
QIF or OFX files from the institutions web sites -- B of A works better that
way anyway :)
Paul McKenna <Paul McKenna@discussions.microsoft.com> wrote:
>Several of my accounts are unable to update information online using MS Money
>- ING Direct
>- Bestbuy Card (HSBC...Word forces Save As when Saving
I have had this happen quite a few times since using Word 2007 (Office 2007
suite) over the last 1+ years . At some point while working in a Word
document, I press Ctrl-S to save and instead of saving the doc as usually
happens, the Save As dialog comes up and I am forced to save the document
with another name. This is very, very frustrating and completely interrupts
my workflow because after saving with a new name, I have to close the
document, delete the original so I can rename the saved-as doc with the right
This seems to happen when I've been working in the sam...Is there a list of characters that Word considers equivalent on Fi
Word's Find will find "equivalent" characters. For example, a find for
straight quotes will also find curly quotes, and a find for a space will also
find a non-breaking space.
Where can I find a list of the characters that Word considers equivalent in
...How to use MSExcel to plot Column A against Col B?
I want to plot col A (x axis) against col B ( y axis). I cant seem to
do it. Can anyone here please give me step by step primer. Thanks in
All I get is the graph of (1,2,............n) (x axis) against the n
values of either col A or B.
i.e 2 graphs instead of one.
(In the old Lotus this was so simple: select the column for the X axis
and then select the col for the Y and press enter, and you'd get the
Why is it so diff in Excel?
Select the entire range you want to graph such as a2:b44>insert>chart>>>>
dguillett1@au...Converting a Microsoft Word document to a PC document
Operating System: Mac OS X 10.5 (Leopard)
I have created a Resume and a cover letter in Microsoft Word on a Mac to be uploaded to the Institute ORACLE recruitment system. <br><br>When I checked how it looked, the format, the bullets and formating were blown apart! I was told to convert the documents to PC format. <br><br>I don't know how to do this. I got some guidance to make them PDF files, but the formating still goes haywire! How do I do the conversion on my Mac?
The most important thing to do is DO NOT TEL...Ease of visibility of the Ribbon in Word 2007 and Excel 2007
As installed the colour intensity of the Ribbon in Word and Excel 2007 is
very faint and it is not particularly easy to read. Is there some means of
increasing the colour intensity to make it easier to read?
I have fairly good sight but still have difficulty. Unless the colour
intensity can be adjusted it must be virtually impossible for people with
poor sight to read the details on the Ribbon.
Try this (not sure if you will have this on your computer but it is worth a
Control Panel / Ease of Access / Ease of Access Center
There are a number of options in here ...Word to Excel conversion
As we are able to mail merge from the Excel data, is it
possible to convert MS Word labels into Excel Data?
how do you store your data currently?. If it is in a Word Table you may
simply copy+paste thiese contents to Excel
> As we are able to mail merge from the Excel data, is it
> possible to convert MS Word labels into Excel Data?
Hope you folks can help me out with a strange one.
I have several worksheets formatted in exactly the same way as follows:
Col A - width 4
Col B - hidden
Col C - width 4
Col D - Width 108
Col E - Width 3
Col F - Width 11
Col G - Hidden
Col H - Width 11 & Empty
My print range should be Cols A:G (I have used page setup to set the
scaling to fit 1 page wide by [blank] pages tall, thus each sheet will
print as many pages as required depending on number of rows]
When I have the print range set to A:G only columns A:E show on the
print preview (and also on the actual print out) and when I m...Higlihting entire rows or lines?
Hi I was wondering is there any way of highlighting entire lines or rows in
If you are talking about text lines, clicking next to the line in the left
margin will select it. Similarly, you can click next to a table row to
select it. (The mouse pointer will look like an arrow.)
Microsoft Word MVP
"D Shah" <D Shah@discussions.microsoft.com> wrote in message
> Hi I was wondering is there any way of highlighting entire lines or rows
Do you mean as ...Business Portal
I am trying to set up our Business Portal to be as easy as possible for our
One of the requests they have made is the ability to find out WHAT PO is
COMMITTED to the SPECIFIC line item in an order. Similar to actually looking
at GP Sales Transaction Entry window where it gives an icon to show that the
item has been purchased, what PO it's been committed to.
I have spent hours trying to make this happen. Has anyone else been able to
do this? If so, I would appreciate detailed steps.
...Using Outlook to access and compile information in calendar
I want to create an application that will compile schedule information from
Excel worksheets or an Access database and display them in a calendar type
format. I know this type of application can be built using PivotTables in
Excel, or forms in Access, but I was wondering if I could use the calendar
in Outlook to display the information rather than creating PivotTables or
custom forms which would wind up looking something like a calendar anyway.
Before I start the job I'd like to know if I can work Outlook into the
equation or if I really have to build it from scratch.
...Amount in words to be printed on the invoice
I need to print the invoice amount in words in MRMS 2.0
this is available through Microsoft. check out the following site:
> Hi Mates,
> I need to print the invoice amount in words in MRMS 2.0
> Any suggestions
...How do I find a value on a line?
I made a line graph of data to use as a calibration. I know the y value and I
want to find the X value. Is there a way that I find find this specifically
on the line without using a trendline formula or guessing by looking at the
The only way to find a specific value is to use the formula.
If you can accept piece-wise linear interpolation, see
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity s...Change Backcolor for the selected line
I would like to be able to highlight or change the color of a single line on
a subform formated as a continuous form.
The user selects one line from many possible lines on a continuous form to
respond to. When he selects the line another pop-up form is display which the
user must complete.
I would like to maintain some kind of highlight (backcolor?) so that the user
can clearly see which line he is reponding to.
Setting the backcolor after selecting a line sets the back color for the
entire form, which really defeats the purpose.
Message posted via AccessMons...w97m.thus.aa in word attachments stopping entourage from sending email
Everytime i create a word document and try to send it from entourage
(all 2004 edition) I get the message that the above virus is in the
document and it fails to send it.
Any ideas how i can sort this out, I've already deleted the
folder and this made no difference.
In article <email@example.com>,
"Nick" <firstname.lastname@example.org> wrote:
> Everytime i create a word document and try to send it from entourage
> (all 2004 edition) I get the message that the above vi...initial default column width
Is there a way to configure Excel 2000 so that when I create
a new Workbook or add a new Worksheet so that all the columns
have a particular width instead of the default 64 pixels?
Create the workbook exactly the way you want it, then save it as a
template with the name "Book.xlt" (no quotes) in you XLStart directory.
It'll be then used as the template for new workbooks.
Likewise, save a one-sheet workbook as a template, named "Sheet.xlt" for
the template for Insert/Worksheet.
In article <419E181F.6251D20D@nospam.net>, Bruceh <email@example.com&...Windows and Mac have two distinctly different units for column width.
Operating System: Mac OS X 10.5 (Leopard)
I am trying to format columns for some data I am entering in a spreadsheet and when I enter "15.00", which is the required width for these columns given by my professor, I end up with a column 15 inches wide. What I would prefer is for the options to be like the default options in Windows version of Excel. In Windows version of Excel, when you hover over the lines between the columns it gives you two numbers (e.g. 8.43 (64 pixels)). These are the default numbers for column width in Windows Excel....MFC get drive information
How to get drive information of my computer?
I want to get available driver letters and the corresponding disk space
Use GetLogicalDrives() to get drive informatio.
Use GetDiskFreeSpace(... to get drive space.
> Dear all,
> How to get drive information of my computer?
> I want to get available driver letters and the corresponding disk space
> Best Regards,
You can use
cha...How to assign unique number to column duplicates?
I need to assign a unique number to a set of duplicates all in one column in
so columnA will has about 9000 numbers, some of them unique, and others are
duplicates of 2-4 approx.
I used to conditional formatting to show which are duplicates, but need to
be able to assign a unique number to each set duplicates, that will be in
ColumnA ColumnB(unique ID)
Any ideas please? I don't know how to do programming, just form...Excel object within Word doc
I am sure I am doing something in error ... but all I want to do is take a
spreadsheet and embed it in my word doc. I click on 'Insert', then 'Object',
choose 'Excel 97-2003', 'Display as Icon', copy data into spreadsheet,
'save', 'close and return' ... However, when I go to view it at a later time
- the spreadsheet does not open and I end up in the picture editing part of
...document elements (et. al.) toolbar in Word 2008
I may be in the minority here, but I happen to love the Ribbon UI on
the PC version. It can collapse down to nothing when needed, and
expand out (and even be customized I hear in 2010). That's on the PC.
On the Mac I want a Mac-like UI. The Document Elements bar is so out
to planet Jupiter on both functionality and as an accelerator into
functions writers need most that it's laughable it made it into a
release. (I'd much rather have a Mac ribbon that the Document Elements
toolbar since at least the ribbon exposes USEFUL functions.) I mean,
really =97 how many UPS or Del Mon...Can i move multiple lines between workbooks
I have a .csv format file listing speed cameras, and the different speeds are
identified by two characters at the end of each line - 30, 40, 50 etc.
I would like to create separate files for each speed, but Excel won't allow
me to cut/copy several lines to created a new file/workbook. Is there any way
Sun, 16 Sep 2007 03:28:00 -0700 from Martin Ellis
> I have a .csv format file listing speed cameras, and the different speeds are
> identified by two characters at the end of each line - 30, 40, 50 etc...how to use 2007 styles in Word 2003
we have Word 2003 but we really like the Styles that come with Word 2007. Is
it possible to export these Styles and use it in Word 2003? And if yes, how
can i do that.
In Word 2007, click the Home tab of the ribbon. In the Styles group, click
Change Styles | Style Set | Word 2003. To make this choice the default,
click Change Styles again, and then click Set as Default. If/when you are
prompted to save the changes to your template, choose to do so.
Microsoft Word MVP
"skoub" <firstname.lastname@example.org> wrote in messa...Filter two columns with criterion applying to one or the other?
I am looking for a solution to the following filtering problem:
I have two adjacent columns, so using a filter for both of them is no
problem. But what I want to do and don't know how to do is this:
I want to filter for values greater than x (a certain number, in my
case 5000) in any of the two columns. I can filter both columns for x
greater than 5000 but that filters out more than I want because there
may be some cells with a value greater than 5000 in only one of the
Is there a solution to this problem (using Excel alone or an add-on)?
you can use th...