Table Layout/Field lookup
I have a table in Access which holds a list of codes (104 records), each
code has Issue text translations for 10+ countries. Currently it is a flat
Code Issue A B C
each letter representing a different country.
Is this the best way to have the table, or should it be relational with one
table for 104 codes and one table containing the translations (ie if 10
countries this would results in 1040 records).
If done the first way I am struggling to be able to extract just one
countries Issues. I have a table holding the current country code though a...Copy paste a table column into another table
Using Word 2007.
I have two identical documents, one in English and the other in Spanish.
I have a table that contain 4 columns and rows.
I want to copy the last three columns from my ENG to my SPA. When I try to
do this, I paste over the 3 selected columns in my SPA and all hell breaks
loose. There is no paste special.
A suggestion would be appreciated.
What happens, exactly?
Microsoft Word MVP
> Using Word 2007.
> I have two identical documents, one in Engli...Using formula to create multiple versions of a Graphs
I would like to be able to use a formula in an Excel 2003 graph, to
dynamically modify the source and lable data of a graph based on a cell
When I enter the number 1 into cell "a1" I would like to have the graph
automatically change to show the map points related to report 1, when I enter
2 inot "A1", I would like the source data to change to show points related to
How can this be done?
On Thu, 26 Jul 2007, in microsoft.public.excel.charting,
BarryL <BarryL@discussions.microsoft.com> said:
>I would like to be able to use a...Using lookup to find todays data and display in different worksheet
I am trying to write a formula.What I need is:
On sheet 1 column A I have a list of dates (for next 2 years). With
varying data in column C E G & J.
On sheet 2 A1 I want it to lookup for todays date and display the data
from the corrosponding row from colmn C, in A2 I want data from E, A3
data from G and A4 data from J.
On sheet 2 Row 2 I want the same but for tomorrow.
and again Row 3 for the next day.
Help I have tried lots of variations but with my limited knowledge
can't solve it!
All the best
You need to use the vlookup.
on sheet 2:
[A1] =toda...Can receive but not send using Outlook 2007 beta
I am using the Outlook 2007 beta. I can receive all my email fine. When I
send email out, it looks like it's sending okay, but it never gets delivered
to the recipients. This has been occurring just the last few days. And it's
not just Yahoo that I have a problem with. No one using ANY ISP is getting my
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/ou...table #3
I need help making a table. I want to make a table in a worksheet (sheet 2)
that incorporates numbers that are calculated in another worksheet (worksheet
1) in the same workbook.
The 1st column of the table contains a list of numbers (loan amounts). The
2nd and 3rd columns are to contain numbers (calculation 1 & calculation 2)
that correspond to the numbers in the 1st column. Worksheet 1 is a modified
loan amortization calculator. Calculation 1 & calculation 2 are specific to
the loan amount entered. In the table, the 1st cell of the 1st column will be
10,000 and increase by 5,...Create a Chart using a Macro
I would like automatically generate a Gantt style graph though use of a
Macro and a little button. I have the following data
Does anyone have some code that I can just use?
Scott, I don't have a Macro but there is a GANTT chart available at:-
Item Number 78.
You might like to download this.
If my comments have helped please hit Yes.
> Hi all,
> I would like automatical...Floating a table.
Can you float a table instead of having it inline as you can a picture?
See the Word help topic "Wrap text around a table"
On 7/04/10 2:12 PM, in article uHYSGig1KHA.5828@TK2MSFTNGP02.phx.gbl,
"tshad" <email@example.com> wrote:
> Can you float a table instead of having it inline as you can a picture?
The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!
John McGhie, Microsoft MVP (Word, Ma...First 10 numbers
I have a query that pulls together states from a program. I group the states
and added the Count aggregate to the state field. I want access to display
the top 10 states including an extra entry if two states have the same number.
I hope this is clear.
Using top 10 should work
SELECT TOP 10 States, Count(SomeField)
GROUP BY States
ORDER BY Count(SomeField) Desc
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County
> I have a query that pulls together states f...PictureIt!99 disappears suddenly while in use
I've just recently started experienceing the problem of the program just closing suddenly on me when I try to crop or make a picture transparent or other activities...I've uninstalled and reinstalled but to no avail. I am suspecting a registry problem but don't know what to do...
Although someone here might be able to help you (we have some terrific
people here), may I suggest visiting the newsgroup for Picture It!? This is
for Publisher which is a completely different program.
[And some people here are kind of snobby about how Picture It! is a "kiddie
program" (not my ...Adding fields to table like LTP1.......LTPn after query execution
UPDATE smallcapm INNER JOIN ppcsmlcap ON smallcapm.ScripCode = ppcsmlcap.
ScripCode SET smallcapm.LTP7 = [ppcsmlcap].[ltp];
I am having a table smallcapm with fields LTP1,LTP2,LTP3........LTP30.By
using above update query i am updating LTP1,LTP2,LTP3....... field of the
table smallcapm from table ppcsmlcap having new value of LTP each time.
Following is my requirement :
1. Instead of modifying the above query before running it as per the field
like LTP1,LTP2,LTP3.... i want the query to go to the next field ie. from
LTP1 to LTP2 to LTP3 etc by successive execution of the query...Lookup table troubles in query
I am using a database, that I admit I created before I was the wiser, and
used combo boxes (lookup fields via the Wizard) in the database table. The
database is now filled with data.
The table has multiple fields, but there are four fields from which I would
like to extract data and combine into one field. Field one is a yes/no type
and the other three consist of combo boxes. In building a SQL statement in
the query builder, I am unable to create a statement that uses data in the
combo box fields as a filter--as you would expect. It is unable to find the
criteria that I specify in...Make table from sql view
I'm using sql 2000 and Access 2003. In Access you can run a Make Table Query.
Is there a way to do something like this using a sql View within Access?
Thanks for the help,
Here's an indirect answer that may help you to figure out other issues in the
Make a temporary Make Table Query in design view and then select View, SQL
View from the menu bar. You can see the SQL code behind the GUI Design view
of the query. This will show you how to code it in SQL.
> I'm using sql 2000 and Access 2003. In Access you can run a Make Table Que...Deserializing an Object from XML Using Schema
I need to deserialize an existing object (not generate its code) from a
serialized XML file.
The only information I have about how the deserialization method is an input
XML schema (which can vary) associated with the XML file containing the
serialized object data. Therefore pre-defining it in code using xml
attributes on the serialized class narrows it to only one serialization
method and won't do.
How can I use the schema to deserialize the object?
"Veilchen" <Veilchen@discussions.microsoft.com> wrote in message
news:A71F15AB-7D2C-4E50-97DB-...Page Numbering #2
I can't figure out how to begin my page numbering with
something other than "1" in the Master pages? Please
If you are using Publisher 2002, go to Insert>Section. If
you are using Microsoft Publisher 2000 and older, go to
Tools>Options>General Tab>Start with page.
Microsoft Publisher MVP
>I can't figure out how to begin my page numbering with
>something other than "1" in the Master pages? Please
...Table Layout Question
I have a table that i need into a different layout..
Name Henry Sally Fran Mark Jared
House # 2 6 9 7 3
House style A B C D E
Porch Y Y N Y Y
Fence N N Y N N
Dog/Cat Dog Dog Cat Cat Dog
I want to lay it out like so:
Name House # House style Porch Fence Dog/Cat
Fran Data from each individual is dropped into the
c...+1 added to phone number
some phone numbers (in contacts) have "+1" added before the area code, some
do not. this is true even for area codes that are not local.
i have tried the phone number settings, but + is not allowed as a symbol.
is there a way to tell outlook to add "+1" to all area codes, both for those
currently entered? and for new ones?
jeffrey <firstname.lastname@example.org> wrote:
> is there a way to tell outlook to add "+1" to all area codes, both
> for those currently entered? and for new ones?
Did you import any of these contacts?
You might want to...Pivot Table from 2 worksheets
I thought I read somewhere that you can create one pivot table from two
worksheets. Does anyone know how to do this in Excel 2003? I need to create
one and don't know how. Thanks so much.
Take a look here
Post back to this thread if you are still having problems
> I thought I read somewhere that you can create one pivot table from two
> worksheets. Does anyone know how to do this in Excel 2003? I need to create
> one and don't know how. Thanks so much.
...avoiding use of UpdateData() and GetdlgItem() with radiobuttons ???
The suggestions made by J.M. Newcomer in his articles
not to use UpdateData and GetDlgItem in a Singele Dialog Apllication sound
very convincing to me. And I would like to make it so in my future
Since I am a real newbie I can not figure out a way to avoid it when using
RadioButtons. In his article Newcomer says that I would have to set the
WS_GROUP flag for each and every radiobutton. This seems rather strange to
me, because then each Radiobutton has its own group.
Als...Saving Excel ranges as database tables
I belive you can save/convert Excel spreadsheets to database file formats. Do
you know how?
You can save the active sheet as a dbf file. File|SaveAs|Type db1,db2 or db3.
Then in Access you can open up this file (I've Just doneit).
But I think that you can open Excel files directly in Access but I'm not
sure about choosing the data sheet. Why not just try it and see.
> I belive you can save/convert Excel spreadsheets to database file formats. Do
> you know how?
> Many thanks
>...Using multiple conditions for a formula
I'm using a formula to calculate average call length for some staff an
want to "bullet proof" it a little. I originally had 4 items t
calculate and used counta to verify if all 4 fields were filled i
before completing the calculation. What I need to do now is accoun
for 3 seperate types of calls. I've modified the formula to calculat
the info properly, but I'm having troubles with the "if" statement. I
order to run the calculations for the 3 different queues, 4 variable
must be filled in. The first queue's data is entered into C4, D4, E4
F4 the second...Coverting linked tables into local tables
I have an Access application whose tables are linked to a remote SQL server
database –the data resides in SQL server. I do not have control over the
I would like to create an Access database (a new database) whose tables are
local –reside in Access- and contain all the data in the linked tables. This
database should also contain the other databases objects: forms, modules,
Is there an easy way to accomplish this?
>I have an Access application whose tables are linked to a remote SQL server
>database –the data resides in SQL ser...using SetBitmap
I wrote a program that is a dialog box and has a callback function. In
the callback function i need to change a picture that is in the dialog
Since the Callback function isnt in the same class as the dialog box i
cant use -(CStatic*) GetDlgItem( IDC_IMAGE);
and have to use - (CStatic*) GetDlgItem(g_hwnd, IDC_IMAGE);
In the first case it works... In the second case (which is what i
actually need) it throws an exception.
the code looks like this -
hBitmap = (HBITMAP)::LoadImage( NULL, "c:\\tactix.bmp", IMAGE_BITMAP,
0, 0, LR_DEFAULTSIZE | LR_LOADFROMFILE);
pImage = (CStat...Pivot Tables and the getpivotdata formula
I use a pivottable to organise data in a list and then use th
getpivotdata formula to pull the data into a customised report.
I have run into a problem now where I try to copy the file and create
new one for the present week. I change the source data however th
getpivotdata formulas all now show ref! error. I've checked the formul
and see nothing wrong. Can anyone help me? please copy your response t
Maxxin's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=...Data table with inputs from a differente worksheet
How can i create a data table in excel 2007, with inputs, formulas and
calculation from a diferent worksheet?
If the cell A1 of Sheet2 has the value 10, then the formula =Sheet2!A1 will
return the value 10
Let's say I want to make the a formula on Sheet1 to sum a range D1:D5 on
Type =SUM(; open Sheet2, and select the range D1:D5, type ); click the
green check mark in Formula Bar or press Enter key to commit formula
Not that if the sheet's name has spaces in it I will get a formulas like
=SUM('Jan Sales'!D1:D5 - observe the single quotes
Does this answer...