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...SasAs Issue: Automation Error
When i use the xlWorkBook.SaveAs(fileName,
Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue,
Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue,
misValue); it was giving me an error.
The issue got resolved when i changed the code to following
...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...GearWrench 81201 Four-Piece 3/8-Inch Drive Wobble Extension Set
Best deal: http:///index.php?id=B000NI93AW
When I got the extensions one had a manufacture defect. The male end of the 10" extension was dented before it was chrome plated and the ball was stuck in place, wich made the tool useless. I called Gear wrench and the shipped me a new one no questions asked to my door in 3 days.
Item #: KDT81201. Features & BenefitsUnique dual position drive extensions provide the ability to use as either a standard extension when fully inserted into the socket or as a wobble extension when partially...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...New Ex2003 SP2 installation teething problems. (Outlook issues)
I have just installed a new Ex2003 sp2 server for a customer. It is an
upgrade from a 7 year old Ex5.5 server. The 5.5 server is still up and
running, as I have to debug a few EX 200 problems. The first one is causeing
me a major headache, the rest are minor)
1 - Outlook - can not use cached exchange mode. As soon as I turn that on in
the outlook profile, the users are unable to open outlook sucessfuly
2 - IMF filter - where does the Archive option save the messages?
3 - Global Adress list - on the old 5.5 server in the recepients folder I
used to create aliases for the HK and Ch...Displaying a negative time
I've created a time sheet in excel for my work. One of my colleagues
however owes the organisation some hours. Sadly this is right at the
beginning of the year so I am having a bit of a problme setting it up
to display this.
She owes the organisation 7hrs 45mins. I tried entering into the cell
30/12/1903 16:15:00 however this then just displays that entry and
Is there any way I can get this to work?
Change to 1904 date system
Tools>Options> Calculation>1904 date system
"Colin Weir" <colin...Excel showing old or new version of file for 2
We have a matrix that we've built in Excel. It is a shared workbook.
As you open the file, an image of the most recent content appears for
just a few seconds, then it reverts to the old content. I believe we
have other files where it happens as well, but the old data appears for
just a few seconds, then the new data appears.
The one I'm most concerned with is the one where the new data shows
first, then is overlayed by the old data. I need to be able to get the
new data. I have taken a snapshot of the screen via the print screen
button, but I'd rather not recreate by hand, 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" <firstname.lastname@example.org> schrieb im Newsbeitrag
> I have implement a line chart b...DST issue
Do i really need to apply the DST patch if the server is based in Europe and
our users don't have anything to do with US?
Don't *have to*
MVP - Exchange
NEW blog location:
"lars" <email@example.com> wrote in message
> Do i really need to apply the DST patch if the server is based in Europe
> and our users don't have anything to do with US?
...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...Outlook 2003 issue after Windows 2003 SP1 install...
I was curious to know if anyone already found a fix to this issue :
When you are using Outlook 2003 on a Windows 2003 SP1 box (not the exchange
box, I really mean the outlook box), you can't connect anymore to the
exchange server (which is up to date).
Is there any fix for that ? I tried to deactivate firewall feature but
nothing changes, it still can't connect to the Exchange server. The only way
to fix this seems to be the rollback of Windows 2003 SP1 (?!?)
Can someone provide some input here ?
Any event in the Event viewer logs (on yours and the Exc...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
<>>< ><<> &...Chart formatting #3
Is there a way to shade certain areas of a line graph? I have a simple line
graph extending horizontally from point 1 to 10 on the x-axis. I would like
to shade the entire background area of the graph from points 2-4 and points
6-8. Is there a way to make the graph apear that the background is grayed
out between these points.
This has been sitting here a long time...
Make a combo chart. Start by locking the Y axis scale parameters (uncheck the auto
boxes). Add a series to your chart which has zero values where you want no shading
and <Y axis max> where ...Error displayed in summary section of report with no data
In an Access 2003 report which has a summary section which Sums a
value in the detail section, when there is no data #Error appears at
the Sum(myField) section. There is no sub reports on this report.
How can the #Error text not be shown when their is no data?
>In an Access 2003 report which has a summary section which Sums a
>value in the detail section, when there is no data #Error appears at
>the Sum(myField) section. There is no sub reports on this report.
>How can the #Error text not be shown when their is no data?
Try using something like:
=IIf(Re...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 ...Text to Columns issue with Date & Time #2
Apparently the answer was simpler than I thought. The suggestion o
copying the column and then formating the orignal and the new colum
for date and time respectively worked fine.
I also tried the 'text to columns' solution with 'other' checked an
the <Alt> 0160 but that did not work for me. I probably did somethin
I have a workable solution, so thank you all for your input
C Andrews's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1625
View this th...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 ...Weird Exchange 2003 Migration Issue
I'm finishing up an Exchange 2003 -->Exchange 2003 migration to a new
server. All the mailboxes have been moved over successfully and I haven't
yet uninstalled the first Exchange Server. Mail flow was working just fine
until I noticed yesterday...Only one user can no longer receive INTERNAL
emails. The users receive an NDR stating it couldn't' deliver in the time
specified. He can (A) send/receive from external domains, and (B) send to
the internal domain successfully. Weird thing is he had zero problems
receiving internal emails until yester...outlook express to outlook #3
I have both on my PC but the default is Outlook Express
and I want to use Outlook instead. How can I make my
outlook the default so I can exclussively use outlook?
Go into Internet Explorer | Tools | Internet Options | Programs. Set the
default e-mail program there.
Ben M. Schorr, OneNote-MVP
**I apologize but I am unable to respond to direct requests for assistance.
Please post questions and replies here in the newsgroup. Mahalo!
"jim" <firstname.lastname@example.org> wrote in message
news:048101c3ab01$668b0650$a301280a@phx....issue with textbox in form
I was wondering if i could get some help with the form.
I'd like to be able to take the cursor back to the text-box where there is
an error. The error may be produced because the entry data doesn't satisfy
For example, there is a textbox called age. I have the following code
Private Sub Age_Exit(Cancel As Integer)
If Me.Age < 20 Then
MsgBox "The age cannot be less than 20. Please check it again"
me.Age = "" ' Clear the box
How do i get the cursor back to the Textbox - age? i have tried to use