The tables tag has no wiki summary.
1
vote
1answer
19 views
Updating a table in oracle using another table rows
I want to update each row of a oracle table based on another table's rows.
To be more specific,
There's a table called Contact with the following fields:
code(PK), name, mobile, email
There's ...
0
votes
3answers
39 views
Excel table - delete rows not in filter
i have a very large table in excel (1000's of rows) and i filter it to only show 10 rows. I wonder if there is a way to delete the rows not shown [ ie dont meet filter conditions]? this would enable ...
0
votes
1answer
22 views
Prompt to select excel spreadsheets in Access?
I have a Microsoft Access 2007 database that uses excel spreadsheets to track changes between the two. A new file is generated every week. I then do a compare against the two of them with some custom ...
0
votes
0answers
8 views
How to return a double-clicked TreeTableNode? [migrated]
I'm working with Eclipse and I've got a question about TreeTables. The tree has several layers, so it's a bit nested. I want a window, showing some information about the node, to pop up, when a node ...
2
votes
5answers
86 views
How to reference a row value in a table in excel 2007 from another row such that sorting table doesn't change it?
Consider a table of employee name, age and employee manager. Employee manager is a reference to employee name in same table but different row. I tried this by referencing cell =A3
Now if I sort ...
0
votes
1answer
41 views
What formatting is applied in this Word 2010 table, and how can I prevent it from being applied in tables by default?
When I insert a table in my document the text in the cells looks like it is aligned to the top of the table. Only when I click the remove formatting button or apply the default style is the text ...
3
votes
2answers
143 views
How to paste table from MS Excel to Wolfram Mathematica?
When I am pasting a region from MS Excel, which contains multiple numbers, to Mathematica, I am getting just a long plain sequence of digits, i.e. one integer number in Mathematica.
How to have a ...
0
votes
0answers
26 views
How can I create a custom OpenOffice / LibreOffice Writer table AutoFormat scheme?
None of the basic table AutoFormat schemes in LibreOffice Writer have both an alternation style defined and no sum column/row style defined. If they have alternation, they always seem to have sums. ...
1
vote
1answer
96 views
How can I copy tables between word documents without having the format change?
I have two both word 2007 documents, A and B.
I want to copy a table from A to B, and that table's format is totally the same as I see in A, not automatically changing the format to B's template ...
0
votes
1answer
98 views
Pasting HTML table into Excel 2007 without modifying the format of each cell
I have a table in HTML having cells storing numbers like 123.0,123.00. When I use ctrl-A to copy the whole page into excel, 123.0 and 123.00 are all changed to 123, which is not something I want to ...
0
votes
4answers
58 views
What is the best way to manually edit and update data within a large table in MS SQL Server?
I have a table in MS SQL server which currently has around 800 records and 20 columns.
I want to manually update and add to the information within this table on a frequent basis.
Would exporting the ...
1
vote
2answers
107 views
Filter and reorder columns in Excel
I've got a service (phplist, a newsletter manager) that exports a user list with several fields. At the end of it, each user has one or more lists to which he has subscribed.
The problem is, that ...
1
vote
0answers
56 views
Org-mode - table columns alignment - little tweak
In org-mode when I am using tables I need either to set up somehow or change algorithm of alignment in columns.
By default there is text aligned to right with one whitespace character prepended. If ...
1
vote
1answer
44 views
Equivalent to rowspan in Microsoft Word tables
Is there an equivalent to the HTML tag rowspan when creating a Microsoft Word table? I seem to only be able to create rectangular grids.
1
vote
0answers
142 views
How to reset/change owner information of Fujitsu Lifebook T4220
I have bought a used Fujitsu Lifebook T4220 tablet, but the previous owner has set the owner information in the bios, and it can't be changed after setting it, how can i remove, reset or change it?
1
vote
2answers
237 views
Excel: text values in a pivot table?
I have a table (in MySQL) with 3 columns:
Location Category Supplier
A Computers Company X
A Printers Company Y
B Computers Company X
B ...
0
votes
1answer
50 views
PowerPoint 2007: Setting custom cell margins causes text to display as if centered
I'm using PowerPoint 2007 and have pasted in a table from Excel 2007. When I paste it in it automatically becomes a PowerPoint table, and looks fine. However, everything is quite squashed together, so ...
0
votes
1answer
36 views
Table AutoExpansion incorrectly changes formula
I have a table in an Excel sheet where one column is calculated.
When adding a new row by typing, the table automatically expands, but wrongly changes the formula of that column in the row above. It ...
1
vote
1answer
96 views
How do I move a table structure down in written documents?
I often run into this issue: I have a table (as in data in a table format) and the table is at the start of a document or email. I wish to move the table down the page but my cursor will only move to ...
0
votes
0answers
54 views
Want a software which can create image based product comparison tables for websites
I'm looking for some software or web-based tool which can create image based comparison tables for putting on a website, which can be used to comparing different products ..
However the angle is that ...
1
vote
0answers
15 views
I would like to highlight/shade table cells in two colors
This does not seem like a possiblility unless I can highlight the text in a second color. Can I add more highlight colors to the options available?
0
votes
1answer
22 views
How to create form that allows only one character in a cell
I would like to create a Microsoft Word document (doc or dot), that faciliates filling a form (or a table) in such a way that user types one character and the cursor is moved to the next cell. Like in ...
1
vote
2answers
377 views
How do I get rid of the extra space in tables with Microsoft Word 2003?
I am copying and pasting tables from another document (Word 2007) over to Word 2003 and when I do this, right click on the upper left hand corner of the table, AutoFit, AutoFit to Contents, I am left ...
0
votes
0answers
40 views
SQL table Referential Integrity
SQL 2008 - could someone please direct me in creating Referential Integrity in SQL Server mgr studio. The front end is MS Access, I now understand this cannot be done in Access when the tables are ...
1
vote
2answers
158 views
How do I pull data from multiple tables into one table in Access?
I have multiple tables that contain tasks according to their category. Each table represents that category. What I need to do is create a 'Master' table that then is able to pull data from ALL the ...
3
votes
2answers
1k views
How do I set the first value of AutoNumber in Access?
I don't need to reset the AutoNumber value like this question, but rather would like to first set the number to:
1001
Which then increments like normal:
1001
1002
1003
...
...
0
votes
1answer
143 views
How can I include only part of an image caption in a table of figures in Microsoft Word?
How can I include only part of an image caption in a table of figures in Microsoft Word?
For my dissertation I am writing long captions on all my figures. This makes my table of figures very ...
1
vote
1answer
874 views
How to adjust the thickness of SOME lines in a Word table
I have a table in Word 2010 and would like sets of rows to be distinguished from other sets, but still all be in the same table. So, I would like a thicker grid line between some of the rows. But I ...
0
votes
1answer
84 views
Start database in Fedora 13
How can I start to create, delete, etc., a table in Fedora 13? How can I initiate to create a basic table in Linux, what are the commands? Will I have to install firstly a database like ORACLE in my ...
2
votes
1answer
81 views
Combining more than 10 tables data in to one table
In Excel 2003 I was able to combine more than 10 tables' data in one pivot table through "Multiple Consolidation Range". However I couldn't seem to find the same option to do it in Excel 2007. Any ...
0
votes
1answer
68 views
Delete table in Writer but preserve the contents
Is there a way to "explode" a table in OpenOffice.org Writer?
That is, delete the table, but preserve its contents in the document?
3
votes
3answers
377 views
Flickering tables using Office 2002 on Windows 7
We are currently using Office 2002 on Windows XP but will be moving our users to Windows 7 in the next few months. Part of our business is writing research documents so there is heavy use of Word ...
2
votes
1answer
65 views
How can I prevent a table within a list from continuing the numbering scheme?
I'm writing a list of steps for some documentation, and want a simple table to show some settings based on conditions. The problem is that Word is adding a number to each cell in the table, when the ...
1
vote
2answers
227 views
Separate tables or single table with queries?
I'm making an employee information database. I need to handle employees that are separated from the company. Should I a. set up a query with a macro to send separated employees to a separate table, or ...
0
votes
1answer
344 views
Microsoft Word: How to line up text beside a table's row separators?
this is driving me mad:
I need to write text that lines up like this
0
votes
1answer
73 views
Word Numbered List Issue — within tables & boxes
Is it asking too much of word to renumber lists within tables within inserted objects (standard rectangular boxes etc.)?
0
votes
3answers
217 views
Excel 2007: “Format as Table” Increments Column Names
I love using the formatting styles for tables in Excel 2007, but in my data I'm using the same column name for multiple columns. When I format my table using the pre-defined styles, it automatically ...
0
votes
1answer
237 views
Using the INDIRECT() function with table formats in Excel 2007 [closed]
My purpose is to create data validation dropdown lists in Excel that reference whole columns in a table-formatted set of data. Ultimately, I hope to create a dynamically changing set of data by which ...
0
votes
3answers
694 views
Dates not recognized as dates in pivot table pulling directly from SQL Server
My pivot pulls from an external data source with a date column. Excel doesn't see this column as a date and the 'Format Cells' option panel doesn't change how the dates are displayed. The cell data is ...
1
vote
1answer
2k views
How to properly merge two tables in MS Word
This could be the dumbest question ever. But I would ask it anyway. Because I'm really pissed of at how MS Word 2010 handles what I really want to do. In this case merge 2 tables together. I do the ...
0
votes
1answer
430 views
Can't type text into table cell when form is protected in Word 2002
I created several tables in an Word 2002 document to act as a form for users to fill out. In some cells I added check boxes and dropdown lists for people to select options from.
When I click on the ...
1
vote
1answer
166 views
Dynamic row height on Word tables, based on mail-merged contents
I'm having to work with some Word templates which contain nested tables of mail-merged fields. I need the row height of one of the child tables to have a minimum height but be able to expand (height ...
0
votes
1answer
119 views
How to add a footer to a table in Microsoft Word?
I have a table that is longer than one page. I have found the option to make the header of the table to be added to the second portion of the table after the page break. Is there a way to do the same ...
0
votes
1answer
549 views
How can I import a CSV file into an SQLite table that doesn't allow null values?
I've been using the SQLite Manager extension for Firefox to edit my Chrome web data file in order to restore my keyword searches, and I think I have everything in place except that when I import a CSV ...
0
votes
1answer
188 views
How to maintain normal ICS routing after the ICS host connects to a VPN?
I have two computers in my home sharing an internet connection. They both have Windows XP and are connected together with a cross-over cable and share the internet connection via Windows ICS.
The ...
0
votes
1answer
381 views
Route Split for OS X
I'm attempting to install a static route for a Mac Pro desktop. I'm using Route Split 1.4, which creates a startup script called /etc/routes.sh (the script waits for the interface to come online ...
0
votes
1answer
122 views
Is is possible to apply separate formatting to multiple different Excel table columns?
I have some calculated columns in an Excel (2007) table. I'd like to distinguish them visually from the user-input columns in some way, but without losing the nifty automatic row banding. It looks ...
1
vote
1answer
768 views
Pasting into multiple table cells in MS Word 2007
The situation: I have the text "123-456" in the clipboard, cut from typing earlier in Word. I then create a 4x4 table, select all cells within that table, and then select Paste.
The end result I'm ...
0
votes
0answers
256 views
MySQL on mac, cannot create tables
Installed mysql dmg package from mysql.com. Started it with the helper.
The database runs, can login as root, create users. Did create a database called "dhcs".
I can't create a table..
mysql> use ...
0
votes
3answers
228 views
How to use excel to disply a list of cells, depending on dropdown box selection
What I want to achieve:
select list A, B or C from a dropdown, when pressed, list of values displays underneath. I would also like the list to be populated from items in a table (which would have ...
