Converting Excel table with multi-line cells into Access DB
I need to export a MSWord table to an Access table. The original Word table
contains multiple lines of text in each cell, separated with
I would like to retain these multiple lines within in each destination field
in Access or Excel
I have the following structure in my Word table:
Column1: PhotoID (alphanumeric,single line)
Column2: Image of the photos(jpeg/bmp)
Column3: Description(text, multiline)
Column4: Code#(alphanumeric, single line)
Column5: Notes(text, multiline)
In short, how do you tranfer those multi-line cells(with
carriage-return...Link to "Video Demos" in Get started tab in Office 2007 not workin
I have installed the Get Started tab in Office 2007. The link to the "Video
Demos" is not working.
Has MS changes the link ?
How can I fix this ?
I have installed this on many computers, how can I get this fixed on all of
...Outlook 2003: How to catch the Delete right-click event in Task List Items.
I would like to catch the delete event in right-click or in the
command-toolbar button. Is it possible to catch the event in a
VBscript on a custom form?
...Line Spacing and Line Justification
I am a Publisher novice.
On a blank page I pasted a PowerPoint Presentation slide. Below the slide I
drew a line and copied that same line multiple times.
How do I make the spacing between theses lines of equal ditance?
How do I align these lines so that they are basically at the same starting
point on the left side of the page?
Any assistance would be greatly appreciated!
The best way would be to create guidelines. Select your created line, while holding
the ctrl, (the cursor will turn into a + sign) pull the copy to the next guideline.
If you go the copy route, ...Skipping a line by condition
Thanks for reading this.
I have a report that is grouped by [positiontitle] in a two column report. It
prints out ok. The thing is what I want it to do is when a new [positiontitle]
comes up I want it to skip a line in the report. For example:
The way it comes up now is:
Non Worker Bill
The [positiontitle] is located in the header of the report.
Thanks for your help.
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/2...Step Line Charts
Does anyone know how I can create a step line chart without having to have 2 data points per x-axis point. What I want is a horizontal line until the next data point and then I want the line to go vertical.
You Will need some form of extra data to get excel to create a step
chart. Take a look at these methods.
> Does anyone know how I can create a step line chart without having to have 2 data points per x-axis point. What I want is a horizontal line until the next data point and then I want the line to go vert...outlook 2007 now has blury text
I don't think this is the IE 7 issue with blurry text i had to fix when i
installed that. Why is the text now default to this blurry gray text?
...Line colors in a bargraph
ColorNum and m_Array are set before entry which works fine except for all
bars are outlined in black
which is not a major problem, but would like to eliminate.
How do I draw the line in the code below a different color than the bars?
Below is a snip from my BarChart() routine:
// ***** THE PROBLEM IS HERE WHERE I WOULD LIKE THE DRAWN LINE TO BE LIGHT
MemDC.Sele...Please help me .... (CListCtrl multi-line column)
I use VC++ 6.0 MFC CListCtrl. And, some data displayed in the control
contains multiple lines. By default, the control displays the multiple-line
text in a single line. In the multiple-line text, it uses "\r\n" (CR-LF).
How can I set the column of CListCtrl to display the column text in multiple
line like the data cell in Excel?
This is the nearest i can find. Hope it helps
> Dear all,
> I use VC++ 6.0 MFC CListCtrl. And, some data di...OWA - Hangs "Loading" Inbox
2 of our OWA servers have recently stopped functioning.
The login appears ok and the interface starts to load, but the fonts
are wrong (times new roman is shown) and the inbox doesn't load at all,
I've searched the forums/web and can see many people had the same
issue, but have found no fixes that work.
"Error on Page"
Error: Object expected.
Any suggestions or help really will be gratefully received.
I had this same issue except one of my owa boxes would work and the
other one didn't. I don't have a KB ar...Multivalue Field in Access 2007...
I have been trying to read a mutivalue field in an Access 2007 without any
luck. I have followed the example at
http://msdn.microsoft.com/en-us/library/bb258183.aspx but have not been able
to get that to work. Has anyone sucessfully accomplished this task?
You might want to look in microsoft.public.access for the answer I posted
Arvin Meyer, MCP, MVP
"Brian Griffey" <BrianGriffey@discussions.microsoft.com> wrote in message
news:D587BE95-7220-4769-BE38-15D68FF1CCD1@micro...Word 2007 doc having trouble with white space above paragraph
I am trying to format a 20 page document. I added hard page breaks and now if
I hit the enter key to put a certain paragraph on a page I get large amounts
of white space above certain paragraphs that will not go away by backspace or
trying to deleting them. Any help would be appreciated.
Just an idea but have you checked Page-layout tab, Page setup group, dialog
starter button, format tab, next to align vertically should be top instead
of centered. If it is not that check the paragraph formatting, maybe you
applied a large amount of pace before or after the...Money 2007 Budget Problem
I just converted from M06 to M07. When I look at my Budget reports, it
lists a bunch of transactions (all from the same account) that are under the
heading "expenses not in budget" in the Monthly Budget report.
This was not the case before the transfer....how do I correct this?
...Microsoft Outlook #5
I have three people that use the same computer for email.
Each have different email addresses. Receiving email is
not a problem, all three email accounts are set up to
receive at the same time.
The problem is when they send email they have to go into
the dialog box and change the from and reply to
Is it possible to have a simple way to allow each person
to send an email with their name as the FROM?
I thought of having three separate folders with Microsoft
Outlook but I could not get that to work.
What version of Outlook are you using, and if 98...outlook #298
I'm under the impression the I can check office outlook 2003 with my outlook
express in my new laptop. Is this possible?
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
After furious head scratching, dan@tpm asked:
| I'm under the impression the I can check office outlook 2003 with my
| outlook express in my new laptop. Is this possible?
Milly - I just signed up so I can ask a question about saving Outlook Express
emails and address book to a ...Outlook 2000 #59
My Outlook 2000 had disconected from almost all of the
data that I have entered over the last 2 years. It has
retained Contacts & Tasks. I'm Pretty sure the data is
still existing but it's not merging with the program.
Do you have multiple PST files on your system? Maybe the data was archived
off to another PST and isn't in the current PST file
"Greg" <firstname.lastname@example.org> wrote in message
> My Outlook 2000 had disconected from almost all of the
> data that I have enter...saving to csv file from excel 2007
I need to save file to csv format to transfer to website...2003 always worked
fine - 2007 doesn't - help??
Office Button >SaveAs
Office Button >SaveAs (menu)
Or use F12
Choose CVS in the list and save the file
Regards Ron de Bruin
"pourlance" <email@example.com> wrote in message news:11D7C094-BD37-4CBD-8E8B-6C3BB3736581@microsoft.com...
>I need to save file to csv format to transfer to website...2003 always worked
> fine - 2007 doesn't - help??
> ...Outlook user profiles
I set-up two different user profiles in outlook. I am not
able to change the settings in one user profile under
Tools/options/mailset-up without it changing the settings
on the other user profile. I need to apply individual
settings for each. Anyone know how to remedy this? I have
Which settings are youi trying to change?
Sue Mosher, Outlook MVP
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
"gia" <firstname.lastname@example.org> wrot...Capture Space within String
My function SplitName below correctly parses a last/firstname string with or
without a comma between the name pair. The only problem I have is if the
last/first name is passed to the function with no "space" after the comma.
If you look at "TEST 2" below, you'll noticce that the first character "M"
in the first name variable gets cut off when the space after the separating
comma is not used.
Can someone help me modify my function so the function will correctly return
the last and first name no matter if it's used with or without the leading
space a...Line chart with value on the line
I have implement a line chart by thousands of data rows for a stock.
Now I want to show values on 10 particular points with the lable
E.g, one extra column for displaying the label.
TradeDate Ticker Close Label
04/01/1999 1234 63.67
05/01/1999 1234 63
06/01/1999 1234 63 Mr. A buy
07/01/1999 1234 67.33
08/01/1999 1234 68.33
11/01/1999 1234 68.67 Mr. B buy
Does anyone teach me how to do this ??
"Ginola" <email@example.com> schrieb im Newsbeitrag
> I have implement a line chart b...removing black lines
Sometimes I type an underline bar across the page. At the end of the page
I'll hit the return (enter) key. When I do, the underline bar turns into a
big black bar. Then I can't get rid of it. It just stays there. How can I
get rid of this black bar?
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> &...adress book from outlook express
how do i impotr adress book from outlook espress in my
computer and how do i do it from outlook on a remote one?
File > Import and Export... > Internet Mail and Addresses...
On a remote computer you must import OE's WAB into OE first.
"ari" <firstname.lastname@example.org> wrote in message
> how do i impotr adress book from outlook espress in my
> computer and how do i do it from outlook on a remote one?
...Links from outlook fail to open
Running Windows XP home edition and Outlook 2000.
When I click on a link wityhin an email in Outlook it would normally open in
Explorer automatically. For some reason my links do not open. Any Ideas?
check internet explorer to see whether links open fine there.
Also if the emails containing the links are in junk email folder then they
"Brian Parkinson" <brian(DELETE THIS)@parkinson11.freeserve.co.uk> wrote in
> Running Windows XP home edition and Outlook 2000....want to filter out emails, with subjest line starting with a specfic sring
I am using MS outlook 2003, I am trying to find out how can i create a
rule to filter out emails with subject line starting with a specific
string, but not to filter if that string is in the middle of subject
i.e. lets take the sting as Foo
Foo is in the starting
don't filter if
if the Foo is not in the starting.
if any of you aware of the trick to make this happen please let me
know, i tried to google it, but couldn't find anything related to it.
outlook doesn't offer anyway to build that sort of rule. If you can coun...synchronizing outlook express in two computers
Hello, I use outlook express in my laptop at home and in
my computer at work, can anyone tell me how to
synchronize them so the same messages appear on both
laptop and computer and that they look the same way i.e:
please email to email@example.com
Thank you all in advance!
Try an OE ng this is an Outlook ng, different app.
or here http://insideoe.tomsterdam.com/
"Christine" <firstname.lastname@example.org> wrote in message
> Hello, I use outlook express in my laptop at home and in