"Array Index Out of Bounds"
I recently purchased "Office Professional Ed 2003." With
it came "Business Contact Manager." When I double click
to open a particular contact or business contact, I get
the above "subject" message. Is there a reason, fix, or
solution for this?
...vbs for macro #2
i have an inventory of appx 1000 serial numbers. using keystroke recording, i
can populate 2 - 6 fields on 4 green screens to complete a process on one
serial number. is there a way to tweak my macro to incrementally continue,
automatically, from a list stored in an excel worksheet on the client? would
be very grateful for fresh ideas.
1st...thank you for giving me hope!
the macro feeds to a cics dummy screen (input only form) linking to corp
dBase from nt/ws 4.0 sp6. Attached below is the macro, which i would like to
link to an excel worksheet (C:\temp\serN...additem to combobox with an array
hi, i'm trying to add itemns to an multicolumn combobox (3 columns)
using an array.
if i just try to add 1 column there is no problems, but when i try t
add more columns to the combobox it wont work anymore.
jocke's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=76
View this thread: http://www.excelforum.com/showthread.php?threadid=47167
Did you change the .columncount property?
I made a small userform and picked up some values off a worksheet to create...Visio 2000 (Font Question)
I'm trying to have my text with a black boarder but filled with a different
How do I do this? eg. outline black, fill red.
If you have Office installed, insert a Wordart object into Visio.
"ShipHead" <GoAway@SpamBoy.com> wrote in message
> I'm trying to have my text with a black boarder but filled with a
> How do I do this? eg. outline black, fill red.
Select text box; Format | Line, and Format | Fill
/ Oz \ ...Option Group Question 10-12-07
I have a form with an option group with 5 choices available. The
fieldname/control source where this info will be stored is BusUnit:
As I am sure you already know the value that is saved in my table is the
numeric value noted above. That means little to the user. I want the
corresponding text value to be saved in my table instead, and I want my
default text value to be "All". Note: within my option group, 1 is the
default as defined when created using the Wizard. So when a new record is
being populated or created the default value is &...hosting 2 domains
I'm hosting 2 domain names for my exchange server, the 2nd
domain can receive e-mail but it cannot send out mail
through its own domain name. Any ideas of what I will need
By default, all emails leaving your system will be stamped with the domain
you have listed as your Primary SMTP address in your recipient policy. You
can recieve for any you have listed, but it will always send as the primary.
You can create 2 new recipient policy's for each domain. Then you can
assign those policies to the users in thier respective domains and set the
Primary SMTP address different...X500 question
in the middle of a site consolidation/migration from 5.5 to 2003.
when I do a cross-site mailbox move the AD account gets 2 X500 addresses...
1 for the old site and 1 for the new. I assume this is normal, and necessary
for mail to continue to flow between moved and nonmoved mailboxes. the
interesting thing is that both x500 addresses are set to primary (they're
both bold with a capital X), and the "set as primary" option is not
available. using ADSIEDIT I can change one of these to secondary by making
one of the X's lower case, and then the set as primary option ...An embarrasing question
Just compiled a C++ program with the "VS 2003 dotnet IDE".
I have a *tad* experience with VS6 where there was a button widget that had a
red '!' on it, which meant "run the program".
I'm looking at VS 2003 dotnet, and don't see the button with an exclamation
point. I don't see anything that appears like it would run the program.
When I started the project, I made it a "console app".
It compiled. Now how do I run it? *sheepish grin*
Hit Ctrl+F5. Exclamation point in VC6 is no longer available in
VS2003/VS2005. You can cus...Split into 2 tables?
I have a pond database I'm working on. We have weather data and notes
associated with a set of data collected for one pond on one day. We have
"current weather" (current weather noted for the day - ambient temperature,
wind speed, etc.) and "previous weather" which consists of notes about what
the weather has been like the past day or two. These data are contained in
one table linked to the main pond data table via foreign key... Should they
be split into 2 tables - one for current weather, one for previous weather?
What are the questions o...SMTP connector, one last question...
my exchange setup is configured to handle mail for the active directory
domain "domain1.com". i needed it to also handle mail for the domain
"domain2.com". i was told that for this i need an smtp connector, which is
what i did. i created an additional smtp connector and told it to forward
all mail for the new domain to itslef. which seems weird to me. tell me
this, can i get rid of all the smtp connectors and have the default smtp
server handle mail for multiple domains? i have already updated the default
recipient policy to allow for the creation of addresses in the domai...=if QUESTION
THIS IS WHAT I WOULD LIKE TO DO:
IF K39-I30 IS =>.25% OF K39, THEN DEDUCT .50% OF DIFFERENCE/REMAINDING TO BE
PLACED IN K42.
SOME HOW IT IS NOT DOING WHAT I THINK IS CORRECT WHEN I REDO IT ON PAPER.
"Colin2u" <Colin2u@discussions.microsoft.com> wrote in message
> THIS IS WHAT I WOULD LIKE TO DO:
> IF K39-I30 IS =>.25% OF K39, THEN DEDUCT .50% OF DIFFERENCE/REMAINDING TO
> PLACED IN K42.
> SOME HOW IT IS NOT DOING WHAT...Macro Button Question
I am trying to insert and delete rows using macros. Ive assigned the
Macro to a button, but would like to be able to insert (and delete)
exactly where the button is on the worksheet, no matter where the
So, I guess my question is, is it possible to get the cell reference
behind a graphic button?
Or, even better, assign a macro to a cell?
There are "insert row" and "insert column" buttons available from
Also "delete row" and "delete column" buttons available from
I'm in an office with 5 networked computers. all incoming/outgoing mail uses
the same address (POP3 account). A single machine running Outlook Express is
used by all of us, in rotation, for email. This is inconvenient and
We all have Office (and can install Outlook). Is it possible to set up a
system whereby all the machines can view the same inbox, outbox, and saved
folders (stored just on a single machine), and that changes made by one user
(e.g. marking an email as 'read') are reflected on everyone's screens?
Ideally all machines would be viewing the folders si...Very specific Question???
I have an Access database (2000 format running on 2007) connecting through
an ODBC to PostgreSQL. Postgres queries are very particular i.e. case
sensitive. Now that we have that out of the way...here is the problem.
I am using a combo box in a form to assign a variable to a table. There are
three options available in the combo box. I won't go into detail...it is
entered like this:
Access removes the last semicolon...so now whenever the value is written to
the table it sees:
option3 <space><space><space><space><space> (...A Review question from the Microsoft book(exam 70-536)
I'm reading a book from Microsoft Press (exam 70-536) and there is some
Review questions after each chaper.
Here is the question "Which command would you use to close the application
domain in the following code sample."
AppDomain d = AppDomain.CreateDomain("New Domain");
A. d. DomainUnload()
B. d = null
The right answer according to the book is B and D.
I have guessed only at D because I can't find why B is also included in the
Because of...Easy question (just not for me)
I am trying to drag down a date for monday through friday throughout the year:
What would be or how would I make it to where it skips the saturday/sunday
dates to go right to the next monday date?
Thanks in advance
With 04/01/2010 in cell A1, enter the folowing formula in A2 and copy down
"Confusicous" <Confusicous@discussions.microsoft.com> wrote in message
&...Radar Plot using geographical coordinates #2
I am trying to generate a circular radar or XY scatter point plot using
geographical coordinates referenced to a tower in the aproximate center
(with its own geographical coordinates and the plotted data in 4 quadrants
(+X/+Y, -X/+Y, -X/-Y and +X/-Y) in order to plot the RF field strength of an
FM broadcast station.
I have 5 columns of data:
1 the Latitude coordinates of the tower for center reference.
2 the Longitude coordinates of the tower for center reference.
3 the Latitude coordinates where I took the measurements.
4 the Longitude coordinates where I took the measurements.
5 The RF...Array+Array
I have 2 (or more) arrays, how can i combine them into 1?
Array 1 = "1, 2, 3, 4"
Array 2 = "A, B, C, D, E, F"
Array_Combined = "1, 2, 3, 4, A, B, C, D, E, F"
On Jan 7, 9:23=A0am, Danny <dannypct...@gmail.com> wrote:
> I have 2 (or more) arrays, how can i combine them into 1?
> Array 1 =3D "1, 2, 3, 4"
> Array 2 =3D "A, B, C, D, E, F"
> Array_Combined =3D "1, 2, 3, 4, A, B, C, D, E, F"
>...Question on Table: Constants
Is it safe to use this table to get the List View Line Item Number. For
example in the window "Receivings Transaction Entry" Open "Purchasing
Distribution Entry" window" The Type column has drop down lists and Work In
Progress is one of the items for Project accounting cost category. And in
the table Constants if you query the column Name "Name" for "POP_DIST_WIP"
You'll find the right matching Line number "15" as a value. I just want to
know if this table will be available in the future updates and if it will be
updated wit...How to count same numbers in a coluum #2
Now, to find out what a pivot table is. :)
FPA1869's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1470
View this thread: http://www.excelforum.com/showthread.php?threadid=26336
Here are some links for pivottable info:
Debra Dalgleish's pictures at Jon Peltier's site:
And Debra's own site:
John Walkenbach also has some at:
http://j-walk.com/ss/excel/...Excel VBA PageSetup Questions
I want to specify that my xlSheet objects page setup so that fit page is
enabled and put Page X of Y in the footer. I have so far:
.Orientation = xlLandscape
.FitToPagesWide = 1
.FitToPagesTall = 1000
.LeftFooter = "Engman-Taylor Co."
.CenterFooter = "Page "
My two problems are fittopage is not activated and I don't know how to
reference page and pages in the footer. Can anyone help me?
Simply setting the properties enables f...Question about interpolation
I have points deffined with x,y and z coordinates.
Now I want to give x, y coordinate of new point and based on othe
points to calculate Z for this new point. How can I do it in Excel
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com
You need to do 2-variable regression. I have used this a lot in the past.
I think it is now an add-in to Excel (I did it in Lotus - excuse me - many
This gives you the coefficents of an equation of the type:
z = r1 x + r2...Basic question regarding checkboxes
I want to check a checkbox using the CheckDlgButton
The checkbox resides in a Dialog box called IDD_MYAPPLICATION_DIALOG.
However, when I put this in the hWND field I get the error
error C2664: 'CheckDlgButton' : cannot convert parameter 1 from 'int'
Conversion from integral type to pointer type requires
reinterpret_cast, C-style cast or function-style cast
What do I have to put in the hWND field to make this work?
>>The checkbox resides in a Dialog box called IDD_MYAPPLICATION_DIALOG.
How...2 Que's regarding dates (matching and subtracting) #2
Thanks for the help!
Okay, I got que. #1 all figured out!
#2 however, is still a little sticky.
This is exactly what I'm trying to accomplish:
The end-user enters a date in cell a2, validated to format DD/MM/YYYY.
I want to look up that date and match it to a corresponding "table" on
On Sheet3, currently, I have the date, in M (September) format, in column B,
and a value (%) in column C.
Essentially, I want to input date ranges in this "table", so for column B2,
it would be September 16th, 2004, to October 15th 2004 (instead of just
September), but I do...Chart Sizing #2
Using Excel 2000 - Is there a way of sizing a chart to an
exact size instead of grabbing the sizing handles to size
If you select the chart whilst holding the CTRL key you can then set the
width and height via the format dialog.
> Using Excel 2000 - Is there a way of sizing a chart to an
> exact size instead of grabbing the sizing handles to size
> Thank you
Andy Pope, Microsoft MVP - Excel
>If you select the chart whilst holdi...