Pages

Search

Microsoft CRM - Sorted by Name Views ('SortOrder')

Microsoft CRM - Sorted by Name Views ('SortOrder')


Sorted by Name Views ('SortOrder')

Posted: 07 Mar 2005 12:21 PM PST

"Julian Sharp" wrote:
 

Hum, not exactly. My problem is not about sorting the grid by a column
(thanks for the detail description, though).

I would like to sort the list with the filters itself - the dropdown
list/menu(s) "View:" on Contacts, Opportunities and etc.

Exmaple:
My Contacts
Inactive Contacts
Sales - John Smith
Customers
Sales - Peter Doe
New Contacts this week
....
and etc... till >25

The list above is not sorted by 'name' and not very usefull, right?
It looks like sorted by DB_ID altough I am not very sure about it.

So my question is "is it possible to sort these lists by name?" if not,
there is a suggestion about it.

It is normal practice to use SortOrder (10, 20, 30 etc) field or just to
hardcode the ORDER BY in the SQL query for lists like that (or it is just me
:)

Cheers,

Miro

Schema Mappings

Posted: 07 Mar 2005 03:35 AM PST

Google on CRM SDK if you haven't already looked at the SDK. Also try
www.mscrmexperts.com for some good articles.

Matt Wittemann
http://icu-mscrm.blogspot.com


"Bouffont" wrote:
 

removing all customization?

Posted: 06 Mar 2005 04:19 AM PST

Just beware that the BOL version will state that the table defination "could"
exceed 8k as long as the columns are defined as VARs. It's the actual data that
cannot exceed 8k. Thus, the program must know this might happen and then handle
the sitiation where the data limit was exceeded. CRM chose to avoid this by
instituing a hard limit at 8K on the definition of the table.

Matt Parks
MVP - Microsoft CRM

----------------------------------------
----------------------------------------
On Sun, 6 Mar 2005 17:18:59 -0600, "Sean Fullerton - eMonarch"
<et> wrote:

I do not know of any "official" online document with regard to the 8K limit.
But you can look in the SQL Books Online for the information.

Sean Fullerton

"HT" <microsoft.com> wrote in message
news:com... 


Help-adding a contact in browser does not sync to SFO

Posted: 04 Mar 2005 11:45 AM PST

I am sorry, I meant to say that i have done that. I have 6 sales reps ,
all have the same problem. It worked great until we upgraded to outlook
2003 (or so it seems)

Outlook Web Access

Posted: 04 Mar 2005 10:21 AM PST

There is no way to get CRM to show up inside of Outlook Web Access, but you
can publish CRM to the internet behind SSL by assigning it a port and SSL
certificate. There is more on the newsgroup about how to do this. Then your
client can hit CRM from outside the network from any internet connection
(with Windows and IE 5.5 or better).

Matt Wittemann
http://icu-mscrm.blogspot.com


"Shauna Koppang" wrote:
 

Upload attachments to CRM notes via post to SRF

Posted: 04 Mar 2005 07:29 AM PST

I am very interested.

I opened up a ticket with Microsoft about a month ago and they basically
told me that it could not be done and to wait for 2.0. I could not get past
the error messages either.


"Paul Galvin" <microsoft.com> wrote in message
news:4ff301c5229c$343f3f90$gbl...
Greetings,

Wanted to let everyone know that this issue is solve for
us. If anyone is interested, I'll share the details.

--Paul Galvin
ISSG
 
Error</title></head><body>Server 


HELP - CRM OUTLOOK

Posted: 04 Mar 2005 07:21 AM PST

when you are in outlook you are the user logged in on the machine.

You need to add the crm URL to the local sites on IE. for instance: http://crm
Then you don't need to login when accessing the system from the browser

/Jakob

"help" wrote:
 

XML and CRM 1.2

Posted: 04 Mar 2005 06:06 AM PST

Wow, thanks, time to brush up on my coding skills, thats looks pretty
in depth!!

Thanks T

CRM migration from CDF opportunity

Posted: 03 Mar 2005 02:05 PM PST

Hi Julian,

Thanks for your suggestions. Did not get this untill we had already started
to do batch conversions. So they are running overnight. Will see what the
results are and will look into your recommendations. It is nice to know
there are people out there who have come across issues posted here and are
willing to share their knowledge. It is greatly appreciated:-) Will post
you if we have any success.

Shauna

"Julian Sharp" wrote:
 

Microsoft Word - "You've chosen to save this web page using short file names"

Microsoft Word - "You've chosen to save this web page using short file names"


"You've chosen to save this web page using short file names"

Posted: 16 Jul 2014 03:12 PM PDT

Dear Community,

 

I would really appreciate any advice you can give to a basic Word user.

 

I have a Word 2007 doc which contains left, top and right frames (pic attached). I want to convert this doc into a web page or whichever file just so I could send a link to it to my colleagues who would then open it in internet explorer, not word doc. I already have this doc in Word and really don't have technical skills to do it any programmes to create web page or write codes. I just want to convert it to a web page or whatever could be opened in IE.

 

When I try to do it by Save As web page I get a message "You've chosen to save this web page using short file names". As much as I understood my file name should be in 8.3 format but all my frame/file names are under 8 characters. If I understood it, the system is interpreting that the file name is 'My drive/desktop/folder name/file name' which is obviously longer than 8.3 format.

 

I understand that Word is a no no for creating web pages but I already have this doc fully functional in Word and I would just need that final step (if possible). I've checked many websites and there are no clear explanations if and how to resolve this matter. One site recommended selecting 'to use longer file names' via Word Options/Advanced/Web options/Files but that doesn't work.

 

Any thoughts how this could be resolved I would really appreciate it.

 

Thanks all.

Pekgor

Word 2010 only prints blank envelopes

Posted: 16 Jul 2014 02:57 PM PDT

Word used to print envelopes just fine now it will only print complete documents; it doesn't matter which printer is used the Epson: NX 625, the W-7010, or the CX 4200 all print a blank envelope you can hear the print head moving but no ink is deposited. I have tried new envelope templates no luck. Interesting thing is with Epson CX-4200 it will sometimes print  the address but not the return address. I have read the postings that say set the file>backstage print command to p0s1 but have not been able to find that setting anywhere it's not under file or options. Am at wits end.

"Pulling files from Recent documents"

Posted: 16 Jul 2014 02:19 PM PDT

I was working on two Word documents on my computer, then closed them and went to work on them in our conference room. We made several changes and I saved them and closed them. I came back to my workstation to to final edits. I chose the files from my "recent" documents drop down list, since i had worked on them earlier that day. When I pulled them up, the changes made in the conference room were not there. Our computer tech seems to think it has something to do with the documents being pulled from "recent", and that they were held in memory and overwrote the revisions made. Does anyone know anything about this?

Formatting place/tent cards

Posted: 16 Jul 2014 02:12 PM PDT

I have a template for tent cards from Paper Direct but I don't know how to format it correctly so that names & table numbers fit.  There are 4 on a sheet.  Also do I do the same procedures for any place/tent cards.  The size is 2x3 1/2.  This is my first time ever doing this in Word.  Can anynone help?  I'm getting very frustrated trying to figure it out by myself.  Thank you.

Ms. Halli

Help with Opening a Word Document

Posted: 16 Jul 2014 02:11 PM PDT

Hi,

I would like to ask for help regarding opening a microsoft word file.

I recently saved my file, but when I try to open it up, I am faced with this error message:

"The file Developer.docx cannot be opened because there are problems with the contents"

When I elect to recover the contents of this document, I am faced with the same error message:

"The file Developer.docx cannot be opened because there are problems with the contents".

Is there anything I can do to restore this document?

Thank you very much,

Steven

How to remove annoying outline from Building Block Gallery Content Control and anchor Picture Control Content?

Posted: 16 Jul 2014 01:26 PM PDT

Hello,

I am crafting an editable template document, as you can see in the attached image.

I am having two problems:

1. I want to anchor the Picture Control Content (appears as the blue box in the image) to its location in the building block.  How do I do this?

2. Is there some way to remove the outline from the Building Block Gallery Content Control?

Thanks

Patrick

How do I turn off Word 365 SharePoint integration?

Posted: 16 Jul 2014 12:58 PM PDT

I have to wait 12 seconds each time I launch Word.

I work at a Fortune 500 company and my Word O365 works great.  My problem is that Word(and every other public Internet program) opens slow 99% of the time.   I work on $5 million dollar Big Data servers that are in a special data center.  Even though I'm sitting in a corporate office with 100s of others, I have to be VPNd in to the data center all day to access special servers.

When I launch IE11, it takes 12 seconds for Bing to come up.  If I stay on Bing, the web is fast.

Any link I click on or other web site is another 12 second wait, for DNS resolution I'm guessing.

All my O365 apps like Word and Excel do the same thing.  I have to wait 12 seconds each time I launch word.  I've resorted to keeping my important notes in notepad just so they'll open quickly.

If I unplug my pc from the network and turn off wireless, Word opens fine.

If I close the VPN connection I need to connect to my servers and do my work, Word opens fine.

How do I make Word think my computer isn't on the network?  Is there a option or registry setting or something?

Please don't tell me to fix the network/VPN bug.  I have no control over that.  I have complete control over my PC including uninstalling O365.  I use Windows 8.1.  Another option is to bring a second laptop to work, one on the VPN and one on the normal corpnet.

I want to do my job and use Word at the same time without a 12 second wait.  I use Windows 8.1

Thanks,

Ray

Adjust calendar wizard vba code to get table grid lines to be set (not to show gridlines, but actually add borders like before).

Posted: 16 Jul 2014 12:28 PM PDT

Í still use the calendar wizard a lot.  But unlike earlier versions of Word, Word 2010 doesn't add the gridlines to the table which makes for an odd calendar where the boxes aren't defined; they're just a lot of numbers sitting in a big square for the entire month.

Up until now, I''ve manually gone in an had to add them but surely there's a way to tweak the vb code within the calendar wizard to fix this?  I stumbled upon how to fix the start day to be Monday.  That was a real revelation.  Can't believe that all these years I manually edited the created calendars by moving the Sunday to the end of each sheet <lol>.  So easy to fix:  http://forums.techarena.in/windows-software/1155408.htm - It was supremely easy and just required I change the line

Public Const iWeekStartDay As Integer = 0

to

Public Const iWeekStartDay As Integer = 1

because "1" represents Monday.

Very neat.

So now, if I can just get the table to have interior cell borders, that would make this completely automated again with the spiffy new end result of my never having to ever again change the start day to Monday manually ever, ever again!  <lol>

Anyone know how to do that, though?  Word 00 and 03 created the calendar with interior cell borders, I never get that in Word 10.

Thank you!!

Automatic update of cross references to a table containing list of document sequence

Posted: 16 Jul 2014 12:05 PM PDT

I have a document with a table at front part of that document containing a sequence number and a reference document title. Said table shown below:

Seq Doc Title
1 X-654654
2 G-645646
3 C-465465


I would like to have it so that whenever I mention a document title at later part of the document (in normal text), I could insert a "cross-reference" to a sequence number in that initial table that corresponds to the document title. I would then like to then have the reference at later part of the document in normal text update automatically (or CtrlA & F9), even if the sequence of the document title is changed. In other words, it will be link REF to the bookmark of the document title but displaying the corresponding sequence number. For example:

"........designed per X-654654 [1]......". I would like to have the "[1]" cross referenced to "X-654654" but displaying the "[1]" as shown. the "[1]" would then update accordingly depending on where the "X-654654" document is in the sequence number.

Thank you very much.

Drop Caps Option Not Available in Word 2003?

Posted: 16 Jul 2014 11:42 AM PDT

According to the manual (Microsoft Office 2003 Bible) the Drop Cap option should be available under the Format tab.  On my system, that option is greyed out and unavailable.  I'm running Windows 7.  Is there a way to make it accessible?

how to stop "do you want to save document template"

Posted: 16 Jul 2014 11:40 AM PDT

We're using Vista Business and Word 2003. Every time I use a template to create a .doc file, a window comes up when trying to save the file asking if I want to save changes to the template. This seems to be a common problem  but I've tried following the suggestions for modifying the register and it wasn't successful.

Is there a way to disable this?

Thanks.

Printer tray selection in Page Setup doesn't work

Posted: 16 Jul 2014 10:59 AM PDT

If I set my printer properties in the print driver settings, I can't change them using Page Setup in Word 2013.  I want to be able to set the media type in the printer driver, because according to the printer company that's the only way to prevent documents from printing on my letterhead when the plain paper runs out.  However, if I use the printer driver to set the media type to "plain", when I'm in a Word document and want to print it on letterhead, I cannot use Page Setup to force it to print from my letterhead tray.  I can select the letterhead tray in Page Setup, but the printer just ignores it and prints from the plain tray.  Supposedly the Page Setup in Word 2013 is supposed to override the printer settings, but I am experiencing the opposite. 

PDF changed to Word file-changes to Word file cause Word to quit responding

Posted: 16 Jul 2014 10:49 AM PDT

I received a pdf. file and converted it to a Word file so I could make changes to it. The page freezes and at the top of the page it says Microsoft Word (not responding).

If I wait a minute or so Word responds and I can continue for a couple more paragraphs and it freezes again.

Trying to Activate account

Posted: 16 Jul 2014 10:39 AM PDT

I just paid for Microsoft Office Student and got the email with instructions to activate the account, but when I enter my account info (e-mail and password) I get an error message that says the e-mail I entered is not attached to any Microsoft office accounts.  Please Help!

Copying the color of a logo

Posted: 16 Jul 2014 10:16 AM PDT

Hi,

I am creating a logo and need to copy an existing color. When I click on the word, it does not bring up any color information. How can I find our what was used to create the color?

Thank you.

MSWord 2013 - How to link dropdown list to conditional content

Posted: 16 Jul 2014 10:08 AM PDT

Hello,

I am attempting to create a word document where the user can select an option from a dropdown list.  Each option represents a display/page of graphics and images.

For example, if the user selects dropdown option 1, then the document populates with this content (minus the purple-- that is for reference re: desired functionality)

(For each "page" (see the attached image which represents the graphics/page to be loaded upon dropdown option selection), some graphics are set, others are bounding boxes which request that the user upload an appropriate image.  All of the text is editable)

So, I am trying to figure out how to link the option selected in the dropdown... to the content.  Such that when an option is selected, the given content appears in the document.

(The content is actually a simulated html email. The idea is that users can change elements of the simulated email view, and then submit it to someone who will build the email based on their specified graphics and text)

Q:  How do I link the options in a dropdown menu to a pre-created page of content (represented by the attached image)?

Thanks,

Patrick

Docs. won't open Office 2013

Posted: 16 Jul 2014 09:54 AM PDT

Microsoft asked me to post my own question "so they could help me".  My Documents wouldn't open.  John( in this community) on line suggested to delete the upgrades for July 10 2014. I did this it worked . If I shut my computer down the upgrades come back. I delete again. Really wonderful on line help from people like John. Microsoft you should hire him! Have you fixed this yet!!! I can't believe this problem with the upgrades hasn't been resolved!

I 'm not a computer savvy person. I just want to trust Microsoft to fix problems before they do an upgrade!!! People like me just want to feel that when we buy your products you stand behind them. Where is your customer service???? You should look at Apple! That is customer service!!!

Waiting for you to "help me individually".

What is the file extension ~$Wiz12s.dotm and how do I get rid of it as Word 2007 cannot find it

Posted: 16 Jul 2014 09:45 AM PDT

Can someone tell me what the file extension ~$Wiz12s.dotm is and how do I get rid of it as Word 2007 cannot find it I get the message that it cannot be found every time I open Word.

Microsoft Update deleted Word from my computer

Posted: 16 Jul 2014 09:05 AM PDT

An automatic update deleted Word and Explorer from my computer.  I didn't care about Explorer but needed Word, so I browsed the Microsoft forums looking for advice.  I noticed that other people had complained of the same issue and weren't getting solutions.  Office was still on my computer, but the Word icon was missing, and when I tried to open my files I would get an error message.  I decided to use System Recovery to restore my computer to a week earlier.  The Word icon re-appeared but the program still would not open.  I tried Quick Repair but it did nothing.  Finally I click on Online Repair.  It re-installed Office on my computer, and Word was working fine; but some time later, a message popped up saying that I had 6 days to enter my product key before Word would become inoperable.  I haven't been able to find my product key; that was why I didn't try uninstalling and reinstalling in the first place.  Office is an expensive purchase.  I bought it last year and am not happy that a Microsoft update deleted the program from my computer.  I'm looking for the key, but if I don't find it I need another solution.

Tracking never turns off

Posted: 16 Jul 2014 08:57 AM PDT

I have a document that will not turn off the Track Changes feature. The track changes is not illuminated. If I say accept changes it says 'The document contains no comments or tracked changes' . When I save it says 'The document being saved contains tracked changes. Continue with save?
With Word thinking the track changes feature on it does not allow our document archive program to render a pdf file.  

Word autoshape fill color grayed out.

Posted: 16 Jul 2014 08:41 AM PDT

In the drawing tool bar, the fill color on the bucket is yellow but the pull-down is gray with no colors. The line color icon is displayed as blue and the pull-down is also gray with no color. The font color icon displays normally, changing color as the selection on the pull-down is changed. I am using MS Word 2002 SP3.

I have seen some discussion on this topic but no solution.  The fill color (highlighting) worked previously and then stopped. I don't see a selection to turn on auto shape (as sometimes suggested), I just have the drawing toolbar active.  The feature seems to work in Excel

Update Text with User Input in Word 2010

Posted: 16 Jul 2014 08:32 AM PDT

I'm trying to create a template that my company can use on a regular basis using Microsoft Word 2010. This form will contain a few different fields that will be used multiple times throughout the document. For example, the beginning of the document will contain a line asking for the [ProjectName]. I want an employee to be able to enter the name of their project so that every reference to [ProjectName] will automatically be updated. It will be a huge hassle to have to edit each line and leaves too much room for error or oversight.

I've been able to create a form field using a bookmark by following the steps listed here: http://superuser.com/questions/414635/update-text-based-on-field-content-in-word-2010.

But from these instructions, you can't just highlight the field and enter the text you want, you just have to type what you want before the name of the field (if that makes sense). I'm worried that this way,  anyone updating the template who doesn't know much about form fields won't do it right and it won't work for them.

Long story short, is it possible to make fields that can be edited but that can still be referenced at other locations in a Word document?

How can i create MATHML code using MS Word 2010?

Posted: 16 Jul 2014 08:09 AM PDT

I have mathematical expressions in word document. Is it possible to export data as MATHML format?

For example below formula existed in a word as a mathematical expression.

Above expression should represent as below MATHML code.


I am able to paste the above example MATHML into word and it will create a graphic. But I am unable create MATHML from existing graphic (in MS Word).

Thank you for your help

Merging an Excel doc with hyperlinks into Word doc

Posted: 16 Jul 2014 08:05 AM PDT

Hi.

I have a simple Excel document and one of the columns includes a hyperlink. I am attempting to mail merge this into Word document. However, when I do, I lose the hyperlink. The text is still present but the linkage is gone.

Is there a way to fix this?

Thanks

Office 2013 - CheckSpelling Method not working

Posted: 16 Jul 2014 08:01 AM PDT

Problem: There is no text in the "Not in Dictionary" box.

It does not show what text it is making the suggestion for?

See below:

Application.CheckSpelling Method work ok in word 2010 but not in 2013.

Is the Application.CheckSpelling Method supported in Word 2013 ?

Thanks

Tabs

Microsoft Word Won't Open One Drive Documents just goes to Menu

Posted: 16 Jul 2014 07:21 AM PDT

Whenever I try to save a document to the one drive or open a document that has been previously save, my Microsoft 365 Word closes and then reopens to the menu. 

I have reinstalled both the OneDrive and the whole Office suite. Nothing has fixed it. 

Same Office 2013 issue as other users

Posted: 16 Jul 2014 06:11 AM PDT

I am having the same issue as everyone else with MS office 2013 not opening.  I  went through the same "find the problem" suggestion and , as of the next morning,  it was still saying it was fixing the issue (I let it run over night).   I and to force a shutdown and reboot and now it's telling me that MS office is "Busy".

From what I could see last night.  it appeared that there was some installation that came through on 7/12?   

Please help -  I cannot access any of my files ( like all others who have posted)  and this is posing a big problem. 

Thank you.

 

Microsoft Office/Word 2013 not working

Posted: 16 Jul 2014 05:09 AM PDT

I am unable to open Microsoft Office 2013 (specifically word) on my computer. I get the error "something went wrong" and cannot fix it in my programs menu. I need to complete work with this program and need assistance ASAP!

Status Bar in Word 2013 doesn't show many features

Posted: 16 Jul 2014 05:09 AM PDT

Hi Guys!

I am using office 365 home and I have a problem in word. Features like word count and line number do not show in the status bar even though they are activated. Please tell me how to fix this as I really need this for my schoolwork. 

Thanks in advance

P.S. Line number starts working sometimes but word count is a major problem.

Creating protected PDF's

Posted: 16 Jul 2014 04:20 AM PDT

Dear all

Now that you can access pdf#s with Ms Office 2013 - The whole point of protecting your documents from modifications has gone out of the window.

How do i now create a pdf (from word, powerpoint, excel etc..) whilst at the same time protecting it from modifying .....in as few a clicks as possible?!!

Thank you

Akhlaaq

headers and footers in MS Word 2010 templates

Posted: 16 Jul 2014 04:19 AM PDT

Hi

I am creating a template in MS Word 2010.

I have used styles to create headers and footers and I want my first page to have a different header (ie none) so I have selected different first page, and created my footer in page 1 (which carries on through the template). I have created my header on page 2 and this follows through in the document, UNTIL i put in a section break.  After this the footer continues but the header doesn't?  When I try and edit the settings in my header, the link to previous option is greyed out.....??  I saw somewhere on a thread, that you need to have at least 2 section breaks for this to appear, however I added another section break in my document, but it still didn't become active.

So my question is: how do I keep my header running through from page 2 of a document (where i was created) after I have added a section break?

thank you :-)

Office 2013 spell checker is not working

Posted: 16 Jul 2014 03:03 AM PDT

We use the Microsoft's spellchecker component within our application - oWdDoc.CheckSpelling().

It works ok with Office 2003/2010 but not with Office 2013.

Problem: There is no text in the "Not in Dictionary" box.

It does not show what text it is making the suggestion for?

See screen below - Office 2013

For Office 2010 - spell checker is ok

Any suggestion how I can fix this problem.

Thanks

Tabs

Macro code error querying SQL database

Posted: 16 Jul 2014 12:32 AM PDT

I have a detailed macro that runs on invoices then queries a SQL database to identify whether any previous invoices have been issued to the client this year and inserts a file containing a table with various fields from the database to list those invoices and the amounts from them. I have copied the code from a similar query that functions properly to insert a different file and modified the SQL table and field names to get the data I need. The file gets inserted but none of the field information is updated and I can't identify why. This is the code I have, which is in a separate module of the macro. The initial codes are in the invoice document. If I include the line rsInvoiceLines.Close, then I get an error, although it functions correctly in the other macro:

Public Sub InvoiceStatement()

Dim rsInvoiceCount, rsInvoiceLines As Recordset
Dim strJobNo, strDate As String
Dim intNumLines As Integer

'Get the job number and date from the doc
strJobNo = GetValue("[JobNo]")
If Len(strJobNo) < 1 Then
    Exit Sub
End If
strDate = GetValue("[Date]")
If Len(strDate) < 1 Then
    Exit Sub
End If
'Find the invoice statement marker and remove it
With Selection.Find
    .Text = "[InvoiceStatement]"
    .Forward = True
    .Wrap = wdFindContinue
End With
If Selection.Find.Execute = True Then
    Selection.Delete Unit:=wdCharacter, Count:=1
Else
    Exit Sub
End If

'See if there are any invoice transactions.  If not, bail out
Set rsInvoiceCount = modDB.Query("select NUM=IsNull(Count(*), 0) from INV where JOB_NO='" & strJobNo & "'")
intNumLines = rsInvoiceCount.Fields("NUM")
rsInvoiceCount.Close
If intNumLines < 1 Then
    Exit Sub
End If


'Insert a new page and the invoice statement file
Selection.InsertBreak Type:=wdPageBreak
Selection.InsertFile FileName:=ModDBMacros.FirmPath & "Invoice_stmt.doc", range:="", _
    ConfirmConversions:=False, Link:=False, Attachment:=False

Set rsInvoiceLines = modDB.Query("select LN.DATE, HEAD=case HD.TYPE when 'INV' then HD.INV_NO, LN.FEES_AMT, LN.PARTS_AMT, HD.DISC_AMT, HD.DATE_PAID from INVDET as LN, INV as HD where LN.INV_AUDIT_NO = HD.AUDIT_NO and HD.JOB_NO ='" & strJobNo & "' and HD.DATE > '2013.12.31' order by HD.DATE")

Selection.GoTo what:=wdGoToBookmark, Name:="Inv_Stmt_Start"

Do While Not rsInvoiceLines.EOF
    Selection.TypeText (rsInvoiceLines.Fields("DATE"))
    Selection.MoveRight Unit:=wdCell
    
    If Len(rsInvoiceLines.Fields("HEAD")) > 0 Then
        Selection.TypeText (rsInvoiceLines.Fields("HEAD"))
        Selection.TypeText vbCrLf
    End If
    
    Selection.TypeText (rsInvoiceLines.Fields("REF_NO"))
    Selection.MoveRight Unit:=wdCell
    
    Selection.TypeText (Format(rsInvoiceLines.Fields("FEES_AMT"), "#,###,##0.00"))
    Selection.MoveRight Unit:=wdCell
    
    Selection.TypeText (Format(rsInvoiceLines.Fields("PARTS_AMT"), "#,###,##0.00"))
    Selection.MoveRight Unit:=wdCell
    
    Selection.TypeText (Format(rsInvoiceLines.Fields("DISC_AMT"), "#,###,##0.00"))
    Selection.MoveRight Unit:=wdCell
    
    Selection.TypeText (rsInvoiceLines.Fields("DATE_PAID"))
    Selection.MoveRight Unit:=wdCell
    
    rsInvoiceLines.MoveNext
    If Not rsInvoiceLines.EOF Then
        Selection.MoveRight Unit:=wdCell
    End If
Loop

'rsInvoiceLines.Close

End Sub

Macro Alt A not working in Word 2013.

Posted: 16 Jul 2014 12:29 AM PDT

Macro Alt A not working in Word 2013. Says "Office Access Key Alt A". How to remove this and get my macro back?

micro soft word problem

Posted: 16 Jul 2014 12:15 AM PDT

I recently had my computer fixed by norton, now i'm unable to access my i tunes and micro soft word info. My CV is on file etc.  It asks me to uninstall  Itunes, then reinstate it.  After numerous tries it keeps saying error 2330.  I need access to the micro soft.

Macro NOT working as intended in Word 2007

Posted: 15 Jul 2014 08:37 PM PDT

I recorded a macro in Word 2007 but it is not working as intended.

The macro is intended to add  the word Remote at a certain line in the document  then Protect the Word document with a password against any editing and then save it as 'using the same original name' of the open document into a DIFFERENT folder on the same hard drive.  Every document has a unique name that needs to be maintained while 'saved as' to the new folder after protection is added.

The macro works as intended to the extent that it adds the protection to the document but saves it in the same folder where the original copy of the document exists and NOT in the intended folder which is different (C:\Users\pas\Desktop\Uploadable\)

Here is the macro:

Sub ProtectANDSave()
    Selection.MoveDown Unit:=wdLine, Count:=10
    Selection.TypeText Text:="Remote "
    Selection.MoveRight Unit:=wdCharacter, Count:=22
    Selection.MoveLeft Unit:=wdCharacter, Count:=1
    Selection.TypeText Text:="  "
    Selection.Delete Unit:=wdCharacter, Count:=1
    ActiveDocument.Protect Password:="lotus", NoReset:=False, Type:= _
        wdAllowOnlyReading, UseIRM:=False, EnforceStyleLock:=False
        ChangeFileOpenDirectory "C:\Users\pas\Desktop\Uploadable\"
        strName = ActiveDocument.FullName
        ActiveDocument.SaveAs FileName:=strName, _
        FileFormat:=wdFormatRTF, LockComments:=True, Password:="", _
        AddToRecentFiles:=True, WritePassword:="", ReadOnlyRecommended:=False, _
        EmbedTrueTypeFonts:=False, SaveNativePictureFormat:=False, SaveFormsData _
        :=False, SaveAsAOCELetter:=False
        
        ActiveDocument.Close

End Sub

Any help will be greatly appreciated. 

On another note, I have no knowledge of Visual Basic at all.

Matt

Vanishing Microsoft Word files

Posted: 15 Jul 2014 08:11 PM PDT

Hello,

   Since about a week ago, many times when I am updating an existing Microsoft Word file, after I save my changes, the file vanishes from the folder. Other files in the same folder are visible. It is only the edited file that becomes invisible.

   If I open up Word, I can see the file in history. And if I save it to the old location, I can see that it still exists in the old location, even though in the folder itself it is not visible. The only way I can restore the file is to go into history, save it to a second location, and then copy the file from the second location to the original location, doing an overwrite.

   In working with a lot of files, this tends to become tiresome....

   I have no idea why this problem started happening. Is there any way to restore Word to normal behavior?

   My system is using Windows 7, and I have Office 2010.

Thank you for your help,

   Greg

I cannot edit Equation 3.0 objects in office 2013, stopped working an hour ago

Posted: 15 Jul 2014 07:06 PM PDT

I have a lot of documents with equations created using Microsoft Equation 3.0.

When I go to edit these objects now, I receive the following error:

"The program used to create this object is Equation. That program is either not installed on your computer or it is not responding. To edit this object, Install Equation or ensure that any dialog boxes in Equation are closed."

I have attempted to resolve this issue by do the following, but none of these work:

1. Running the quick repair, which results in the error "Microsoft click-to-run is not running" - which is incorrect because office works.

2. Installing the compatibility pack for word, excel, and powerpoint file formats (http://www.microsoft.com/en-us/download/details.aspx?id=3)

3. Trying to locate a Microsoft Equation 3.0 download, which doesn't exist.

4. Running the network repair, which seems to do nothing but prevent me from using office until I restart my computer

How do you edit equations created with Microsoft Equation 3. using Office 2013?

Word 2013: View Documet Souce Not Available

Posted: 15 Jul 2014 04:25 PM PDT

I am attempting to learn the source of an inserted picture / chart from Excel.  Word 2013 will not show the properties and the "Review, Compare, Show Document Source" does not work.  Show Document Source is grayed out.  Any idea how I can learn the name and location of the source spreadsheet?

Prior versions of Word permitted seeing the source code, but haven't seen the ability in Word 2013.  What am I missing?

Thanks for the help.

Copy text from a drawing

Posted: 15 Jul 2014 04:03 PM PDT

I think I remember being told, when our company changed from Word 2003 to Word 2010/2013, that I would be able to copy text from a drawing, but I can't find any reference to that topic in Help.  Is there a way to copy text from a drawing? 

Distribution groups not working - Microsoft Exchange

Distribution groups not working - Microsoft Exchange


Distribution groups not working

Posted: 12 Feb 2007 01:32 PM PST

It would make sense if the group were null. Many times when I see this
probem it is because the distibution group is not a universal group. The
membership of universal groups is stored in the GC partition. For domain
groups, the membership must be expanded by contacting a domain cotroller
(designated expansion server) and is often problematic. If the expansion
server cannot be contacted or is not designated, a null set is returned.
Try converting the distribution groups to universal groups.

As a side note, try this experiment: Create a distibution group with no
members. Mail enable it and give it the smtapaddress of your choice (may I
suggest com). Turn message tracking on and send a
message to it. Does the output of the tracking logs look familiar? (If you
every really want to send mail to the bitbucket, this is the way to do it)




"Clayton Sutton" <com> wrote in message
news:b25Ah.182649$news.easynews.com... 


From field in OWA

Posted: 12 Feb 2007 11:46 AM PST

Thanks for your answer but this is what a get: logonname
[com]..
How can I remove or change the logonname ??

// Kenneth

"Leif Pedersen [MVP]" <dk> skrev i meddelandet
news:%phx.gbl... 


Corrupted public folder

Posted: 12 Feb 2007 01:54 AM PST

In news:eqqaan$1jq$1$demon.co.uk,
Smiley <com> typed: 

If you're doing a brick-level (aka mailbox level/folder level) backup, you
should probably check with Symantec support. You also want to make sure you
are doing such a backup*only* in conjunction with an *online* backup of the
full Exchange stores, both public and private. Mailbox/brick-level backups
and restores are often fraught with errors and are generally not
recommended. 



Additional Email Domain

Posted: 11 Feb 2007 10:51 AM PST

Thank you, we have SBS 2003 and this worked, I haven't used Exchange since
2000 was released.
--
Thanks,
Douglas A. Maske
Network Administrator
Redux LLC
http://www.drinkcocaine.com


"Leif Pedersen [MVP]" wrote:
 

Public folder named Microsoft

Posted: 10 Feb 2007 05:34 AM PST

On Mon, 12 Feb 2007 21:01:11 +1100, "Gremlin" <mate>
wrote:
 
Good question on how your previous address as supplanted by the system
folder, that certainly shouldn't have happened. Will try and search
out what happened and why.

Updating of MS Intelligent Filtering

Posted: 08 Feb 2007 04:54 PM PST

It uses Microsoft Update.
You can turn off automatic updates and go to Microsoft Update manually in a
web browser, or you can schedule Automatic Updates to be run at a certain
time. Alternatively, Scott Roberts posted this script on the team blog that
you can use to download IMF updates only. You can run the script as a
scheduled task.
http://msexchangeteam.com/archive/2006/04/12/425060.aspx

--
Bharat Suneja
MVP - Exchange
www.zenprise.com
NEW blog location:
exchangepedia.com/blog
----------------------------------------------



"Jer" <microsoft.com> wrote in message
news:com... 


fe be different administrative groups

Posted: 08 Feb 2007 04:40 PM PST

HI,

The authentication box appear and don´t accept my password.

FE can see the BE.

Excuse me for my poor English. I´m Colombian (south America)

thanks,

bye


"Leif Pedersen [MVP]" wrote:
 

Mailboxes migration

Posted: 08 Feb 2007 12:50 PM PST

Hi,

It will take some time after the move before Outlook realizes that the
mailbox has been moved - how long have you tried to wait?

Leif

"Steve Amiro" <com> wrote in message
news:phx.gbl... 


keep a security copy of all emails

Posted: 07 Feb 2007 12:33 PM PST

I would actually check what you are required to retain before looking
at what you can use to retain whatever it is you need/want to retain.

Faxing from Exchange??

Posted: 07 Feb 2007 11:32 AM PST

Thanks for the reply, it helps a lot.

I'm looking at no more than say 100 per day if that.

I think your latter suggestion may be the way to go.

Thanks again.

"Mark Arnold [MVP]" wrote:
 

restricting RPC over HTTPS

Posted: 07 Feb 2007 11:00 AM PST

LOL, I'll give that a try

thanks
Paul

"Mark Arnold [MVP]" <org> wrote in message
news:com... 


Mailbox full

Posted: 07 Feb 2007 01:15 AM PST

Mark,

We look after a large number of customers on different sites. Is it just me
or is it that when people get these e-mails they just ignore it?

Although I check the exchange like you said, some users have different
limits on their mailbox. So it would be helpful to receive the e-mail as well.

I hope this sort of explains the scenario but if it can't be done then fine.

Many thanks,

Luke

"Mark Arnold [MVP]" wrote:
 

Sharing Calendars across Forests

Posted: 06 Feb 2007 08:48 AM PST

Hi,

You can replicate free/busy time between the forests:
http://support.microsoft.com/?id=238573

Leif

"Kevin" <microsoft.com> wrote in message
news:com... 


Groupwise 7 to exchange 2007

Posted: 05 Feb 2007 01:18 AM PST

Thanks for your reply, NDS will be removed within a year and we will be
building a MS AD but I need info on doing the migration, or should I do a
Migration to Exchange 2003 and then an upgrade to Exchange 2007?
Thx, Lasangne>

"Lanwench [MVP - Exchange]" wrote:
 

OWA and spam messages

Posted: 04 Feb 2007 01:56 AM PST

Sorry about the late reply.... been sick....

but thanx... will look into it :)

Regards

-AA_