How is the data gathered when the last page of a CPropertySheet (wizard
mode) class fires the OnWizardFinish button event? The member variables
in each page appear to have valid data in them but I cannot figure out
how to make use of it when the finish button is clicked.
Mark F. wrote:
> How is the data gathered when the last page of a CPropertySheet (wizard
> mode) class fires the OnWizardFinish button event? The member variables
> in each page appear to have valid data in them but I cannot figure out
> how to make use of it when the finish button is clicked.
The usual wa...about transfer order
I created a transfer order "TO666", transfer items from store01 to store02,
the system automaticly created a TO No."00001_TO666 ". And the strange thing
happend: the items in "TO666" is so different with the items in "00001_TO666
where is the problem?
with a lot of thanks.
Try creating another order with the same items, if the problem still exists,
most probably you have a problem in the IDs of those items.
What HQ does is to map the items in the created order in Store1 to the
corresponding items in HQ, then map them again to Store2 and th...Transfering messages
I want to transfer all my messages from one PC running Vista to another
running Win7 which I have Windows Mail running on. However, I have two
1. On transferring some of the transferred folders contain the full message,
some only contain what you might call place holders e.g my transferred Inbox
has 'From' with a list of 30 or so messages but just shows an envelop and
the date and time but no message
2. Is there away to transfer attachments too?
"Ron O'Brien" <firstname.lastname@example.org> wrote in message
news:uBH3g6UjKHA.218...Sorting data question
I have 200 rows of data in one colum, each row contains a random number
but the total column value is 200. I want to sort the data into 4
approximately equal sized blocks (adding up to 50). Just a bit stuck as
to where to start the filtering process if there is one that can do
...Data Load Performance
Running SQL 2008 SP1
I am comparing a data load into a Heap Table and a Clustered Table. The
schema from each follows:
CREATE TABLE dbo.HeapTable(
HeapTable_UID int NOT NULL,
Col1 char(25) NOT NULL,
CREATE TABLE dbo.ClusteredTable(
ClusteredTable_UID int NOT NULL,
Col1 char(25) NOT NULL,
PRIMARY KEY CLUSTERED (ClusteredTable_UID, Col1) )
CREATE NONCLUSTER...Listbox with huge number of rows
My app has a listbox that displays a huge number of rows (several thousand)
for multi-selection. I'd like some way to position based on the first letter.
Is there a good way to do this?
It may be possible to use the KeyPress event of the list box, but it sounds
like a really horrid interface.
Might be better to use a temp table (for the selected options), with a
subform for selecting them.
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
I have set up the IMC's Message Filtering to disable a previous
employee from sending mail from his home email address in to our
server. I am now being asked to block internal users with accounts on
our server from sending out to this users home email address. Is
there a way to block outbound email to one email address? We are
running Sybari Antigen on our server but I can't see of a way to do
this with that application either.
...Import data from Access to Excel containing VB code
I am trying to import data from an Access database to an Excel
spreadsheet. I have imported several queries from Access into Excel
already. However the last piece of data that I am wanting to import
into Excel has VB code in the query doing a calculation automatically.
So when I go to Excel to import that piece of data, those queries that
contain the VB code don't even show up as import-able. Is there a way
to import these queries from access into my excel worksheet? I am
using Access 2003 and running on an XP OS. Is it possible to do it in
Excel 2007 if not available in Excel 2003?
I...HR Position Transfers
Is there a way to import a mass amount of position changes in GP HR?
We are getting ready to effect changes for our upcoming fiscal year.
There are numerous changes to our departments, positions moving from
one department to another and some of the departments are altogether
new. Is there a tool to import Position Change/Transfers? If not,
does anyone know all the tables I would need to hit if I need to
import the data?
...Problem inserting a column!!!
I just accessed a worksheet which Im trying to add a column to...
I highlight the column which i want the new column inserted ...and when
i try to insert a column it doesnt work! A warning message comes up
stating that a column cannot be inserted until blank cells are removed
from the right side of the sheet or something to that effect!?
Whats going on???
londonchick's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24529
View this thread: http://www.e...Summing Data based on Its Category
I have a spread sheet that has data on buldings set up in such a way that the
rows are different room types and the columns are Floor Type and Sq.
Footage. At the bottom of the sheet I have a row that gives total square
footage for each floor type of all the rooms combined.
Right now I am using the Sum() function but I have to go through and
individually select sq footages for the respective floor type. For example
if 3 rooms have a cement floor I look down the sq footage column and sum the
ones that have "cement" in the floor type column, and same with capret, etc.
respec...Passing RetrieveGlobals9's Connection Object from IM to another dl
I am using RetrieveGlobals9 to get a connection and successfully connecting
to the database from within script events in Integration Manager. However,
when I tried to pass the open connection to another (VB.Net) application from
within the script, I get an error, "Class does not support automation." Is
this something that I can fix by rewriting the VB.Net application, or will
that always happen when I try to call an external .dll from within
Thanks in advance.
...Windows Easy Transfer
I am having trouble with Easy Transfer from an XPhome to XPhome installation.
Actually it is the same computer after re-installing XP. I ran the Easy
Transfer to back up the data onto an external drive. When I run it now on the
new build I don't get the "Continue transfer in Progress" option. It does not
ask if this is the new or old computer. I haven't used it before so maybe I
am not using it as intended. I have user the XP File settings and transfer
program for a situation just like this with no problems.
Computer is a basic HP Pavi...Transferring an order to an invoice...
We are transferring over to GP 10. I have a question about invoicing that
I hope someone here can help me with.
In GP 8, there was a transfer button on the Sales Order Transaction screen
to transfer the order to an invoice. In GP 10, the transfer option is in a
pull down menu. Can we make the transfer option a 3rd button on the screen?
If someone could let me know, I would appreciate your help greatly!
yes you should be able to do that if you wish using a button and a bit of
This posting is provided "AS IS" with no warranties, a...Hide embedded objects contained in row that is filtered out
When using the >Data >Autofilter a row becomes hidden but if it contained an
embedded object it show in the next row that appears - bad.
how can embedded objects be hidden along with the row they are embedded in?
select the object(s) and use Format/Selected Object (or format autoshape...),
then on the properties tab, select Move & Size with cells.
> When using the >Data >Autofilter a row becomes hidden but if it contained an
> embedded object it show in the next row that appears - bad.
> how can embedded obje...Data Shifting Between Records
Has anyone ever had experience with data moving from one record to another?
I have a form in which I'm using the FMS rich text control ("Total Access
Memo"). Several times when there has been an error (such as the user unable
to print, or other error), the user finds that data in one or two of the
rich text fields are actually data that had previously been saved in another
record. This has happened two or three times in the past few months. And,
while not a frequent problem, it is especially troubling when it happens.
I've checked the FMS web site, and haven't seen...table design question
I have table of 40 milion rows (sql 2005). There is one column, Id, which is
integer (basically month), and there are 20 different values for this column
(around 2 million rows per id value). At the same time, there is very long
primary key on this table (12 columns, around 400 bytes), and nonclustered
index on this primary key. Table is being accessed frequently by Id, so I
created clustered index on this column (usually, developers create temporary
tables per id, and then do further processing) to lower physical reads...
Does this sound like a desirable design? I don't wan...Formatting Cells/Data
Hi, I hope you are doing well.
I have a file I downloaded from our AS/400 (OS400 operating system). I open
the file as a text file and go thru the wizard for converting the file to
excel format. One of the columns/fields is numeric with some neg and pos
numbers and some blank cell contents. During the wizard conversion the field
is categorized as DOUBLE with no option to change the field. When I finish
the wizard I save the file as an Excel workbook. Then I use the autosum
option to calculate the total of the field/column; however, it only picks up
on the positive #'s. Hence the t...Cut not Copy Appended Data
In this great Macro, created by Micky (MVP), is there a way to cut and paste
the data from all the columns instead of copy and paste? I just want all the
appended data in Column A".
Application.ScreenUpdating = False
LR = ActiveSheet.UsedRange.Rows.Count
LC = ActiveSheet.UsedRange.Columns.Count
Ind = LR + 1
For C = 2 To LC
For R = 1 To LR
If Cells(R, C) <> "" Then
Cells(Ind, 1) = Cells(R, C)
Ind = Ind + 1
Application.ScreenUpdati...System does not auto create Transfer In during Inter-store transfe
my customer running 2 stores and both store having the same interstore
transfer option setting. my problem is 1 of the store does not auto generate
Transfer In doc
1. store A - Transfer Out Doc store B - auto generate
transfer In Doc
store A uploaded 2 HQ message to HQ & store B received 2 HQ message.
2. store B - Transfer Out Doc store A - NOTHING GENERATED
store B only uploaded 1 HQ message to HQ & store A received 1 HQ message.
anyone got ideas how to solved this?
Did you set the HQ Configuration options to auto gen...Filter for two columns
I have two columns Purchased Date and Depreciation Start Date. Can anyone
help me to get the records with Depreciation Start Date greater than
sort with two conditions, highlight both columns, 1st condition Depreciation
in descending order and as a 2nd condition Purchased in ascending order
if this was helpful please say yes
> I have two columns Purchased Date and Depreciation Start Date. Can anyone
> help me to get the records with Depreciation Start Date greater than
> Purchased Date.
Use a helper col. As...printing multiple copies slowly and stopping between each one
For some reason in publisher only, when I want to print multiple copies of one
project, it stops between each one I print and take forever instead of
them all at one time.
This article has troubleshooting steps you can try. Pay close attention to the
How to troubleshoot problems that you may experience when you try to print to a local
printer by using Office programs in Windows XP
Mary Sauer MSFT MVP
"dmscofie...combination of stacked and clustered column
Any ways to combine two types of chars: sgtacked columns and clustered
If you stagger your data, you can create side-by-side stacked columns.
Bernard Liengme has an example and instructions on his site:
and Jon Peltier has links to other sites with information:
Grigori Margolin wrote:
> Any ways to combine two types of chars: sgtacked columns and clustered
Excel FAQ, Tips & Book List
I have 2 excel worksheets, both are in different formats. Both will
contain the same data but spread across different parts of the
if I have filled in the data for 1 worksheet, how can i automate this
data to be filled into the other worksheet?
In Sheet2 use linking formulas.
Sheet2 H1 formula is =Sheet1!A1
For contiguous areas these can be copied by dragging.
For non-contiguous areas..........manually enter references.
Gord Dibben MS Excel MVP
On Thu, 1 Apr 2010 08:13:17 -0700 (PDT), Lynn <email@example.com>
>I have 2 excel work...Any one seen this BUG in Matrix Items.
I have come across what I think is a bug in RMS Matrix Items occurring when
the description of the dimensions contain a single inverted comma (').
Take this example:-
Matrix Item called: Magazine
Single Dimension called: Title
Add any item and set the Title column to somethin like: Jason's Adventures.
Save the Matrix Item.
Sell the Item MAG in POS, The matrix selection screen appears - choose the
Item Jason's Adventure, then crash with this error and POS Closes.
"Run-time error '3001' Arguments are of the wrong type, are out of