How chart time scale x-axis with another date serie
Hello all. I have this problem, I will need to create this chart that I don't
know how to.
Serie 1 is below which needs to be time scaled
Serie 2 - needs to plot the three dates in serie 1's time scaled X-Axis with
I will look something like you have a line of count on a time-scaled chart,
with 3 dates point in the x-axis. Please ...DAO is less relevent than Wnidows 3.1
why do you diptards still use DAO again?
why would you want to have 2 different DIALECTS of SQL?
Anyone using MDB or DAO should be fired and then spit upon
" S u s i e D B A [ M S FT ] " <s u s i e d b a @h o t m a i l.com> wrote:
>why do you diptards still use DAO again?
>why would you want to have 2 different DIALECTS of SQL?
>Anyone using MDB or DAO should be fired and then spit upon
Note that this person is really A a r o n K e m p f and that he is not an employee
Tony Toews, Microsoft Access MVP
Please respond onl...Can't Make Attachment
I just upgraded to outlook 2003 and now I can't drag and drop files into a
new mail message; even though I can click on the paper click and attach a
file that way. I had this functionality prior to upgrading to Outlook 2003. I
am running Windows XP. Please advise if anyone knows of a setting for this or
a registry fix.
...how to edit my x-axis data on a line graph
Operating System: Mac OS X 10.5 (Leopard)
my x axis data on my graph is just showing numbers 1 2 3 4 5 6 7 8 9 10 11.... and it is suppose to show the years. I can't figure out how to change these values
...Gift Cards Implementation
I need advice on how to travel here please. I have 10 stores and an HQ
setup. I want to implement a gift card that is barcoded.
Here is what I envision:
1) All barcodes of giftcards are in the system and they have a dollar value
2) Gift card is then scanned and made active somehow at the POS ??????
3) Money received goes to a common enterprise account and z-report is
modified to remove reporting of gift cards as this money does NOT belong to
4) Profit Margin report is reworked to remove seeing sales of gift cards as
the sale will stuff up the profit m...Createing Quote sometimes make Error: 80070057
Today I found some funny problems.
I create Quotes via the quote WebService from the CRM.
This normally works fine, but now I have some quotes, which will get me an
error, when I open it. This error is no normal error, I will get an
white/yellow Page with ASPX Errorpage:
Here the Message (sorry but I only have this error in German):
Serverfehler in der Anwendung '/'.
Beschreibung: Beim Ausf�hren der aktuellen Webanforderung ist ein
unverarbeiteter Fehler aufgetret...Need Hyperlink from Menu Page to work in email
I have a workbook with several tabs. First tab is a "menu" type page
(summary of other pages). Currently I have hyperlinks to all the other pages
from the menu page. What I want to be able to do is copy the menu page into
an email and enable the users to click on the existing hyperlinks (whatever
adjustments needed) to go directly to their page of the workbook. Using
Excel 2007. Please advise how to do this and what changes may be need for
both options to work.
...Open web page from Word 2007
I have the following code to open a web page:
Set IE = CreateObject("internetexplorer.application")
mySTR = "http://MyWebPage"
The code works if I run it from vba - it opens the page on top of Word. But
if I assign it to a QAT or Ribbon button, it opens the page but leaves it
How can I get it to open on top of Word?
...How do I make door hangers using publisher?
Is this even possible?
Mary Sauer has a website with a generous collection of goodies including
Take a look at just above George Washington's portrait (way down the page)
Don - Publisher 2000�
"medinapie" <email@example.com> wrote in message
> Is this even possible?
I have a sample on my web page. Scroll down -- on the left.
Some cute ones here that you could mod...Both sides of a report page
Is there a way to utilize both sides of a report page as if printing a book?
On Wed, 9 Jan 2008 08:06:03 -0800, TRS <TRS@discussions.microsoft.com> wrote:
>Is there a way to utilize both sides of a report page as if printing a book?
Yes. But it is dependant on the printer your using, not on Access.
...replacing a credit card account with a new account with same institution
My credit card was just replaced causing some credits and debits on
the old account and transferred to a new account. Do I need to merge
these accounts? When I update the accounts I only get a balance on th
enew account and no transactions. Any advice would be appreciated.
In microsoft.public.money, firstname.lastname@example.org wrote:
>My credit card was just replaced causing some credits and debits on
>the old account and transferred to a new account. Do I need to merge
>these accounts? When I update the accounts I only get a balance on th
>enew account and no transactions. Any advice...Can't Make this Work
I create a new Datasheet form from tlPB and get the "FIRST SQL VIEW".
I then select DirectoryID and from the Row Source, I get the "SECOND
I then select DeptID and from the Row Source, I get the "THIRD SQL
DirectoryID and DeptID are both Combo Boxes.
I want only those DeptID's that are related to the DirectoryID that
has been entered in the Datasheet.
Can someone show me how this is done?
FIRST SQL VIEW
SELECT tblPB.PBID, tblPB.DirectoryID, tblPB.DeptID
FROM t...Problem with printing listbox bigger than one page
I created form "Invoice". It contains few list boxes (like: Brand,
Product, Price, etc.). Each list box is big enough to display 50
items. It works in this way: user is chosing product from table
Products_tbl and clicks on "Add to invoice" button which adds to each
list box new item containg apropriate information about chosen
product. At the end, user can print the form. Before it was limited,
and user could put max. 50 products on one invoice, but I wanted to
get rid of this limitation. I did it in this way: after 50th item,
with each added product I extend list boxe...How do i apply a background to only half the page?
How do i apply a background to only half the page?
> How do i apply a background to only half the page?
One way would be to add the background
and then create a text box / resize it and
reposition it to cover half of the page and
type Ctrl+T to make it opaque (white).
John Inzer MS-MVP
Digital Media Experience
This is not tech support
I am a volunteer
Solutions that work for
me may not work for you
Proceed at your own risk
How about filling a rectangle or text box?
Don - Publisher 2000
Vancouv...Comparing 4 dates and getting 1 headache
I have a problem hopefully some one can help me out with.
I have the following 4 dates…
Beginning Date of Service
Ending Date of Service
Eligible Beginning Date of Service
Eligible Ending Date of Service
I need a formula that will compare the Beginning Date of Service to the
Eligible Beginning Date of Service, if the Eligible date is later it will
take that if is earlier then it will take the Beginning Date of Service and
compare it to the Ending Date of Service if the Eligible Ending Date of
is later then the Ending Date of Service or the Ending Date of Serv...make a Year to date column
Can someone please suggest how I can get the year to day column display
Nothing if there is not anything in the preceding column?
Eg... Column K is YTD. Column J is Invoice total. I figured out how to
hide the zeros in the J column... but can't figure out how to make K show
nothing until there is a figure in J.
Its a simple sheet. Just adds invoices.. and provides a YTD figure. But
looks DUMB when the last YTD figure is carried all the way down the column.
Thank you ...
Try something like this
in say, K2, copied down:
=IF(J2="","","<yourCumuYTDformul...how to make a view (without a title bar) draggable?
I want to create a listbox (using CWnd::CreateEx()) as a child view of
the main view. But the lustbox must not have a menu bar and a title
bar. How can I make this listbox child view draggable (but not
resizable)? Please help. Thanks.
Handle OnMouseMove() at the Listbox level and send a WM_NCLBUTTONDOWN
message with wParam = HTCAPTION to the listbox itself. Something like
void CYourListBox::OnMouseMove(UINT nFlags, CPoint point)
SendMessage( WM_NCLBUTTONDOWN, HTCAPTION, 0 );
// CListBox::OnMouseMove(nFlags, point);
Check Abdoul [VC++ MVP]
...Save Worksheet As HTML Page
I recorded a macro to do a simple html export that is assigned to a button.
This works fine.
The VBA code is
' Macro1 Macro
' Macro recorded 9/02/2006 by rulebr
With ActiveWorkbook.PublishObjects("Brady Standard Quote 7.2.06_23158")
.HtmlType = xlHtmlStatic
Id like to add a few more in the file name it saves it to.Through vba code
a way to make the file that is save with the following file name format.
So an example would...How do I update my Outlook (standalone) to SR-1?
I use a stand alone copy of Outlook on my laptop with Windows ME.
I would like to update the outlook to SR-1 so I can use some Franklin
Planning Software I have.
Any links or help is much appreciated.
Go to http://www.microsoft.com/office/downloads and click on the option to
"Check for updates" and allow it to find what updates you need. It will
automatically install the ones you select.
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
&...Copied Objects to new Page Move Around
I am trying to copy a set of interconnected Visio objects from one file to
The copy itself seems to work okay, however, once the objects are pasted in
the new, blank document, Visio goes ahead and re-organizes all the objects
the way it wants to.
Is there any way to STOP Visio from re-arranging pasted objects?
Thanks in advance (I hope)....
Keith C. Jakobs, MCP
what kind of drawing?
Hope this helps,
"Keith Jakobs, MCP" <elohir@NOSPAM.hotmail.com> wrote in message
>...Publisher 03, how do I apply a change to all pages in a calendar?
I created a 12-page calendar - a full page per month. How can I change a
font and have it apply to all 12 pages? Similarly, how can I add a graphic
and have it show on all pages? Thanks!
Click the font scheme, it should be on the calendar task bar, if not open it from the
format menu. Select a font scheme or create one of your own.
The graphic is simple enough, insert it on the first page, paste it on the next 11.
It should paste exactly where it was placed on page one.
Mary Sauer MSFT MVP
"EddieP...Web Page doesn't display in e-mail.
When someone sends me web page via e-mail, the web page
does not open properly. Instead, I get a bunch of lines
that are embedded links in the web page. Is there anyway
to have the web page open correctly when I open the e-mai?
...How to set time on x-axis of a bar graph?
I want to make a graph that has the x-axis labels a full 24 hour period. I
have data points at random times during the day and I want to express that in
the graph. For example, if I have 5 at 7:00, 2 at 7:40, and 3 at 11:00, I
want it to show that the 5 and 2 are closer together than the 9, for example
that there were more occurances at 7, none between then, and 1 at 11:00?
In a bar (or column) chart, the x-axis is a <category> axis not a numeric
one. This means the x-values are treated as text and each is equally spaced
from the other.
You might consider an XY chart with 100% n...How do I make a Switchboard in Access 2003?
My real question is: How can I get back my switchboard manager I had with
Access 97 in my present Access 2003.
Don't know where it was in '97 but in 2003 goto
Tools - Database Utilities - Switchboard Manager
>My real question is: How can I get back my switchboard manager I had with
>Access 97 in my present Access 2003.
There's ALWAYS more than one way to skin a cat!
Answers/posts based on Access 2000/2003
Message posted via AccessMonster.com