Product Key Query #2
I have a mac office 2004 product with 3 product keys. What has
happened is that i installed it, it read the product key and then
nothing happened... so I wasted a whole product key. Can i get help
so I can re-use it and also help with the installation. I have a
macbook - white - 2.00GHz
On 30/1/07 07:28, in article
"email@example.com" <firstname.lastname@example.org> wrote:
> I have a mac office 2004 product with 3 product keys. What has
> happened is that i installed it, it read the product key and ...Custom LDAP/OPATH query to create custom address list?
I'm going to ask this again because it seems to be a big problem going
to exchange 2007. How does one create a custom LDAP query to an
external server to build a custom address list? It would be nice to
be able to create custom address lists built on LDAP queries to Active
Directory or OpenLDAP, etc.
Can this be done?
Only recipients in Active Directory can appear in Address Lists.
You would have to import external recipients into AD as Contacts to be able
to do this.
MVP - Exchange
NEW blog location:
------------------------...BUG: Validating datasets written from a generated strong-typed dataset
I have a pretty simple XSD schema:
* XSD SCHEMA
<?xml version="1.0" encoding="utf-8" ?>
<xs:attr...query timing out. how do you stop this from happening?
What can be done to keep a querie from constantly timing out? Almost all my
queries and functions are doing this lately as my database grows. Any advice
on this is very much welcome.
Message posted via AccessMonster.com
...display the result
I have the following programme.module for generating all possiible
combination of in a group of 3 items and it works like this
Private Sub Command1_Click()
Dim rs As ADODB.Recordset
Dim stocknames() As String
Dim i As Long
Dim j As Long
Dim k As Long
Set rs = New ADODB.Recordset
rs.ActiveConnection = CurrentProject.Connection
rs.Open "select stockname from stocknames order by stockname", ,
i = 0
Do While Not rs.EOF
ReDim Preserve stocknames(i)
stocknames(i) = rs.Fields("stockname")
i = i + 1
rs....Different Type of Picture in a Document
I have received a document that i have to work on that was compiled by
various folks and I have no idea who did what.
When I select pictures within the document, I have some pictures with
the usual single border; circles at the corners, and squares at the
I have other pictures, that when selected, have a double border, that
is turquoise. There are three dots in a row at the sides and three
dots in a triangle at the corner. With this type of picture I cannot
explicitly set the size or other options available with the type
Does anyone know why some pictures would be ...How do I type in a web-link?
Operating System: Mac OS X 10.5 (Leopard)
When signing an email, sometimes I want to add my website address as a clickable weblink. I thought that i used to do this by simply typing the address and hitting return, this doesn't seem to work, though. What should I do?
It works in Word, but not in Entourage. Links become clickable if the
message is viewed by the recipient, but it does not show up as such in the
Compose window. If you type your message and hit the Send Later button, you
will find the message, complete with clickable hyperlinks, in your outbox.
...Still get limit warnings after change
I have been working with my E2K3 server to enable more convienient use of the
Mail message warning limit. I installed the Quota message service which works
very well but when i change a users limits and/or the limits set in the ESM
console (mailbox store properties) i am still getting a warning for a user
who is now within limits. Is there a lag time? can i manually update
something? so the user doesn't receive limit warnings anymore??
Quota changes can take up to two hours to take effect.
MVP - Exchange
"Protecting the world from PSTs and brick backups!"
&q...How do I get rid of/refresh the browsed pages links in the hyperli
It's driving me nuts just to find one link. Ig I could clear it up once in a
while that would be cool. thanks for the help. :)
In Internet Explorer, tools, Internet Options, delete files.
Mary Sauer MSFT MVP
"adumbledore" <email@example.com> wrote in message
> It's driving me nuts just to find one link. Ig I could clear it up once in a
> while that would be cool. thanks for the help. :)
...INSERT TEXTFILE Leading to odd results
I am very new at Publisher. I am testing a template that I designed which is
a two-sided one-sheet brochure where each side contains three text boxes that
I inserted. Each text box is of equal size and I have the overflow links set.
Now, when I go to INSERT|TEXTFILE and point to a MS WORD 2003 file that is
six pages it all flows into the text boxes, which is fine. The problem is
that the formatting within the WORD doc is not preserved. Specifically, I
have paragraphs with borders that are squished-up in the PUBLISHER image.
Each paragraph is treated as a seperate table, whic...Running Sum Query
> Q.1: I have table "HMADetail" That has fields as
> Date Lot# SubLot# HMAPlacedToDay HMAPlacedToDate .......
> (1) (2) (3) (4) (5)
> I Have not created Query table from this table but created report with
> fields (4) and (5) same. I set property for Field (5) with Running Sum
> Overall. This report works good. But it writes all records from begining date
> to end date. I need The end date records only. How do I get this without query table?
> Q2: If I have to creat ...Problem in permanent type add-in toolbar
Hi, I have been facing a issue with dealing with my add-in toolbar. I want to
make my toolbar permanent so that use can hide and reposition it
permanently(even after restarting Outlook). At the same time, I want to
support my add-in toolbar for all opened Outlook explorer.
I want to make sure that at any point of time there must be one and only one
toolbar on any Outlook window. I have tried below methods but none worked:
1. Tried deleting toolbar on shutdown. This doesn't delete the toolbar and
each restarting outlook adds new toolbar.
Private Sub AddinInstance_OnBegi...Help with expression builder in a select Query
I am a beginer of Access. I have a database that consists of 4
columns/fields of dates. These dates/fields can be filled or can be blank.
I call them A, B, C, D.
Now I want to make a query or report to retrieve the date data in the
column/field of A. The criteria for this: all the dates in field A must be
later /larger than those in field B or C or D if B or C or D contains any
I queried the A,B,C,D from the table that contains these fields. The first
criteria I wrote is "A is not Null". But then I want to say if B or C or D
is not blank, A must be ...Save as type missing types
What would cause the save as type drop down list not to have any options
except for *.xls?
...Can I change the Excel Queries Developed From Reporting Tools
I have created the Excel iqy queries from the third party
reporting tools and during the process there is an option
either to pass the User Login id and Pass word as a
parameter or not. We have developed some queries using
generic id so that the users do not have to pass the Login
id and password and now we want to change that. Is there a
way to modify that excelquery.iqy file without redoing
can i see the sql script of that "iqy" file.
can i modify that?
Please let me know.
Thanks in advance!!!!
...Certain e-mails get bounced back to me with the following error.
Certain contacts I could send to recently now come back
undelivered with the following error message. I have
looked into the knowledge base and nothing matches.
553 Sorry, that domain isn't allowed (#5.7.1)
Thank you in advance for any assistance.
You may need to authenticate to your outgoing server, which can be set up on
the "Outgoing Server" tab for your account.
This posting is provided "AS IS" with no warranties, and confers no rights
"Lance Stevens" <firstname.lastname@example.org> wr...Exact match query
My colleague told me that there's a function in sccess that can accomplish
I need to check every month's report against the last. As I don't want to
waste time checking those entries that were checked previously, I want to run
a query to find the unmatched entries (comparing 2 tables). However, I don't
have a primary key as these tables are imported from excel. I need to find an
exact match for every cell in the row.
I've tried running the unmatched query on access and it only matched the
data in 1 column. How can I go about it? Is there a way to do it in ex...Saving a Filter as a Query in VB Via a button, Can it be done?
Saving a Filter as a Query in VB Via a button, Can it be done? P.S. I use 07'
More info can be found here about my question.
> Saving a Filter as a Query in VB Via a button, Can it be done? P.S. I use 07'
...getting other folders than inbox synchronized when checking internet mail
I am using Outlook 2002 with Windows XP.
can I download mail messages from an internet based
account (defined as pop3) that are in a folder other than
Merrav <email@example.com> wrote:
> I am using Outlook 2002 with Windows XP.
> can I download mail messages from an internet based
> account (defined as pop3) that are in a folder other than
> my inbox?
If you want messages received with another account to go into a folder other
than Inbox, you'll have to create a rule to move them there.
3290 Patterson A...GP 10 Web Service - CreateSalesOrder method
I am using the Dynamics GP 10 Web Service, CreateSalesOrder method to
create a sales order from my Windows Forms application. I would like
to display for the user the Sales Order number that is assigned
(automatically) when the order is created.
MSDN says the key.id is automatically populated in the SalesOrder
class. This may be true, but if so the scope does not extend back to
my call because SalesOrder.key.ID is null.
The CreateSalesOrder method returns void, so the answer is not there
I have a kluge answer in which I read the SOP10106 to get back the
number of the order just cr...How do I get PPt 2007 out of safe mode
Just installed PPT2007. Switched an older version presentation to 2007 and it
seems to be locked in safe mode. Any ideas on what caused this and how to get
Save as a new name
"delcoronado" <firstname.lastname@example.org> a �crit dans le
message de news: 4C54D52D-875B-46CE-8961-386B86D649D7@microsoft.com...
> Just installed PPT2007. Switched an older version presentation to 2007 and
> seems to be locked in safe mode. Any ideas on what caused this and how to
> it out?
Has the trial period expired on the new 2007 i...HOw do I get the formula to figure out a percentage?
H & P Consent Pre-Sedation
YES NO YES NO YES NO Total Cases
11 13 12 98
I need the percentage of each column.
Assuming that your numbers are from A2 to F2, here is a very simpl
solution, i.e., not an elegant formula but will work.
If you want the percentages to appear below the numbers, enter in B2
and copy this up to cell F2.
Another option is
Also, don't forget to "percent" format your cells (B2:F2).
> H & P Consent Pr...Clicking on "Help" in Word 2007 results in a blank help window.
Instead of the online help displaying as it should, the content of the Help
window is completely blank.
The user reports this happened quite a while back, so doing a System Restore
would be shooting in the dark. Is there some registry change to make to get
this working as it should?
...Getting a space between Concatenated cells
When merging data from multiple cells to one cell, is there a way to make a space between the merged text? Example, to have the end cell look like "Bob Jones" instead of "BobJones"?
Thanks to anyone who can help!
"Kristine" <email@example.com> wrote in message
> When merging data from multiple cells to one cell, is there a way to make
a space between the merged text? Example, to have the end cell look like
&qu...I want to get rid of this message!
"The contents of this appointment have been updated."
Office 2009, WinXP
Oops.....I meant Office 2007!
> "The contents of this appointment have been updated."
> Office 2009, WinXP
> Please Help!
Under what circumstances are you seeing that message?
Ben M. Schorr, MVP
Roland Schorr & Tower
Author: The Lawyer's Guide to Microsoft Outlook 2007: