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...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...Reading .wks file
Greetings...according to the Excel "help" file, as well as the file extension listing, I *should* be able to read an *.wks file, but Excel insists that it cannot. I am pretty sure the file was created in Microsoft Works. Is there a converter somewhere that I can download/install? Cheers - S2
Excel can read Works 2.0, not later. You have to save them in Works as excel
files or Works 2.0 or get a commercial
"Skip Stocks" <email@example.com> wrote in message
news:AFC110E0-641D-4D87-9464-B930CC41CF02@microsoft....Inserting text from a .txt file
I'm trying really hard to jump on the bandwagon and migrate from Outlook
Express to Outlook, but the more I try, the more frustrated I get.
Anyway, here is my question: How do I insert the text from a text file into
my e-mail document. I am using the rtf editor.
"~~Alan~~" <alan.shepro_NOSPAM@verizon.net> wrote in message
> I'm trying really hard to jump on the bandwagon and migrate from Outlook
> Express to Outlook, but the more I try, the more frustrated I get.
> Anywa...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...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
...importing saved registry file
how do I import a Windows 2003 registry file to Windows 2008? We are moving
our server O/S from windows 2003 to windows 2008 and I need to migrate the
Am 22.06.2010 18:23, schrieb Pearl:
> how do I import a Windows 2003 registry file to Windows 2008? We are moving
> our server O/S from windows 2003 to windows 2008 and I need to migrate the
> registry shares.
You could either do that with the File Server Migration Toolkit (FSMT)
which is a free download from Microsoft -- or use a script to
regedit /s myexport.reg
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...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?
...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...Holding a file open in FTP?
We have a user who wants to share an editable spreadsheet on
their web server (IIS5) with others over the internet. So we placed
a spreadsheet file in the FTP directory, established FTP accounts for
the users, and they can open the spreadsheet by opening the FQDN
The problem is that when they open the file this way, the file is locked
only for the duration of the FTP data transfer to the client, after which
it is freed. A second person can come along and open, change, and
save the file while the first one has it open (on their remote machine)
and making changes.
...Print Excel file to PDF
Is there a VBA code, or a program whereby I can print an Excel file to a
PDF? (Maybe an add-in?)
I'd like to do it directly from Excel similarly to the way Word Perfect has
that option in the file menu if possible, but anything will be a help.
(I'm using Office 2000)
You could purchase Adobe Acrobat.
An alternative to buying Adobe Acrobat....
I have had success with the free file downloads and instructions for use here
at Dale Nurden's site.
Saves first to single *.ps file which is then converted to *.pdf
Return...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...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...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...duplicating data
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...Max file size
Is there a max file size for an excel workbook?
The only limitation is dictated by how much memory your computer has. HTH
"Shane" <Shane@discussions.microsoft.com> wrote in message
> Is there a max file size for an excel workbook?
(And also how much patience you have!)
Otto Moehrbach wrote:
> The only limitation is dictated by how much memory your computer has. HTH
> "Shane" <Shane@discussions.microsoft.com>...how a file can change its type from '.xls' to '.tmp'
I have a file that keeps changing its name by itself and if I change it back
it locks the file
It sounds like you are attempting to change a Template file into a Workbook
file. Templates are intended to remain as such so that new workbooks can be
created based on tem rather than alway using blank workbooks that have to be
restructured each time.
It's best to not OPEN the template. Instead use File>New or depending on
version of Excel, New from Template in the Task Pane. When you save the new
file it will prompt you for a name and be saved as a .xls as usual.
"...Validating data in a subform against data in main form
I have a main form with a subform. Each form is bound to its own table but
are linked through a primary key (customerID).
On the main form, I have a customer's date of birth (dob).
On the subform, I have the customrer's date of order (doo).
Basically, I want to validate that the date of order entered by the user is
later than the date of birth.
How can I do this? I tried to do it in the subform's BeforeUpdate event but
it failed. It didn't seem to recognize dob (customer's date of birth).
Perhaps, I was not referring to dob properly.
I'm new to ...WMP won't play MIDI files
for some reason my PC (Dell Vostro 410, Windows 7, WMP 12) cannot play MIDI
files any more. But it can play MP3 and other sound files.
When I try to play a MIDI file I get the following error message :
"Windows Media Player cannot play the file because there is a problem with
your sound device. There may not be a sound device installed on your
computer, it may be in use by another program, or it may not be functioning
I cannot relate this problem with everything I could have done. My PC is
pretty stable, I only use straight applications an...Copy Unique data to a different worksheet
Date Prod Id Customer Amount
1/2 B123 John Doe 5
1/2 B123 Jane Doe 4
1/3 G456 John Smith 5
1/4 S789 Jane Smith 4
I need a formula, function, or Macro to do the following: resulting in WB 2
Copy unique Prod Id (ex. B123 is listed twice but I only need it displayed
once on WB 2 with the amount of both as displayed). This to help track sales
of a product quarterly.
Result for Worksheet 2
Prod ID Jan Feb Mar
B123 9 0 0
G456 5 ...