Enter month, get the first date
I want to be able to select the month from the drop down list and once the
month is selected, I want the first date cell to change itself to the first
date of the month selected. For rest of the date cells I have just used the
formula "First date cell + 1"
any help will be appreciated!!
Thanks a lot in advance.
Check your other post.
> I want to be able to select the month from the drop down list and once the
> month is selected, I want the first date cell to change itself to the first
> date of the month ...i need money for beer
since every one wants to place the bogus adds on these news groups
i figured lets see what happiens .i need money for the folowing
1) Beer becase i want it
2) A New tv becase my 68inch is to small
3) My daughter needs new barbies like see needs anouther one
4) my new computer is old now
5) becase i just need more money & u are giving it away
6) becase every idiot on here will post crap like this & get money SO THEY SAY
so why not me
7) i need money to renovate my Brand new house
8) i have to mutch food so i need more winter is coming u know
So if u have extra money send it...need help! very urgently needed
i am using an Activex control in a dialog based applicaton(VC++).
created an member variable for that(myportcontroller). In a non-stati
function i am able to call the Activex control methods using the membe
variable and worked fine. But i need to call the activex control method
in an static function. Here i cannot use the member variable as it is
static function. So, i declared an object for Activex control class
Using that object i called the methods. I had no compile time error
But i am getting run time assertion error as "winocc.cpp line:345". Ca
anybody help? I need very urgen...Getting unescaped XML from a transform
I have a stylesheet that contains C# functions to generate XML. When I
apply the stylesheet to my document, everything works perfectly except
the data I get back is escaped like so:
<test>this is a test</test>
I need to get <test>this is a test</test> rather than the escaped data.
Any input would be appreciated.
I am working in Microsoft Word, we have a permit form that has a dropdown box
that has two options either Full LDP or Perimeter LDP. I want the following
to be displayed in a text field in the form later on. the text field is
text19. How can i write an IF then statement that recognizes which option was
selected from the dropdown box and then displays "This permit is for
construction of perimeter erosion controls ONLY." in the text19 field?
To start with, you should assign meaningful bookmark names to your
formfields as it will make your macro coding much easier to under...Need help #8
Cannot find outlook on my new Vista 64 computer, can you help? Sincerley
Rudy Ramirez 702 353-4141 Fax 702 450-0580 RealEstate.com 10100 W.
Charleston Blvd, Suite 170 LV,NV 89135 mailto:firstname.lastname@example.org
RUDY RAMIREZ, you wrote on Fri, 20 Mar 2009 17:27:30 -0700:
> Cannot find outlook on my new Vista 64 computer, can you help?
Outlook doesn't come with Windows. Outlook is part of Microsoft Office
that you need to buy if you want to use it. But you can download and
install a trial version of any Office Version you want, but not Outlook
http://us20.trymicro...oma needs asp net version 1 but iis is running version 2
sbs 2k3 with exchange
outlook mobile acess ( oma ) is broken. i've drilled down to a probable
cause which is the asp net version needed to run oma, being 1. something
but the thing is, iis is running asp net 2.
i've read that to run both asp net 1 and 2, iis needs to run separate
processes, one for each version.
has anyone fixed this issue before ? how was it done ?
PEdro LEite from Portugal
...Publisher needs the disk to run..
I have Publisher 2000 and running XP Pro.
after years of working fine, Publisher suddenly needs the disc in the drive
to open a file.
This is cumbersome...
Oh by the way,, I have already tried "repair" & "unistall & re-install"...
> I have Publisher 2000 and running XP Pro.
> after years of working fine, Publisher suddenly needs the disc in the drive
> to open a file.
> This is cumbersome...
> Any thoughts?
I'm running the same as you but without the problem you describe.
I...Are you the XML expert I need?
Do you often wonder who built a certain website and how it is done? And who
manages that website right now?
Strange, but developers usually stay anonymous while they should present
themselfs to get more orders.
We have been working on a website to change this situation:
WebmastersLookup.com. It's a special Searchengine that lookes for
Webpersons, not for Websites.
We want as many webpersons as possible to join us. So that visitors can
search for somebody who will do the job for them. If they find that person
they can view his/her profile and portfolio. They can search o...Getting rid of the grid
I have finished a spreadsheet and I would like to make it look a little
slicker. If there any way to remove the cell edges so It is just white.
Tools>Options>View tab, uncheck Gridlines
Microsoft MVP - Excel
"wildertaz" <email@example.com> wrote in message news:BEE772D9-A094-40B8-94C4-5403D93E1351@microsoft.com...
|I have finished a spreadsheet and I would like to make it look a little
| slicker. If there any way to remove the cell edges so It is just white.
Select all cells, by clicking on the square to the left ...Need more Reports
GP does not provide detailed reports itself. reports such as sales by
customer, best selling items, inventory valuation and so... Also the reports
that it provides are not in good design and format (not useful). Is there any
report package from third party that can be purchased or there is any other
solution to get in depth reports and analysis?
Since Great Plains cannot possibly be all things to all people, get to
know the layout of the Great Plains database and where all of the data
is stored. Then roll your own reports using the native Report Writer,
SQL Reporting Services, Cryst...Finding Value of a Cell in a Range
In cell C1 I want to place a formula that will return a value of 1 if the
value of cell A1 is contained in the range of cells B1:B127 and a value of 0
is the value of A1 is not found in the range of cells B1:B127. All values
or use your b1:b127 instead
"Wendy L" <firstname.lastname@example.org> wrote in message
> In cell C1 I want to place a formula that will return a value of 1 if the
> value of cell A1 is contained in the range of cells B1:...getting info from 2nd spreedsheet
H First I'm new to Excell. What I want to do is retreive info from a 2nd
worksheet. I have the first which is a list of part numbers and Qty's
(my inventory) and a 2nd from the manufacture which has prices,
I would like to look at a PN on worksheet 1 and look it up on worksheet
2, find the price, and enter it in a colume (cell) on worksheet 1.
Posted via http://ms-os.com Forum to Usenet gateway
It sounds like =vlookup() or =index(match()) would be a good choice (depending
on how your data is laid out).
Visit Debra Dalgleish's site:
http://www.co...Do I need a subquery?
I am having problems creating a query to show cars with WorkOrders. The
tables involved are Customers (CustomerID as PK), CustomerCars (CardID as PK,
CustomerID as FK) and WorkOrders (WorkOrderID as PK, CustomerID as FK, CarID
as FK). I would like to have a query as the recordsource for a listbox that
shows the WorkOrderID, CustomerName, CarYear, CarMake and CarModel. My
problem is that I keep getting all of the customers' cars with the same
WorkOrderID. ie If I am the customer and I have 5 cars listed in CustomerCars
they all show in the query and I only want the one...Need a Training Database
I am on the lookout for a Training Database.mdb - to keep track of
employee training, for generating training needs employee wise as per
different training categories such as Technical, Management
Development, Safety, Environment, etc. Any help where I can get one? I
work with Access 2000 version
Where have you already checked?
Microsoft Office/Access MVP
Microsoft IT Academy Program Mentor
Microsoft Registered Partner
"shriil" <email@example.com...No data showing in query
I am new to Access and am using Access 2007.
I wanted to create a query to bring data together from several tables to
complete forms and form letters.
I used the Query Wizard to create a query which selected data from the
different tables. It worked fine and I was able to complete a form in Word.
I have now used the the same process using the same tables for a couple of
other queries but now there is no data in those datasheets. Anything I'm
missing here? Thanks.
There are three ways of creating a query. The query wizard, which you've
used, is at one end of the &q...Choice of Date or another field
I have a column which is used for component completion date. The latest
date is teh complition date for teh project. I am using MAX(field:field) to
select the latest date. However, we are running across the occurance where a
date is TBD(to be determined) How can I choose the TBD if it is present in
the column over the max date?
Format cell as DATE
"Mark" <Mark@discussions.microsoft.com> wrote in message
>I ha...Not getting Child ON_WM_LBUTTONDOWN messages
MFC Guru's please school me!
I have a simple SDI application generated by the AppWizard. From within
the MFC generated view class I create, from another CWnd derived class,
a second sub/child window.
BathyWin BWin; // Simple class with CWnd as parent class
BWin.pBathyWin->Create(_T("STATIC"), "Now is the time for all good",
WS_CHILD | WS_VISIBLE | WS_BORDER | WS_VSCROLL,
CRect(10, 10, myRect.Width(), myRect.Height()/2), this, 1234);
...ADO Parameter value truncation
Starting to pull my hair out about this one, thought I'd see if anyone
else has seen this!
I have an ATL COM component which I call from my (C++ and VB) clients
to execute a stored procedure. The COM routine I call expects BSTR
values, which I then use to populate the parameters of the query. No
matter what combination of values I use to create the parameters ( ie
adVarchar, adVarWChar, adBSTR), and using both varchar and nvarchar at
the SQL Server end, I only ever get the first character of a string
passed into the SP. The values are getting passed into the COM
component OK, I have checke...Outlook Express Needs to be Opened Twice
The first time I open Outlook Express it connects and down
loads my messages. The next time I open it it doesn't
connect. I then close it and the next time I open it it
connects and downloads messages if I have any.
How can I fix this?
This is a group to support Outlook from the Office group of programs.
Outlook Express is a part of Internet Explorer and is a quite different
program, despite its similar name..
You will probably get a faster and more expert answer if you post this to an
Outlook Express news group.
Try posting in one of these newsgroups:
microsoft.public.windo...Query leaving out some data
I think this must be a pretty easy question, but unfortunately I'm unable to
identify the solution . . .
CustomerID Company Name
3301 ABC Industries
3302 My Store, Inc.
3304 A1 Company
3305 Mom & Pop's Shop
Query should pull CustomerIDs for all Orders and list the CustomerID,
OrderID and Company Name. (SQL = SELECT Deliveries.CustomerID,
Cu...How to ID a table source being used in a Union Query
I have created a Union Query that uses 3 tables to pull data from. I need to
see identify which of the three tables the data came from. I tried adding a
column to the original tables with a default value "FP 07-09" which would ID
the table for me but my problem is: I cannot fill in this column with that
value on the existing rows of data all at once. I would have to paste it in
one row at a time unless someone can help me understand how to fill down the
column with this value or paste this in the new column on all the existing
rows. Someone else created these tables and I cann...Axapta Developer NEEDED!
I'm a recruiter for a $600 million sales company. We are looking for an
individual to work out of our beautiful corporate offices in Southern
California. This individual would have one year experience doing Axapta
development. I can't find anyone...please help!
...Do I really need OFFSET?
I have defined a Dynamic Name as follows:
The label for the data is in A3, the data starts in A5 and continues
downward. The definition above does start plotting from A5 but adds a blank
cell. There is always one extra empty data point that is plotted. Is there
an easy fix so that the plot starts at A5 and stops at the last data point?
See whether changing -1 to -2 (two places) fixes the range definition. If
so, you have two non-blank cells that you don't want to count instead of
one. On...append query discrepancy
I have an append query that is outputting to a table that I use for mail
merge. The problem is in the table view of my query, I see the correct
information in certain fields like "City, State, Zip" in the regular format
of, say, "Elmira, NY 14905". When I go into the table that the query is
outputting to, in the "city, state, zip" field I get a number, which
corresponds to the ID Autonumber that corresponds with each city, state, and
zip in the table the query is pulling it off of. Any idea how to fix this? I
can send a copy of the mdb. Please feel free to...