Tracking Dates For Future Occurrences
Can this be done? I want to track a yearly review. I would like the date,
once entered - say 6/1/2009, to conditionally format to change yellow 30 days
before, then red 15 days before, and then to stay red until the date is
updated again for say 6/1/2010. Can this be done? I am new to all this,
In 2007 Also..
> Can this be done? I want to track a yearly review. I would like the date,
> once entered - say 6/1/2009, to conditionally format to change yellow 30 days
> before, then red 15 days before, and then to stay red until the date is...I want year in one table to be less or equal year in another table
I have some problems writing a query and I hope someone can help me.
I have a database with serveal tables. In one table I have this information,
Lake ID-number, treatment, year for treatment. In another table I have Lake
ID-number, fish species (I am intrested in pike), year when pike is present.
I want to find all lakes that have pike present before the treatment was
done, I want the year in the second table to me less or equal the year in the
first table. Is there a easy way to do this?
Try something like this substituting your table and field names.
S...parsing a date and time field #2
I am having trouble parsing the date and time in a field. I download
data from a data base and the date and time come together in one
field. I want to seperate the two. The date and time comes across as
the following: "2/1/2009 14:37" in the cell. When I parse it, it
seperates into three columns as follows: "2/1/2009", 2:37 AM", and
"PM" I can see what is going on but I would like to get two columns
with one as the date and the other as the correct time. are they any
ideas on how to address this?
Try using the TimeValue and DateValue functions.
First format ...Day of week time control
Let's say I wanted something to occur at specific times (via DDE) on Sunday,
a different thing on Monday -Tue, Wed, Thurs, Fri Sat and continue over and
I see how I can know the day and time, but to use it in a formula escapes
The use is for a simple area based light control in my house.
"vernon" <there@there> wrote in message
> Let's say I wanted ...converting tabular structures in a Word document into an actual table or reading data from the tabular structures using VBA code
I have a macro which can read the last cell/column of all tables in a
Word 2003/2007 document and store the data in an MS-Access table. But,
some Word documents have the data in structures like a table format
but are not actually tables. The structure looks like a table, but the
table borders are actually line connectors. These documents were
created by a software(VeryPDF PDF to Word converter) which converted
the PDF documents(the original format these documents were) into Word
1. Is there a way I can convert/replace the tabular structures with
actual tables in Word so t...Exchange 5.5 to 2003 upgrade issue 3
We have upgraded our Exchange 5.5 server to 2003 and moved all the mailboxes
and moved and re-homed the folders following the KB articles.
We turned off the 5.5 services and for a week everything was working fine.
Now for some reason the messages to the main distribution list is being sent
to the old 5.5 server on a x400 protocol.
How can I stop this and assure that the 2003 server is self contained so I
can get rid of this server?
...Insert,Update Data in sage (MS Access Linked tables) using Vb.net form
I am developing application using vb.net which requires integration with SAGE
LINE 50 (Accounting software ) V11... The data which SAGE is using is MC
ACCESS 2003 database... with linked tables in it... Now I Have developed the
Sage connection using ODBC which works fine when reading the record but
cannot Add or Update record into the Linked tables.... When i debug the
program the error is at the line where it has...
Can anybody Help ?????
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/acce...How do I convert a word table into an excel document?
I have managed to get the info accross no problem but the formatting is all
over the place. For instance - 07/10 meaning July 2010 is appearing as 07/Oct
despite me going into format cells custom then enter mm/yy which has always
You can't use it like that regardless of formatting, you need to put in the
whole date or else Excel will always assume the current year so any real
date used for calculations needs to be numeric and needs a day, so you can
enter (assuming US date format) 07/01/10 and use a custom format of mm/yy
or if you don't need it for...Indiana Time Zone
Indiana, which has always been on Eastern Standard Time, has changed to
observe Daylight Savings Time. As we switch computers over, we have noticed
that all day appointments now appear in two days during daylight savings
time. Is there a patch to fix this issue or do have have to go in and
manually change all the appointments.
Instruct all your users to change their timezone to the normal Eastern time,
and change all your servers likewise.
MVP - Exchange
"Protecting the world from PSTs and brick backups!"
"d3harvey" <d3harvey@discu...Sumproduct with multiple date criteria
Having a tough time with this one.
Column A = Start Date, Column B = End Date, Column C = Quantity.
Row A = Start Date, Row B = End Date.
I would like Row C to sum quantity from sheet 1 where ever the two date
The date ranges on sheet 2 represent the beginning and ending of a week
Column A Column B Column C
01JAN2010 24JAN2010 1,000
Row A 04JAN2010 11JAN2010 18JAN2010 25JAN2010
Row B 10JAN2010 17JAN2010 24JAN2010 31JAN2010
Row c 1,000 1,000 1,000 0
Do the Sheet 2 Star...help with dynamic tables
This is a bit complicated to explain but I'll try my best. In columns A, B,
C I have different drop down lists. Column A has Store1, Store2, Store3,
etc. Column B has Dept1, Dept2, Dep3, etc. Column C has ProductA, ProductB,
ProductC. As of right now, these lists are not dependent on each other, I
can choose anything from any list regardless of the previous category. Also,
the length of these lists is undefined, meaning I will constantly be adding
to them in sequential rows below. And then columns D and beyond have data
such as Sales, Profits, # of items, etc.
What I...Publishing Layout and tables
Operating System: Mac OS X 10.6 (Snow Leopard)
I am trying to copy and paste text from one cell of a table to another cell in the same table. The document is in Publishing Layout. The paste command deletes the text in the destination cell and then places a big empty text box on top of the table. I do dozens of these documents that are primarily tables and graphics. Previously I used Publisher on my old PC. Should I go back, or can this be done in Word for the mac?
On 2010.01.29 8:44 AM, in article 59bb1ce2.-1@webcrossing.JaKIaxP2ac0,
"Toni_T@officefor...How do I make a chart with several times during a day
This seems like it may be a simple thing, yet I can not for the life of
me figure out how to do this (or at least semi-easily with VBing it for
I have a simple table filled with the following information (example
12pm 5pm 10pm
11/20 5 4 7
11/21 5 4 7
11/23 5 4 7
11/24 5 4 7
11/25 5 4 7
So basically I am keeping track of a numeric value three times a day. I
would like to make a chart of it with...Bogus Helo
I could not send email to 1 or 2 domains and the rest all emails going
fine, I checked with ISP my IP is not blocked and I don't have any
virus on the server but the only problem from my point of view is
creating problem my domain name is like main-server.local which i
think suppose to be main-server.com
Any Help would be appreciated
configure the FQDN as explained here:
IMF Tune - Unleash the Full Intelligent Message Filter Power
"Adnank5" <adnan.inay...Querying multiple records in two tables
Hi, in my database I have tables for users (UserID, UserName),
projects (ProjectID, Project Name), and qualifications (QualID,
QualName). I have join tables for users_qualifications (UserID,
QualID), and projects_qualifications. (ProjectID, QualID).
What I need to do is run a query for a project to show which users
have the exact matching qualificiations.
Users can have many qualifications, projects can require many
qualifications, users may only work on a project if the qualifications
required/held match exactly.
Assuming that ProjID, and QualID are numeric, the following sho...Time update as a limited user not working
I added time update permisssion to my limited user acct. but it does
When I try, the time synchonization is greyed out.
How can I get it to work.
On Apr 4, 12:33=A0pm, Mint <chocolatemint77...@yahoo.com> wrote:
> I added time update permisssion to my limited user acct. but it does
> not work.
> When I try, the time synchonization is greyed out.
> How can I get it to work.
Is this Windows MCE SP2?
What method did you use to add time update permission to your limited
Does your unlimited user accou...Office 2004 issue with documents NOT BEING ABLE TO OPEN APPLICATION, but application can open documents.
Just migrated all my files and apps from a G4-400 to a new Mac Mini
1.87ghz Intel running pre-installed OSX10.4.10.
Used CD to install 'normal' version of Office 2004 Mac on the new Mac
Mini. In fact its the same disk that I used originally to install Office
on the G4-400.
Neither old .xls and .doc documents (made on old Mac, nor new .xls and
..doc documents (made on new Mac)will not open their respective
applications, when clicked upon.
However, when I use either of the the application's "Open" feature,
theres is no pr...Converting date from an external source
I am having an issued with converting a date from external data source. the
data has the timestamp in the general date form mm/dd/yyyy 00:00:00. I want
to convert the date to mm/dd/yyyy format so when i run a query for a single
day it will return the data for that date, I can currently return the data
but i have to set the parameter in the mm/dd/yyyy 00:00:00 format, i want to
simply return the data by setting the parameter in the mm/dd/yyyy format
Don't confuse how data is stored with how it is presented. As long as you
import the date into a field defined as a Date data type, you...Chart printing issue in Excel 2007
A spreadsheet with charts was created using Excel 2003. I have Excel 2007
and saved it in compatibility mode.
I inserted a couple colored lines on the chart and created my own legend
based on these. A couple of issues:
1. When I close the file or even minimize, 2 of the colored lines on a
couple of my legends disappear upon reopening.
2. When I try to print a chart, it looks good in Print Preview, but then
looks magnified,half off the page, and only one of my drawn lines is printed.
When someone with 2003 prints, the sizing is correct, but all of the
colored drawn lines are missing...Excel pivot table #2
i encountered an error in my pivot table.
i created an olap cube using the analysis manager.
the cube displays the correct data of my measures but on my
pivot report, it displays #N/A....
i need help to fix this one... thanks.... =)
...Single keystroke issue
Since upgrading from IE7 to IE8, I have lost the capability in the
right-click menu to hhit a single key to perform a function. For example,
right click a "favorite" and hit "m" to rename, or hit "d" to delete.
Instead, now have to mouse over the command to perform. Also, the shortcut
keyletter used to be underlined in IE7, now nothing underlined.
I'm sure it is something simple, but I haven't been able to find the answer
FerretDaddy & the FBR-Gang
They changed the way the Favorites Pane and Links toolb...Reminder Time vs Due By Field
I'm using O2003. For a contact, there is the Due by Field. There is
also a Reminder Time field. If you update the Due By field, it updates
the Reminder Time field. However, if you update the Reminder Time
field, it does not update the Due By field. By default for a contact,
you have access to the Due By field. The Reminder field is avaialble,
but you have to manually add it.
In Tasks, it seems to work the same in that if you update the Due By
field, it updates the Reminder Time field. However, if you update the
Reminder Time field, it does not update the Due By field.
However, you have a...Tables in 2007
What are the advantages to converting a list to a table in 2007? Why does
the table have a name?
I did read in help that you can post a 2007 table to sharpoint services.
What does that mean?
Go to the excel help and type Tables then open the one that says Demo:
Organize your data by using an Excel table, and then in How to do it, click
on Overview of Excel Tables
if this helps please click yes, thanks
> What are the advantages to converting a list to a table in 2007? Why does
> the table have a name?
> I did read...Deleting a Batch from company DB table SY00500
This is a multi-part message in MIME format.
Is there a way to see all the TRX in a Batch saved in SY00500.
Also, what if we delete a batch in SY00500 will there be any other place =
to look for; besides this? I had a batch sitting here for a long time =
and there were few (3) trxs ( Sales Credits) in it as well.
I wonder if I could retrieve those one by one and then delete them as =
well as these belong to a fiscal period which is closed plus we...Macro help with saving a spreadsheet with date and time in it
Can someone help me with some code that would save a file name as
Alan, how about something like this
ActiveWorkbook.SaveAs Filename:="Schedule " & Format(Now,
"mm-dd-yyyy-hh-mm") & ".xls", FileFormat:= _
xlNormal, Password:="", WriteResPassword:="",
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it