How to display a field from a different table in a list box?
I'm trying to create this flow action without sucess:
I've a form with a combo box (with a list of values) and a list box.
What I want is to select a value from the combo and display in the listbox,
one colunm of one specific table.
This is possible to do?
> I've a form with a combo box (with a list of values) and a list box.
> What I want is to select a value from the combo and display in the listbox,
> one colunm of one specific table.
> This is possible to do?
Yes, take a look at the RowSource property of the ListBox.
I have created a template in word which I call through a VB script from
excel. The excel data is populated in the word every time I run this script.
Everything works fine and the data get populated.
I have a header in the template which is represents one of the fields in the
excel sheet. The header shows the correct linked value for the first 10 pages
but then on shows the variable name instead of the value. I have no idea why
it does that?
can someone help
The code is as follows:
For iCurrentRow = 1 To iLastRow
If ActiveSheet.Range("B" & iCurrentRow...Precision in Excel 2002
I have read complaints about lack of agreement in the
coefficients of polynomials obtained by fitting trendlines on
the graph and those obtained from LINEST. I had occasion to do
some experiments yesterday using a third order polynomial with
Excel 2002 and, as far as I can tell, at the same number of
decimal places the coefficient results are identical. The data
used had random errors and was not from an exact curve.
Can anyone tell me which versions of Excel can be relied on or
else what problems I should look out for?
E-mail, with obv...Preventing Excel Time format
An Excel (2000) spreadsheet that I use regularly has had its column
formats (though fortunately not the data) corrupted following a PC
crash. There's a couple of columns that I use for storing
latitude and longitude data in the format eg 52:00:00.
Since the corruption, Excel insists on treating this column format as
Time (and adding a Date prefix if I try to edit one of the affected
cells). I know I encountered this same problem previously and managed
to fix it but can't remember the fix. If I select the colum and do
Format Cells | Text then all the values immediately change to decima...Excel 2007: Vlookup Problem
I don't use Vlookup much and it's not working for me. I know it's user error
so can you tell me what I did wrong?
I have two worksheets in my file. In the first one, I have a list of
addresses with a full unabbreviated US state name in column T, row 2. Column
U is blank because I want to put the two-digit state code in there (starting
In the second worksheet I have the full state name in Column A and the
two-digit code for it in Column B (rows 1-50).
Here's my formula starting in U2:
What is wrong?
...Editing Chart Data Table
I have a bar chart with 2 different series of data (Item
cost in $, and % of total volume delivered). I want to
create a data table under the chart, but have it only show
the values for the volume delivered and not the item
cost. Is there a way to exclude data from the data
...Excel Crashing with Outlook
Can anyone advise me what the problem is and how to fix it with Excel. What
happens is I might be working on a spreadsheet in Excel and then go to
outlook to send an email and Excel then crashes causing me to lose all my
work. I know one should regularly save one's work, but to have to do it
because you're sending an email is just rediculous.
Does anyone know the solution.
----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - ...Outlook issues after Exchange migration
We recently migrated Exchange 5.5 mailboxes to Exchange
2003 on a new domain. This was performed with the exmerge
utility in a 2 step process. Now there are 2 issues with
1) When a user types a recipient name into the address
field, the name autocompletes as normal. But when the mail
is sent, a message returns saying it is undeliverable.
However, if the user goes into the Contacts folder and
from there selects the same user to send a message to, it
2) If a user shares a calendar, specifying the user with
whom to share and the level of permissions, all users in ...Taskbar issue
I'm hoping someone can help me with this long-standing problem with both XP
and Vista on separate laptops and every computer I've had (except I think
Win98). I'm thinking there may be no solution, but what it's worth a try.
With both of my machines, I have the taskbar (as well as other toolbars) set
out to maximum size - typically half the screen - and to auto hide. (This
makes a great program and file launcher)
The issue is that the operating system decides it wants open the taskbar on
its own from time to time on its own. Various things prompt this, ma...DST issue
I entered the catalog item:
<Feature Name="Item" CatalogItemId="Item:MS:sysgen_timesvc_dst" />
and confirmed that the device has the registry key:
HKLM\Software\Microsoft\Clock\AutoDST = 1
But the device still does not automatically adjust for DST. I set the
timezone to Pacific, set the time to 3/14/2010 at 1:59AM, waited for one
minute...and the time changed to 2:00AM instead of 3:00AM.
What am I missing?
which OS version are you using? have you updated it with the relevant qfes
which deal with the changing in DST starting day?
-...Excel 2007 Sheet with rows more than 15000
While working with excel sheets having rows more than 15000 lines, sometimes
I observe that the processing is slowed down if data more than 15000 lines is
selected. However the work is takes very less time if number of rows selected
are less than say 12000. I have 2GB RAM, Can someone help me on this issue?
I'm not sure what type of help you're looking for. Excel 2007 is what it is,
and you either need to select more than 15,000 rows or you don't. Other than
purchasing and installing more RAM on the computer or buying a newer, faster
computer with tons of RAM I'm not s...excel front sheet
Don't know if this is possible?? I have a excel doc which basically
calculates lots of different costs. I want to use a front sheet which
has fields of input a "GO" button to export the data to the relevant
sheet and then clears ready for the next entry. Is it possible within
Excel or will my front sheet need to be done in access. If so how do I
Click the office button > Excel Options > customize, then select commands
not in the ribbon from the choose commands from toolbar, scroll until you see
form and add it - you will then see an icon of a form in ...Excel 2007
One of the features that I have often used in previous versions of Excel is
having a control (e.g., a spin button) in a chart. Obviously, the control would
be linked to the spreadsheet from which the chart gets its data. I cannot get
this to work in Excel 2007. I am using the B2TR. When I try to put the control
on the chart, I get a status bar message that says to click and drag, but
Have they eliminated this functionality? I really hope not, since this is very
valuable for presentations in my finance classes.
I didn't test this very thoroughly. I do...Outlook/EX Email Issue
I'm running Windows XP with XP Professional. I cannot send email but I can
recieve it using Outlook. There error says that Outlook was unable to access
the SMTP server. I cannot access my email at HOME through the web email. What
I can do is send/recieve email using Outlook Express AND I can access my
email through my web email client outside my home. My ISP (SBC) says its not
them and I'm somewhat inclined to agree with them? They say I could have a
corrupted kernel32.dll file. I have turned off my Norton, deleted my account
and set up a new one and re-installed XP professiona...How do I link Excel pages to a different master Excel workbook?
I am trying to take part lists from different assemblies and link them to a
master part list. Ideally one sheet from the assembly part lists will have
many pages and be linked to a sheet in the master part list with the name of
that specific assembly.
I am operating on Midrosoft Office Version 2003.
open both the master and your part list on your master if you set a cell to
(="name of part list book"!A1) you can do that by clicking any cell on the
other workbook with them both open its just like a formula on the sheet only
instead it has the workbooks name first i hope thi...Extender Install Issues
GP 8.0 Extender install - I'm encountering the following:
*Login to GP brings up screen: "Great Plains Extender needs to finish
installing. This may take a few minutes". It has an OK button and clicking
on this gets you into GP but it comes up everytime. How can we stop this
from popping up all the time.
*When creating a new Extender Window and I get select the Form, I get the
following error: "A remove range operation on table
'PT_User_Defined_Window_Keys' failed accessing SQL data." Procedure or
function zDP_EXT40101L_1 has too many arguments spec...Pivot Charts from Excel not to update automatically
I have a pivot chart in Excel and want to copy this to Powerpoint.
Copy>Paste obviously works fine but as soon as I change the pivot table
feeding the chart, e.g. adding row data it updates the chart in powerpoint.
How can I prevent this from happening as I want to copy>paste different
variations of the pivot chart into one powerpoint presentation? As soon as I
do this it updates all graphs in the presentation to whatever the pivot chart
is showing at that time...
Thank you for any help!
In article <D77A8CB0-C1C5-47BD-8401-6D6658239842@microsoft.com&...Possible Report Issue
Hi. I'm working on a database for a safety audit. The auditors would like to
be able to use some of the tables and subtables as a sort of checklist for
the audits. The table/subtable structure is as follows:
I decided to create a report that will output that data. However, the report
is only outputting information if there are ProgramRequirements already
entered for a given ProgramArea. Is there a way to get it to output the
ProgramArea and ProgramRequirement even if blank? Or am I going about th...Adobe issues
We are running GP 9.0, using Windows 7, just installed Adobe 8.0 and are
unable to send documents to PDF from GP - the PDF option remains grayed out.
We have folowed the KB articles that are available, no success. Do we need to
install Adobe 9.0 due to running Windows 7? Is GP 9.0 compatible with Adobe
9? Thank you for any assistance..
I have a client using Adobe 9 on Windows 7. However, they are on GP 10.0
It is working succesfully.
> We are running GP 9.0, using Windows 7, just installed Adobe 8.0 and are ...Issue with formula is Pivot table
I have the following formula in a pivot table:
First to the issues that I am experiencing. First, the formula wa
originally added as the one below but then updated to the formula abov
to correctly reflect what I was trying to accomplish.
This issue is the original formula appears in the very first cell o
the pivot table and then periodically through out the column. So, yo
see ...Any help with Excel Toolbar?
I'll admit, I'm not a good Excel user, or google searcher, so I'm hopin
someone can help me.
If you have a google toolbar, you customize it, then use it, but clos
excel and reopen it and it goes back to how it was before....? Is thi
normal or is this something I can fix? The file it creates i
excel10.xlb in the documents and settings\username\applicatio
Any help would be most appreciated.
Message posted from http://www.ExcelForum.com
Normally any changes you make to your Excel toolbars are saved in your XLB
file and rest...Excel Templates be modified?
I'm trying to modify templates in Excel XP and 2003 and can't get it to work.
Possible? Please advise.
Some Templates have worksheet protection enabled.
Tools>Protection>Unprotect Sheet. No password required.
Those from Spreadsheet Solutions containing macros have the VBA Project
Not knowing what alterations you are attempting and what "can't get it to
work" means, makes it difficult to offer more.
Gord Dibben Excel MVP
On Wed, 16 Mar 2005 18:51:02 -0800, "Frenchfish"
>I'm...Outlook Web Access OWA Issue - Login Prompt for Images
Dear Outlook 2003 / Exchange 2003 Users,
Starting over the last two weeks (possibly after an update on the
Exchange server), all of my users are starting to encounter the same
issue when using Outlook Web Access (using IE6 on XP Pro systems). We
have images in our signature block, and now when someone replies using
Webmail to an e-mail originally sent via Outlook 2003, a login prompt
appears for each image in the e-mail. Every time you cancel the login
box, a red x image box appears, until all of the images that should be
there are represented by the red x boxes. For the record, this has
w...Print a 2-sided document in Excel for a 3-ring binder?
How do I print a 2-sided document in Excel for a 3-ring binder? I have tried
everything I can think of, but the margins on the backside are identical to
the margins on the front and that doesn't work. The right margin on the back
needs to be like the left margin on the front in order to punch holes in the
document. Any help you can give would be great! I cannot be the only one
who needs to know how to do this.
You would normally set that option on the printer functions, File>Print>click
Properties next to printer name.
&...Hyperlink Issue #2
I have an issue with hyperlinks. When you click on the hyperlink on a
webpage it returns an error stating that the the "item could not be
created". Outlook 2000/Windows 2000