converting tabular structures in a Word document into an actual table or reading data from the tabular structures using VBA code
I have a macro which can read the last cell/column of all tables in a
Word 2003/2007 document and store the data in an MS-Access table. But,
some Word documents have the data in structures like a table format
but are not actually tables. The structure looks like a table, but the
table borders are actually line connectors. These documents were
created by a software(VeryPDF PDF to Word converter) which converted
the PDF documents(the original format these documents were) into Word
1. Is there a way I can convert/replace the tabular structures with
actual tables in Word so t...Twist Data?...
I've got the following in a dataset:
19 30 1200 FI FI 20030906 36
19 30 1324 FI FI 20030906 36
and I want the following result:
19 30 1200, 1324 FI FI 20030906 26
Any guess on how to do this?
Not quite clear:
The data is arranged in columns, I assume
It looks as if both items in the same column are the same, you want just one
item, otherwise the one in the top row first, then the one from the bottom row.
But what about the last 36s that should yield 26? Typo?
Does the dataset have more columns or more rows or both? And how big is it?...moving payables data from open to history
A client says that someone imported data about a year or two ago into Great
Plains from their AS400.
Many payables documents that were imported should have been coded during the
import as open, instead of history. The client knows that she can take care
of this herself within two hours, by simply turning off the posting to the GL
and entering and posting the payables documents to move them to history.
But, she is wondering if there is a quick and easy way to do this on the
I'm familiar with the open and history payables tables within GP. And, I
know through a T...merging 2 cells without losing data?
How can I merge 2 cells without losing data from the other cell?
Not possible I'm afraid. Try placing the dat from both cells into one
and use "Center across selection" under Format>Cells>Alignment
Merge cells always end up causing grief. they are best avoided.
***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****
"bob" <email@example.com> wrote in message
> How can I merge 2 cells without losing data from the other...Problems Converting Data from Quicken 2001 Deluxe to MS Money
I have a relatively new Compaq Desktop (2.5 GHz Celeron with 512 MB RAM).
I have a Viewsonic Pocket PC and I wanted to use it to track my financial
data so I purchased Money 2003 Standard.
I tried several times to convert my Qucken Data (it's a big file--I've
been using Quicken since 1995). My Quicken program is Quicken 2001
Anyway, the MS Money program started to convert and after a few minutes
"Your Quicken file could not be converted. Money could not convert your
Quicken file. You might have run out of disk space or system memory. Try
closing othe...Trying to create an Update query based on HR data to find upline V
Hi All, looking for some advice. I have an HR table that contains employee
information but does not contain management chain info. Basically i am trying
to determine who the employees upline VP is. The fields i have to work with
are [Employee Name], [Manager Name] and [Job Title]. I figure the logic would
be to check the employees' manager and if the manager is a VP (based on job
title), return the manager's name to a field called [VP]. If the manager is
not a VP then check that manager's manager, so on and so forth until a VP is
Any ideas would be much appr...Transformation of data into columns
I have the data from a flattened spreadsheet in a table in the
f1 f2 f3
period to: Scheme1 Scheme2
31/01/2005 Net Gross
28/02/2005 Net Gross
31/03/2005 Net Gross
30/04/2005 Net Gross
31/05/2005 Net Gross
30/06/2005 Net Gross
31/0...How can I sort duplicate text data in excel?
I have a large list of noames that I need to make sure that none of them are
duplicated. Is there a way to have excel check it quisker than me reading
every name until I find a duplicate?
After selecting your data go to filter Advanced filter and check "Unique
You can even copy it to another area all uniques entries if you want to ...
"TinaScheu" <TinaScheu@discussions.microsoft.com> wrote in message
>I have a large list of noames that I need to make sure that none of them
>...Insert,Update Data in sage (MS Access Linked tables) using Vb.net form
I am developing application using vb.net which requires integration with SAGE
LINE 50 (Accounting software ) V11... The data which SAGE is using is MC
ACCESS 2003 database... with linked tables in it... Now I Have developed the
Sage connection using ODBC which works fine when reading the record but
cannot Add or Update record into the Linked tables.... When i debug the
program the error is at the line where it has...
Can anybody Help ?????
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/acce...Offline Database Sync #3
Is there anyway to manually sync the offline database with the online
database on the server?
We have a register that travels to several weekend shows. We use the
offline database when it travels and would like to reconnect it when it
returns to the store.
Since we process credit cards with a secure wireless connection, we want to
run a Z report each day and settle the EDC Batch for credit card
transactions. In order to accomplish that we do the following.
We sync the offline database before the show. Then modify the SO Admin to
point the primary database to the offline databas...Data Validation List not showing
I'm using Excel 2003. My data validation lists have stopped working on one
sheet in my workbook. It is working on all other sheets.
I have googled the problem and found the following advice:
1. Make sure freeze panes is off.... check.
2. Select "Show All" under Tools->Options->View->Objects ... check.
The problem remains. Any ideas?
"Stopped working" doesn't do much to describe your problem. When you select
one of the "stopped working" Data Validation cells, do you see the drop-down
arrow to the right of the cell? When you select t...Deleted items folder in o2k3
The big boss refuses to empty or archive his deleted items, now holding some
25,000 messages and approaching 3 gigs in size for the deleted items folder
Does Outlook treat messages in the deleted items folder any differently than
messages in other folders? Would it be better for him to never delete
messages since he doesn't really want to delete them?
It would be better to not delete them since Deleted Items... is for things
you want to get rid of.
"Wowbagger" <none> wrote in message
> The big boss refuses ..."x" button enables deletion.... can we put a focus trigger there?
on three forms, I put focus triggers on the "delete" button because I need
to validate some additional data before allowing the user to delete.
However, if the user clicks on the corner "x" button to close the form and
gets the dialogue box saying they have changes, do they want to "Save",
"Delete" or "Cancel", they can delete the record anyways. Is there any way
to put a focus trigger on the button of the dialogue box, or on the "x"
Thanks in advance.
I assume you are working with Dexterity.
To work with an add...Adding extra data options
Is there a way to customize CRM to allow for adding another heading? I would
like to add a second field similar to topic and would like to call it type.
Can you add extra data fileds and types in CRM 3.0?
You can add extra data fields to an entity. Go to entities customization at
> Is there a way to customize CRM to allow for adding another heading? I would
> like to add a second field similar to topic and would like to call it type.
> Can you add extra data ...make outlook automatically delete html mail with linked images
The junk mail filter should be able to automatically delete html mail with
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/community/en-us/default.mspx?mid=9e1b783b-c9c1-44f2-a1dd-93da59216c56&dg=microsoft.public.outloo...Retreive a deleted file
How can I retreive a delted file
If you have setup Excel to automatically create backup copies; then check
that folder for the last backed-up version....If it is from your PC, check
out the Recylcle Bin (on your desktop) and restore the file. If the file was
on a network drive you may need to contact your network administrator and
check whether they can recover.
Jacob (MVP - Excel)
> How can I retreive a delted file
Go into your Recycle Bin. If deleted from there;
...emails not showing up in deleted items until i do a find?
This just started happening a last week. A message comes
in the Inbox and I click the delete key so delete it.. so
far ok. then i go into the deleted items folder it's not
visible. but if i do a find then they show up in the find
box but still not in the folder. any ideas?
this program makes me crazy sometimes *s*
starindy <firstname.lastname@example.org> wrote:
> This just started happening a last week. A message comes
> in the Inbox and I click the delete key so delete it.. so
> far ok. then i go into the deleted items folder it's not
> visible. b...Database #2
I'm new to Outlook.
I hear of an Outlook database in other threads. Is this synonymous with the
..pst or .ost files people mention?
Does it corrupt often and if so are there tools to repair it?
There's a utility called ScanPST.EXE that will scan and attempt to repair
Yes, typically when a user says Outlook database they're referring to their
"Craig Roberts" <email@example.com> wrote in message
> I'm new to Outlook.
> I hear of an Outlook d...Using "fixed" decimal place function data for charts
Is there a way to graph data which utilizes the "fixed" function for decimal
places? When I try this it will not graph, as the data has become text or
something - even though I've selected number in the cell formats.
If you've fixed the number of digits using only number formats, the values remain
numeric, and they should chart just fine. This means selecting the range, going to
the Formatting menu and selecting Cells, and on the Number tab, selecting Number in
the category list, and setting a number of digits.
I'm not familiar with a "fixed function". I...How to delete incorrect entries from Dictionary
On occasion, Outlook 2000 recommends a spelling
that's obviously incorrect. I suppose that I clicked on a
word too hastily. I'd like to remove these incorrect entries
tools, options, spelling, edit dictionary (from any app that supports the
office spell check) - its also available from the spell check screen when
you press F7 or you can search for custom.dic and edit it with notepad.
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Author, Google and Other Search Engines (Visu...Deleting a Batch from company DB table SY00500
This is a multi-part message in MIME format.
Is there a way to see all the TRX in a Batch saved in SY00500.
Also, what if we delete a batch in SY00500 will there be any other place =
to look for; besides this? I had a batch sitting here for a long time =
and there were few (3) trxs ( Sales Credits) in it as well.
I wonder if I could retrieve those one by one and then delete them as =
well as these belong to a fiscal period which is closed plus we...Does table size make a difference in how well Access protects data
I am having a problem that has been going on for several weeks now. I am
slowly trying to figure it out. the problem is that Access 2003 keeps
deleting records after they are entered. Quick view of database: running
Access 2k3 back end and frontends, 12 machines access the DB at any one time,
mixture of Win2k Pro and Win XP pro all patches and service packs installed
for all OS's as well as Access 2k3. Running Client/server set up controlled
by Small Business Server 2k3. database resides on a machine running XP Pro.
when new orders are entered into the system, the DB will tell the d...Deleted email not going to Deleted Items folder
I am using Outlook 2003 on WinXP Pro SP2 setup with POP3 accounts.
When I delete an email it does not go to the Deleted Items folder - it
does not pormpt me it just disappears. The shift key is not being
This also happens when I drag an email to the Deleted Items folder - it
just disappears. However, if the email is Unread then it does stay. As
soon as I open the email it too disappears.
I have tried to upgrade to Office sp2 but is did not fix the problem
Change your View, Arrange by settings to All Messages instead of Unread ones.
> I am usin...Sending data with CAsyncSocket.
Please tell me if/where I am wrong...
If I have an established TCP connection using CAsyncSocket...
When I send data I will normally be sending a packet that is about 100 bytes
or so. I would send each packet with a separate call to "Send". Normally the
Send will return a value equal to the number of bytes I sent. I would just
write my code to call Send whenever I need to send a packet.
Normally I would never receive an error or an indication that fewer bytes
were sent. But if I did, I would handle this error.
There is no need for me to use the "OnSend" function. Co...PF-replication: SQL-Data -> PF-contacts
we have some customer information stored in our MS-SQL Server 2000 and
like to sync it with the contacts in our public folder (Exchange 2003).
Of course ye can do it manually, but is there a way to automate it?
Or is it possible to make a public folder with all data stored on the
sql-server? (kind of a view)