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...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...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...Sending Pictures #3
I have a problem sending pictures to a mail recipient. I
use to be able to right click the picture and use "Send
To / Mail Recipient". Currently this option is not
working. A dialog box appears to ask if I "Want to make
my picture smaller" and nothing happens. Before this,
the same dialog box appears and then my Outlook would
open up with the picture as an attachment ready to send.
This time, my Outlook does not open up. Can anyone help?
...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...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...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" <firstname.lastname@example.org> schrieb im Newsbeitrag
> I have implement a line chart b...Tiled background picture on MDI form
I used in some apps a tiled background picture - usually on an form -
to display a company logo.
That's easy, load the logo into a StdPicture und use PaintPicture in
2 nested loops to paint the logo "tiles" on the form background.
In a new app I have to tile the customers logo on the client area of
a MDI form. And the MDI form has no PaintPicture, ScaleMode,
ScaleX, or ScaleY.
I first thought about StdPicture.Render but it seems for the destination
ScaleMode must be vbPixels.
I came up with two solutions in plain VB6 and used the second:
1) a PictureBox o...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...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
<>>< ><<> &...Line graph question
How do I get my date axes (the horizontal axes) to start at zero followed by
the first day of the month.
If your dates are entered in the spreadsheet as dates then you may have
problems - Excel stores dates as numbers so today is 39594 and 0 would be
January 0, 1900. This would tend to spread the x-axis out quite a ways. If
your dates are not entered as dates then make the first entry 0,0 - that is
put another entry in the data area whose date value is 0 and whose value is
0. There are potential problems with this approach - each entry will be
spaced equidistant apart ...can .php (microsoft picture it!) files be converted to .pub files"
I have some "old" .php files that I would like to get converted to .pub files
or any other more contemporary format. Does anyone have a thought as to how
this might be done?
Copy and paste. Otherwise, there is no "conversion".
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"
"Don S" <Don S@discussions.microsoft.com> wrote in message
>I have some "old" .php files that I would like to get converted to .pub
> ...reading line by line
I have a big problem, but I don't known how excel can solve it.
I have a sheet with like it:
process process_line status values_USD
0255155 10 44 10
0255155 20 44 20
0255156 10 33 11
0255156 20 44 21
0256157 10 33 12
0256157 20 33 22
0256157 30 33 23
0256158 10 ...how do i change or make this macro??? pictures and code included
i need to either make this from scratch or change it to suit my needs.
Firstly a link to the template it is from
the code is
Dim revgrowth As Single, costpercent As Single, smgrowth As Single
devgrowth As Single, gagrowth As Single
Dim intincome As Integer, noncontitems As Integer, otherexps A
Dim taxrate As Single, avgshares As Integer
'dialog box gets displayed
If .Show = False Then
revgrowth = .EditBoxes(1).Text
costpercent = .EditBoxes(2).Text
smgrow...Forwarded emails dont include pictures in Entourage
Operating System: Mac OS X 10.6 (Snow Leopard)
Email Client: pop
Hi Rockstars, <br><br>When I forward emails in Entourage, the pictures that are in the original emails do not get sent. I am trying to forward emails that have charts and other graphics to clients, but they cannot see them. What the? <br><br>Thanks <br>
On 1/12/10 6:13 PM, in article 59bb0ca7.-1@webcrossing.JaKIaxP2ac0,
"email@example.com" <firstname.lastname@example.org> wrote:
> When I forward emails in Entourage, the pictures tha...Adding a line to the line/column chart?
Is there anyway I can add a second line to the line/column chart?
Basically I have 3 sets of data that I want to plot vs. time on the
same graph. 1 using the column format, the other 2 being lines
connected by data points.
Create the chart using all the data, right click on the one you want to
change to a line and select chart type from the dialogue box and choose the
type you want. There are a few restrictions on the mix you can have though.
MOS Master Instructor
Please reply & rate any replies you get
Ice Hockey rules (especially the Wightlink Raiders)
"Steven"...Can I link timeline labels to a line chart?
I've been trying to do this for a bit and can't seem to find a way.
I am trying to do a line chart of weekly sales for two product lines
over several years (2 separate lines).
What I would like to do is overlay labels for press releases (so you
can see if they have an impact on sales) on the same chart, and have a
line from the name of the press release to the correct corresponding
point on the line chart that is "active", so as more points are added
to the chart, the line indicating the unit corresponding to the date of
the press release will move also.
Additionally, the...fonts line by line
I'm doing line by line translation. How can I easily use different fonts for
Assuming you're pressing Enter at the end of each line, so each line
is a separate paragraph:
Define two paragraph styles, one for each font.* In the definition of
each style, specify the other style as the "style for following
*In case you don't know, to define a style, click Format > Styles and
Formatting (Word 2003 and earlier) or press Ctrl+Alt+Shift+S (Word
2007) to open the Styles pane, then click the New Style button.
Jay ...Dynamically control how many lines on a graph?
I apologize if this is a FAQ, for some reason my newsreader isn't picking
up any messages from this group (looks like no postings) so hopefully I'll
be able to access responses, if not, I'll googlesearch for responses later
today and tomorrow...
I have many sets of data, all on the same sheet (in a repeated pattern-
starting in row 1, then 11, then 21, etc)
My single graph is based on named ranges, and the named range(s) are based
on Steve Bullen's funchart1 (autoexpanding chart) to control how many
x-axis values are shown- whic...Outlook 2003 Embedded pictures
Outlook 2003, SP 3, with all latest updates. Windows XP Pro with all latest
When I receive a message with pictures embedded in the body of the message,
I can see the pictures OK. If I forward this message to others, my copy of
the forwarded message shows the embedded pictures OK too. However, if I
forward this message to myself (to get rid of all the extraneous From and
To and subject lines), the copy of the sent message has all the embedded
pictures, just like the original. HOWEVER, when I get receive the message I
just forwarded to myself, the embedded pictures arrive a...Write from one file to a specific line of another
I need to make Excel read a value from a specific cell (A3 for
instance) in a specific file (Input file), read a group of cells on
that file (for instance D5:G5) and write them in a specific row (that
corresponds to the value in cell A3) on a different file (Database).
It would be really helpfull if somebody could give me some help on
Thanks in advance
Would you want to overwrite the values that are already there, or would you
want to insert a blank row? Is the value in A3 a row number? Where to you
want D5:G5 to go? D to G of Database?
Or would you rather that the numbers j...simple line graph
I am a church consultant, and I want to make a simple line graph to
paste into my Powerpoint presentation, showing the rise and fall of
our membership numbers, from nothing up to 11 million, and then down
to 7 million. I don't know how to do that.
Tom in Texas
Why not just create the chart in PowerPoint? It uses the same tools, as does
You don't give enough info regarding the data to be plotted for any specific
direction, but if you have a look at either Word or PPT Help on the topic:
Create a chart
you shouldn't have any problem.
...Drawing lines in a CListCtrl
Hi, I am using a CListCtrl in LVS_ICON mode to create a tree structure of my
icons (which are the bones of a skinned mesh). I have the icons all drawing
OK, but would like to draw a red line to link a parent to a child and a blue
line to link siblings.
I have tried various ways of getting the lines to draw, but cannot get the
control to draw both the items and lines at the same time. If I over-ride
the WM_PAINT message in my CListCtrl derived class and draw the lines, I
cannot see the items.
If instead I write a separate routine to draw the lines that is called by
the dialog class, ...