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...How do I create a "fixed-width" datafile?
I need to create a fixed-width file from an Excel .xls file to import into my
FedEx shipping software.
How may I save or convert my file into a fixed field datafile?
Thanks in advance,
If you don't have too long a line (no more than 240 characters per line), try
saving a copy of your workbook as a .prn file.
Look in the Save As Type box:
Formatted Text (Space delimited)(*.prn)
I like to change to Courier New font and resize the columns the way I like.
Alex K wrote:
> I need to create a fixed-width file from an Excel .xls file to import into my
> FedEx shipping...Outlook, email address field, email forward does not work
This problem is very hard to explain. I have a friend, she has a small
business and has a website. She is using an offshoot of that website
hosting service to forward email to her home email address which is on
Comcast. Lets say her site is www.services.com.
She has the forwarding service setup to forward firstname.lastname@example.org and
email@example.com to her home email on comcast, firstname.lastname@example.org.
By the way, there are two other forwards setup on the forwarding site,
both of them are to a webmail email, one is a yahoo email and the
other is a gmail account and they both work fine.
Her forwared...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 ...How do I create an hourly daily planner?
I am using excel 2003. From start to finish, how can I create an houly daily
Why not use Outlook's Calender or Tasks, it is already set up
> I am using excel 2003. From start to finish, how can I create an houly daily
what exactly are your requirements?
"zed" <email@example.com> wrote in message
>I am using excel 2003. From start to finish, how can I create an houly
...Creating a userform?
I would like to enter data to a speadsheet with a userform.
I want enter the data in a form that will automatically insert the data to
the correct cells in my spreadsheet. And then allow me to enter new data on
the next line below.
Is this possible?
I have just put up a file for you at:-
It is item number 42 towards the top of my home page.
In here I have tried to explain, as clearly as possible, what you need to do
to set up and use a Form in EXCEL 2007. There is a simple worked example for
you to work through if you want to.
Please d...Tracking of Activities created in Outlook
Activities (like meetings, phone calls and tasks) created in Outlook to not
appear in the History of a contact or account? How to change?
Thanks everybody for help on this!
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?
-...forward to: field
im looking for the AD attribute in which the 'forward to:' field of the
delivery options is stored.
Thank you in advance
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/
Its in the altRecipient attribute.
"Marc Wenger" <haga(at).iesg--nspm-noa9h.gmx.ch> wrote in message
> Hi Everyone,
> im looking for the AD attribute in which the 'forward to:' field of ...Summation/Lookup Function
I have two worksheets.
On the first one, I have two dates
On the second one, I have a f/x rate that corresponds to
August 1 1.33
August 2 1.34
August 3 1.37
August 4 1.32
August 5 1.66
I'm trying to figure out how I make Excel sum up the f/x
rate between the two dates on the first worksheet by
looking at the second worksheet.
With the two dates in D1 and D2 and the table of rates in A1:A5 of
Sheet4, then enter in a cell on the same sheet as the two dates
=SUM(INDIRECT("Sheet4!"&"B"&MATCH...get popups/alerts when i created a table from a query
I created a table using a query. Now whenever I run the query I get
popups/alerts informing me that I am deleting the table and another informing
me that I am added the data records to the table. The query works fine. But
I can do without the popups/alerts. This database will be available for to
all users. How can I avoid these popups/alerts as well as the other users.
On Thu, 14 Feb 2008 14:00:01 -0800, Ms937j <Ms937j@discussions.microsoft.com>
>I created a table using a query. Now whenever I run the query I get
>popups/alerts informing me that I a...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...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...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...Disable ability to create folders in Exchange
Our corperate office has implemented a new document retention policy. Part
of the policy requires users to contact the IT department if they want a new
folder created in their Exchange mailbox (Each folder must have a retention
policy setup by the IT dept using Symantec Enterprise Vault). We have been
told that we have to come up with a way to disable our users ability to
create folders in their mailboxes. I was wondering if anybody has any ideas
on how to set this type of security on Exchange. I can't see how to do it
via "Mailbox Rights". Thanks for the help.
I'...Contact address fields Outlook 2002
I've converted my Outlook 2000 contacts to Outlook 2002, the address
information seems not to be right.
The City-info is in the ZIP-field, the state info in the city-field and the
zipcode in the state-field. In the 'All fields'-tab the information is in
the right fields.
I've migrated from Outlook 2000 SP3 English to Outlook 2002 Dutch. It seems
some programmer/translator mixed up the addressfields in the
contactinformation-window. I need this information for my program. Is this
solved in a servicepack/upgrade, or is any workaround available?
It seems to be a common probl...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 ...create controls in a seperate thread
I am currently writing an application, which have to create on run-time a
new Control ( for example a CEdit-Control ) in a sperate thread. But when
the thread tries to create the new Control with a call to Create the
application hangs. The class which holds the Thread looks like the following
( The code is only for demonstration purpose ):
Testing() : bCreate(true)
void set_parent(CWnd* pWnd)
m_pWnd = pWnd;
m_hThread = ::CreateThread(NULL, 0, (...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 ...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...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
...creating color map
I would like to illustrate an Excel chart with a color map.
Columns would be X value
Lines would be Y values
Content of the cells would be color temperature (0=blue 100=red).
Is there any software to generate that kind of map ?
Perhaps an Excel ad-on ?
Perhaps an Excel function I don't know ?
I'm not sure what you are looking for but Excel charts include a chart type
called Surface, two of which might meet your needs.
If this helps, please click the Yes button.
"g. bon" wrote:
> I would like to il...Creating an autofill type function from a data validation box
I have a time keeping spreadsheet that has a data validation box to select
the payperiod (ie 01/16/10 to 01/31/10, etc) and I need to have boxes for
time entry with the dates above them auto complete for the date range for the
I know it can be done, but I can't figure it out, eveything I try is leading
me to a dead end.
Go back to original thread and see my last reply.
Gord Dibben MS Excel MVP
On Fri, 29 Jan 2010 13:53:02 -0800, SethT <SethT@discussions.microsoft.com>
>I have a time keeping spreadsheet that has a data validation box to ...