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
"firstname.lastname@example.org" <email@example.com> 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:
------------------------...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
...Document ID Field Locked
I'm trying to use VBA to unlock the DocumentID field (TypeID on the Sales
Transaction Entry window). Initially when entering a new order it is unlocked
but when you navigate off this field it locks and cannot be changed. The
people who installed GP are no longer here so I'm not sure if this is a
customization or if all GP installations work this way. In any case, I'd
like to unlock this field completely so that users can change the Type ID at
any time in case they put in the wrong one. No matter what VB code I use and
what event, the field stays locked after tabbing off...Calendar Printing Assistant-won't update
Besides my own Outlook 2007 calendar, I am also the "owner" of a public
calendar to which several others have editing privileges. I can add and
change appointments to the public calendar, but when I go to print it, my
updates are not there even though they are visible on my Outlook screen.
What can I do to get CPA to print the updated appointments?
My understanding is that CPA does not handle merged calendars very
You may want to consider using a Outlook Calendar printing app called
Wincalendar instead. It allows you to render your Outlook calendar in
various....NET 3.5 update failed, error #0x8007064C
Windows update downloaded and failed to install updates for .NET 2.0 and .NET
3.5 initially. Found instructions to download cleanup tool, remove both 2.0
and 3.5 and manually reinstall them. The problem with 2.0 went away, but the
update installer thinks I still need the update for 3.5 and keeps trying to
install it, and failing with the error code: 0x8007064C
It's blocking all other updates. Please suggest how to fix it.
Google is your friend. A search for this error code showed this as the
first of many entries: http://support.microsoft.com/kb/958055/en-u...Update 1 of 1 installing, computer won't shut down
When I shut down my computer and get the message, 1 of 1 updates installing,
do not turn off your computer", nothing installs and my computer doesn't
automatically turn off like it usually does. I have had to turn it off at
the power switch, when I press the off button on the CPU, nothing happens.
It just continually goes back and forth from, " installing 1 of 1 updates,"
to "do not shut down your computer, it will shut down automatically."
I would appreciate any help in fixing this issue.
> When I shut down my com...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 ...Updating GAL from Excel?
Can anyone recommend a tool for updating a global address list from an excel
spreadsheet? Im not sure if such a thing exists but this would be a major
I have an excel spreadsheet with my entire corporations address information
and the execs would like to rely on the GAL for finding contact information.
This would take me hours to do manually and having a tool or a script that
can import or update fields would make the labor much simplier. I appreciate
On Fri, 7 Oct 2005 08:41:03 -0700, "Keith"
<Keith@discussions.microso...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 ...Taste this internet update from the Microsoft
Content-Type: multipart/related; boundary="jukqxrdabzx";
Content-Type: multipart/alternative; boundary="ygcghhjyswr"
this is the latest version of security update, the
"November 2003, Cumulative Patch" update which eliminates
all known security vulnerabilities affecting
MS Internet Explorer, MS Outlook and MS Outlook Express.
Install now to help maintain the security of your computer
from these vulner...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!!!!
...MS Office 2007 update junk email filter (KB977839)
I cannot install MS Office 07 update junk email filter (KB977839).
I have tried several times but still it do not install (error code 646)
> I cannot install MS Office 07 update junk email filter (KB977839).
> I have tried several times but still it do not install (error code
> Please help.
Rather than using Windows Update to install this update, try
downloading it manually and installing it.
http://forums.sl...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...Task Update History
We use MS Project 2007 and we are having an issue getting resources to
report their hours every day. Is there a history report that would show us
the history of which days each resource reported their time?
Sorry but Project Server 2007 does not have those kind of detailed logging
Are you using My Timesheets or My Tasks or both? If you are using My
Timesheets, you might be able to create an SSRS or Data Analysis report that
shows which days the resources have reported hours against.
"Stacey" <Stacey@discuss...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'
I'm trying to understand how the 'snapshot' reporting works and need to
understand how the ItemDynamic table is maintained.
My working hypothesis is this:
When shops connect overnight, they receive new data from HQ and send up
sales data for the period since the last connection.
Shops only send details for items that have changed - i.e. been sold or had
goods received or transferred.
Probably the snapshot date in ITEMDYNAMIC is the last date that an item had
This means that any cost/price data in ITEMDYNAMIC relating to a snapshot
could pre-date new cost/price d...Microsoft Query is changing a negative number into a date
I am using Microsoft Query to pull a subset of a large excel file however two
of my columns which are suppose to be numbers are not pulling in the negative
numbers. If I look at the query in microsoft database the number shows up as
a date/time string. I've tried formatting the original number as a number
but the query still won't read the negative number. How do I get the query
to read a negative number as a number and not a date.
Highlight the columns and format as a date
> I am using Microsoft Query to pull a subset of a large ex...3D Updateable table
I need to create a 3d table consisting of a bunch of companies in rows, each
with a set of fixed variables for each across the top in columns- the same
for each of the last 20 days. Each day I want to put "today's" new "sheet"
on the "front" and drop off the back one.
Conceptually at least, any ideas how the smart way to think about this ?
Brent Wheeler Limited
Ph (09) 379 2344
Website : www.brentsjam.com
Latest : www.brentsjam.com/bwl.html (Updated 01/08) - Integrity
& the Legal Profession
Client S...Dynamic Update
I have a data set that looks like this:
I have been creating 2 charts, 1 from the amount column and 1 from the mid
price column which looks like
How do I make the charts update automatically? I can follow the examples for
a single column of data that updates the chart when a new row is added but I
am adding 4 columns at a time and using the data in every fourth column and
I cant work out how to do it.
Worksheets are inexpensive. Add a worksheet that links t...Expression builder in a select query
I want to determine the qualifying % of commission based on Margin $ as follows
>75 and <149.99 8%
>150 and <249.99 10%
>25 and <349.99 12%
My expression below do not produce correct results.I need help.
,IIf([Net_Margin]<149.99,"...FW: See important update from the M$ Corporation
Content-Type: multipart/related; boundary="xlbtnant";
Content-Type: multipart/alternative; boundary="ilsjlfrsssmnt"
this is the latest version of security update, the
"September 2003, Cumulative Patch" update which eliminates
all known security vulnerabilities affecting
MS Internet Explorer, MS Outlook and MS Outlook Express
as well as three new vulnerabilities.
Install now to help maintain...SQL update for Payables manual payment distributions
Can someone please provide me with a SQL script to update the distributions
of a payables manual payment. The correct check amount is already available
for each transaction in the manual payments screen. I now want to use the
same value (check amount) for each payment and update the related
distribution line items.
Thanks in advance,
I'm being dense here, but I don't understand what you are trying to do. Do
you have the manual payments already saved to a batch and you want to set the
distribution accounts without having to open the window?
If yes, the dis...Why is the data pulled down from an online update, ALL WRONG?
I'm using Money 2004 Deluxe. I just figured out how to get online updates
for my 403(b) from Fidelity. I've pull everything down into MS Money.
Looked cool, at least for a while.
Then I noticed that out of the 6 mutual funds I'm investing in, only 2 had
symbols associated with them. So I tried to assign the symbols to the other
4. Only thing is when I did, I got error messages saying that the symbol
was already in use.
So then I went into help and found that if I went to the Investing menu
option and choose "Work With Investments" and then choose "Choose ...Date time combined query
I need to pull all records out of a main table from a beginning date at a
certain time.... till a ending date at a cerain time. please help
Do you have significant table and field names that you can share? I always
recommend creating a form with controls that allow users to enter or select
criteria values that can be used to filter a query, form, or report.
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
"Desperate Wes" wrote:
> I need to pull all records out of a main table from ...