Drop Down List Question!
How do I go about having a drop down list in a invoice so as it will link up
with a name and address on another sheet.
Sheet (Address) has name and address in A1, A2, A3, A4, A5. Then in Sheet
Invoice I want to have a drop down list then select and the next 4 cells
fall below to complete a invoice address!
Thanks in advance for your help....Bob Vance
Select the cells of your address (A1:A50) in Sheet Address Then |
Insert| Name | Define
give a name - for eg: "add"
Now in your Invoice Sheet, go to the cell where you want the address to
Data | V...Can i get origional back after trial?
I bought my laptop used from Craigslist, so i dont have the discs. I have
office pro 2003. i dL the free trial of office pro 2007. After the dL, i
discovered i have to delete my outlook in order to run the 2007 version. If i
delete 2003, is there any way to retrieve it if i dont upgrade 2007?
Nope. In addition, if you didn't get the license and discs for 2003, you
don't have the rights to use it.
> I bought my laptop used from Craigslist, so i dont have the discs. I have
> office pro 2003. i dL the free trial of office pro 2007. After the d...Can not get MS Money Premium to connect to internet after KB searc
I can not log into the Windows Live ID because Money will not connect to the
internet. I am running Win XP SP2 on Tablet(Pro version) with IE 7 and have
upgraded and reset ie7. I have gone through KB
http://support.microsoft.com/kb/899935/ from Cal Learner's previous posts.
However, these have not worked and I cannot get to use Windows Live ID since
it will not connect. I also reinstalled Money again, but not available.
Anyone have any ideas? I know this has been a running problem, but I want
to use the Live ID process so my bank info wi...Can I edit a web query?
I want to download some data from the web which is in a
simple table format (7 columns x 50 rows). I use MS Web
Query to do this.
Is there anyway that I can use VBA to just download the
first row of the table? Web Query only allows the whole
table to be downloaded and I cannot find a way to edit
this using Excel to just get specific bits of data.
As always, advice is well received...
If you give me the url and your present code, I will take a look at it. OR,
import to one sheet and use a macro to extract to another sheet.
"Alex&...Help!! Is there any way I can get a deleted folder back??
I accidentally did a shift delete on one of my folders as it was highlighted
instead of the e-mail I wanted to delete. Is there any way I can retrieve
Imperial Beach, CA
"NZuser" <NZuser@discussions.microsoft.com> wrote in message
> I accidentally did a shift delete on one of my folders as it was
> instead of the e-mail I wanted to ...Modifying reports with VB6
I have a program written in VB6 with an mdb file backend on the server in
Access 2000 format. I
have reports that I create on my computer that has Access installed that I
need people on other computers to be able to print. The problem is the old
issue of Access resetting the paper size if it happens to run out of legal
paper. The code that I've seen and used to fix this problem depends on being
able to create an instance of the Access app. This of course does not work
on a PC that doesn't have Access installed. Is there a way to
programmatically do this from VB6 without the Access app...Can you open the websit?
Can you open the websit eachenet.go.51.net and eachebay.go.51.net ?
I can ,but i can't understand the meaning of the content?
Can you tell me what should I do next step?
"Alexander" wrote in <news:firstname.lastname@example.org>:
> Can you open the websit eachenet.go.51.net and eachebay.go.51.net ?
> I can ,but i can't understand the meaning of the content?
> Can you tell me what should I do next step?
Based on a vague "can you go open" request which says nothing of some
unidentified professed problem, Ale...want to convert string into byte array hw i can do it
SqlConnection SqlConn = new SqlConnection(Scon);
SqlDataAdapter da = new SqlDataAdapter();
DataSet ds = new DataSet();
SqlDataAdapter ADAP = new SqlDataAdapter("Select * from User1 Where Id =
DataSet DS = new DataSet();
//Fill dataset with ImagesStore table.
//string filename = GridView1.Rows[GridView1.SelectedIndex]
string filename = DS.Tables["User1"].Rows...How can I lock worksheets while macros can still enter into them?
I want to lock worksheets for outside users. But when I do it and a macro
needs to go into the worksheet, the system gives an error. So is there a way
to lock worksheets while still allowing macros to enter into the sheets and
enginguven, you can protect the sheet with user interface only, like this
ActiveSheet.Protect UserInterfaceOnly:=True, password:="123"
Sheets("Sheet1").Protect UserInterfaceOnly:=True, Password:="123"
or use something like this
Const PW As String = "123" 'Change Password Here
ActiveSheet.Unprotect P...editing pictures
There used to be a way to click on an icon and be able to blend several
colors from the background of a picture together and use that new combination
to fade or smear out other objects in the picture. I have done it, but don't
remember what program it was in, it was in a MS program. Does anyone know
what program that is? Did MS change it?
Might be thinking Digital Imaging, it was bundled with an earlier version of
Publisher. John Inzer has more knowledge about this application.
"mcharron" <email@example.com...Can't Find Contact Folder?
When I click the contact folder I Outlook "cant find the folder". Where is
this setting so I can see which folder it's looking for?
.... version Outlook XP
Sorry about that. Microsoft Outlook 2003 running on
In Outlook, there is not a seperate file for contacts. It is part of the
same pst file as the other folders. Never heard of this before, so this may
not work, but since OL does not believe thecontact folder is there it might.
Right click Personal Folders and select New Folder, name it Contacts and see
what happens. Worst that could happen is that it will ...Supplier Cost Edit?
Does anyone know a way to edit the cost by supplier? I can modify my retail
cost by a adding a percentage to my cost in the Inv. Wizard by department,
however, I need to mark up according to what supplier I am dealing with.
Maybe I am over looking something. Any suggestions would be great!
have you tried "items from this filter" in Inv. Wizard
"David D." wrote:
> Does anyone know a way to edit the cost by supplier? I can modify my retail
> cost by a adding a percentage to my cost in the Inv. Wizard by department,
> however, I need...Data validation list problem
I am using Excel 2002 sp3.
I have a number of sheets that use data validation to limit the values that
can be entered in specific cells - this list is several columns wide by up to
1000's rows long (sequential currency amounts for each denomination). It
resides on its own hidden sheet which is protected. All works fine but
occasionally one or two (or more) of the values in this list seem to be
getting altered. e.g, the column may read 98.0, 98.5, 99.0, 99.5 and instead
of the next one being 100 (which it was originally) it is now 90 and so on.
A number of different users...Can different editions of Publisher be used together?
If my son uses Publisher 2003 on a school computer, downloads his work to a
flash drive, brings it home to edit on Publisher 2007, will he then be able
to take the edited work back to the school computer to be used, or will it
not be compatible?
> If my son uses Publisher 2003 on a school computer, downloads his work to a
> flash drive, brings it home to edit on Publisher 2007, will he then be able
> to take the edited work back to the school computer to be used, or will it
> not be compatible?
Publisher 2003 and 2007 share a common file format, so the sc...Including Country in RW SelectAddrLine Function
Is it possible to include the Country field in the Report Writer
rw_SelectAddrLine function? We want the Country to be the last line but
still include two address lines. If so, what's the proper format?
Replace the last set of double quotes in the function with the country field
from the appropriate table. Do this for all of the calculated fields. You
will probably have to create a Line 4 (or 5) calculated field for the
address. Look closely at the existing fields and replicate the function
remembering to increment the line number in the parameter list.
"El...Can't see messages in Inbox
When I go to Outlook, and click on the Inbox, the inbox showed up for a
second, then it is replaced by PopNav website. This website had replaced my
homepage in IE also. I can't see messages in my Inbox anymore. HELP !! What
can I do to fix this?
Note: as of yesterday my Outlook inbox worked fine.
"Fie Fie Niles" <firstname.lastname@example.org> wrote in message
> When I go to Outlook, and click on the Inbox, the inbox showed up for a
> second, then it is replaced by PopNav website. This website had replaced
> homepage ...Distribution of MFC42.dll
What's the recommended way of distributing the MFC42.DLL? Is it wise to
install this in the folder with my application .exe that uses the .DLL
instead of relying on what happens to be on the system its installed on?
In the past I've used the InstallShield program to have it attempt to update
the system copy. I believe XP and Win2K don't easily allow this system
update, however. I'd appreciate any advice on what shipping products are
>What's the recommended way of distributing the MFC42.DLL? Is it wise to
>install this in the folder with my ap...Macro to edit cell
I would like to write a macro that edits the first 6
digits of a cell but leaving the last 6 digits as is.
for each c in selection
"Kevin" <email@example.com> wrote in message
> I would like to write a macro that edits the first 6
> digits of a cell but leaving the last 6 digits as is.
...windows mail...error message and I can't send mail.
I get the same error message, but not all the time. Randomly I will not be
able to read or send mail. I copied but there is no provision to past it
Unknown error...server, etc...
Same error message as what?
If you can type in a window, you can paste text into it. Are you trying
to paste an image? That won't work.
Next time you get a Windows Mail error message, right-click on that
error message, click Copy, then paste it into a reply here. We can't=20
do much troubleshooting without the complete error message.=20
Gary VanderMolen, Microsoft MV...how to match between two list using letters
I have two sheets as follows:
D-173 abcd ?
B-241 efgh ?
TI-242 XYZ ?
E-0124 STQ ?
What I want to do is taking the value from Colum A in sheet1 and put it in
column C in sheet 2 using Sheet1 Column B as an indicator.
Please note that the Column A in sheet2 has the same data of Column B in
sheet1 but there are extra letters and characters.
In C1 of sheet2 and copy dow...News reader included in Outlook 07?
I read somewhere that the newsreader feature would be available in Outlook
07. My ISP also indicated that I can set up and aread from an Outlook
folder. However, I can find no way to do this. A search of MS web site
indicates that I have to buy an additional MAPI product for this to work. I
guess I don't understand since I can read any group I want from Outlook
Express. Why would this service not be available on the versio of the
software that I paid for separately? Or, am I missing something? Since the
MAPI servies is running on my machine why can't I simply access it from an
...Convert mailing list from columns to rows
I have been handed a list that I need to convert and I am stumped.
The worksheet contains three columns of addresses. The addresses are
generally in one of three formats:
Street number and name
Street number and name
The repeat of the above with two lines for street information.
As far as I can tell so far, these four are the only different
Some of the addresses have a comma between the city and state.
One final complication, some addresses use the 5 digit zip, some use
the zip+4 with a dash.
Is the...Microsoft Visual C++ 2008 Redistributable Package (x86), can i redistribute single files of it?
until today i always forced users to download/install the
complete package of the Microsoft Visual C++ 2008
Redistributable Package (x86), but mostly my applications
only need the msvcr90.dll to run. So my question here is
if i can pack this file into my installer and redistribute it with
my application. For my case it would be just fine if the
dll would be in the same directory as the app is.
Is it legal to redisitribute the single dll or do i have to
pack the complete msi installer into my app installer,
which makes the complete installer a huge package,...
I didnt find any informatio...Help! Can't enter duplicate tracking numbers
We just discovered that after 2 years of using GP, our FedEx and UPS tracking
numbers are starting to duplicate, because they're reusing the numbers.
We can't load them into GP via eConnect anymore because we get a duplicate
record type of error. It seems that the Tracking Number field in the SOP10107
table is a key.
Has anyone encountered this?? What, if anything, can we do??
Microsoft Certified Business Management Solutions Specialist, GP 9.0
Currently supporting: GP 9.0, SP2
I just tested entering a tracking number already in the SOP10107 table ...Why won't word alphabetize a list of email addresses?
I typed a list of single spaced email addresses separated by paragraphs and
want to alphabetize them. When I try, I get an error message "Word cannot
sort fields in the selections." How can I sort this list? Thanks!!!
In the Sort dialog, for "Sort by," make sure you have "Paragraphs" selected
instead of "Field 1" or anything else.
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
"Sort list of email addresses" <Sort list of email