Outlook 2003 Duplicate Events
I have noticed, that when I receive a meeting request and
accept it - two events are placed into my calendar for the
same meeting (One as tentative the other accepted).
What is causing this, and how can I stop it from happening?
...What's the use of LOG file in MDBDATA
To whom it may concern
I am now using Exchange 2003 now.
I find there are many .LOG files in the folder MDBDATA where 5 G each
What's the use of this files ?
Can I delete those file ?
On Thu, 16 Mar 2006 09:57:35 +0800, "Hughs Man"
>To whom it may concern
>I am now using Exchange 2003 now.
>I find there are many .LOG files in the folder MDBDATA where 5 G each
>What's the use of this files ?
>Can I delete those file ?
Those are your transaction logs. DO NOT delete them.
Run a full, online exchange awa...How to Analyze Attributes in a Query
Is there a function/formula that you can use in a query against a field to
return what type of attribute the field value is?
If so, can you then change that attribute just in the query output?
What do you meand by attribute? Are you talking about the data in the field?
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
> Is there a function/formula that you can use in a query against a field to
> return what type of attribute the field value is?
> If so...Linking queries on a report
I built a number of queries that all tie to the same table. Each query
sorts the data differently, but comes from the same data source. I would
like to show the results of these queries on the same report, but I get and
error message that the wizard can't connect the queries. How can I display
multiple queries on the same report. I've tried subreports, but they don't
seem to export as well. Thanks
What does "export" have to do with this?
If I have multiple sets of results I want to show in one place, I create an
empty "main"...min query
How do I get the 2nd minimum value and the 3rd minimum from a table after I
have done MIN query for the 1st minimum value?
SELECT dbo_CON.SC, dbo_CON.SN, Min(dbo_CON.SQ) AS MinOfSQ
GROUP BY dbo_CON.SC, dbo_CON.SN
This will give me three different SC SN records. I am looking for same SC
SN records that has next min SQ.
SC SN SQ
1 100 1
1 100 2
1 100 3
1 100 ...Excel and Access Database Query
I'm starting with a Spreadsheet that is being used to represent the
financial and audit information for individual projects. 1 spreadsheet
document = 1 project.
I have a worksheet that is linked to an Access Database. I need the
information from this Spreadsheet Document to be filtered into a Formatted
Worksheet within another Spreadsheet Document.
Currently I have the Worksheets (linked and formatted) in the same document
and I am using a VLOOKUP format to transfer the information.
However my problem occurs - because I need to 'save as' so that each
individual project...Deleted Entourage calendar events not deleting in iCal
Operating System: Mac OS X 10.5 (Leopard)
Email Client: imap
Hi, <br><br>Here's yet another sync oddity regarding Entourage and iCal/Mobileme. When I delete a calendar item in my Entourage calendar, it is not getting deleted in iCal and MobileMe and, hence, my iPhone. Even when I sync the iPhone manually via iTunes, the deleted item remains. Any thoughts on how to correct this would be appreciated. <br><br>Thank you.
...Need help with query summing hours
Tring to get total worked hours and total maintenance hours summary.
I have a table with the clock hours
And have a maintenace table
Needing help combining the information to get summary something like this..
Date - Employee - Clock Hours - Maintenance Hours
1/1/10 Joe Billy Bob 8 6
1/1/10 Billy Joe Bob 8 7
Whay type of query do I need to build, any help would be great.
Message posted via http://www.accessmo...Moving Exchange logs and database
I am attempting to move the log and database files for Exchange 2003. I
have followed all the steps listed here:
However, the log files are still being written to the old log folder.
Are there any subsequent steps that need to be followed? Is it just a
matter of waiting?
Thank you for your help,
Are you sure you're looking at the right logs? Did you make the change for
all storage groups?
MVP - Exchange
"Protecting the world from PSTs and brick backups!"
<firstname.lastname@example.org> wrote in message
news:1158769...make query from to 64 bit system
I have a application need to be compile for 64 bit system. how can i read
data from vb.net 2005.
On 09.12.2009 17:36, Jennifer wrote:
> I have a application need to be compile for 64 bit system. how can i read
> data from vb.net 2005.
First of all, I don't see the point why you're asking this question in
an Access newsgroups.
Further more, you should really be more spefific...
--> stefan <--
...How to select query fields based on Combo box?
I have a table which has 5 fields, ID, Name, Age, School and Class. I have a
combo box which shows the fields of a Query. This combo is located in form
which presents all the fields of the table. What I want to do is once the
user selects a field for more than one the fields in form shown as selected.
Also, I want to make a button for reshow all fields in form.
Thank you in advance.
...<> data query
I have two tables and both have a field called tag_id. The first table
"my2003" has about 5000 records. The second table "monitor2003" is a subset
of table "my2003" and has about 3000 records. I need help building a query
that will give me the records in table "my2003" where the "tag_id" field is
<> to the "tag_id" field in the "monitor2003" table. Also which type of
joining of the two tables is needed?
Use the query wizard to create an unmatch record query that will list all the
records in my2003 but are n...Different queries but the same?
Access 2003. I accidently double clicked on the wrong thing in a new query
based on another query. In the query grid, I added the
qryVentThpyWithinLastArea and double clicked on the *. It only filled one
column of my grid but when I ran the query, it showed all the fields from
the query. I then dragged down Area field and added my criteria. I had
been taught to double click on the blue title bar and then drag all the
fields to the grid then add my criteria. Both ways give me the same data.
What is the differnce?
I pasted the sql below so you can see what's going...can send but can receive- event log shows loop within Exchange
When I try to send email to my exchange 2003 server from an external email
account I never get the email. I get the following error message in my event
A non-delivery report with a status code of 5.3.5 was generated for
recipient rfc822;email@example.com (Message-ID
Causes: A looping condition was detected. (The server is configured to route
mail back to itself). If you have multiple SMTP Virtual Servers configured
on your Exchange server, make sure they are defined by a unique incoming
port and t...Event ID 9554
I"m getting the following error:
Event Type: Warning
Event Source: MSExchangeIS
Event Category: General
Event ID: 9554
Time: 1:33:15 PM
Unable to update Mailbox SD in the DS. Mailbox Guid:
3b5b90b3-9fcd-4540-9858-d13d6498e9e1. Error Code 0x8004010f
For more information, click http://www.microsoft.com/contentredirect.asp.
3b 5b 90 b3 - 9fcd - 4540 -9858 - d13d6498e9e1
(msE...Domain name not always needed to log into OWA?
This is something I've wondered about for a while.
Why is it that only some of our new Exchange Server installs insist on
the OWA login <up to 13 chars. of domain name>\<user name> while
others have no trouble with only <user name>?
"Julie" <firstname.lastname@example.org> wrote:
>This is something I've wondered about for a while.
>Why is it that only some of our new Exchange Server installs insist on
>the OWA login <up to 13 chars. of domain name>\<user name> while
>others have no trouble with only <user name>?
Probably b...trim in query
I am trying to trim a leading space at the start of each field in my
"Customers" table which is an Exel spreadsheet imported using
After researching the internet I have been able to get this to work using,
for example: CustomerName: Trim([F3]) in the Field line of a select query
My promlem is that when I append the data from "CustomersTrimQry" to the
"Customers" table the space returns.
Prior to using trim I ran 3 queries from the original "CustomersImport"
table, "C...Database SQL query
Sorry for this post here. If someone knows a group I can go to for this
question, please let me know. I have a program in MFC that accesses and
updates an Access database. The problem is I can't figure out how to add a
field which contains a word with a single apostrophe ie (St. Vincent's). I'm
using the CDaoDatabase and CDaoRecordset classes. I understand that DAO is
interpreting the apostrophe as some type of terminator but there must be a
way around the issue. MS Access has information on how to do it in Access VB
but that doesn't seem to work in MFC.
Ughh ...why getting event 9551 warnings?
I thought that when you switched to native mode (which we have) that
these problems with zombie ACL's went away. Why are we still getting
(running Exch 2003 SP1)
...Creating Event procedures from a macro
I'm using Jon Peltier's workaround (to Excel's inability to create
hyperlinks to chart sheets) to create a table of contents. The following
event procedure is placed in the code module for the "contents" sheet. It
activates the chart sheet when the user selects the linked cell:
' Thank you Jon!
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Intersect(Target, Range("B2")) Is Nothing Then
This works fine, except that I need to create it on the fly from within a
ma...MS query and Firebird
I am accessing a Firebird data base with MS Query into Excel.
I am trying to change the column heading (column name) but as I writte a
"Newname" in Column Heading MS Query dont accept.
I try to change directlly the SQL statement with "AS" clause and without
"AS" clause but MS Query dont accept. I dont know if the format of select
statement is different in Firebird data base or is a problem with MS Query.
...What event does a hotkey generate?
I have a date field in a form that has vba code attached to the 'after
Then I setup a hotkey to auto the current date in the same field.
The problem I am having is that when I hit the hotkey sequence the field is
populated with the current date - however my vba code does not work.
Any idea what event the population of the field by a hotkey produces?
Thanks for you help.
On Tue, 15 Jan 2008 11:30:00 -0800, Tom
None. And for good reason. Programmatic filling of fields typically
does not trigger any event. So you rewrite...Event Handling
I have a project that creates 18 CBitmapButtons. As you know CBitmapButtons cannot be created (or at least to my knowledge) from adding the componet to the form. So I decided to create 18 CBitmapButtons in my code to create the buttons. Here is the problem...
I need to write an event handler for these 18 buttons, and since there isn't the convenice of the event handling that you will find when you are adding componets to the form, I cannot figure out how to manually add event handlers.. Here is some of the declarations I made:
CBitmapButton* Button1 = new CBitmapButton();
Button...Project Manager 2007 queries
I am considering purchasing Proect Manager for my my Planner, we are a small
office who a familiar with the basics but have a few queries which are a
little more detailed, I hope someone may able to advise on:-
1. Reporting - What are the options for importing and exporting documents
and the number of format types, are they clear and easy to learn and use ?
2. Graphs - Is graphical data readily available, are there differing options
of graphs and are the tools for producing them clear and easy to use ?
3. Sand pits - Are there areas where 'offline' working is availabl...UDF XLA and SQL queries
Newbie question. Apologies in advance if it's too simplistic or in the wrong
I want to add an UDF to Excel. This UDF queries a SQL database.
Say the function name is 'MyFunc';
I want to be able to have (in a cell) =MyFunc("ABC") return some data from
the SQL database (for example here, say the Product Description for product
The user needs to select the database the first time he uses the workbook.
The UDF is called often in the worksheets of a given workbook so I would
prefer to open the connection once at the beginning and...