Two Momey 2007 Issues/Suggestion
I recently upgraded to MS Money 2007 Deluxe from Money 2004 and found two
issues that MS has never seemed to resolve.
The first is the frequency that bills are set at in the Bill Minder. The
list of options in 2007 is still the same as in 2004. I would have figured
that MS would finally allow you to set custom recurrent times. For example,
I have a subscription that is billed every 3 weeks - not possible to do in
Second, is what I believe to be a bug that I found to be pretty prevalent,
but apparently has not been fixed. The issue that that when I am entering a
transaction and ...Textbox in form that updates a table.
Is it possible for a textbox within a form to update a section within a
table? If so how. Also I wanted to know is it possible to gray out a command
button on a form after its clicked.
Normally a textbox will update a single value in a single field in a table.
To update several rows of a table, you can use an update query. The update
query can use the value in the textbox on your form.
To grey out a command button, you would set it's enabled property to false.
Note: you must move focus to another control so that the command button
doesn't have the focus at the time.
Jeanette Cu...Sample CRM Data Install Issue
Installed test version of CRM fine running as a web site on its own IP
Try to run the sampledata wizard on CD1 but it fails at the first dialouge -
enter the address of your crm server. Mine is running locally on
192.168.0.91 - accessible fine thnrough a browser - so I enter this and get
back an error message saying crm server not found or not got sufficient
priviledges to do this. Am logged on as Administrator account?
Any advice on what needs to change to make the wizard work?
...Use the ctrl+t to move from tab to tab in a form
I have a department that would like to be able to use the keyboard instead
of using the mouse to select a different tab in their form.
My form consists of the following;
In the Detail: I have a Tab Control (TabCtl211) that consists of 3 tabs and
with in the tabs there are several fields that they add/update
Case Entry/Update (0), Legal/Closure (1) and Restitution (2)
I want to use the ctrl+t to move from tab to tab, because they use the tab
key to move from field to field and then to new record.
How do I make this happen for them?
"Penny Miller" <Penny.Miller@CO....How do I copy a screen in Excel for use in Powerpoint?
I need to copy a few Excel screens for training purposes and want to paste
them into a PowerPoint slide show. Can anyone help?
Alt+PrintScreen and the paste into Powerpoiint.
> I need to copy a few Excel screens for training purposes and want to paste
> them into a PowerPoint slide show. Can anyone help?
It shows that i have transferred it to the clipboard but it will not show me
the screen in PowerPoint. Any ideas on what I'm doing wrong?
"David Hepner" wrote:
> Alt+PrintScreen and the paste into Powerpoiint.
> "Bess" ...should i hide a form or make it modal
Quick question looking for others opinions on the subject
I develop apps for a company and up until now I have been using modal
forms to keep the most resent form open on top I have recently learnt
how to hide the access window and keep the forms visible using popup
quite neat to be honest.
My reasoning behind this is staff here use many apps but when I
present them with an app that is built using ms access they think they
cannot use it as for some reason in their heads it is harder to click
a button using a ms access app than to click a button using a non ms
access app. (PS if yo...Reference previous record
I have a query that lists our parts and their cost. Some parts have 1
record and some parts have 2 records because their cost have changed.
How can I have the query compare the previous cost for that part if one
On Tue, 20 Apr 2010 15:37:06 -0400, "Jasper Recto" <firstname.lastname@example.org> wrote:
>I have a query that lists our parts and their cost. Some parts have 1
>record and some parts have 2 records because their cost have changed.
>How can I have the query compare the previous cost for that part if one
...Looking for XML Template Reference Docs
I need to make some changes to the Receipt Templates and Statement formats.
In RMS, these templates are designed in XML. Can somebody point me to a
reference doc that will assist me in customizing these templates? I am most
interested in seeing a list of possible variables that can be included in
Anderson Plywood Sales
Culver City, CA
...HELP..Tax exempt issues
hey there kind of stuck..I have a client and she needs to use the indian
status tax exemption. I have it set up that when everything is done that she
can select the HST tax or the Tax Exempt (meaning pay only PST) i
When we do this for some reason it goes to $0 in tax which isnt correct..I
tried it like 5 times and all same thing..i rechecked everything and i know i
am doing it correctly because i ave done it other clients..this one has
become a mystery..plz anyone help me asap
...Labels in user forms
In a Userform, can the label (where you enter text) show the result of a
formula so that the message changes depending on the formula?
Or is there a way to do this in another way if the label can't do that?
I assume that you mean a textbox not label, as that is where you enter text.
One way could be to trap the Calculate event for the sheet that your formula
is on and update the text box from there, something like
Private Sub Worksheet_Calculate()
UserForm1.TextBox1.Text = Range("A1")
... looking out across Poole H...Easy way to reference a specific cell in a new worksheet
This project is for week over week sales. A new worksheet is added every
week. The current week's sales are in Column E for every salesperson and the
previous week's sales are in Column F. I would like the Column F to
automatically reference Column E on the previous worksheet every time a new
worksheet is added by copying the previous worksheet. It's not that hard to
work around it now, I would just like to save time and automate the process.
Is this possible? Let me know if what I am attempting to do does not make
without VBA this is not possible
...Odd Webmail issue
When you use a favorites shortcut to our e-mail server spell check does not
work. We get an error that says The spelling in this item cannot be
checked. When you type the webmail address in the browser spellcheck works
find. Does this have something to do with SSL?
...Multiple date validation in a single cell
I am trying to do a rather complicated validation (I think it i
I want to allow ONLY dates of a particular format to be entered int
the one cell - i.e. YYYY OR mm/YYYY OR dd/mm/YYYY
For example, the same cell can have either one of these format
entered, but MUST match one of them to be accepted.
1970 is OK and is captured in the cell as 1970 (not 1/01/1970)
70 is assumed to mean 1970 on entry
05/1970 is OK, captured in the cell as 05/1970 (not 1/05/1970)
5/70 or May-70 is assumed to mean 05/0970 on entry
05/06/2004 is OK
5/6/04 or 5 June 04 is assumed to mean 05/06/2004 on entr...copying charts into new sheets, data is pulled from old sheet
i make a sheet with a load of data and some graphs,
then i want to copy the whole thing into a new sheet to process some similar
but different data,
all the cell references translate cleanly, and refer to the new sheet
however, the graphs reflec tthe previous sheets ranges and data.
how can i copy the graphs so they refer to cells on the new sheet?
btw i know excel pretty well, and i could go through and drag new data on,
but i would like about 30 graphs per sheet, so its tedious.
instead of copying just the data, use the Move or Copy Sheet option under
Edit and copy the whol...Documents in Multiple Monitors
Excel and Powerpoint (even in Office 2007) make it ludicrously hard
(impossible?) to view two documents on multiple monitors. Even seeing them
side by side is unintuitive (compared to Word).
Will this be finally addressed in Office 2007? It wasn't as of the last beta
I'm able to do it with my multiple monitor setup. What problems are you
having? How are you trying to do it?
> Excel and Powerpoint (even in Office 2007) make it ludicrously hard
> (impossible?) to view two documents on multiple monitors. Even seeing ...Easiest way to insert multiple copied rows?
Operating System: Mac OS X 10.6 (Snow Leopard)
Currently, I copy a row, right click and choose insert copied cells. <br>
This works great but only works for copying one row below. <br><br>What if I want to copy 2 or 3 rows below? <br><br>I can find blank rows, copy them, and insert them and then do this, but that is real tedious. <br><br>I wish there was a was to simply copy a row and hit some keystroke which would copy that row right below as many time as you click the keystroke. Does this exist? thanks!
Try clic...CRM Cluster Nodes cannot reference virtual name
We have an installation with CRM two clustered nodes using Windows
Nodes: CRM01, CRM02
Virtual Name: CRM
Apart from standard CRM implementation, we use CRM assemblies, both
for workflows but also for pre/post-callouts
Users PC's can access the system using http://crm:5000 (the virtual
name) and NLB correctly balances the load between the two nodes
The problems start when trying to access CRM from the web server
Using http://crm01:5000 works without requiring username/password
Using http://crm02:5000 works as above
Using http://crm:5000 works giv...How to change the view at "View Duplicates" form?
Please help on how to change the view at "View Duplicates" form? we want to
add more columns on this view. But I cannot find this view at SavedQueryBase
MS CRM consultants at Melbourne
Visit my CRM blog at http://melbournecrm.spaces.live.com/
...Transparency and Images
Can any one help with a solution to enabling the use of images of circles
with transpaernet backgrounds to be displayed correctly. I am using files in
a BMP format that have a transparent background but when they display in the
form the image has a 'white' square area where it is supposed to be
Any assistance is appreciated.
You could use a gif and set the background to transparent.
> Hi Folks,
> Can any one help with a solution to enabling the use of images ...how may I copy color of a other cell
I need a function that copy also the full format/color/size of a cell
A1 = USD 12'500.00 (monetary size, 12 fat, blue bottom)
A2 = mon 12.03.2004 (dates, 10 not fat, white bottom)
If in A3 I type: =" A1 " I would like a blue bottom, 12 fat, etc. and
If I type =" A2 " a white bottom, 10 not fat, etc....
Is it possible?
Thank you for any help.
Maybe you can use the Format Painter. Select the cell that has the
formatting you wish to copy, and click the Format Painter. It's a
paintbrush on a button on the Standard toolbar. Now click the c...How to copy Rules & Alerts from one PC to another
I occasionally copy my Outlook.pst file from my desktop to my laptop when I
travel, and then back again when I get home. I also export and import the
Rules & Alerts. The problem is that the Rules & Alerts for my emails don't
copy over very well. The rules are there, but they say "on other machine",
and most (but not all) of the rules that reference a specific email account
(e.g. when received through specified account) are missing the account
specification. Since I have quite a few rules, it is laborious to fix all
these rules every time I transfer my fi...Searching Multiple Sheets
Is there a way to search multiple Excel Sheets (same workbook), other than clicking on each sheet and using the Find feature? Thank you, in advance.
With XL2000 and higher, you can select multiple sheets by
holding down the Ctrl key and then do Edit > Find. Or
select all sheets by clicking the first sheet, hold down
the SHIFT key, and click the last sheet.
>Is there a way to search multiple Excel Sheets (same
workbook), other than clicking on each sheet and using the
Find feature? Thank you, in advance.
Thank you ...Forms...
I have a couple of questions relating to Outlook Forms.
1. Let say I develop a form on my computer. I can then fill it out and send
it to another individual to complete? Or do they need a copy of the form on
2. If I wish to use a form through an organisation, how can I
create/distribute it so everyone has access to it?
3. Can anyone recommend any good websites to learn more about Outlook forms?
Thank you for enlightening me,
Author a Word Document, save it as an attachment in a E-Mail.
"QB" <QB@discussions....Help! Form always in design mode
I'm pretty new to forms, I completed my first one yesterday which woks
fine. However, I'm now doing a second which is causing no end of
I have followed the instructions in help, but every time I open the
form up it is always in design mode by default, which mean that I have
to unprotect it and turn design mode off before I can use it properly.
I have tried saving it in several different ways, as a word doc and as
a template, but still it opens up in design mode, (still protected),
but the check boxes do not work.
What am I doing wrong?
The fact that you m...multiple indexes in one document
I have a document that lists information in a table. This information has to
be split into two indexes in separate parts of the same document. Trick is
that one index will need to contain all of the information and the other just
I created the main index and it is fine, however I do not know how to double
mark entries for use in the second index.
There are two separate mechanisms for this, and you can use one or the
other. (I would discourage trying to use both at the same time.)
If all the items for the second index are together in one part of the table...