After Update If
I have a combo box on a form (frmTaskDetails) that has the status of the
current task open and a second field that has Completed Date. I'm looking to
have the Completed Date automatically populate with Date() if the user choose
Completed in the Status combo box. How would I go about doing this? My
thought was in the After Update but everything I'm trying is not working. I'm
trying to avoid validation rules if possible since it seems you can't control
the message it pops up with.
Message posted via AccessMonster.com
http://www.access...Share your Sharing Wisdom
I hope someone can help me out here. In my Outlook I have
tons of subordinate folders within Outlook Today and my
Inbox. I literally have 104 to be exact. My question is
how can I share all of these to another user so they can
access EVERYTHING? I know how to give them permission and
add my account to their Outlook view but how can I apply
permissions to all of the folders instead of doing them
one by one? Please help me if you can. I'm scared of the
possibility of a daunting task the looms in my forecast.
I sincerely appreciate any and all effort one provides in
resolving...Shared Workbooks-shared headers and footers
My question is revolved around using shared workbooks being updated by
different users. It seems that each person is having to setup the formats,
page setup, individually. If this workbook is being saved in a shared drive,
why can't the first person that saves these specifics, save for each. Is
there some setting that is not updated properly in the workbook?
Since no one answered this question, I will add what I think I have learned.
Under Tools/Shared Workbooks/Advanced tab. Bottom of this tab 'In personal
view". This setting is defaulted as flagged as personal settin...Sharing calendars
I'm currently using OL2000 (from Office Professional 2000) and use the net
folders capability to share a family calendar on my home network. Each PC
can view and update the calendar and have those changes be reflected in all
other calendar's via the emailed net folders. Works fine.
I've been considering upgrading to a later Office Suite (eg Office 2003) but
I understand that net folders disappeared a few versions ago. My question
is what features or options exist to share a calendar in OL 2003? I've read
a bit in some reviews but seems sharing a calendar has gotten more diffic...Hangs when exporting calendar
Thanks in advance for any help you may be able to offer.
In Outlook 2003, whenever I try to export my calendar to
anything other than a PST file, Outlook hangs.
This happens with any date range I try, no matter what
events are in that range.
This also happened before I upgraded to Outlook 2003. It
happened after a reinstall, an uninstall-then-reinstall
and a version upgrade.
Also, I tried exporting to a PST (the only thing I can
do!) and bringing my calendar to another computer. Same
thing - Outlook on that computer hung, too!
...New Calendar event only showing as all day tas
When I create a new calendar event, say for an hour. It creates itself as an
all day event. (Outlook 2002)
If I view the event in OWA the event shows properly as the one hour event.
If I view the event and look at the scheduling tab, the event shows properly
Sometimes the event will disappear in Outlook, but I can still see it using
The users mailbox has been deleted and recreated (mail reimported using a
This problem can be recreated on a different workstation.
New profile did not fix problem.
...Accessing outlook calendar from another company
We are working very closely with another company and need to be able to
see each other's calendar. We use oulootk 2003 with an exchange server
verison 5.5. The othe company use outlook 2003 without an exchange
server. Is there any way to be able to see each other's calendar
through the internet?
Thank you very much for your help
"Marta" <firstname.lastname@example.org> wrote in message
> We are working very closely with another company an...shared folders
My shared folder is not in my address book anymore? Where
did it go and how do I get it back? I can't import or
export either. It won't allow me too.
Thanks so much for your help!
...Sharing Macros #2
I've created a macro in Excel 2002. I need to share this macro with others.
How can I e-mail this to others for them to use?
Macros live in workbooks.
So save your macro workbook with a nice name (RussUtils.xls???)
email that workbook.
Tell your users that they can either open the workbook anytime they need the
Or they can put a copy in their XLStart folder and that workbook will open each
time they open excel--and the macros will be available for them.
(Don't use personal.xls as the name. If you do, you could be screwing up their
own personal.xls workbook--you can only...Calander Share #2
Before 15 January, I had 2 PC's set to share a calendar
via email). However, on 15 January, one of the PC's
received the following message: "Oulook caused invalid
page fault in module fldpub.dll at 015f:4c51a697". I went
to the support page and printed the resolutions for that
error. However, since then, the calendar does not share.
How can I share (via email) again? One of the PC's is a
laptop and is only connected to the network during the day
(that is why I am/was sharing the calendar via email
versus putting the calendar on the shared drive of the net
wo...masive remove share records
Hi, is there any way to remove many share records at the same time?
using the sdk...not using the interface
Microsoft CRM MVP
"Alejandro Jara" <email@example.com> wrote in message
> Hi, is there any way to remove many share records at the same time?
...Delegate multiple calendars for Manager
Hi - I need to delegate the calendars for 12 department members to my
manager. Is there any way to do this, other than on a user-by-user basis?
You can set calendar permissions using pfdavadmin (can be found on MS web).
"TheITDude" <TheITDude@discussions.microsoft.com> wrote in message
> Hi - I need to delegate the calendars for 12 department members to my
> manager. Is there any way to do this, other than on a user-by-user basis?
> Thank you
...Sharing a excel document over the internet
I am looking to improve a few things with a client of mine. I have an
excel worksheet(office 2000, but we coudl also purchase office xp if
needed) which contains work that i have to do for my client. What i
would like to do is setup an excel doc that would inform us(depending
who modifies the document) that there were changes made (like in
outlook or something).
he writes that he wants me to install 2 new computers in section
d(whatever) of the office. HE then saves the excel file, and outlook
automatically sends me a notice that it has been modified. I then
double ...adjusting calendar without changing the duration
i got several msp files by my collegues without resource planning. Now
i want to add resource planning and have to adjust the canlendars.
Therefore, i set the dailywork from 8hrs to 6,4hrs and the weeklywork
from 40hrs to 32hrs. However, as i do that, i dont want, that the
existing dates and durations change. Everything shall stay the same,
except that i define the working hrs new, to calculate the needed
How can i do that?
Furthermore, another question. Why can i define a workday from 8am to
5pm with an hour break, but still define the dailywork with 6,4h...B share to A share exchange
Money 2004 Deluxe, Win XP Pro.
I've held B shares of one of my mutual funds for 6 years and they have been
automatically exchanged for A shares.
Has a method ever been developed in Money for exchanging/converting B shares
of a mutual fund to A shares.
There is a 1 cent difference in NAV's (A shares $4.28 - B shares $4.29) so I
will receive slightly more A shares than I had of B shares.
I'm considering entering a sell of B shares and a subsequent buy of A shares
to retain an accurate cost basis.
Any other thoughts or ideas would be appreciated.
I th...setting up meeting on calendar
In work, when we set up unit meetings, my boss sends the email, and
you send back by choosing if you are going to attend or not. If you
choose to attend, it puts the meeting on your calendar.
ANyone know how to do this?
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to the
Swen virus, all e-mails sent to my actual account will be deleted w/out
After searching google.groups.com and finding no answer
Det. Sipowicz <firstname.lastname@example.org> asked:
| In work, when we set up unit meetings, my b...Sharing rules
I have created a rule for moving messages tagged with [SPAM] by our
spam filter to the Spam folder. I haven't been able to share this rule
with any other users though. Any thoughts?
Shane <email@example.com> wrote:
> I have created a rule for moving messages tagged with [SPAM] by our
> spam filter to the Spam folder. I haven't been able to share this rule
> with any other users though. Any thoughts?
I don't believe rules are shareable.
Have a look at this third-party utility:
Victor Ivanidz...Sharing a Contacts Folder
This is under Windows XP Pro and Office 2003 on an Exchange server .......
In Outlook I created a new contacts folder (at the same level as the default
contacts folder) called 'Contacts (Test)' under my main Exchange "mailbox".
I updated the permissions to 'Contacts (Test)' to include the user I want to
share this folder with, and gave him "reviewer" privileges (basically
From his account, he selected File->Open->Other User's Folder and up popped
a dialog box asking for a username and with a drop down listing the folder
types. ...reminders in 2007 Outlook calendar
I was trying to put a sound/reminder on certain birthdays in Outlook
but I am getting a window that says "Will not appear because item is
in a folder that doesn't support reminders" -
So which folder should it be in so that a week previously it will
remind me of the forthcoming birthday ?
it needs to be in your default calendar folder - this is the calendar folder
outlook created in your "default delivery location".
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick...Lebans Calendar Control
I have a continuous subform embedded on a main form. The Totals query
underlying the subform calculates the total number of hours and their value
based on each staff member's BillingRate.
The subform is linked to the main form by the ProjectNumber.
There is query criteria that references two textboxes on the main form that
hold the starting and ending date of the period to be examined. I am
attempting to use Steven Lebans fantastic calendar control to select the
start and end dates, afterwhich I want to requery the subform, but for
reasons I don't understand, changing the dat...Office V.X update
I downloaded and installed a office v.x security update today and now I
can't open any office programs without providing a CD key. There was
no warning about needing a CD key to install an update. Problem
is....I don't have one. Is there any way to find the CD key on the
computer? Please help if you can.....I use office daily and now I have
a major problem on my hands... :(
In article <firstname.lastname@example.org>,
> I downloaded and installed a office v.x security update today and now I
> can't open any ...Shared Contacts
Forgive me if the answer to this has already been posted somewhere but
I cannot seem to find it.
I need some help trying to organise contacts on a 2 user PC using
outlook. Here is the situation:
On a Vista PC there are two different users which need to use the same
contacts. The tricky thing is that each user has a different identity
in outlook i.e. user 1 = personal, user 2 = work. User 2 wants to have
the same contacts as user 1.
Is this possible without having to manually export and import csv
files between the two user profiles?
Thanks in advance for any help :0)
Hard to say as you didn&...Issue Viewing Multiple Shared Calendars
I am on MS 2007 Exchange Server using Outlook 2003.
I have access to my bosses calendars. They list within the Other Calendars
section of my calendar view. When I select 2 of my bosses calendars and
deselect mine as I do not need to view mine, I can view them both side by
side. However, when I change to Mail view and go back into calendar view the
2 calendars no longer remain. One boss becomes unchecked and the other
bosses always remains. This never used to happen before. Nothing new that I
am aware of was applied\installed onto my machine.
Does anyone know how I can f...How to fix Unable to install Office 2007 Updates
I couldn't install Office 2007 updates but I was given an expert to help
which I said in an earlier question that I would post if it worked. It did
work so here is how:
"1. Click on Start, Run and type "REGEDIT" (w/o the quotes). The Registry
Editor will open.
Using Registry Editor incorrectly can cause serious problems that may
require you to reinstall your operating system. Microsoft cannot guarantee
that problems resulting from the incorrect use of Registry Editor can be
solved. Use Registry Editor at your own risk.
2. Navigate to the ...Problem with calendar
We have IS status meeting every week and it is scheduled in Outlook. It is
only two of us and I was invited and accepted the meeting.
There is a Word document that I prepare and print 2 copies for each of us.
The idea is to keep the word document attached to every meeting with
corresponding content. We also keep the hard copy.
I don't want to change the document on my computer and then attach it to the
meeting. I would like to attach it to the first meeting and then keep adding
things to it on every future meeting. I have tested it, but once you change
it is the same for future and past me...