Vendor list

Hi,
I have searched and cannot find this, so if it's a duplicate I am sorry.  I 
need to print a list of our suppliers with address, phone, web, e-mail and 
account  number.  Does anyone have this?

Thanks,
George 


0
9/19/2007 4:33:30 AM
pos 14173 articles. 0 followers. Follow

2 Replies
257 Views

Similar Articles

[PageSpeed] 3

Here is the SQL you will need .... 


select
	id as 'Account',
	suppliername as 'Supplier',
	address1 as 'Address',
	address2 as 'Address (Cont)',
	city as 'City',
	state as 'State',
	zip as 'Zip',
	phonenumber as 'Phone',
	faxnumber as 'Fax',
	emailaddress as 'Email',
	webpageaddress as 'Web Site'
from supplier
order by id





"geokar" wrote:

> Hi,
> I have searched and cannot find this, so if it's a duplicate I am sorry.  I 
> need to print a list of our suppliers with address, phone, web, e-mail and 
> account  number.  Does anyone have this?
> 
> Thanks,
> George 
> 
> 
> 
0
Luminox (155)
9/19/2007 11:56:03 AM
This is a multi-part message in MIME format.

------=_NextPart_000_029E_01C7FBDE.1F634760
Content-Type: multipart/alternative;
	boundary="----=_NextPart_001_029F_01C7FBDE.1F634760"


------=_NextPart_001_029F_01C7FBDE.1F634760
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Geokar,

Try this one,

--=20

Jeff=20
Check Point Software

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D

You must be using Outlook Express/Windows Mail or some other type of =
newsgroup reader to
see and download the file attachment(s).  If you are not using a reader, =
follow
the link below to setup Outlook Express.  Click on "Open with =
newsreader"
under the MS Retail Management System on the right.

http://tinyurl.com/75bgz
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D

  "geokar" <george@aluminumbats.com> wrote in message =
news:OfTPAZn%23HHA.3716@TK2MSFTNGP03.phx.gbl...
  Hi,
  I have searched and cannot find this, so if it's a duplicate I am =
sorry.  I=20
  need to print a list of our suppliers with address, phone, web, e-mail =
and=20
  account  number.  Does anyone have this?

  Thanks,
  George=20


------=_NextPart_001_029F_01C7FBDE.1F634760
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type =
content=3Dtext/html;charset=3Diso-8859-1>
<META content=3D"MSHTML 6.00.6000.16527" name=3DGENERATOR></HEAD>
<BODY id=3DMailContainerBody=20
style=3D"PADDING-RIGHT: 10px; PADDING-LEFT: 10px; FONT-SIZE: 10pt; =
COLOR: #008000; PADDING-TOP: 15px; FONT-FAMILY: Arial"=20
bgColor=3D#ffffff leftMargin=3D0 topMargin=3D0 CanvasTabStop=3D"true" =
acc_role=3D"text"=20
name=3D"Compose message area">
<DIV>Geokar,</DIV>
<DIV>&nbsp;</DIV>
<DIV>Try this one,</DIV>
<DIV><BR>-- <BR><BR>Jeff <BR>Check Point Software</DIV>
<DIV>&nbsp;</DIV>
<DIV>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D</DIV>
<DIV>&nbsp;</DIV>
<DIV>You must be using Outlook Express/Windows Mail or some other type =
of=20
newsgroup reader to<BR>see and download the file attachment(s).&nbsp; If =
you are=20
not using a reader, follow<BR>the link below to setup Outlook =
Express.&nbsp;=20
Click on "Open with newsreader"<BR>under the MS Retail Management System =
on the=20
right.</DIV>
<DIV>&nbsp;</DIV>
<DIV><A title=3Dhttp://tinyurl.com/75bgz=20
href=3D"http://tinyurl.com/75bgz">http://tinyurl.com/75bgz</A><BR>=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
<BR></DIV>
<BLOCKQUOTE=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #008000 2px solid; MARGIN-RIGHT: 0px">
  <DIV>"geokar" &lt;<A title=3Dmailto:george@aluminumbats.com=20
  =
href=3D"mailto:george@aluminumbats.com">george@aluminumbats.com</A>&gt; =
wrote in=20
  message <A title=3Dnews:OfTPAZn%23HHA.3716@TK2MSFTNGP03.phx.gbl=20
  =
href=3D"news:OfTPAZn%23HHA.3716@TK2MSFTNGP03.phx.gbl">news:OfTPAZn%23HHA.=
3716@TK2MSFTNGP03.phx.gbl</A>...</DIV>Hi,<BR>I=20
  have searched and cannot find this, so if it's a duplicate I am =
sorry.&nbsp; I=20
  <BR>need to print a list of our suppliers with address, phone, web, =
e-mail and=20
  <BR>account&nbsp; number.&nbsp; Does anyone have=20
  this?<BR><BR>Thanks,<BR>George <BR><BR></BLOCKQUOTE></BODY></HTML>

------=_NextPart_001_029F_01C7FBDE.1F634760--

------=_NextPart_000_029E_01C7FBDE.1F634760
Content-Type: application/octet-stream;
	name="Custom - Misc - Supplier (Detailed).qrp"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment;
	filename="Custom - Misc - Supplier (Detailed).qrp"

//--- Report Summary --- //

Begin ReportSummary
   ReportType =3D reporttypeMisc
   ReportTitle =3D "Supplier (Detailed)"
   PageOrientation =3D pageorientationLandscape
   OutLineMode =3D True
   Groups =3D 0
   GroupDescription =3D "Total"
   DisplayLogo =3D True
   LogoFileName =3D "MyLogo.bmp"
   ProcedureCall =3D ""
   TablesQueried =3D <BEGIN>
	FROM Supplier WITH(NOLOCK)
	<END>
   SelCriteria =3D ""
   GroupBy =3D ""
   SortOrder =3D "Code"
End ReportSummary


//--- Title Rows ---//

Begin TitleRow
   Text =3D "<Store Name>"
   Font =3D "Arial"
   FontBold =3D True
   FontSize =3D 16
   Color =3D "Blue"
End TitleRow

Begin TitleRow
   Text =3D "<Report Title>"
   Font =3D "Arial"
   FontBold =3D True
   FontSize =3D 12
   Color =3D "Black"
End TitleRow

Begin TitleRow
   Text =3D "As Of: <Report Date>"
   Font =3D "Arial"
   FontBold =3D True
   FontSize =3D 10
   Color =3D "Black"
End TitleRow

Begin TitleRow
   Text =3D "Designed and/or modified by Microsoft Corp. and/or Check =
Point Software"
   Font =3D "Arial"
   FontBold =3D False
   FontSize =3D 8
   Color =3D "Black"
End TitleRow

//--- Filters ---//


//--- Columns ---//

Begin Column
   FieldName =3D "Supplier.Code"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "Code"
   VBDataType =3D vbString
   Formula =3D ""
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1560
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
End Column

Begin Column
   FieldName =3D "Supplier.SupplierName"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "Name"
   VBDataType =3D vbString
   Formula =3D ""
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 2500
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
End Column

Begin Column
   FieldName =3D "Supplier.AccountNumber"
   DrillDownFieldName =3D "Supplier.AccountNumber"
   DrillDownReportName =3D ""
   Title =3D "Account #"
   VBDataType =3D vbString
   Formula =3D ""
   ColHidden =3D True
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1400
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
End Column
=20
Begin Column
   FieldName =3D "Supplier.Address1"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "Address"
   VBDataType =3D vbString
   Formula =3D ""
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1750
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
End Column=20
=20
Begin Column
   FieldName =3D "Supplier.Address2"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "Address2"
   VBDataType =3D vbString
   Formula =3D ""
   ColHidden =3D True
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1500
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
End Column=20

Begin Column
   FieldName =3D "Supplier.City"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "City"
   VBDataType =3D vbString
   Formula =3D ""
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1560
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
End Column
=20
Begin Column
   FieldName =3D "Supplier.State"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "State"
   VBDataType =3D vbString
   Formula =3D ""
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 600
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
End Column
=20
Begin Column
   FieldName =3D "Supplier.Zip"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "Zip"
   VBDataType =3D vbString
   Formula =3D ""
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 870
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
End Column

Begin Column
   FieldName =3D "Supplier.Country"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "Country"
   VBDataType =3D vbString
   Formula =3D ""
   ColHidden =3D True
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 870
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
End Column

Begin Column
   FieldName =3D "Supplier.PhoneNumber"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "Phone #"
   VBDataType =3D vbString
   Formula =3D ""
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1365
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
End Column

Begin Column
   FieldName =3D "Supplier.ContactName"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "Contact"
   VBDataType =3D vbString
   Formula =3D ""
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1750
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
End Column

Begin Column
   FieldName =3D "Supplier.FaxNumber"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "Fax #"
   VBDataType =3D vbString
   Formula =3D ""
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1365
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
End Column

Begin Column
   FieldName =3D "Supplier.EmailAddress"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "Email Address"
   VBDataType =3D vbString
   Formula =3D ""
   ColHidden =3D True
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 2000
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
End Column

Begin Column
   FieldName =3D "Supplier.WebPageAddress"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "Web Page"
   VBDataType =3D vbString
   Formula =3D ""
   ColHidden =3D True
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 2500
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
End Column

Begin Column
   FieldName =3D "Supplier.AccountNumber"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "Acct #"
   VBDataType =3D vbString
   Formula =3D ""
   ColHidden =3D True
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1750
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
End Column

Begin Column
   FieldName =3D "Supplier.TaxNumber"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "Tax #"
   VBDataType =3D vbString
   Formula =3D ""
   ColHidden =3D True
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1750
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
End Column

Begin Column
   FieldName =3D "Supplier.Terms"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "Terms"
   VBDataType =3D vbString
   Formula =3D ""
   ColHidden =3D True
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1500
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
End Column


Begin Column
   FieldName =3D "Supplier.CustomText1"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "!CaptionSupplierCustomText1"
   VBDataType =3D vbString
   Formula =3D ""
   ColHidden =3D True
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1800
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
   ColAlignment =3D flexAlignLeftCenter
End Column

Begin Column
   FieldName =3D "Supplier.CustomText2"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "!CaptionSupplierCustomText2"
   VBDataType =3D vbString
   Formula =3D ""
   ColHidden =3D True
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1800
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
   ColAlignment =3D flexAlignLeftCenter
End Column

Begin Column
   FieldName =3D "Supplier.CustomText3"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "!CaptionSupplierCustomText3"
   VBDataType =3D vbString
   Formula =3D ""
   ColHidden =3D True
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1800
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
   ColAlignment =3D flexAlignLeftCenter
End Column

Begin Column
   FieldName =3D "Supplier.CustomText4"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "!CaptionSupplierCustomText4"
   VBDataType =3D vbString
   Formula =3D ""
   ColHidden =3D True
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1800
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
   ColAlignment =3D flexAlignLeftCenter
End Column

Begin Column
   FieldName =3D "Supplier.CustomText5"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "!CaptionSupplierCustomText5"
   VBDataType =3D vbString
   Formula =3D ""
   ColHidden =3D True
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1800
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
   ColAlignment =3D flexAlignLeftCenter
End Column

Begin Column
   FieldName =3D "Supplier.CustomDate1"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "!CaptionSupplierCustomDate1"
   VBDataType =3D vbDate
   Formula =3D ""
   ColHidden =3D True
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1300
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
   ColAlignment =3D flexAlignLeftCenter
End Column

Begin Column
   FieldName =3D "Supplier.CustomDate2"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "!CaptionSupplierCustomDate2"
   VBDataType =3D vbDate
   Formula =3D ""
   ColHidden =3D True
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1300
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
   ColAlignment =3D flexAlignLeftCenter
End Column

Begin Column
   FieldName =3D "Supplier.CustomDate3"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "!CaptionSupplierCustomDate3"
   VBDataType =3D vbDate
   Formula =3D ""
   ColHidden =3D True
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1300
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
   ColAlignment =3D flexAlignLeftCenter
End Column

Begin Column
   FieldName =3D "Supplier.CustomDate4"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "!CaptionSupplierCustomDate4"
   VBDataType =3D vbDate
   Formula =3D ""
   ColHidden =3D True
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1300
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
   ColAlignment =3D flexAlignLeftCenter
End Column

Begin Column
   FieldName =3D "Supplier.CustomDate5"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "!CaptionSupplierCustomDate5"
   VBDataType =3D vbDate
   Formula =3D ""
   ColHidden =3D True
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1300
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
   ColAlignment =3D flexAlignLeftCenter
End Column

Begin Column
   FieldName =3D "Supplier.CustomNumber1"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "!CaptionSupplierCustomNumber1"
   VBDataType =3D vbDouble
   Formula =3D ""
   ColHidden =3D True
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1080
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
   ColAlignment =3D flexAlignLeftCenter
End Column

Begin Column
   FieldName =3D "Supplier.CustomNumber2"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "!CaptionSupplierCustomNumber2"
   VBDataType =3D vbDouble
   Formula =3D ""
   ColHidden =3D True
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1080
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
   ColAlignment =3D flexAlignLeftCenter
End Column

Begin Column
   FieldName =3D "Supplier.CustomNumber3"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "!CaptionSupplierCustomNumber3"
   VBDataType =3D vbDouble
   Formula =3D ""
   ColHidden =3D True
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1080
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
   ColAlignment =3D flexAlignLeftCenter
End Column

Begin Column
   FieldName =3D "Supplier.CustomNumber4"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "!CaptionSupplierCustomNumber4"
   VBDataType =3D vbDouble
   Formula =3D ""
   ColHidden =3D True
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1080
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
   ColAlignment =3D flexAlignLeftCenter
End Column

Begin Column
   FieldName =3D "Supplier.CustomNumber5"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "!CaptionSupplierCustomNumber5"
   VBDataType =3D vbDouble
   Formula =3D ""
   ColHidden =3D True
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1080
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
   ColAlignment =3D flexAlignLeftCenter
End Column

Begin Column
   FieldName =3D "Supplier.Notes"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "Notes"
   VBDataType =3D vbString
   Formula =3D ""
   ColHidden =3D True
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 2115
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
   ColAlignment =3D flexAlignLeftCenter
End Column


------=_NextPart_000_029E_01C7FBDE.1F634760--

0
cptsoft (1247)
9/21/2007 6:29:43 AM
Reply:

Similar Artilces:

How to move down through a list?
Hi, I have been attempting this but having no luck. I have sheet which I copy info from A1:A9 to another sheet. Then I save and close that and go back to the original sheet. I need to move down to row 2 and do all the copy and paste again. There are about 300 rows and the exact last row could change. How do I get this to move down to the next row until there are none left? Thanks Gerald Not sure of what you are asking. What is "this" in: "How do I get this to move down to the next row until there are none left?"? Are you using a macro? If so, post back an...

Protecting a sheet with a list box
I have a list box with a number of companies. I then use a vlookup formula to bring in the account information to the proper cells. It works perfectly, except that when I protect the sheet, it will not work What am I missing Al Bailey Hi whcih Excel version are you using? In Excel 2003 (and I think also in Excel 2002) you can enable this in the protection dialog -- Regards Frank Kabel Frankfurt, Germany "ABYPFCS" <anonymous@discussions.microsoft.com> schrieb im Newsbeitrag news:97CFF827-0BD3-48E4-B890-F12D30F8E346@microsoft.com... > I have a list box with a number of ...

SFO Address list block
What is the process to disable the warning popup whenever you try a set up a crm appointment from within Outlook 2002 Users are tired of allowing 1,5, or 10 minutes for each use. This usually happens if your admins have made some additional security lockdowns in your organization. The fix is to trust the CRM add-in - there is information on MSDN about how to trust an Outlook add-in. -- This posting is provided "AS IS" with no warranties, and confers no rights. "Jim" <jim@kinetic.distillery.com> wrote in message news:etw4HYexFHA.3588@tk2msftngp13.phx.gbl... > W...

List Exchange 5.5 OWA Users
I found a post that references Exchange Svr 2003. I need the same commands for Exchange 5.5. I would like to be able to generate a listing of users with OWA access on our Exchange 5.5 server. Any and all help will be greatly appreciated. Thanks, GMan ...

Have multiple price breaks for a vendor
When we order products from a vendor we can save money by ordering maybe 100 at a time versus 1 at a time. There is no way in the system to enter multiple price breaks for a vendor. If we order 200 we may even get a cheaper price. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the mess...

Vendor Statement
Dear Sir, We are looking to have Vednor Statment to be print showing Begining Balance All transaction withini selected period and closing balance. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser...

Add vendor balance to "Payables Transaction Inquiry
When doing Inquiry > Purchasing > TRX by vendor, show the outstanding balance due the vendor when a vendor is selected. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx?mi...

Word 2004: Style List / Style Dialogue Box Bug
Hello all -- I'm in Word 2004. Upon opening a new document, it defaults to showing only a couple of styles in the style list. I want to be able to see all of them. Word Help suggests going to the Formatting Palette and selecting all styles. This works, but I don't use the Formatting Palette that often. The second option: View All Styles in the Style Dialogue box doesn't work. This is the one I want to use. It tells users to go the the Format menu and select Style command, then select All Styles on the List popup menu. I did this and clicked apply, but when I go back to the documen...

Temporary Vendors/Vendor History
We are using Great Plains v7.5. In one of our Company ID's we have 1777 vendors, of which 690 of them are Temporary Vendors - which are only used once, possibly twice. I know I can delete these vendors and still inquire in: 'Inquiry, Purchasing, Trx by Document' BUT the Vendor Name shows as "Vendor not found" and I'd still like to have that information. Is it possible to save Temporary vendors and their accompanying transaction history (possibly in Excel, although I'm open to other suggestions)to CD. Thanks Chris Chris Chris, I believe that the temp ...

Employee list
In column A, I have a list of employee numbers. In column B I have their first name, and in column C their last name. What I want to do is to enter an employee number in a cell, and for that cell to return their first and second name. How can I do this please? --- David Scott Hampshire, England Assuming that the labels are in Row 1 and the cell with the Employee Number look up in in E2 try: =IF(ISNA(VLOOKUP(E2,A2:C100,2,FALSE)&" "&VLOOKUP(E2,A2:C100,3,FALSE)),"No Match found",VLOOKUP(E2,A2:C100,2,FALSE)&" "&VLOOKUP(E2,A2:C100,3,FALSE)) --...

how do I format a numbered list where only first line is indented?
I like to use numbers for paragraphs in the same essential formatting as the rest of the text: first line indented, the rest flush with all text. The only way I've figured how to do this is to laboriously format each list by clicking until I direct the software to indent only the first line (versus "hanging"). But I cannot save this style as a unique style, or alter the "list paragraph" style or the "normal" style or any other pre-made style - the modification isn't recognized. It's as if Word 2007 requires all numbered lists to have mar...

Sort address list by using LDAP query
I am not sure if it is possible on Exchange 2003. Currently our address book is sorted alphabetically by its display name entries. I want to sort it so all distribution lists will become on top of the list and followed by user names. On Exchange System Manager, under 'All Address Lists', I have an Address List with the following LDAP query (using 'Custom Search'): (&(&(mailnickname=*)(|(&(objectCategory=user)(company=*))(&(objectCategory=group)(displayName=*))))) Is there any LDAP keyword that I can add here so it can be sorted as I want? Thank you in adv...

Payables Transaction Entry, change vendor
When I am in Payables Transaction Entry, it would be nice if I could change the vendor without having to delete the voucher. As it is now, the last vendor used is what pops up in the Vendor field. so you have already put in the date and the description and the Invoice # and if you accidentally tab the last used vendor name pops in and you have to delete the entire transaction and start over. If we had the option to change the vendor name without deleting it, it would save a lot of time. -- Sheri Salomone for Margaret Lopez THANKS! ---------------- This post is a suggestion for Micros...

Tally lists based on results
I need to calculate how many alike products are chosen in a table from data tables (validated data) to show a tally. How on earth do you do this? How do i calculate how many "Blue" items are listed each time a Blue item is added to the list etc? Each time a new item is listed, it will automatically appear in the tally list as a new item and/or count tally. There is a possibilty of 1000 items though commonly only a maximum of 10 should appear in the tally. eg. The data collected by input. A B 1 Blue $50 2 Red $40 3 Blue $50 4 Orange $20 5 Blue $50 6 Orange $20 etc In this exam...

Duplicate Name List
I have a large file, some 3000+ lines with account names, of these most are duplicated, at the most there are only around 70 individual names. How can I produce a list with just one line for each name. Hi 1- Search help for advanced filter. or 2- arrange the accounts in ascending order. If ur data starts from cell A1, then in B1 write this formula "=A1=A2". Drag this formula down to the last account. Apply auto filter and delete all records that are TRUE. there might be other ways of doing this but these are the quickest. Regards Asim -------------------------------------...

Recipent list shows all
We are trying to send out a newsletter and are having problems with the recipient list. We have created a distribution list. If we put it in the "TO" field all names, but not email addresses, show up. If we put it into the "BCC" the TO field is blank. How do we us the list and have only the individual recipients name show in the TO field? You'd have to perform a mail merge, either through Outlook or Word. -- Patricia Cardoza Outlook MVP Author - Special Edition Using Microsoft Office Outlook 2003 Lead Author - Access 2003 VBA Programmer's Reference Author - Ab...

Discrepancy between Vendor Summary and Vendor Detail records
Our auditors asked for a report showing vendor history for the past year. I ran the Vendor Summary report and gave it to them, but I thought I'd spot check a few of the figures just to make sure I could support what appeared on the report. Well, surprise - I discovered a discrepancy between the detailed A/P files (i.e., the PM20000 Transaction Open and the PM30200 Paid Transaction History Files) and the PM00202 PM Vendor Master Period Summary. There is a record in the PM00202 (summary) file for period 5 of 2007 that has $7,702.97 in the AMBKDLIF (Amount Billed Life) field. I find t...

Update Price List via Workflow
What am I missing? I would like to change the price list assigned to selected account records from time to time, via an on-demand workflow. Within the workflow rule definition, in the 'Update Account' form, clicking the lookup button for the Price List field (defaultpricelevelid) displays the lookup dialog without any of the existing price lists displayed; an existing price list cannot be selected. Even if I use the [New] button to create a new price list on the spot, that new price list likewise is not available for selection. The bottom line is that I am unable to use work...

Disable an item in a list
Is it possible to tag an value in a listbox as not selectable i.e., greyed out. I don't want to remove the item permanently as depending on a number of things it could become selectable again. Thanks, Martin I don't think that is possible. -- Jim "Martin" <Martin@discussions.microsoft.com> wrote in message news:2FDBA66A-13A1-4D5B-BEA7-FEC3F01FD31E@microsoft.com... | Is it possible to tag an value in a listbox as not selectable i.e., greyed | out. I don't want to remove the item permanently as depending on a number of | things it could become selectable aga...

black list
where can control if my mail domain is in any black list? On Wed, 22 Jun 2005 17:29:05 +0200, "MMC" <ryuken_26@yahoo.it> wrote: >where can control if my mail domain is in any black list? > You can only control whether or not your site ends up on a black list by making sure the server isn't being used as a relay and making sure your users aren't wildly sending out thousands of unsolicited messages to all and sundry. It's a behavioural thing really. Check the following to see if your mail server is in a blacklist. Also, check the headers in any mail retur...

vendor holdbacks
Hi, Can anyone recommend a solution for handling Vendor holdbacks? For example, we receive an invoice from a vendor for $100,000 for services rendered in Recevings Transaction Entry. We would like to issue payment to the vendor for $60,000 and hold back the other $40,000 of the invoice until the project is complete. We need the entire $100,000 to hit the job as a WIP. Thanks, If you are working Construction projects, Wennsoft has a project management product that does this. Otherwise, when you voucher the invoice from the vendor, the entire amount hits the distribution (WIP)...

Formulas List
How do I print a list of all formulas contained in a worksheet? Tools/Options, and on one of the tabs there's a box to display formulas. Click that, do your printing, then change the setting back. The shortcut key for this is CTRL+` (the single back-quote to the left of the 1 key on the upper row of the keyboard). On Sun, 12 Dec 2004 20:05:04 -0800, "Earl" <Earl@discussions.microsoft.com> wrote: >How do I print a list of all formulas contained in a worksheet? "Earl" <Earl@discussions.microsoft.com> wrote... >How do I print a list of all formulas ...

Filters, Can't Find Exception List In Rules
I'm trying to set up my filters for junk mail. I want junk mail with certain words in the subject sent to deleted folder. I found the filters.txt file and some of the words are already there. So apparently the filter isn't working. I tried to follow the directions on how to turn them on and they said to choose the exceptions entry in the rules wizard but I have no such choice. I know how to edit the filters.txt file but Outlook is not using it. Can anyone help? The Filters.txt file isn't actively used by Outlook -- it's really just a "readme" type file to sh...

Marshaling list of strings
Sometimes people asked here how to pass strings between C++ and C# (or other managed environments). Since Visual Studio 2008, the marshal_as template library was introduced. However, this library is more like an infrastructure, to be completed by the programmer, basing on his particular needs. I'd like to share a simple template specialization I did, to marshal lists of strings (Unicode UTF-16 strings) between managed and native worlds: http://code.msdn.microsoft.com/MarshalAsStringArray Giovanni Very cool. Thank you. AliR. "Giovanni Dicanio" <giovanni.dicanio@in...

hyperlink validation list
I have a excel file with 2 worksheets. The first worksheet is a list of hyperlinks to files (with a "friendly" display name). I want to create a cell in the second worksheet which uses data validation to pick from the list of hyperlinks. I want the hyperlink on the second page to be active so that users can click on it and go to the file. I also want only the user "friendly" name to appear in the cell. So far when I use data validation the link does not work and only the "friendly" name appears as regular text in the cell. Help! Stacie, I have the same ...