Adding lines automatically #2
I'll be very specific.....
This is what i want, given the following data:
Apr 80,201 24,060
May 80,201 24,060
Jun 24,060 24,060
Jul 24,060 24,060
Act - 81,568 45,376 -
Apr 1,003 80,201 24,060
May 80,201 24,060
Jun 24,060 24,060
Jul 24,060 24
Now given this data, how do i add 5 or so lines in between
each product (the products being VB...2nd Posting
Haven't had an answer to this one, so I'll try again, I really need some
I've got a query that I'm not sure how to develop.
Quotes - QuoteNo, RaisedBy, Customer
QuoteItems - RecordID, QuoteNo, PartNo, Lifecycle, Value
There's a one-to-many relationship between Quotes and QuoteItems, i.e. one
quote can have many items.
I need to run a query to show a list of quotes with totals from the
QuoteItems table i.e.
QuoteNo, RaisedBy, Customer, List of PartNos, List of Lifecycles, TotalValue
I haven't got a clue how to start this, I know it needs to b...Best Way ?
Looking for some information. With Outlook you can have all your
contacts...address, email address, yada, yada, yada. Can I use this
information in to say mail merge with Word and email a letter to the ppl
with email addresses? Or is this better done with a Access?
The reason I ask is that we want to deliver an email to all our clients with
the latest promotions. And want it to be a bit more automated?
Any information or pointers in the right direction would be appreciated.
Have a good one,
You can use either Access or Outlook as the data source for a ma...A way to create sub-categories?
I want to group contacts by category and then a sub-category for easy
viewing. Apart from creating a new field for sub-category is there a way of
doing this? Outlook doesn't seem to support sub-categories.
Author - Special Edition Using Microsoft Office Outlook 2003
Lead Author - Access 2003 VBA Programmer's Reference
Author - Absolute Beginner's Guide to Microsoft OneNote 2003
"Casebase" <firstname.lastname@example.org> wrote in message
news:%23rx5a...Printing options within Outlook
I've got two Office XP printing questions for the
1. Is there a way to print only the content of an e-mail
message without having to save it as a .rtf file and
editing it? The goal is to print the message without the
2. When printing calendar items that were sent to a large
group of people, how do you print the "To:" field. In XP,
it appears that this field is not printed after a certain
number of recipients are reached.
Any help would be appreciated.
I can be e-mailed at:
...Is there a way to color code Outlook Contact File Folder Labels?
Is there a way to color code Outlook Contact File Folder Labels?
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Author, Google and Other Search Engines (Visual QuickStart Guide)
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Join OneNote Tips mailing list: http://www.onenote-tips.net/
"isailhbca" <email@example.com> wrote in message
>...exporting email from outlook express to microsoft outlook 2003
I have several email accounts on outlook express. When I try to import them
to the new accounts I set up in Outlook, all the email/addresses/etc. from
one of my accounts (the default email account in Express) goes into each new
Outlook account. How can I import just the email from one account into a new
"Wendy" <Wendy@discussions.microsoft.com> wrote in message
>I have several email accounts on outlook express. When I try to import them
> to the new accounts I set up in Outlook, all the email/addres...is there a way to crop a corner out of a rectangular image in Visi
Using subtract on two shapes accomplishes what i want to do, but when the
first shape is a .gif image, it does not work.
No, the "boolean operations", as they're called, do not operate on foreign
objects like bitmaps and controls.
Visio has crop functionality for imported graphics, but it is only
You could draw a small white triangle and give it "no line". Then place it
over the corner of your bitmap.
Hope this helps,
"doug" <firstname.lastname@example.org> wrote in message
I have a user who is reporting that whilst creating a new mail/ replying to a
mail, it will occassionally blank out all the text in the mail.
If he minimizes or maximizes the mail he can breifly see all the text he has
typed, but it dissapears straight away.
I've not managed to recreate teh problem myself, but am hoping this is a
general issue with a simple answer.
Thanks in advance.
...Outlook not displaying holidays
I am using Outlook 2000 and have elected the option to
display holidays. The only place I can see a listing of
holidays is in the catagory view and then nothing past the
end of 2003. Is there something I am not doing to make
Thanks for any advice you can give me.
>I am using Outlook 2000 and have elected the option to
>display holidays. The only place I can see a listing of
>holidays is in the catagory view and then nothing past
>end of 2003. Is there something I am not doing to make
>Tha...Query regarding A,B,C char. width values returned in 16-bit and 32-bit OS
I am trying to retrieve individual character widths of a string
(from a TrueType font) and I tried using GetCharWidth (which weirdly
works for TrueType fonts too tho' MSDN says otherwise) and/or
GetCharABCWidths to retrieve the A,B and C spacings. Please
note that I have selected the TrueType font (hFont) into the Device
I used GetCharABCWidths. Problem is this: GetCharABCWidths returns
correct A,B and C widths in Win 98 and incorrect (much lesser A,B and
C widths such that the characters OVERLAP) in other 32-bit OS (NT,
The effect is seen across all TrueType fonts, th...is there a way to change the time card repor format?
i'm using activereports in RMS to generate a custome timecard report. for my
timein and timeout colums, the datatype i have assigned to the columns is
vbDate. when I generate the report, the columns only show the date as
mm/dd/yyyy, they do not show the time of day piece for exactly when the
cashier punched in or out. is there any way to change the formatting of this
so that in the report the time shows up? for example, instead of showing
2/6/2005 in the time in column, it would show 2/5/2005 8:00:00 AM.
thanks in advance,
There is a timecard report on the Reports Library...Archiving Errors in Outlook 2000
I am having trouble autoarchiving a users mailbox. I get
the same error if I try and archive the sent items or the
inbox. I also get this error when trying to export to
a .pst file.
Error trying to archive inbox. The items either have been
moved or deleted.
Does anyone know how to fix this problem?
It is outlook 2000 on a Exchange Server 5.5
...Which table will refresh by adding new Account / Contact
I am new to CRM and trying to update CRM Accounts and Contacts from our
Sales Management system. I am using Micorosft Bulk Import utility. I am in
preparation of CVS files but not sure what columns do I need in CVS file to
complete one Account/Contact record. Could anybody please help. I am .NET
expert developer, please let me guide If I could develop CRM by using .NET
Microsoft do provide CRM SDK for CRM enhancment using .net. You can download
from following url
http://www.microsoft.com/downloads/details.aspx?familyid=9C178B68-3A06-4898-BC83-BD14B74308C5...Adding new pages
Any thing I do on new pages happens simultaneously on any previous page. Can someone help me please?
Can you be more specific? What stencils are you using and what are you
John... Visio MVP
Need stencils or ideas? http://www.mvps.org/visio/3rdparty.htm
Need VBA examples? http://www.mvps.org/visio/VBA.htm
Common Visio Questions http://www.mvps.org/visio/common_questions.htm
"Joanie" <email@example.com> wrote in message
> Any thing I do on new pages happens simultaneously on any previ...Outlook 2007 Rules Do not work 01-26-10
I have just upgraded outlook 2003 to outlook 2007. I am running Xp.
I have a number of email accounts coming through to my outlook.
I want the mail that is addressed to one of my work email accounts to be
moved automatically to another sub folder of my inbox.
I have tried deleting them and starting from scratch, removing any client
machine specific rules and using server based rules etc and I am still stuck,
I have seen a lot of posts about this problem but no real solutions.
Any ideas would be very gratefully received
This all used to work so well with outlook 2003 but ...Outlook & Outlook Express on same PC
I had both Outlook 2000 and Outlook Express on my PC with
Windows 98. Each was connected to different email
accounts and had different messages.
I want the same set up on my new PC with Windows XP Home
edition. But I could only find one pst file. It had the
data from Outlook. How can I find the data for the
Outlook Express folders?
Thank you in advance.
OE stores data in a different file structure to OL
"cp" <firstname.lastname@example.org> wrote in message
>...best way to deserialize xml
I'm at a quandry as to what's the best/fastest way to deserialize an
incoming xml stream?
I ran a small test on xmlserializer and on a small file it performed 10
times worse then when I used the XMLDocument and deserialized the values
myself. Is the xmlserializer really that slow?
I'm expecting a file about 1 MB in length and if it's that slow on a 2 K
file then I can't phantom how it's going to behave on a 1 MB file.
Should I just skip the xmlserializer and XML Dom and go straight to
xmlreader and do the deserialization myself?
This has been discussed a few times...Can You Count This Way?
I have some cells with note type data:
Is there a way to count every item between the commas?
Timothy Wright wrote:
> I have some cells with note type data:
> For ex:
> Is there a way to count every item between the commas?
On Wed, 19 May 2004 20:13:53 +0200, "Frank Kabel"
>=LEN(A1)-LEN(SUBSTITUTE(A1,&q...Adding macro to checkbox
I am trying to add a macro to a check box in such a way that clicking on the
box makes the macro run while un-clicking the box makes the macro "un-run"
or return things to how they were. Is there a way to do this?
Thanks in advance for your help!
You could have the first step in the macro check the checkbox's value,
and branch either to a "do" or "undo" routine.
If your checkbox is from the forms toolbar:
Public Sub Checkbox1_Click()
If Sheet1.DrawingObjects("Check box 1").Value > 0 Then
E...Outlook 2003 Compatibility #2
Can Outlook 2003 be installed on a computer with Windows ME Operating
"Les" <email@example.com> wrote:
>Can Outlook 2003 be installed on a computer with Windows ME Operating
...Is there a way to Sort data by color in Excel?
I am trying to sort data by color, is that possible?
"SRTUC" <SRTUC@discussions.microsoft.com> wrote in message
> I am trying to sort data by color, is that possible?
You're gonna need a User defined function to get the value of a color.
See Chip Pearson's site for a nice version:
Look for: Returning The ColorIndex Of A Cell
Then you could use that UDF in a separate colu...Outlook Express toolbar keeps resizing.
After my Outlook Express sits open for while the
toolbar's size increases to the point that it starts drop
selection options from the screen. Anyone run into that
Try posting this in an Outlook Express news group - this is not one of them.
Outlook is a part of Microsoft Office and is what this group supports.
Outlook Express is a part of Internet Explorer and has its own news groups.
You can also find some good Outlook Express information here:
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Du...cleaning up exchange from AD?
I need to delete an exchange 2003 server and i want to make sure that =
ALL references to exchange or mail management are deleted from active =
How can i do this?
Is there some AD cleaning tool out there?
Do you have other Exchange servers? As long as this is not the first
Exchange server in the org, simply running Exchange setup and choosing
Uninstall should do the trick for you.
Otherwise, you'll probably want to look at
and keep in mind that the schema has already been extended ...Pivot Table Query crashes access 2007
Until recently I was able to create pivot table queries, now for some reason
I am unable to.
I create my query as per normal, then change the view to Pivot table view
and access crashes, stops responding, and restarts. I think this is as a
result of the updates for office that were downloaded and installed today.
Otherwise, were can I go check to make sure I have all the correct add-ins,
etc installed and activated, I doubt this is the cause though as I have not
I have also tested this in multiple databases and all of them crash.
I am running Vista Business and Offi...