Rebuild HQ Item Data
I currently messed up with the HQ database.
Since I still have an optimized database on my store, I would like to know
if it is possible to import item and sales data into my "NEW HQ".
I tried to sync it to the "NEW HQ" but RMS would not permit me because the
store database is "flagged" to the "OLD HQ"
...Exporting Data from VB Flexgrid to Excel
I have a set of records that is displayed in vb
MSFlexgrid,i need to export that data in to excel ,
pls could u find out and i am eagerly witing for ur reply.
...Get pointer to parent of parent (2 levels back)
My application is dialog-based.
The App creates a dialog. The dialog creates a property sheet. The property
sheet creates 4 property pages.
The dialog opens a file. I want the property pages to be able to write to
the file. How can I get access back to that file pointer? I found
m_pParentWnd in the Property Page. But, I can't go back like this
m_pParentWnd->m_pParentWnd to get two levels back.
I thought about passing the pointer to the CFile in via the contructors of
the dialog, then to the sheet, then to the pages but I am not sure how to do
Any help is greatly app...Data List #2
In relation to an earlier question, I am looking for a way of creatin
box which displays the contents of a list, which when clicked on can b
copied to a current cell, but other items added to this list.
For example, in one spreadsheet a list of;
In another spreadsheet, a view of this, so that the values can easil
be copied over, but also the abaility to add another name.
| John |
| Paul |
| Peter |
Message posted from http://www.ExcelForum.com
Lookup data validation.
It is very straigh...Getting HTML back out of XML
I'm having a hell of a time figuring this out. ;o)
OK, thanks to Oleg, I finally figured out how to get XHTML in my XML by
using writeRaw to get it to not encode the XHTML going in.
However, I can't get it back out. I'm transforming my XML using XSLT:
Dim trasformedXML As New System.IO.StringWriter
xslt.Transform(doc, Nothing, trasformedXML, Nothing)
lbl_rulesText.Text = trasformedXML.ToString
The element that also has XHTML in it is transformed SANS the HTML tags.
<xsl:value-of select="text" />
That's returning the text of the node, but none of the HTML ...Convert Lotus Organizer 6 Data to Outlook 2003
i am searching for a solution on how to convert my OR6 data to outlook 2003
and have found until now only the difficult way via a text-file export. this
needs the cells to be declared one by one by hand wich is a very unnoying
isnt' there a different solution? a tool, a filter or something?
thanx for any hint,
Tom H. Lautenbacher <firstname.lastname@example.org> wrote:
> i am searching for a solution on how to convert my OR6 data to
> outlook 2003 and have found until now only the difficult way via a
> text-file export. this needs the cells to be declared o...Backing up Notes in Outlook
I found the toy that transfers Notes in Outlook to OneNote. Is there any
other way to back up one's notes other than making a backup of the
thank you for any help or suggestions
"jer&liz" <jerliz@home> wrote in message
>I found the toy that transfers Notes in Outlook to OneNote. Is there any
>other way to back up one's notes other than making a backup of the
No, not unless you're using an Exchange Server.
Well, you could manually copy the notes to a diff...data tab inactive
I am trying to goal seek. All my tabs are active, but when I click on the
data tab it is not active. Trying to finish a chapter for school.
Watch out if you have grouped all the tabs, or your ctrl + key is enabled at
the time of selecting the tabs.
Click on Yes, if it is useful.
Thanks & Best Regards,
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)
New Delhi, India
> I am trying to goal seek. All my tabs are active, but when I click on the
> data tab it is not active. Trying to finish a chapter...data sort of like
I like to have a tabel like this
This is one 1
This is two 2
This is someother 5
that say a text that is assosiated with a number. Then (some where else in
the spreedsheet) I like to have a drop down wther I can choose between
("This is one"; "This is two", "This is..."), and depending on the choosen
text I will use the assosiated number in some calculations. Is this possible
e.g. if in the drop down is in cell A5, and there is choosen "This is Two",
and in cell A4 says 55 like to write some ...CSV Import with Data Migration Manager
I am trying to migrate from goldmine 6.5 to Microsoft CRM 4.0 and I am
having some trouble at the final hurdle.
I have imported all company data as Accounts, then I import individual
people as Contacts, but I leave the Company Name column in and map it
to parent customer -> account name.
This works to a degree, but for some reason will only accept 1 of each
company, so if there are multiple contacts under one account then it
takes the first one and rejects the rest. It looks like the
relationship is stuck at 1-1 for the import, but I can then manually
change it afterwards, s...How to get BCC line back into my email as a default
I have just reinstalled my O/S (2000 Pro) and lost a lot
of my settings. I can't find out how to get the BCC line
back into my email format and I would like that set as the
default for all my email correspondence.
Also am unsure how to put a VCard signature into my email -
had it all set up before, but can't remember how I did it.
MuckyBeast <email@example.com> wrote:
> I have just reinstalled my O/S (2000 Pro) and lost a lot
> of my settings. I can't find out how to get the BCC line
> back into my email format and I would like tha...Upload data into GreatPlains
We are using GP 8 and are soon upgrading to GP 10. Is there a way to upload
data into the system?
The purchase orders we enter are quite lengthy and I was wondering whether
there was a way to automate this process.
We also change prices of our retail prices twice a year depending on whether
the Euro has changed much. It would be nice to be able to upload these
Please drop a email to discuss about custom PO automation solution.
> We are using GP 8 and are soon upgrading to GP 10. Is...Adding specific objects based on data...
I am working on a spreadsheet which I currently manually populate with
specific objects (colour-coded stars) depending on the respective date that
that event occurs on. I want to implement a system whereby if I populate the
date column, that excel will place the appropriate object in the appropriate
I have two columns for the two different types of star. I have one column
for everyday from start of June through to the end of February. Does a method
exist to implement this?
I can't see a (non-macro) way of doing *exactly* what you want, but I've got
a compromise work-...back up restore
Hi- I have made back up, how do i restore (rms1.2)?
in SO Administrator, Database/Create
This creates a new DB instance from your backup file. You will either have
to choose a different DB name than the existing database, or DROP the
database by using Query/New first.
Tiber Creek Consulting
Please DO NOT respond to me directly but post all responses here in the
newsgroup so that all can share the information
"bh" <firstname.lastname@example.org>...Messages not reaching recipients or bouncing back
1 user has found this week that all mail she has sent have simply
disappeared! Emails sent to a variety of destination email addresses - no
bouncebacks, but none have been received.
We investigated & found this to be true. Test messages are definitely
leaving our server, and at least arriving at the mail server that we forward
to (though they have not been able to confirm that they have left that
This is what we've tried so far:-
1) We virus-checked the user's PC - none found - virus definitions up to
date & we have good firewall + rules to prevent users rec...backing up to cd #3
I'm trying to back-up my Microsoft Money file to a CD.
However whenever I try it I get the message "You do not
have permission to open this file.
See the owner of the file or an administrator to obtain
permission." (I am the owner).
I am using Money 98. PLEASE HELP! I don't wan't to lose
this information when I plug in my new upgraded computer,
so I have to save the file.
In microsoft.public.money, Terri Benshoof wrote:
>I'm trying to back-up my Microsoft Money file to a CD.
>However whenever I try it I get the message "You ...Outlook Data files???
When I click on File-> Open-> Outlook Data File..., there are no files
shown. Shouldn't there be a/some pst files here?
It depends on whether you have created .pst files in the default location or
some other location.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.
After searching google.groups.com and finding no answer, Jackson asked:
| When I click on File-> Open-> Outlook Data File..., there are no fi...SBS4.5 crashed a while back!!
We have been asked to get involved with retrieving some emails from a EDB
The situation is: Server was SBS4.5 running Exchange 5.5. We have the
PRIV.EDB and PUB.EDB, but we do not know what the site, organisation names
Are there any tools that can extract this information for us - we are hoping
(and praying!!) to be able to install Exchange 5.5. with the correct details
and then restore the EDB files and do a isinteg -patch and see if that gets
Any advice greatly appreciated.
There are a few pre-requists here. Org name, Site name and Service pack
level for...Access dB_MSCRM data and Get filteredfieldname
In CRM 3.0 I have attached the NAME_MSCRM data to excel however when I open
the data drop down windows all the available fields start with
filteredxxxxxxxxxxxx, with xxxxxxxxxxx being account, address(1) etc… so its
giving me the field names with “filtered” on the front.
What/Why is this and how can I see/access the data as I did in 1.2
Darryl - email@example.com -www.mtccrm.com - Only Microsoft CRM
CRM 3.0 uses views to enforce data security. These views are all prepended
with the word Filtered. Using these views will make sure that CRM users only
see records they have permission to se...Adding conditional data from 2 separate columns
Hope someone out there can help, Ive fallen and I cant get up!
Basically, I am trying to write a formula that reads something like
If ('data' from 'worksheet a'! column E4:E695 is "X" AND 'data' from
'worksheet a'! column F4:F695 is "Y") then add them up in a certain
cell on a different worksheet.
So, If I have 10 instances in worksheet a column e is X and in column f
is Y, it should add up to 10.
I hope this makes sense. I tried using the COUNTIF function, but cant
seem to get it right.
FWIW, I didnt write the program, ...Backing up Contacts
This is a multi-part message in MIME format.
I am able to back up all my e-mails and settings except my Contacts,
which has all my friends and family e-mail address. Can anyone tell me
how to back up my contacts in Outlook 2003? I would appreciate it if you
could CC my e-mail address as well as the newsgroups.
David C. Stevens
14 Broadview Avenue
Berlin, New Jersey 08009-1618
E-Mail : firstname.lastname@example.org and/o...question about data from excel to work
I am trying to take input from an excel sheet and mailmerge it to
word....the thing is I want to make it so from here on out ..if I change
something in the excel sheet it automatically updates on word as
well..if not a mail merger what can I use ?
Hi Pooja Kamdar,
You can link the Word document to the Excel workbook, so that any changes in the Excel workbook will be reflected in the Word
document. To do this:
1. copy the source range in the Excel workbook
2. in the Word document, use Edit|Paste Special > Paste Link and choose the paste format you wan...Outlook 2003 Email Immediate Bounce Back
I'm having an odd problem with outgoing email in Outlook 2003.
I just got a new laptop w/XP Pro and loaded the MS Office Standard Suite w/SP1. I also downloaded and installed Office SP3.
I set up Outlook email w/all my POP3 settings and tested the settings in Outlook -- all fine.
Incoming email is no problem. However for some outgoing emails, I get an immediate (and I mean instantaneous) bounce-back message that looks like the following:
Your message did not reach some or all of the intended recipients.
Sent: 2/5/2010 12:13 PM
The following re...Deleting Data
I could really use some help here. I need to delete data without deleting
formulas. I don't want to have to do it on a cell by cell basis. I would
like to be able to select the entire sheet and then click a button like
"clear contents" but leave all formulas and formats.
Select a cell on the sheet and go to Edit>Go to...>Special>Constants and
press the delete button
Microsoft MVP - Excel
"Joel" <email@example.com> wrote in ...Data validation with a cell value linked to the same cell.
I Think that my post name is very confusing but I'll explain.
I�m doing a data validation in cell f1 usig the data validation option
the value entered in cell f1 need to be equal or greatter than th
value in cell b2 and cell b2 is calculated with the formula =a2+c4-f1.
What I'm trying to do is to prevent to enter a value in cell f1 tha
I'll make cell b2 negative.
But its not working, any suggetsions???
Message posted from http://www.ExcelForum.com
Change your CF criterion to
Formula is = F1 <= (A2+C4)
In article <rodolform.161w07@excelforum-n...