Public folder unread message count
Hi There !
Is it possible to get subj. on public folders (inbox alike) where the unread
message count is pr. user based ?
With Kind Reguards
On Wed, 21 Jun 2006 07:25:01 -0700, Kim (KBData)
>Hi There !
>Is it possible to get subj. on public folders (inbox alike) where the unread
>message count is pr. user based ?
>With Kind Reguards
If you are running Exchange 2k3 you can change this setting on the General
tab of the Public folder in question. If you are running Exchange 2k let me ...Parameter query in Access 2003 report
I want to create a parameter query that asks the user to select one,
many, or all values from a field when opening a report. I would like
the selection to be available from a list, radio box, or pull down
menu to minimize spelling errors, etc. Unfortunately the list is of
names which number about 100. Can this be done? If so, could someone
please point me to the help pages that describe this process?
My solution seems clunky but it is the only way I can see how to do
it. Any suggestions as to how else might I best approach this?
Thanks in advance
See my sample database that shows ...a count field in a query?
I have a query in which I would like to create a field which
increments by 1 for each record selected, so if there are 10 records
selected by the query, this column would show numbers 1 to 10.
Ideally I would like to have some text in front of each number, say
invoice1, invoice2 etc.
From a previous posting I realise that this is frowned upon but it
would be the simplest solution for my problem!
How can I do this?
On Mon, 03 Dec 2007 08:54:00 +0000, Geoff Cox <<>> wrote:
>I have a query in which I would like to create a field which
>...VBA to count periods in a single cell
I am looking to count the number of periods within a single cell using vba.
For instance if I have 4 cells that contain the following:
Thus the output of the code for the first cell should be '2', the second
cell output would be '3', and the third/fourht cells would be '4' because
that many period characters were encountered. Data within these cells will
contain letters, numbers, periods, a few spaces and the "-" dash symbol. Any
help is greatly appre...Plotting results of survey fields
I have a spreadsheet that measures various aspects of particular features
(i.e. usability, age of application, etc) as noted in the chart sample below
Feature Use Flexibility
A 1 4
B 2 2
C 3 5
D 5 5
E 1 1
I want to compare my results in a matrix that allows those features ranking
low (1,1) to be plotted on the lower left of the chart and those ranking high
(5,5) in the upper right, with values in between. I have tried to do this as
a scatter diagram, but am having difficulty getting the results to plot
Also, I need to separate those entries ha...CRM customization query
I have a customization query, I want to see the number of records available
before I am getting the data for reports. I need this because, I want to
generate a report by applying some filter criteria but at the same time I
want the resultant record number below a
On the advance find, after I am applying the filters we get hte resultant
data by clicking on the Find button. This takes us to the page where we can
see the data. Now I want to add a new button on the Advance find screen on
click of which I can get the record count of the result set for the filter i
have ...Entering the same value into two table fields at the same time
Say that there is a table which has 2 fields (A, B)
There is a form [Form1] (data entry type) to enter data for A by
There is also one more `TextBoxB` which is Not Visible.
My target is to record the value of (entered thtough `TextBoxA`) into
B field of the table as well.
So I write down a code "Before Insert" of the Form1 that:
" Form_Form1.TextBoxB = Form_Form1.TextBoxA "
It is not recording A values into the field B... Where am I wrong? Can
you help me please?
When I write down the same code into `OnExit` of TextBoxA, it is
yes, ...including dblink in a query to retrieve data
I connect to a table using a db link
i want to execute an spl query and populate results in to a pivo
table. My MS Query does not allow me to use a dblink and connect to th
table. Please help
Message posted from http://www.ExcelForum.com
...Counting highlighted cells?
Is there a way to count cells in a column which have been highlighted or text
that has been italicised??. As i have a column full of dates, and when
something is completed the suggested date is changed to the actual date,
highlighted and italicised. I need to keep a count on the completed dates.
In article <BC6F544F-DF88-41A8-8F15-5A8D460F73FE@microsoft.com>,
"Josh - Westfield Australia" <Josh - Westfield
> Is there a way to count cells in a column which have been ...Change Legend Entry label of "Total" to actual name of field.
I have two pivot charts. One has multiple criteria and when I create a
pivot chart, each series field breaks out properly using the names
provided in the multiple criteria given.
Now, the issue is when I have a single (one) field name, the chart
automatically has the legend entry of "Total" since I am using the
'sum of' option. I've manually changed the name of the field in the
pivot table, but the label on the chart remains the same. I've go so
far as to read several tips on going to the source data to change this
but of course when working with pivot tables, you ca...Database degrag query
I am using exchange 2003 with SP1. I have calculated the total size of
mailboxes , it is total 30 GB. But the size if edb file is 50 GB and
stm file is 25 GB . I have defraged the database offline so that it
will purge the white space if there is any. but after defrag no
difference in size of the database. it is still 50gb edb and 25 gb stm
file. can anuone explain if i have only 30gb total mailbox size then
why it is taking so much space. there is no rules and othere things
Waiting for your help.
On 25 Oct 2004 20:45:43 -0700, firstname.lastname@example.org (abhi...Union Query with division
Hello, it would like to join two tables, Table1 and Table2, however when
joining table2 the items listed in that table need to be divided by 2. I
normally do this division in a query then join that query to the union query
with table1. I wonder if I can accomplish the same thing directly from the
union query only. Also, is there a way to rename a customer ID with the same
query? (See Customer 9 as example, changing to Customer 15)
Customer 1 10
Customer 3 5
Customer 9 ...Query to count between list of number (Predicting Start/End that may occur in data range)
I have a below list of numbers.
I want a query that would return a count between start and end of
Start End Quantity
566665 566669 5
566671 566672 2
566680 566680 1
On 2 apr, 07:17, Angela <ims...@gmail.com> wrote:
> I have a below list of numbers.
> I want a query that would return a coun...conditional "business required" field
I have 2 fields, A and B
Depending on picklist selection from field A, I want field B to be
"business required" or not. Is this done with onchange Jscript on field A?
What are the CRM events controlling "business required". Is there a list of
all CRM supported events?
Yes, you should use onchange event of FieldA.
Use "crmForm.SetFieldReqLevel('field_schema_name', true);" to make it
Required, or put 'false' for the second parameter to remove requirment. Note
that the function SetFieldReqLevel is unsupported.
The list of all ..."ghost or blank" messages with date field of "none".....help?
using the ESEUTIL utility, we recently had to rebuild our message store
because of a corrupted
restore attempt. everything restored nicely...execpt now we have some
users that have what seems to be blank messages. when outlook is
opened, and messages are listed in the inbox or deleted items folder,
these messages are blank except for the word "none" in the date field.
they can not be accessed nor deleted. any ideas on how to resolve this
On 26 Sep 2006 12:07:04 -0700, "kamor56" <email@example.com> wrote:
>using the ESEUTIL utility, we recentl...How to update a specific field from a Find Duplicates querie
I have to update 1 table that has multiple duplications. If i search for
duplicate on Field1, Field2, and Field3 all matching, i receive many
duplicates where Field4 and Field 5 are different and/or Null. What do i
need to do to the query so that Field4 and Field5 will be automatically
updated when the duplicate is found?
Field1 Field2 Field3 Field4 Field5
Mike Smith 1234 KEEP
Mike Smith 1234 DELETE 9012
Field1 Field2 Field3 Field4 Field5
Mike Smith 1234 KEEP 9012
(...Save query result in a variable
hi! hope you can help me AGAIN!
i have a form that let's the user pick a name, job, between dates, tax(with
or without) and percentage. this is for calculating the comision each
employee has earned.
i did this by a query that gets the info from the form adn then opens a
report and in the report i make the calculations.
but it turns out that several employees have 2 or more "jobs" and for each
one diferent % of comission.
the form and the reports handdle it fine, i'm looking for a way to add all of
this reports for each person.
i was thinking of saving the sum of each que...Form Query
I am trying to run a query for a form, I am using the following criteria
The form name and the text box from the form.
When I click the command button the launch the query a parameter dialog pop
The dialog ask for the text that is in the text box. I use forms to query
dates, they work great, why don’t this work?
You're missing an s in Form:
Doug Steele, Microsoft Access MVP
(no private e-mails, please)
"rap43" <firstname.lastname@example.org>...Generate selective query results
Who can give me advice?
In a table I am storing the information of apartments and their total
surface area in square meters within a building.
When I select an apartment within a building in a form, I would like to
print a report of maximum 10 equivalent apartments of approximately the same
size (surface area ± 2 m2). Of these apartments I would like to see the
apartment number and the size of the surface area.
I tried the Top 10 option but that does not give me the correct result.
Key of the table is the building number (CPX_NUMBER). The fieldname of the
apartment is VHE_NUMBER ...Delete Field in Backend Database
Access 2007 user looking for code that will delete a field from a specified
table on a backend database. AND/OR...change the Field Size on an existing
No user should have this ability. This is a recipe for disaster!!!!
Anywho, To delete a field you'd do something along the line of
Dim db As DAO.Database
Dim tdf As DAO.TableDef
Set db = CurrentDb
set tdf = db.TableDefs ("YourTableName")
or using SQL, something like
Db.Execute "ALTER TABLE YourTableName " & _
...modifying field values in an Access 2003 query
Someone please help. Is there a SQL or Visual Basic statement that can be
used to set/change the values in a field in an Access 2003 query to a default
I'm more familiar with the concept of a table's field (or a control on a
form) having a "default" value. How is it that you expect a query's field
to have a default value? What are the circumstances?
If, for example, you want to display something like "n/a" when an underlying
field in a table contains a Null, you could use something like:
IIF(IsNull([YourUnderlyingField]),...Activate "Contacts" field within a Contact
I just upgraded from 2003 to 2007. I was using the Link Contact field in
2003. I just found the Contacts field in 2007 but I cannot edit this field.
How do I activate the field. Is there a way to show this field when you open
You need to add the field to that view:
Tools > Options > Preferences > Contact Options > Show Contact Linking...
"AJ" <AJ@discussions.microsoft.com> wrote in message
>I just upgraded from 2003 to 2007. I was using the Link Contact fi...Joining two queries
Is there a way to join two queries together?
In query 1, i have Invoice ID, Description, and Total
In query 2, I have the same fields.
I would like to see all the records from both queries. Please advise.
"Tia" <Tia@discussions.microsoft.com> wrote in message
> Is there a way to join two queries together?
> In query 1, i have Invoice ID, Description, and Total
> In query 2, I have the same fields.
> I would like to see all the records from both queries. Please advise.
I believe what you're...Field Type Mismatch on select
I have an input field (InputFieldA) that a user can type either a location#
(alphanumeric - could be all numeric) or zipcode (numeric).
I have the following select:
select * from TableA
where location = InputFieldA
I would like to just do something simple to select the information
regardlesss of whether they type in location# or zip. I thought something
like this would work:
select * from TableA
where location = InputFieldA
or zipcode = InputFieldA
This works if the field is a zipcode (numeric) but not if it contains
characters because it fails with a mis match on field type. (The ...fail when try to select field from an entity view
Hello, I have a problem when I am tryin to select a field from an entity main
viewalthough I succeed to do that when I open a session from a the CRM
Server. Can somone help to find an explaination.
I should mention that even when I open a session from a client machine I use
the administrator credentials
Thanks in advance
Try adding about:blank to the trusted sites in IE and check.
"Ahmed Maaloul" wrote:
> Hello, I have a problem when I am tryin to select a field from an entity main
> viewalthough I succeed to do that when I open a session from a the CRM