Updating Table with a form
Center for technica education
I have Two Tables ,a Student Name Table with Two Fields, Student Id and
Student Name the other table is a Rubic Table and has the same two fields
along with other fields. I have created a form with a combo box(Names) on the
form and I am trying to get the Name and the Student Id to be entered into
the into the Rubic Table fields but I can't seem to get the Student Id to be
entered. I know I am doing something stupid but I can't seem to make it work.
Thank you in advance for all the help. You guys are great.
On Mon, 17 May 2010 15:18...Extract and Reverse Text
I am trying to extract text and reverse it. Here is a example.
Located in Cell A1
ABC Company-Smith, Joe
I am trying to have in Cell D1
The line in cell A1 will always have the " - " between company and the
name and with that I can
seperate the text and I can get it to reverse the name. I can not get
it to do it togeather.
The Name will always have a " , " between the last and first name.
The name could have a middle name.
I don't know if this can be done.
Thank you very much for your help.
Message posted from http://www.ExcelForum.com/
Thi...The scale on vertical axis equals to scale on vertical axis of ano
I have a chart that displays 'before product implementation' scenario and
another one next to it that dispalys 'after product implementation'. The user
will have two countries to choose from so I have to leave the scale on auto
rather than fix it because the the countries have very different size
What I would like to do is to make the vertical scale of graph 1 equal to
the vertical scale of graph 2 so that I can show the impact of the product
more clearly. Is there a way to do this which doesn't involved fixing the
Many thanks...Text to Minutes:Seconds
Good morning all.
I have recently been given an export of data from a program that i
text (delimited), which I can import fine. The problem I have is when
want to work with the data as minutes. By default, Excel is treatin
them as hours (because they are in the **:** format, not the **:**:*
My question is this. Is there a way to take all my text value and mak
them all be 00:+My minutes:My Seconds? Nothing will go over 60 minutes
the largest value is 21:39, the smallest value is :31 (exactly lik
that. The program didn't export a leading zero for this. There are onl
3 values lik...Sorting with merged Cells
When I attempt to sort a section of a spreadsheet which
has columns containing merged cells and other columns not
containing merged cells, I get the message that you must
have all of the merged cells be the same size and it wont
let me sort. Is there a method for doing sorts with some
merged cells that will work on both EXCEL 97 and EXCEL
In my opinion, merged cells was one of the worst features put into Excel.
New users of Excel get themselves into much trouble with merged cells.
Great for presentations after all the sorting, filtering, copy/pasting is
complete, but...EXCEL to TEXT file
I know how to convert .txt file to excel spreadsheet, but how do you
get EXEL spreadsheet to a .txt file ?
Thanx in advance
just save it as 'Text' file. see the options in the SaveAs dialog
> I know how to convert .txt file to excel spreadsheet, but how do you
> get EXEL spreadsheet to a .txt file ?
> Thanx in advance
"Steve" <email@example.com> wrote
> I know how to convert .txt file to excel spreadsheet, but how do you
> get EXEL spreadsheet to a .txt file ?
In addition to what Frank ...Missing email content, body text, from etc
I have one user on our exchange 5.0 system thats having some weird problems.
We have a exchange 5.0 box that handles internal mail. We also have pop
accounts with our ISP. In the client (Outlook 2000) I get the pop account to
drop all the pop email into the exchange mailbox.
Everything seems to be working okay from inside the network. We have another
building with computers setup. This computers (XP) have a vpn connection and
outlook XP set up the same as it would be on the internal network. Users
connect via the vpn connection and then open outlook. It shows their
exchange box and also coll...tabbed form each tab shows the entry from a field from the a table
I have a personal kennel program. At the moment I have a form with the
Clients info & a sub form with each of the dog's info. I have the sub form
set up as a single form view with each of the dog's information shown.
Question: Is there a way that I can make a form that shows the client info
AND have a tabbed form with each tab shows each dog? I have a table called
Dogs. In that table I have a field called DogName with (lets say) Rover,
Jake, Sam, etc.
I want a tabbed field with Tab 1 showing Rover's info.
Now if a client has 2 dogs (Jake & Sam), then tab 1 wil...Vertical line isn't vertical!
Hi All -
I need to insert a 'dynamic' vertical line into a line-chart -- the
line will separate the Past from the Future. After some searching, I
found Jon Peltier's site, which had some really good information on it
...... but I just can't get it work!
Right now, the vertical line is in the correct spot and 'moves'
properly -- but the line isn't quite horizontal, more of an 85deg angle
(like this: / ). The vertical line is definitely setup as an XY
scatter connected with a line (no markers). What am I doing wrong? Or
did I miss a step?
Hello ag...referencing cell range in different excel files
I have files that individuals are updating individual schedule data that
I want to bring it together in a master sheet. I tried using reference
for just one cell and keep getting the REF! error. I would like to
reference the server name instead of the drive letter it is mapped to
Thanks for your help!
Here is the syntax I am using - just trying to see cell C!0:
us1n50 maps to my U: drive.
Message posted from http://www.ExcelTip.com/...link update within workbook failing
Using XL2002 under WinXP, there are two worksheets in same workbook.
Cell A1 in sheet 2 refers to cell A1 in sheet 1 using formula:
The problem is that contents of Sheet2, A1 doesn't update when cell A1
in Sheet 1 updates even when recalculation (F9) is forced. The contents
of Cell A1 in Sheet 1 is a formula. i.e.
data > Sheet 1,A1 > Sheet 2, A1
Sheet 2, A1 doesn't change when data changes.
The contents of Sheet 2, Cell A1 will update when the formula in Sheet
1, Cell A1 is modified. Problem doesn't seem to be related to protected
posted on ...1 Page for every CELL!!
Hi, I would like to think that I know my way around excel pretty well but
this has really go me!!
Suddenly spreadsheets that were printing on one page and have been for weeks
have switched to a print layout of one page per cell! I have tried:
Adjusting print boundaries manually.
Adjusting % scale
Changing file- print area.
...and just about anything else I can think of.
Can anyone help- it's really urgent!!?
'Insert - Remove pagebreaks'
"Naomi" <Naomi@discussions.microsoft.com> schrieb im Newsbeitrag
ne...Link chart axes' scale values to cells
Hello Everyone. I have some sort of a problem with linking chart axe
(min and max values) to cell values in a worksheet. I am using th
macro that I found in Mr Peltier' site:
It worked just fine for a simple test I was doing.. BUT, I came up wit
the idea of assigning to the cells (the cells that contain the scal
params) some worksheet functions, to determine the values from a set o
data. When I did this, the macro didn't work anymore. It didn't pop u
any errors or such things, it just didn't adjust the chart anymo...Extra spaces when I insert text
When I forward a message but need to edit the text in the body of the message
(the message in the forwarded email) OL automatically places an extra space
before the inserted text. I tried putting it right next to the previous
word, but then I have an extra trailing space.
I am using OL 2003. Messages are composed in HTML .
Any ideas of why this is happening and how to fix it?
"smhish" wrote in message
> When I forward a message but need to edit the text in the body of the
> (the message in the fo...Pivot table form 05-15-10
I have a pivot table form based on a query
the data contains names and course dates in the following format
Gas Check Oil Check
Name Date got Date Expires Date got Date Expires
Peter 1-1-2007 1-1-2010 1-2-2008 1-2-2010
i am trying to make the form highlight the date expires field if it is less
than todays date
cant get the conditional format to work
must be missing something
any help would be appreciated
When a case is resolved, there is a dropdown to select
the amount of "Billable Time" for the case. I have
searched tables but cannot find where this data is
stored. Is there anyone that know the schema where this
data is kept?
When you resolve a case, the resolution screen fields are added into the
activity table as a resolution type of activity. The Billable Time value
appears in the TimeSpent field. (While building my auditing application,
VAST, I've had to become much more of a CRM schema expert that I ever wanted
to be - by the way, you can see these reso...how do i freeze a vertical column & horizontal row in excel?
I am trying to freeze a vertical column and a horizontal row in the one
document...can anyone help?
click underneath and to the right of what you want to "freeze" (ie if row 1
and column A click in B2)
choose window / freeze panes
"Lainey" <Lainey@discussions.microsoft.com> wrote in message
>I am trying to freeze a vertical column and a horizontal row in the one
> document...can anyone help?
...How do I put drawing objects behind text/cells in a spreadsheet?
Using a background will not work because I am dealing with mutliple objects
which need regular moving and changing.
since objects sit on top of the sheet, i am not sure you
can do that unless the object has a transparent setting.
>Using a background will not work because I am dealing
with mutliple objects
>which need regular moving and changing.
...Total Within A Query
I have the following query the gives me the total Balance by pool. I'm
Trying divide the Sum of each pool to the over all balance within a query.
SELECT POOL, Sum(Portfolio.Balance) AS SumOfBalance
GROUP BY Portfolio.POOL
Pool Balance %
2006-01 10 67%
2006-02 5 33%
One way to approach this:
SELECT Pool, Sum(Balance) as SumOfBalance,
SumOfBalance/DSUM("Balance", "Portfolio") as Pct
GROUP BY PortFolio
Another that would work is the following. I believe this would be faster
with a lar...CRichEdit Control -Vertical Allignment(Visio Type)
Iam looking to insert text in RichEdit Control so that it is
centered/left/right vertically and by default VC++,CRichEdit supports
Horizantal allilgnment and i would like to do similar to Visio if we drag a
box and enter the text and we have both options(Horizantal/Vertical) to set
the text in the box and any expert comments would be helpful
Thanks and Regards
...Import PO from a text file?
Is there a way to import and create POs from a text file, xml, or
something like that?
We have version 1.2
Do you need of a tool that create PO for you?
Do you have one?
I could use some information on it
"Antonio Mazzeo" wrote:
> Do you need of a tool that create PO for you?
Yes, I have.. but with my customer rules and my text file :)
Does anyone have anything like this already? An add-in?
I'm very interested.
"Antonio Mazzeo" <firstname.lastname@example.org> wrote in message
news:uFZ...test currency format of cell
I have several cells format as currency.
The cells can be of different currrenc=EEes euro, dollars, british
Is there a way to test if a cell is a different format?
I would like to use this information to later check the exchange rate
in a lookup table.
First enter this tiny UDF:
Function txet(r As Range) As String
txet = r.Cells(1, 1).Text
This function converts the display value into a string. If A1 displays:
then =txet(A1) will have the pound symbol as its first character. You can
use it in other formula:
...Country Prefix in same cell
I'm trying to pull country prefixes for matching countries from the second
sheet that has recurring countries with respective prefix to the first sheet
that is not recurring, prefix for same country in one cell separated by comma.
Please see attached link for a visual description.
Will appreciate your input.
try using a Pivot Tablej
or a macro solution
of course this is just using the second sheet as input in creating...text to appear at top of cell
in every cell I am tapping Alt and return so all the text appears in one box
when the box is filled i manually drag the box down so all text is diaplayed
rather half of it
1. Is there a shortcut way to apply this to all cells so that the text will
display in one cell automatically in all cells and it automaitcally returns
down so all text is diaplayes
2. When doing this in all cells the text displays in the bottom how can i
set it so the text displays in the top
Hit ctrl-a (twice in xl2003) to select all the cells.
(You could also just select the rows you want...Referencing Database tables with excel functions
I have a number of large data tables in a SQL database that I need to
access from Excel. Currently I move the tables to Excel and use each
column as a range in a SumProduct formula, creating a single cell
result for each column.
I would like to expand the number of sumproduct functions to the point
that moving all the SQL tables into Excel is impractical. Can someone
tell me if and how I could directly reference the SQL data without
brining it into EXCEL. Esentially I wish to change
sumproduct(a1:a400,d1:d400) into an expression like
sumproduct(a1:a400, reference to external datasource).