How do I print query parameters on the report?
I'll try to keep this short. I have created a query with multiple
parameters. I want to print reports showing invoices to a specified customer
between certain dates. When I run the query, it is set up to enter the
customer name first, and then type the beginning date of the invoice period,
and then type the ending date of the invoice period. I have that part down
okay. When I print the report, I want the date parameters that I typed in
for the query to appear on the printed report. I created a text box in
Design View on the report, and for the Control Source, I entered the sam...FileNotFound returned by Bitmap::Save() when saving to stream
I have a little chunk of code which is supposed to take a bitmap image and
save its PNG encoding into a block of memory. The problem is, I keep getting
a FileNotFound error back from Save(). If anyone has any ideas, I'd love to
Here's the code (more or less) in question; there really shouldn't be much
to it, I would have thought:
Allocate an IStream object to write the data into a global
memory block. We indicate that the handle to the underlying data
will be freed when the stream object is released.
VERIFY(S_OK == ::CreateStreamOnHGlobal(nil, True,
static_c...can TIME values be aggregated?
Can time values be aggregated? I'm putting together a summary report
that will need to show the sum time that something happened.
(Employee breaks, for instance.) If break times for 3 employees were
"01:00:00", "00:15:00", and "00:12:30" in length, how do I aggregate
them to get "01:27:30"? Simply treating them like char values so they
can be parsed into integers and added and then divided by 60 doesn't
seem like the best way.
new DBA in '09 wrote:
> Can time values be aggregated? ...Handling of savings accounts and 401k accounts in the budget
I noticed that Money treats money that I contribute to a 401k account or
transfer to a savings account as an expense. Basically, the more I
contribute, the worse my budget looks. Is there a way to prevent this from
Right now, I exclude transfers to my savings account from the budget and it
solves the problem, however, I shouldn't have to manually do this each time.
For 401k contributions, I cannot find a way to do this.
Why does it show up as "an expense" (what Category???) instead of something
like Transfer Out of Budget Accounts? The 401k cash account sh...chart fixed as default
I know about using "Format Chart Area" -> "Don't move or size with
cells" to make my charts stay fixed. How do I make this the default
...how can I make one DocTemplate as a default open?
Below have two group DocTemplate, as normal, we Open New File, System
automatically pop up a dialog with listbox for us to select one of them
as open format.
How can I set something to make m_p1Template as default open. I don't
hope pop up this choice dialog.
m_p1Template = new CMultiDocTemplate(
RUNTIME_CLASS(C1Wnd), // standard MDI child frame
m_p2Template = new CMultiDocTemplate(
RUNTIME_CLASS(C2Wnd), // standard MDI chi...Unable to save password in Outlook 2003
I cannot seem to save my "network password" for Outlook 2003. I tried
everything I can think of. I tried editing the registry. I use XP. I try
going into Control Panel, go to mail and go thru the process there
and....nothing worked there. I uninstalled Office the reinstalled
it.....nothing! I even went as far as unistalling my internet software,
still...nothing! Someone told me that XP will not save passwords. My
Outlook express works fine. Someone HELP!
I also had this issue in Outlook 2003, but also in indows Live Messenger and
Internet Explorer 7.
I spend hour...what encoding does system.xml.xmldocument.save(string path) use to save the xml document if there is no <?xml... in the front of the xml document?
what encoding does system.xml.xmldocument.save(string path) use to save the
xml document if there is no <?xml... in the front of the xml document?
> what encoding does system.xml.xmldocument.save(string path) use to save the
> xml document if there is no <?xml... in the front of the xml document?
UTF-8 is the default encoding.
Oleg Tkachenko [XML MVP, MCPD]
http://blog.tkachenko.com | http://www.XmlLab.Net | http://www.XLinq.Net
utf8 i suppose would be default
"Daniel" <email@example.com> wrote in message
news:e8#...Save and save as
I am looking for some help with a macro, I need to disable anyone from
saving a file or save as and also disable the prompt if the close button is
pressed you get an option to save the file then, I need to disable all of
these, also have a pop up box to warn that save as been disables when a user
tries to save the file fro save and save as.
Can anyone help me with this. I am using word 2003
Once you give someone access to a document, you have ceded all control over
it. You can however stop them from overwriting the original file by making
the doc...How can I create a formula for Salutation
How can I create a formula that will look at the name in a column and create
With your names in column B, assuming them to be forenames, then
If the names are last names, then if you had Title in another column,
say title in column A, Forename in Column B and Lastname in column C
="Dear "&A1&" C1"&","
>How can I create a formula that will look at the name in a column and create
> How can...sorting by date #2
I am having trouble sorting a table by date. When I choose to sort th
column by date - it sorts it alphabetically by date - i.e. with Augus
How can I have Excel sort chronologically, when the date include
month, day, yea
Message posted from http://www.ExcelForum.com
It sounds as if the dates are formatted as text. You can change this to an
Excel date value by inserting a helper column and using the following
formula (assuming your dates are in column A:
and copying down. Excel will then recognize the values as date values, not
text, and will sort chronol...Date Query 04-14-10
Hi all, I was wondering if anyone could please help me? I have a database
table that has a column allocated to the date a person consented to have
their details added to the database. What I need is to create a query that
displays any date entries and the number of times that particular date has
been entered (as many people would give consent on the same date).
I then need to add another column that calculates what week that date fell
into starting from Week 1 (21st December 2009).
The main reason I need this query is to build a chart that displays the
amount of consenting people...Saving Images
When I right click to save an image in an email, it will only save as a .bmp.
I need to use it as a .jpeg or a .gif. How can I fix this?
Angi <Angi@discussions.microsoft.com> typed:
> When I right click to save an image in an email, it will only save as
> a .bmp. I need to use it as a .jpeg or a .gif. How can I fix this?
Clear your internet explorer temp file cache.....go to control panel,
internet options, and choose 'delete files'
"Angi" <Angi@discussions.microsoft.com> wrote in message...Can I email url links
OK, I understand security concerns! I would like to email url links to
other co-workers using Outlook 2003 and Exchange server. Sureoly there is
some way to do this? Thanks!
You have me at a little disadvantage. I use Outlook
2000. Did you ever use Outlook 2000 and were you ever
successful using URLs? The reason I ask is that I AM able
to send in Outlook 2000. If you are not the Exchange
Administrator, you might consider asking him/her if there
has been extra security added somewhere.
Best of luck,
>OK, I understand security c...Text box in the Bar chart
I have inserted text box in the Bar chart. not able to format the text
inside the text box...
any guidance please.......its bit urgent
You can control the box by right clicking and choosing "Properties."
I don't think you can change the text settings - or if there is a way, I
haven't found it.
- Andrew Lavinsky
> I have inserted text box in the Bar chart. not able to format the text
> inside the text box...
> any guidance please.......its bit urgent
Select the text inside the text b...ATTN: Need to import data from access database, hosted on web.
This should be fun.
I can use the import data feature to get data into excel from a loca
But i need a central access dbase on the web, and when someone open
the excel workbook, it auto updates from the access dbase hosted on th
Im assuming this has something to to with the connection strings et
that i need to write, could anyone point me in the right direction o
post a solution,
many many thanks in advance.
Message posted from http://www.ExcelForum.com
...Date Question #2
I am creating a worksheet that will last specific dates in column B. In
Colum C I want it to just list the month. There is going to be about 20-100
lines for each day, so i guess i want to use a formula that says if b6 =
1/15/2006 then in column c6 put January, etc. Is that possible?
Try this formula
and format cell as "mmmm"
daddylonglegs's Profile: http://...charts #23
I am making a chart but all of my y axis values don't show up.
What kind of chart, what Y values are there, and how do you expect them to
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
"alvinb" <firstname.lastname@example.org> wrote in message
>I am making a chart but all of my y axis values don't show up.
..."Unattainable" savings goals
I've learned to mostly ignore it, but it drives me
batty. I have a particular loan with a goal to pay it
off by 7/4/04. The loan balance is 14,000. I have
marked a savings account to be "used for budgeted savings
goals." I deposit $1300 per month into the account which
has a balance currently of $13000. Money 2K4 says that I
cannot reach my savings goal. What can I do to help fix
this? Any feedback would be appreciated!
...Saving default tabs
I can't seem to get a change in the default tab setting to
When I reopen publisher the tab setting reverts to .5
which was original default.
I'm I the only person who is having this problem? I'm
using the 2003 verson but had the same problem with 2000.
Why not take the default page, set the tabs you want and save it as a
template with a file name of,
"My Very Special Tabs Settings for Future Files.pub"
(jerking your chain a bit<G>)
Then when you want to create what you want, use your created template file
and when your pub file is what you want, do a Sa...Sending web page attachments
Whn attempting to send a web page via e-mail I receive
the following message. What do I need to do in order to
send these pages error free and why is the message being
received in the first place? Thank you -
Outlook blocked access to the following potentially
...VB6 service under Server 2008 can't run another VB application
I have a VB6 service that has been running for years on 2000 and 2003. I'm
trying get it to work on Server 2008 and it's not working. The service
calls shell to run another VB6 .exe program. This .exe program is not being
called when the VB6 service program is run as a service. If I run the
program as an application, it works like it should. Obviously, something in
2008 needs to be changed to allow this but I don't know what it would be.
Steve Ricketts brought next idea :
> I have a VB6 service that has been running for years on 2000 and 2003. I'm...Save to unProtect a Document?
Our company has word documents that we use as templates on a fileserver. How
could I protect the documents so that when they open them, they dont make
changes to the server version, but save their OWN version and do what they
First of all, make use of true *template* files (with the *.dot or *.dotx
extension). Also, assign the template files the read-ony attribute.
Microsoft Word MVP
"Chris" <Chris@discussions.microsoft.com> wrote in message
> Our company has word docum...can't send emails; get the following....
The message could not be sent. The authentication setting might not be
correct for your outgoing e-mail [SMTP] server. For help solving this
problem, go to Help, search for "Troubleshoot Windows Mail", and read the
"I'm having problems sending e-mail" section. If you need help determining
the proper server settings, please contact your e-mail service provider.
The rejected e-mail address was 'email@example.com'. Subject 'registration
', Account: 'firstname.lastname@example.org', Server: 'outgoing.verizon.net', Protocol:
SMTP, Server R...Can you make a cell with a diagonal, so that you can edit the upper and lower part of the cell?
If you make a square cell, then make a diagonal border you can make it
look right for printing, but I was wondering if there is anyway to
make it so that you can edit.
I would like to make a cell and then split it into 2 cells, so that it
will almost look like a fraction.
1/2 #1 in the upper cell,# 2 in the lower cell, then use a border
to do the diagonal.
Not really. But you can take two side-by-side cells, format them so that
their text is on a 45 degree angle, put a vertical border between them, and
then adjust the row heights and column widths to get some...