Using VBS t o configure outlookis it possible to create a vbs script to automatically
configure outlook 2002 for user on a domain.
Thanks
James
...
Date/Time criteria problemI am trying to create a query that allows a user to select a specific date
for which to show results. Following is sample SQL with a fixed criteria:
SELECT qryShopJobsIO1.JOB_NO, qryShopJobsIO1.[TOTAL QUANTITY ORDERED],
qryShopJobsIO1.[ENTRY DATE], qryShopJobsIO1.SumOfTotalHours
FROM qryShopJobsIO1
WHERE (((qryShopJobsIO1.[ENTRY DATE])=#4/27/2010#));
This particular example returns no records. I know that I have records for
which the ENTRY DATE field is 4/27/2010. I believe that the problem is that
the default value of that field (in the table definition) is set to =Now() ...
Problem with dateHi, I just converted my adp project from Access 2000 to Access 2003. In the
2000 version the date written on the SQL server are OK (mm/dd/yyyy). I use
the Access 2000 in French and the SQL server is version 7 in English, and
the date is ok on the SQL server. After the conversion the date on the SQL
server is dd/mm/yyyy. I used Access 2003 in French and the same sql server
that I used with the 2000 version. The regional paramater are the same,
English (USA), but my workstation is a Windows French 2000 .
The command that insert the data in the sql server is an INSERT INTO with a
variable, ...
Problems with contact!Hello,
I have created a lot of contacts with external address in Active Directory
and after I have created Address Lists in Exchange 2003 that contains these
contacts.
All works fine except 1 contact. When I try to send an email to this contact
from Outlook 2003, inmediatly it comes with a non delivery report that says
that "The email address doesn�t exist in this organization, please contact
administrator......". All other contacts works fine and there are a lot of
them that belongs to the same email domain.
I have tryed to remove and create again, and refresh and reconstruct the
ad...
Exchange 2003: Free/busy problem
Hi,
All of a sudden as of a couple of days ago, when anyone in my exchange org
tries to invite people to a meeting, a message displays when they try to
check the other person's availability that says "No free/busy information
could be retrieved"
What I noticed that may have changed is that the public folder that
apparently used to house this information is gone. So I followed
instructions on microsoft's website to reset the system folders. Once that
was done, I restarted the info store on all the servers in the admin
group... but I still get the "no free/busy&...
Using Exmerge #2Hi there,
I'm using Exmerge for the first time on an Exchange 2003 box. I was reading
through the KB article 174197 http://support.microsoft.com/kb/174197/
and it says "Before you run this program, make sure that the Microsoft
Outlook Client and the Microsoft Exchange Administrator program are
installed on the computer that Exmerge.exe is being run on." then in the
next paragraph it notes, "We recommend that you do not install Outlook on
the Exchange server."
So, before I go installing anything can someone please point me in the
correct direction? Can I run exmerg...
no warning file in useHi. I've got a question about a shared Excel file stored on Windows 2000
server. This file is accessed by two different Windows XP end users running
Excel 2002 on their machines. Recently these two different end users have
been accessing the same shared Excel file simultaneously without the usual
file lock or warning that the file is in use. Sometimes they get the
warning, sometimes not. When they don't, they assume they have rights to
save to the file, only to find later on that their changes were not saved.
I'm having both check for updates so that their Microsoft s...
Closed Investment ProblemOne of my closed investments still appeats on my Money
Home Page Investment Summary. All the other investments
appearing in the summary are open, except this one. I
checked the investment transactions for this investment
and they are all correct, resulting in a zero share
balance. Help!! How can I get rid of this appearing in
the investment summary without deleting all the
investment's data?
Thanks!
http://www.umpmfaq.info/faqdb.php?q=98 might give you a solution to this.
--
Glyn Simpson, Microsoft MVP - Money
http://money.mvps.org
Check http://support.microsoft.com/default...
Problem with "Search box" in Help windowWe are using Excel 2003 on XP. This problem is occuring for all users.
When you click Help-Microsoft Excel Help, and try to type in the Search for:
box under Assistance, the text is inserted into the spreadsheet instead.
The only way you can manage to enter any text into this box is to copy it,
then right-click paste it into that box (Edit-Paste and Ctrl+V do not work)
I can't find anything in the kbase (except for the tip about pasting).
What is up with this?
...
CDOSys.dll and Basic AuthenticationI am trying to use Microsoft CDO For Windows 2000 Library (cdosys.dll,
version 6.6.6001.18000) for sending email from an Access 2007 application.
Here is my code, somewhat altered for readability etc:
Dim oCDOMessage As New CDO.Message
Dim oCDOConfig As New CDO.Configuration
oCDOConfig.Fields.Item(cdoSendUsingMethod) =
CdoSendUsing.cdoSendUsingPort
oCDOConfig.Fields.Item(cdoSMTPServer) = "smtp.example.com"
oCDOConfig.Fields.Item(cdoSMTPServerPort) = 25
oCDOConfig.Fields.Item(cdoSMTPAuthenticate) = cdoBasic
...
Problem with CTreeCtrl and WS_CLIPCHILDRENHi All,
I have a modeless dialog that is a child of a view. The dialog has the
WS_CLIPCHILDREN flag set so that it reduces the flickering effect of resize
and redraws. The dialog has a CTreeCtrl with tooltips.
Here is the problem:
If I have a enough items in the tree control to where the vertical scroll
bar is shown, and an item is long enough where the tooltip shows up. When I
hover over a long item and the tooltip is up, if I scroll the tree control
the new item which should be drawn where the tooltip was in not drawn at all
(the background of the dialog box is drawn instead). This is e...
E-mail signature: problem with tablesI have created an e-mail signature using a table to control the layout and
formatting. This is fine until I reply or forward a message, as the signature
then joins to the message I am trying to forward/reply to.
I have gone into Advanced Edit > Table > Table Properties and set the text
wrapping to 'None', which seems to work. However, when I make any edits to
the signature it resets the table wrapping back to 'around', so that I get
the problem repeated.
Any ideas?
EssexSi <EssexSi@discussions.microsoft.com> wrote:
> I have created an e-mail signature ...
SUMPRODUCT using Time between two valuesThanks in advance for any help you can provide me. I have a sheet
with the following layout of data (shortened here and changed for
obvious reasons)
Venue Date Event Start Event End
Act
Disney 4/13/10 7:00 PM 10:00 PM
Goofy
MSG 2/13/10 1:00 PM 3:00 PM
Basketball
Park 3/14/10 6:00 PM 8:00 PM
Harlem Globetrotters
So, what I have is a user input a Venue, Date, Time Value, and I would
need the Act returned...
For example,
Disney, 4/13/10, 8:25:13 PM, would ou...
Excel Queries using Access dataIm trying to create a query from within Excel. When I select new database
query and select a database which has no securtiy login/password, no problem,
works fine. However, when I try to source the data from a database which I
have created using user logins/passwords it says that I do not have admin
privilages to use the database even though I am putting in the correct
login/username in the popup window? Please can anyone help?
I've had limited experience with this sort of thing but I've always had to
strip out the protection on the Access Database and create a copy before
suc...
Public Folder Replication problems #4I have 2 exchange 2003 servers in the same exchange org. I added the new
exchange 2003 server to the public older replication but the folders did not
replicatce. Both servers have the same patches. Below is:
Event Type: Error
Event Source: MSExchangeIS Public Store
Event Category: Replication Errors
Event ID: 3093
Date: 9/19/2005
Time: 9:09:45 AM
User: N/A
Computer: SYNMAIL1
Description:
Error -2147221233 reading property 0x674b0014 on object type tbtMsgFolder
from database "First Storage Group\Public Folder Store (SYNMAIL1)".
For more information, click http://www.microso...
Virus Outbreak by using SMTP virtual serverHi,
The client was accidentally open approved-password.zip file then the
nightmare began to spread out. It will use "system administrator" and
"webmaster" as sender to inform the user that their password is grant or
deny. Today, it tried to send out as NDR style. I assumed the virus on the
workstation is using our smtp server. Will there a log that SMTP virtual
server may generate so I can keep cross reference such as workstation or
username so I can pinpoint? Any suggestion or recommendation will be
appreciated. I am currently using Trend Micro Offican or Scan...
FAX notification problemSBS 2003 R2 SP2 is installed and working pretty well.
FAX's are received, sent to a selected folder just fine.
Notifications doesn't work.
I have tried sending to a local Exchange user or an internet address and it
doesn't happen.
What I'm trying to find is what is the transport that the system uses for
this messaging.
I don't see any related event messages.
Any help would be appreciated.
Doug Sanders
Hi Doug,
Thanks for your post.
First of all, I still would like to suggest you double check the fax recipients notification configurat...
Publisher 2007 Birthday card jpg rotation problemI'm running SP2 MSO and selected the Birthday 4 template. It's a side
fold card template. I wanted to change the image on the front (page
1) and the inside left (page 2). I had two jpgs on my computer, so I
used Insert-Picture-From File... . In each case when they were
inserted, I need to rotate them CCW 90 degrees, so I grabbed the green
dot rotate handle and rotated them so they were right side up (they
were flowers). I then added a text box above each one.
The print preview showed the correct orientation of the flowers with
respect to the text above them for both page 1 and pag...
Workflow Posturl problemHI
I have created a webservice in .net that takes the lead id then queries our
ordering system and writes some data back to CRM.
When i add the post url in workflow manager and then create a lead, the
action enters the workflow monitor in a paused state it also write the
following to the even log
MSCRM Platform Error Report
--------------------------------------------------------------------------------------------------------
Error: <description>Error in action posturl.</description><details>Failed to
connect the url
http://localhost/test/OrderCheck.asmx/DoOrderCheck...
There is a problem with this website's security certificateHello,
I bought an SSL certificate for my server (Windows Server 2003, IIS
6.0).
Server included already a web site with SSL certificate, so I created
a 2nd web site with different IP and different SSL certificate and
different application pool that is running.
When I try to access the 2nd web site I get a message from IE "There
is a problem with this website's security certificate." If I click on
option "Continue to this website (not recommended)", I get error
"service unavailable"
What could be the problem ? 1st web site is running without ...
Converting access tables to XML for use in .NET web appI need to access tables in an .mdb file and convert them to XML for use in my
..NET 2.0 web application.
Can anyone point me to any tutorials or references on how to accomplish
this? (Note: I am using VB)
Thanks!
...
Possible to open word documents in Excel using hyperlinks?Hi,
I wondered whether it was possible to open office documents from within MS
Excel using hyperlinks to the related files. The documents in question are MS
Word format.
Cheers
Have you try it ?
Ctrl-K
Existing file ......
--
Regards Ron de Bruin
http://www.rondebruin.nl
"DobieM" <DobieM@discussions.microsoft.com> wrote in message news:2DFD72F1-0F21-4414-929D-4D9307997D68@microsoft.com...
> Hi,
> I wondered whether it was possible to open office documents from within MS
> Excel using hyperlinks to the related files. The documents in question are MS
> Wor...
Can you share a calendar using Outlook web access?We are using Outlook Web Access only. Is there a way to share calendars?
In news:AED7800B-502A-44D1-A386-5A9274753BDB@microsoft.com,
betzie <betzie@discussions.microsoft.com> typed:
> We are using Outlook Web Access only. Is there a way to share
> calendars?
You can access a calendar (or any mailbox folder, I believe) if it's already
shared - but you can't create the share/set the permissions in OWA.
You might post OWA questions in microsoft.public.exchange.clients - OWA is
part of Exchange, not Outlook.
...
Remove blank entries from a list box either using VBA or basic formula #3
Thanks Debra
Havent thought about using dynamic ranges before.....I am a bit of
Excel learner.
I shall look into this as you suggest.
Thanks again
Celtic_avenge
--
Celtic_Avenge
-----------------------------------------------------------------------
Celtic_Avenger's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1410
View this thread: http://www.excelforum.com/showthread.php?threadid=27183
...
Workbook Memory Problem
I have worked up an excel document that consists of four sheets, one
sheet being the data entry sheet which then in turn post data to the
other sheets providing needed information. It also includes links to
external workbooks to calculate the end result. When the output is
posted we then need to save the workbook for future reference for up to
one year.
Problem: The files are consistently around 1.5 megs after the data is
posted which at the frequency that the forms are created is not ideal.
So what would you suggest?
*Some brainstorming I had:
Do I save it as data file that will not...