Help with field translation with Scribe
Does anyone have a uself guide for using scribe to translate fields from
Salesforce to the integer codes used in crm. I have a good amount of our data
migrated but I'm stuck on theses translation. I used their setup for the user
mapping and it either does not work or they left steps out of the guides that
If anyone has an alternative to using scribe to get this done I'm open to
that as well. Specifically what I need is a way to find value "A" in
salesforce and insert value "01" in CRM. Its on the replace step I need halp
with I got the field matc...Configure Exchange 5.5 for backup to another domain
Is it possible to configure Exchange 5.5 to be a back
mail server for another domain as well as it's host
domain. Example... mx record has 10 -> firstdomain.com
20 -> backupdomain.com If firstdomain.com's exchange
server goes down is there a way to configure
backupdomain.com's exchange server to accept mail for
firstdomain.com and send it to the server when it comes
back online? But it cannot stop accepting mail for
Yes, it is posible.
On Exchange server for backupdomain, in Exch Admin prog, IMC props,
Routing ta...Outlook Forms????
I created a form, however, there is a message page, with the To:, From: ect.
& a Page 2. I really don't want the form to be 2 pages. How can I get
everything onto the message page. This way a user does not have to click the
P2 tab to fill in the form.
Cut and paste the controls on Page 2 to the main message page.
FYI, there is a newsgroup specifically for Outlook forms issues "down the
hall" at microsoft.public.outlook.program_forms or, via web interface, at
Sue...Is it possible
I would like to know is it possible to make million dollar in the internet, if you have any suggestions, write on my forumhttp://isitpossible.truemillion.comMark...Personal Folders in OWA
I have just enabled OWA on our Exchange 2003 SP2
through ISA Server 2004. Is there any way to
access personal folders in OWA?
Thanks in advance.
If by personal folders you mean .pst files, the answer is NO! Sorry.
C C wrote:
> I have just enabled OWA on our Exchange 2003 SP2
> through ISA Server 2004. Is there any way to
> access personal folders in OWA?
> Thanks in advance.
"C C" <firstname.lastname@example.org> wrote:
>I have just enabled OWA on our Exchange 2003 SP2
>through ISA Server 2004. Is there any way...Memo Field 09-25-07
I have a memo field in my table and the user can update this field from a
form. The problem is that when they input a lot of data at one time, it
turns the last lines to garbage and/or truncates the last lines.
I would appreicate any suggestions as to why this is happening.
Is there something in the text box property I should set so access knows
this is a memo field? ( grasping at straws)
Thank you in advance for your help.
Post the SQL statement of the form's Record Source. Identify the field that
is the memo data type.
<MS ACCESS MVP>
"Sha...pivot table macro
I want to create a pivot table using the pivot table wizzard from a worksheet
into a worksheet with the name table by running a macro. when I record the
macro I create the pivot table using the wizzard and it works fine but when I
try to run the macro again it errors "unable to get the pivot tables property
of the worksheet class" any help?
Post the code you have created
"skippy51" <email@example.com> wrote in message
> I want to create a pivot table usi...Downloading Statements Directly Not Possible
I have Money 2002 installed on an Win XP Pro SP1 machine. Something
happened and I probably did it, that causes the statement downloads not to
go directly to the account. Rather they want to be saved in a file and then
opened into Money. I then have to delete the download.
I have tried several things in order to fix this:
1. I verified the file associations of OFC, OFX were correct. They were.
2. Lowered all my security settings in IE. Even put banks into Trusted site
zone. No go.
3. Made new accounts. Didn't help.
4. My IE cache is large (500MB) and regularly cleaned out.
5. I made s...Moving an old transaction from one account to another.
I have a *very* strange situation here...
Once upon a time, Mr. Pat Smith married Ms. Pat Jones. The Mrs. Pat Smith
was a cute oddity for the duration of the marriage. Sadly, the marriage
ended. Mrs. Smith did not change her last name back to Jones...
Now we have two people in town with the same name. 'Pat Smith'. Mr. Pat
Smith bought a mattress set. In RMS, the mattress is on Mrs. Pat Smith's
account. This probably would have gone unnoticed for along time, possibly
forever, except for the unfortunate demise of the mattress under warranty.
Now we need to return the m...is this possible? reload a form that is based on a query with new query that is defined in the form.
I have a basic form.
The form is based on a query, so when I open the form, a pop comes up
where I enter in what I want to query.
So instead of 30,0000 records, I get 1-10 records.
on the form, I have a text box. I want to be able to enter in what I
want to query next and afterupdate have the recordset/form reload with
that query instead of my original qeury.
I figure this has to be done with VB. I am just starting to learn some
VB but I am lost.
Any info would be great, thank you.
You need to apply the new query or table name, or the sql string to
the forms recordsource, then...internet explorer won't recognize my e-mail address/why
I don't know why,when I try to send an e-mail from microft word.it won't go
through and says it dosen't recognize my e-mail address(firstname.lastname@example.org)
You'll need to be a bit more specific then this.
How does Word and Internet Explorer play any role in this?
You're sending emails via Outlook.
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003
Outlook FAQ, HowTo, Downloads, Add-Ins and more
Real World Questions, Real World Answers
...what is another way to unlock my word document?
I've tried many ways to unlock my document but none of them work?
what can i do?
> I've tried many ways to unlock my document but none of them work?
> what can i do?
Jocy626, I now have the same problem as you have. I can not open any saved
word docs, nor can i save new docs im trying to do
Give us SOMETHING to work with!
What versions of Office and OS are you using?
Are they patched up to date?
Please describe your problem with some detail such as is this just one Word
document or all Word documents?
Terry Far...Waiting for Input in a macro
In a macro I am running, the cursor is required to select a cell 'E1',
where the user is expected to enter some value and once the value is
entered, the macro should execute the remaining lines. However, I am
unable to cause the macro to wait till the input is actually entered
and the macro executes all the lines without waiting for input. Can
someone suggest a solution ?
ActiveCell.FormulaR1C1 = ""
ActiveSheet.PageSetup.PrintArea = "$A$1:$I$51"
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Coll...The message interface has returned an unknown error #2
When I try to enter an new event in my calendar I get this error message. I can't enter any new events. I have restarted Outlook many times and that does not fix the problem. I know there is a pretty easy way to fix this. Does anyone know what it is?
Try closing Outlook and deleting/renaming the frmcache.dat
and then reopen it and see if it helps.
>When I try to enter an new event in my calendar I get
this error message. I can't enter any new events. I have
restarted Outlook many times and that does not fix the
problem. I know there is a pretty ...Blocking fields to avoid use in formulas
Is there any possibility to block the particular field in order to
avoid users to use invalid fields in formulas ?
You can lock and unlock cells (then protect the worksheet) so that users can't
change certain cells.
But if you allow them to type a formula into a cell, then I can't think of
anyway of stopping them from pointing at A1 when A1 shouldn't be used.
Is that what you meant?
If it is, maybe someone else has a way...
If it's not, maybe you should rephrase your question.
> Is there any possibility to block the particular field i...Possible to detect changes to an XmlDocument object?
If I instantiate an XmlDocument object, the load a file through the Load
method, is there a way, later on in execution, to easily determine if the
XmlDocument object has changed from the original version loaded?
I'd like to be able to check a condition to see if the document in memory
has been editted (i.e., nodes added, attributes changed, etc.) so that my
user can decide whether or not to commit changes to the disk file before
moving to another file.
Will I have to resort to re-loading the file, and comparing OuterXml
Gabe Covert wrote:
> I'd like t...Mapping of ID fields
I created an custom entity with parent relationship from Opportunity. I can
map Name and other fields from opportunity to this new entity fields, but
what is the right way to map the Account (potential customer) from
Opportunity to custom field in the new custom entity?
...Deleting Duplicate entries #2
I have a huge spreadsheet with over 7500 rows which has
been given to me. A large number of the entries are
duplicated many times within the sheet. Is there a way to
run a macro or a worksheet function which will
automatically find and erase the duplicate entries based
on one unique column that I can use?
Check out this site
And this page "Delete duplicate Rows"
Regards Ron de Bruin
"email@example.com" <firstname.lastname@example.org&...auto fill a form
please help I have tried but cant seem to get this to work. What I need is
information from form 1 to be auto field in on form 2 I already have a combo
box on form 2 that pulls data from a field (unit number) on form 1. Now I
need the information for 4 more fields (vin mumber,make,model,year) on form 2
that is also on form 1. Thank you.....
I may be reading too much into your description...
It sounds like you want to replicate data. That is, you want data in one
table (visible via form1) to be added to a second table (via form2). If
this is what you are trying to accomplish, consider ...E mail attachment in Vista
I have Windows Vista and am having trouble opening e mail attachments in
Windows Mail. I am novice so any help would be appreciated.
This newsgroup is dedicated to the Microsoft Access database product. The
Microsoft website is not all that clear and may have misdirected you. I
suggest post your question to a Vista newsgroup:
Windows Vista discussion groups:
Microsoft Access MVP
http://www.access.qbuilt.com/html/expert_contribut...Copy a chart from one workbook to another workbook?
l've tried to copy one workbook to another workbook using VBE.
Does anyone have any idea?
Thank u :D
What is it you are copying, an embedded chart, a chart sheet, a worksheet,
or a workbook? If it's a chart, are you copying just the chart, or the chart
and its data? Is your intent to use the data from the new workbook with the
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
"y0ngb00n" <email@example.com> wrote in message
&g...Changing Content of mapped Fields
is there a way to change the content of mapped fields?
I have got an custom entitie which is mpped with company and offer. If I
creat my entitie from "company" the mapped field (companynumber) is set its
value as it should be, in my costom entitie field "customernumber".
Creating a new record from my custom entitie and select via mapped lookup
field a company the mapped entitie field remains blank.
Also having an other field mapped to an entitie. By changing data in the
source field the mapped field won't change (update) either.
How could the solution loo...How can I execute my macro for every row in worksheet
I'm a macro newbie...
In my worksheet, I want to use a macro to find the word "RETENTION" and
insert a blank (new) row after this word until all the rows in the worksheet
Any suggestions? Thanks.
try the following macro. It tests column A and inserts a row if
the value is 'RETENTION'
Dim lastrow As Long
Dim row_index As Long
lastrow = ActiveSheet.Cells(Rows.count, "A").End(xlUp).row
For row_index = lastrow - 1 To 1 Step -1
If Cells(row_index, "A").Value ="RETENTION" then
Cells(row_index + ...Minimise form. leave open in background etc.
I have a user form which has been set up to be used as a menu with lots
of buttons doing various operations.
After clicking a button and carrying out the task(s) I would like to
able to move back into a worksheet(s) do some work and then step back
to the form.
At present I have to close the form do the work and then reopen it.
Is it possible to minimise the form, leave it open in the background
whilst I work on the sheets and then maximise to choose/use further
menu items etc.?
Any help with coding would be gratefully received.
You can make the userform modeles...Is it possible to compare a string and a field name
I have the following tables: Membership, Subscriptions, OfficeUseOnly. The
Office Table contains a Year, Year To and From [financial year] and the other
fields are the 5 membership types (regular, student etc) and these 5 fields
contain the different amount each type of member has to pay.
I want to create a form whereby on entering the financial year and the
membership type the correct amount is automatically inserted into the
FinancialYear - in current form = OfficeUseOnly SubsFinYear
and then if MemberType = 'Student' find Student field ...