Changing text in X and Z reports
I want to change a text in X and Z reports. The original text is "Paid
on Account." I want it to say "On Account."
How can I do the change?
I already found the XML report template but don't know where to go from
Thank you in advance.
open file in Frontpage or text editor. Do "find" and type in "paid on
account" to get you to the section quickly. or, just roll down until
you find this section
Section: Grand Total Out
<ROW...How to change multiple folders views in Outlook
When you first create an account within Outlook (currently using 2007
but I'm sure it's the same for other versions) it defaults the folders
so that certain columns are visable they all have the viewing pane
Is there a way of changing one folder so that all folders look
identicle (Deleted, Drafts, Inbox, Junk E-Mail, Outbox etc etc etc).
I'm sure there must be a way but I'd be damned if I can find it...and
it's driving me nuts!!
email@example.com <firstname.lastname@example.org> wrote:
> Is there a way of changing one folder so that a...9.0 Table Changes
Will be updating to V9, am looking for a list of the tables that changed and
the documentation says it is on V9 cd 2, under the SDK
But I don't see anything on the CD so do I have to install v9, and the SDK
before I can get a list of the table names?
You need to install the SDK
> Will be updating to V9, am looking for a list of the tables that changed and
> the documentation says it is on V9 cd 2, under the SDK
> But I don't see anything on the CD so do I have to install v9, and the SDK
> before I can get a list of the tabl...How can I change the program used when following a hyperlink
I have a database which uses hyperlinks to take me to a set of image files,
gif & jpeg. I have recently moved to Firefox. If I click on a link to a gif
file it opens in Firefox, but if I do the same for a jpg it persists in using
IE. The file association for jpg files on the computer are to Photoshop. But
I prefer opening the links in the browser as I am only viewing, not editing,
Anyone got any ideas
Use a button that when clicked calls this code (pass in the value on the
Public Sub OpenWebPage(url As String)
Dim browser As Vari...Saving data in Access table with VB ?
I have a form with a button and if you click the button, a list of invoices
are generated and saved in the table 'Invoice'.
Problem is, the data isnt saved :(
Here's my code:
Private Sub Knop0_Click()
Dim Invoicenr As Long
Dim Invoicedate As Date
stdocname = "Invoice"
DoCmd.OpenTable stdocname, acViewNormal, acAd
Invoicenr = 111111
Invoicedate = Now
DoCmd.Save acTable, stdocname
What am I doing wrong ?
Answered in microsoft.public.access
"Bauhaus" <email@example.com> wrote in message
news:7Exii.firstname.lastname@example.org...Record Change Confirmation
This is a multi-part message in MIME format.
Access 2007 sp2
I'm using the following code I found on the web, on a Single Form, to =
have the user
choose to either save the record or not save the record or close the
message box and continue editing:
Private Sub cmdSaveAndClose_Click()
If Me.Dirty Then
Dim BlnOutcome As Integer
BlnOutcome =3D MsgBox("Record(s) have been added or changed." _
We are having problems when end users hit the cancel button on the Exchange
2003 OWA password change screen, it actually gives an ASP error when hitting
the cancel button on this particular screen. Does anyone have an TechNet
Articles on why this doesn't work?
Thanks for posting here.
In order to narrow down the problem, please provide me with the detailed
message of the ASP error. You may capture a screen shoot and attach the
picture when you post back.
Also, I would like to give you the detailed steps for enable change
password in Exchange 2003 OWA:
You must firs...Change measurements from inches to centimeters in EXCEL 2002?
I want to see measurements for margins for Page Setup in both Centimeters and
Inches - how do I change the display? (EXCEL 2002)
...Why am I prompted to save?
Why is it when closing certain files that I�m prompted to save when I
haven�t changed a thing?
This question was posted earlier about a month ago from someone else
and the response didn�t explain anything.
I understand why certain functions such as TODAY() and NOW() would
require the save dialog to pop up on closing but why INDIRECT, OFFSET
or CELL ect., what�s happening with these functions? I don�t get it.
Flintstone's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=...Why can't I click on the signature section to change my signature
When I go into tools, options, and then the mail format tab, the signature
option is greyed out and I can't click on it. I therefore cant edit my
existing sugnature or create a new one.
I've tried changing the format options to compose the message in, and still
Are you perhaps in a corporate environment? Then you mail admin might have
disabled that option as a corporate policy. Ask him/her or your manager for
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003
Outlook FAQ, HowTo, ...Save Link Problem
I run Windows 2000 & Excell 2000 with service pack 3.
I have an autoshape button that I have added a hyperlink to which opens a
html file on a server.
When I add the hyperlink and press the autoshape it takes me to the file ok.
I can do this as many times as I like and it works ok. The problem arises
after I save the spreadsheet. As soon as I save the spreadsheet the hyperlink
no longer works. I get the error message "The address of this site is not
valid, Check the address and try again". To add some more mystery to this, I
emailed the file to a friend and he inserte....xls changes sizes from one computer to another
An excel worksheet that we use prints out nicely on one
computer; however, when another user accesses it off of
the network and does a print preview, the columns of the
worksheet squash together in the middle of the worksheet
into and only by reducing the view by 99% is the second
user able to print correctly. I don't know the
circumstances regarding this but I am told this is the
way it has always been. Any input would be greatly
...Problem Changing from Average Costing to FIFO Perpetual (Version 9
Our company changed our inventory valuation method from FIFO Perpetual to
Average Costing. After two months we reverted back to FIFO Perpetual.
We now have a problem when we create a new SOP document. The cost that the
system is retrieving on the document is the CURRCOST from IV00101, not the
STNDCOST as we would expect. We have run the Change valuation method utility
and have checked links and reconciled, but this behaviour continues. If we
create a new item that have not gone through this FIFO to AVG to FIFO chance
cycle it picks up the STNDCOST correctly.
J...Money 2003: Change investment type from fund to stock
One of my investments was set up incorrectly as a mutual fund rather
than a stock. Now when I sync with my brokerage website, it doesn't
find the stock (since Money thinks it's a mutual fund) and it wants to
add all the stock shares to my account as new shares.
How can I change the investment type from mutual fund to stock from
the Investments area? There are no menu options to do so and the
online help doesn't provide any clues. I have several years worth of
transactions for this stock, so I'd hate to have to re-enter them all.
In microsoft.public.money, IanP. wrote:
>...Macro to "save as"
Am using excel 2003 and am wanting to create a macro, attached to a button,
that will save as a particular cell #, say A2, and then print. Have the
print down pat, but can't figure out the save as part.......
Thanks for the help
What is in cell A2? Try things like these, depending on what you have and what you want to do....
ThisWorkbook.SaveAs Range("A2").Value & ".xls"
ThisWorkbook.SaveCopyAs Range("A2").Value & ".xls"
ThisWorkbook.SaveAs "C:\Folder Path\" & Range("A2").Value & ".xls", Ad...Read-only files
I want to email an MS Publisher 03 file. It is read-only protected, but it
can still be accessed and changes made, although it has to be saved with
another file name. Is it possible to make it unaccessible - so that no
changes can be made at all?
and it doesn't even have to be saved with a different name, all you have to
do is change the file attributes.
"secretariat" <email@example.com> wrote in message
|I want to email an MS Publisher 03 file. It is read-only protected, but it
|...Changing multiple appointment times
I have hundreds of appointments and would like to move
them back one hour. I know there is a link in microsofts
support site that lets you change the time zone without
changing appointment times. However, recurring
appointments are not supported by that method. Does
anyone know of a way to move all my appointments back one
...how to change font on printed copy of outlook calendar week view
When I print out my calendar by the week the font is too small. I can't find
how to increase the size of the font so it PRINTS larger. I could change it
on the view of the calendar but it doesn't change on the print preview.
Randi Steiger;110316 Wrote:
> When I print out my calendar by the week the font is too small. I can't
> how to increase the size of the font so it PRINTS larger. I could
> change it
> on the view of the calendar but it doesn't change on the print preview.
Which version of Outlook? Did you check the page setup options w...Changing the names of fields in tables after creating other object
I just leaned about the naming conventions after I have created my tables,
reports and several queries. Can I change the name of fields in my tables
(to remove the spaces and give them unique names ie not just last name but
childlastname) without destroying the work I have done in queries, reports,
Positive Direction for Youth & Families, Inc. (www.pdfyinc.com)
Possibly. If you are using a newer version of Access, say 2003 or 2007 AND
you have Name Autocorrect, and all it's options, enabled, it MIGHT work. I
found it somewhat buggy.
Before you...MS Word file extension changed through e-mail
MS Word .docx files sent as attachments are received without the x, as
a .doc instead. The same is true for MS Excel .xlsx changed to .xls
Speak firmly to whoever set up the email system.
They have not applied their updates. When the file goes through, it is
being recognised as a Microsoft Word file, but the extension is being
Some free-mail web services have a bad habit of doing this.
It's not a Word problem, the change is being made either by the sending
email program or the receiving email program.
On 24/02/10 2:32 PM, in article
2e082f5...enforce user change their password every 30 days
we are using GP9 and sql2005. How do I set up user password change every 30
Set this in the user setup window against the advanced sql server options.
You need to have a Windows Server 2003 domain for this to work - if you don't
have this, then the option will be grayed out. I believe SQL Server just
enforces the Windows domain password policy, so I think you would need to set
that to password change every 30 days.
> we are using GP9 and sql2005. How do I set up user password change every 30
> Than...Dynamically change pick lists?
Has anyone found a workaround for the following :
dynamically change the choices in one pick list based on the selection
in a second, associated pick list.
I know this question has been asked before, just wondering if someone
found a resolution for it.
I haven't tried it yet, but it is my understanding that
the first picklist that will modify the valid values in
the second picklist. HTH,
>Has anyone found a workaround for the following :
>dynamically change the choices in one pick...Changing Default Contacts List for E-mail
I have two separate Contacts lists open. When I go to
select names for the e-mail addresses, Outlook always
defaults to the wrong list, and I have to manually select
the other one. How can I change the default list that
shows up when I click on the "to:" header field in an e-
Sue Mosher, Outlook MVP
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
"Michael Leu" <firstname.lastname@example.org> wrote in message
I work on file that has several sheets in it and I
only access one of those sheets and add data to it
after I am done adding the data I click on the save bottom
and I get amessage saying that your file has been saved
as "527E5100" and it's no longer has the extention
of ".xls" and the file is no longer saved as an excel
I access the file 5 days a week and on Monday,tuesday and
Friday it saves fine but On Wed and Thursday I have
the problem mentioned above. this has been going on for
the last 4 weeks. I have already reloaded my office
but...Change Dots into Commas as Decimal Divider
I wonder if anybody can help?
I create a lot of automated reports. These reports include costing and
percentages, with several decimal places. In the English format the "1000
Seperator" is a comma, and the decimal places are seperated with a dot.
Now the problem:
I have to send the reports to clients in mainland Europe, where the "1000
Seperator" is a dot, and the decimal places are seperated with a comma.
So far I could only remove the "1000 Seperator" entirely (in Format cells),
send it to the Europeans, and they had to change the Comma on the de...