Before Update event for Form
Why is it I cant use 'setfocus' in this event? I validate field contents here
and would like to set the focus to fields that are invalid. Am I doing this
wrong? Is there a better way? Thanks.
>Why is it I cant use 'setfocus' in this event? I validate field contents here
>and would like to set the focus to fields that are invalid.
Can't tell what's wrong without seeing the event procedure,
but what you are describing is the normal way to do it.
MVP [MS Access]
...Changing dd/mm/yy to the day of the week
Am looking for a macro or whatever which will change a set
of dates into the corresponding week day. Ie: I have a
column of dates in this format: 01/01/03 thru to 16/10/03.
I want to write a quick macro which will then drop into an
adjacent cell, the day of the week that each day is, so in
column 'A' we have the dates (01/01/03) and in column 'B'
we have the day that that date was ie Wednesday.
any help would be great.
On Thu, 16 Oct 2003 02:13:51 -0700, Gerald wrote:
> Am looking for a macro or whatever which will change a set
> of ...30, 60, 90 days late and due within 14 days
I am working on a spreadsheet that will calculate late suspenses. Basically
I have 3 different types of late suspenses and am looking to calculate
between 0 and 30 days late, 30 - 60 days late, 60 - 90 days late and over 90
days and each of these time frames for the three categories. Here is what my
spread sheet looks like:
Name ID TYPE SUSP DAYS OVER DUE UNIT
WOOD 6470 N/A 18-Mar-05 (234) A
SMITH 7453 UNIT 22-APR-05 (199)
JONES 9741 CO 1-Nov-05 (6)
...send mail every days
Have a question about outlook 2007. I need to run a macro every days, this
macro send a mail with information of a SQL. Have the macro created and run
succesfull but how i can to do for run every days automatically ?
is possible schedulle this macro ?
Thanks in advnace and sorry by my english,
This might help you:
Michael Bauer - MVP Outlook
Category Manager - Manage and share your categories:
SAM - The Sending Account Manager:
&...Dynamic Button with Event
I've new to .NET. I'm trying to add a button dynamically with an
event. Initially, I have a button with a click. The original button's
click event response writes a test message and adds a button. The new
button has a click event attached with a test message. Unfortunately,
when I click the dynamically attached button, nothing happens. Could
someone walk me throught this?
<html xmlns="http://www.w3.org/1999/xhtml" >
<form i...How do I stop 1 day tasks splitting over 2 days?
I am using Project 2003 and it has got an annoying habit of splitting most
tasks with a duration of 1 day into 7 hours of work on one day and 1 hour of
work the following day when you look at them within the Resource Usage view.
This is mucking up my Gantt chart as the tasks effectively look as if they
are 2 day tasks (although the duration cell definitely says 1 day). Any idea
what is causing the problem and how do I fix it? Things to note:
- The project calendar and resource calendars are definitely showing 8 hour
working days (8-12 then 1-5) so that isn’t causing the probl...Calendar day not days
I am trying to figure a way in which I can add a specified number of
calendar days to a date (ex: 9/21/2006 + 14 days = Calendar date).
I thought it would be an easy thing to do, but when I try what is on
MS help, I get the total days from 1 Jan 1900 and can't figure out how
to convert it to the calendar day.
Can anyone help out in figuring this formula out.
Dan (Still going in circles)
All dates are actually a count of the number of days since 1 Jan 1900 but
are just formatted to look like dates. Try re-formating the number you get
as a date.
In Perth, the ancie...Scheduling issue with 5.5 Users
Right now we are in the middle of migrating from 5.5 to 2003. Half of our
users are on 5.5, the other half on 2003. The issue is that when users on
2003 Exchange schedule a meeting with those on the 5.5 server, you can't see
their (5.5 users) calendar to determine what appointments they already have
for that day. The other way around is fine.
Make a replica of the schedule+ free/busy folder on the 2003 server.
"JS" <none> wrote in message news:efQA1awjGHA.3496@TK2MSFTNGP02.phx.gbl...
> Hello All:
> Right now we ...Years, Months, Days, Hours, Minutes, Seconds Formula?
Could anyone PLEASE help me with a single cell formula that would take the
difference between TWO cells containing Dates AND Times, and return the
elapsed difference in the following format:
"3 Years, 9 Months, 15 Days, 14 Hours, 8 Minutes, 16 Seconds"
I've been trying all day to come up with it, but so far have only managed to
do the date part!
I would be extremely grateful for any help anyone can offer.
As long as you have date & time in each cell as entered by Excel
you simply subtract the earlier timestamp from the later ti...Windows NT Service Shutdown Issues
I have developed middleware that provides RPC functionality to multiple
client applications on multiple platforms within our organization. The
middleware is written in C# and runs as a Windows NT Service. It handles
things like file access to network shares, database access, etc. The
middleware is hosted on two high end systems running Windows Server 2008 R2.
When one of our server administrators goes to reboot the machine, primarily
to do Windows Updates, there are serious problems with how the system behaves
in regards to my NT Service. My service is designed to immediatel...Calculating Time over days
I am trying to calculate hours since I last worked in a daily log. Th
issue I have is if there is a day off in between, I need it to go t
the previous day totaling the Hours Off. (File Attached)
Any and all suggestions appreciated.
Attachment filename: time calculation.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=61019
Message posted from http://www.ExcelForum.com
Check out the NETWORKDAYS function in Help.
On Tue, 6 Jul 2004 17:15:12 -0500, TimSmi
>I am trying to ...Event 448 Database Corruption
I have a exchange server which have this error.
However, we dont discover it, it at error come at leaat 1 year before(
we haven't a procedure to keep log,just let it delete,so we dont know
the exactly time), because we can backup successful with backupExec, so
we did't notice it.
I search in google and microsoft. I found the follow article to solve
but the problem is that I have not enough harddisk space to do
Give more information first
Server A, install exchange, 1 store, around 30G, the partition is
Server B, backup Server many...::: How To Display An All Day Event Into A Work Week or 5 Days Calendar :::
I am working with Outlook 2003.
My calendar is setup to show the work week (5 days - Monday to
Friday). This is my preference.
When I enter an appointment of "x" hours I can see it on the related
column (example: Tuesday from 10:00AM to 11:00AM). No problem,
But when I enter an appointment using the tick box "All day
Event" (for one or several days) it doesn't show into the column. It
shows only on the top of the day columns. Would you know if there is a
way to make it appear into the day column to clearly show that I am
In advance many thanks fo...Goto/Goti Issue
I have a database that has been working since 2003. On the form we have two
look-up fields. One is a Goto Look-up and the other is a Goti Look-up.
Every year has it's own table, forms, queries and reports. When creating the
new years tables, forms, queries and reports we use the save as option,
rename them and then make the necessary adjustment to the structure. This
has worked until 2010 started. Now the look-up fields are not working. I
have matched the coding and properties and cannot locate what is wrong.
Could you give me any suggestions? Thanks,
Any...Deploying Web Service SDK 3.0 Issue
I have a web service that I have developed. The web service interacts
with CRM 3.0, creating and updating opportunities from an exteranl
application. The service works great on my development machine. I can
even call it from an external machine, and it works just fine.
However, when I deploy it to my production server, I get the following
File or assembly name Microsoft.Crm.MetadataService, or one of its
dependencies, was not found.
What am I doing wrong in the deployment? I never had any deployment
issues with CRM 1.2. Have I not included something?
Thank you in advance,
pjm...System folder Sync Issues and Sync Issues1
We recently upgraded our server to Exchange 2003 and now Outlook has
created both a "Sync Issues" and "Sync Issues1" folder. I have tried
deleting one but when I try to empty my Deleted Items folder it gives
me this message:
"Outlook has not finished synchronizing local changes made to items in
this folder. You cannot delete this folder until the synchronization
with the server is complete"
My guess is that synchronization will never complete therefore I will
never be able to get rid of the extra folder. Can anyone help me get
rid of the duplicate folder?
Th...event handler wizard
We have just migrated a very large project from VC++ 6.0 to .NET 2003. This
project uses resource only DLLs with the resources in separate directories
from the code. Class Wizard in VC++ 6 handled this very nicely and we were
able to add new event handlers using the wizard. In .NET when we bring up
the event handler wizard there are no classes or message types displayed.
Does anyone have any ideas for how to get this to work?
Just another example of how VS7 sucks. There were a LOT of things we could do easily in
VS6 that VS7 either forgot about, or makes so hard to find that they are ...Issues when validating xml in VS2003
I am trying to validate an xml file and schema and when I
am trying to validate I am getting the following error. I
have been trying to come out with a solution but I have
failed so far. The document validates ok in xmlSpy but it
fails in VS2003. Is there any article or fix for this?
Thnaks in advance.
"The Keyref 'Details' cannot find referred key or unique
in scope. An error occurred at file:///C:/test1.xml, (7,
<?xml version="1.0" encoding="UTF-8"?>
<...1.5% on your investment every day 365 day`s a year!
For a short information, click:
...Show actual days
I have two tables :
CREATE TABLE [dbo].[FD__PROGRAM_CLIENT](
[ClientKey] [int] NOT NULL,
[PgmKey] [int] NULL,
[Date_Admit_Program] [datetime] NULL,
[Date_Discharged_Program] [datetime] NULL,
CONSTRAINT [PK_SYS_FD__PROGRAM_CLIENT] PRIMARY KEY CLUSTERED
CREATE TABLE [dbo].[DateLookup](
[DateKey] [int] NOT NULL,
[DateFull] [datetime] NULL,
[CharacterDate] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS
[FullYear] [char](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[QuarterNumber] [tinyint] NULL,
[WeekNumber] [tinyint] NULL,
[WeekDayName] [varchar](10)...Character Spacing Issue
I created a document in Word on an XP machine. When I opened the same
document in Word on my Mac, the character spacing was noticeably
greater, although the font was the same (Franklin Gothic Medium). This
caused the layout to be altered as text that originally took one line
ran over to two. I have since opened the same document on my same
machine using OS X as well as my Windows Boot Camp partition. It is the
exact same document but it looks terrible on the Mac. Is there any way
to fix this?
The disparity is most likely caused by a difference in printer drivers &
print settings on the X...Weird Issue
This may not be a GP Dynamics issue, but I have never seen this before. We
have GP Dynamics v 8.0 with up to date SP's . One user, and only one, when
she accesses GP via citrix has disappearing menu items. I have watched this
occur and what happens is this: She opens GP, accesses the Purchasing module
and all the menu items are shown. Within 2 minutes a number of menu items
disappear. Has anyone seen this issue before? Any ideas?
After logging into Microsoft Dynamics GP/Great Plains there is a background
process (that can be seen with File >> Process Monitor) which hides the m...Task vs Event
What difference is there between the task vs event on
items that are reoccuring? I would like a cleaner, easier
read for myself.
An event is a full day (or multi day) appointment in the Calendar =
folder. It has a definite start and end time.=20
A task is an item in the Tasks folder. Start date and due date are =
Sue Mosher, Outlook MVP
Microsoft Outlook Programming - Jumpstart for=20
Administrators, Power Users, and Developers
"Nancy" <email@example.com> wrote ...Strange 401k Download Issues
Has anyone else ever experience this...
I am currently using 2006 deluxe, but also had this with 2005 deluxe. I
download my Motorola 401k information from Hewitt and track the transactions
and balances. Everything works fine for a few months, then the transactions
stop downloading. It updates the positions, and if I let it, Money will add
"Add Shares" transactions to correct the fact that individual transactions
stopped coming down and the position data doesn't match. The strange thing
is if I select "Stop Online Updates" for the account and then re...Find a Contact issue
When I enter a name into the Find a Contact box and press enter, all the
contacts (my personal and any public) are searched for a match. My PC has
Outlook 2003. If I go to a PC that has Outlook 2000 installed, it appears
that all of the contacts are not searched. Is there a way to change this
behavior. At one time the PC with Outlook 2000 functioned that same as the
PC with Outlook 2003. Any help would be appreciated.
tk <firstname.lastname@example.org> wrote:
> When I enter a name into the Find a Contact box and press enter, all
> the contacts (my personal and any p...