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...Time calculations for Scheduled vs Actual Employee Time and Wages 11-28-09
I am THRYING and TRYING to make a simple schedule worksheet for a manger to
use to calculate the time he schedules an employee to clock in and out and
what it will cost him in regards to his allocated budget and then to be able
to compare it after the job is completed. BUT time calculations have thrown
me for loop and I am stuck for hours on trying to calculate time fields.
PLEASE DEAR GOD can someone help me.
Below is a simple example of my worksheet.
A2 (Time IN) = 1:00 PM
A3 (Time OUT) = 5:00 PM
A4 (Time Worked) = 4:00 (h:mm format) ...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...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,...Windows Forms DataGridView
Could someone please tell me how I'd create the same datagrid functionality
(bind,add/edit/delete) from an asp.net page into a Windows form using the
DataGridView control? I am able to bind the control in the windows form but
not able to get add/edit/delete functionality working? Also need drop
downs, etc. in the grid. Event handlers? Buttons for each task? I'd
certainly appreciate any feedback?
It's a little bit different on the windows forms side of things. It took me
a while to get the hang of it too.
This MSDN posting should be helpful to you:
When I try to create a new contact, I get the following
Error Loading Form. Some of the needed controls may not
I'm using a custom form for contacts, and in the past when
I've encountered this, I just went to tools | forms |
choose a form... chosen the right form, it gets re-
installed and all's well in the world. That's not working
for me this time.
Thanks in advance.
You can try clearing the forms cache -- Choose Tools | Options | Other |
Advanced Options | Custom Forms, then click Manage Forms, then Clear Cache.
If t...Set access times
What would be the best method to set times when a connection is available
for internet access through SBS2008.
I want to restrict the times when an xbox 306 is allowed to connect to xbox
In a business environment, signed and ageeded to Computer Policy Manual.
In a home environement, "Kids, Listen Up!"
Please post the resolution to your
issue so others may benefit
Get Your SBS Health Check at
> What would be the best method to set times when a connection is
> for internet a...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...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...VBA forms
I'm using the following in a macro but it doesn't work:
If Cells.Select = "0" Then Selection.ClearContents
What should I change???
what are you trying to achieve ?
"One-Leg" <OneLeg@discussions.microsoft.com> schrieb im Newsbeitrag
> I'm using the following in a macro but it doesn't work:
> If Cells.Select = "0&quo...exporting mail settings and rules
I'd like to switch to using outlook instead of OE as my mail client but over
the years I've got a comprehensive set of rules configured and also about
25 different email addresses to check. I know I can export the message but
is there any way to export thee rules and email account settings?
I don't know a way of doing this from OE to Outlook. OE to OE is all I know
about. The two aren't easily translated.
"sniper" <firstname.lastname@example.org> wrote in message
> I'd like to switch to usin...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...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...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...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.
...form appearence or view
I've created a form named '' Employee List ''.
The form is suppose to appear as a dynamic form.
This form is accessed from a splash screen (main menu). When I click
the button on the main menu, the Employee List appears in a normal
form view ; not a dynamic table view.
I did change the form propreties so that the default view would be a
dynamic table but it dosen't seem to work..
Any ideas ?
On Oct 22, 1:05 pm, macdoum <macarpent...@netscape.ca> wrote:
> I've created a form named '' Employee List ''.
> The form is suppose...WLMD Cannot Be Set As Default Email Application
I runs on Windows 7 Ultimate, and I already set Windows Live Mail Desktop as
my default email application of my OS, but there often a message box appears
and tells me my OS has no default email client application, why? How can I
solve this problem? Thanks!
Are you in IE trying to use the Send Page / Send Link feature when you get
"Michael Cheng" <Michael Cheng@discussions.microsoft.com> wrote in message
> I runs on Windows 7 Ultimate, and I already set Windows Live Mail Desktop
> ...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
>...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...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=...telephone message form / tempalte
is there a standard, delivered "telephone message" form
that we could use in outlook? if not, any ideas on how to
would obviously want to be able to send this to anyone in
my company's email contact list and/or my personal outlook
in advance, thanks for the help
Go to below link, there are various forms (including phone message) that you may find useful. They are easy to setu
Good luck :
...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...Axapta 3.0: Setting the linktype of DataSources at runtime
I have a button on form. It's click-EventHandler contains a line:
CIRTRAStndTourOrderLine_ds.linkType(Transporteinheit.valueStr() ? 3 /*
InnerJoin */ : 4 /* OuterJoin */);
Where "CIRTRAStndTourOrderLine_ds" is the data source generated by MorphX
(CIRTRAStndTourOrderLine) is a table. "Transporteinheit" is a StringEdit.
The behaviour I would like to achieve is, that if I enter something into the
StringEdit it sets the linktype to InnerJoin otherwise to OuterJoin another
In MorphX I set the linktype to OuterJoin (as a default).
The problem i...Query or Table Description
all my database are developed in Access 2003... When viewing the queries in
2003 there is a 'Description' field. This is always viewable for all queries
AND is sortable. I use this field to put my queries sequence... This is how
I know the sequence of queries to run - I sort this field.
I also use this field to put notation for Tables.
Now in 2007 this field requires a right click and only one query description
is available at a time... So now I'm lost, some of my DB's have up to 100
I'm praying there is a solution for this.... Help
Thank y...Table of contents from Named ranges?
Just a quickie.
Is it possible to construct a table of contents from named ranges?
I have a spreadsheet with suppliers names and then their products. As i get
new suppliers, they get inserted into the list. This list now stands at 124
Obviously when i insert a new supplier, the list becomes incorrect.
I know that i can do this sort of thing with Word, but it doesn't seem to
import into Word at all well.
I have named the cell with the suppliers name, so that i have 43 named
I need to construct a simple table of contents with
suppliers name..........page 43