Entering 2 incomes, one self-employed
My wife's income is from an employer, who withholds taxes. I am
self-employed, so my freelance income has no taxes withheld.
What's the right way to enter the income(s) in Money? Should my wife's be
entered as Paycheck-->Net Pay?
I plan to use Money to estimate quarterly withholding taxes for myself, but
do not want my wife's income included in that calculation. Do I need to
specifically label income as either hers or mine? Or will Money know that
"Net Pay" has already had taxes taken out?
Thanks for any help.
Use the paycheck wizard for your wife. Con...Out of range line disappears in print as it re-enters graph
Hello, I have a problem with "Out of range line disappears in print as
it re-enters graph"
Here is what I did:
I measured RF power and made a graph. After initial settling I switch
off power, then after some time switch on. I measure and make a graph
In order to get a good view of the settling I must zoom into the
interesting area. The signal (line) goes outside my graph and re-enters.
On the screen everything looks perfect.
As I print the line LEAVING the graph prints but the line RE-ENTERING
the graph do not print.
The line start printing after the first data point in ...Value Entered Isn't Valid...Error
I have a cbo ShopName on my subform which is populated by ltblShop. The cbo
displays the Name, but is bound by the ShopID. If the user doesn't enter a
value, I want a msgbox to open confirming this and then entering "None",
which is an item in my ltblShop. Admittedly, the idea of having a tbl for
Shops which then has a "None" entry which isn't a shop feels wrong but seemed
to be the most expedient at the time and easiest for such the novice that I
am. The code for this upon entering and exiting that control seems to work
fine. The box opens upon a...PLS, Help: Separate a string that was entered with the help of Alt+Enter
I have a datafile that was generated by accounting software. My proble
is follow: I have a cell there with a string value, it contains tex
that looks like it was enetered with the help of Alt+Enter in a cel
(looks like several rows in one cell). I need to separate string into
several string subvalues and cant understand how to recognize tha
nonprintable char between the subvalues. May be some can gives me a
advise or other way how to do it...
thanks in advanc
StanUkr's Profile: http://www.excelforu...Enter/Tab not functioning
We have a customer who recently upgraded to GP v 10.0. They are having
random issues with the User Preferences for the Tab/Enter key. On certain
instances when the User logs into GP, he is unable to use either Tab or Enter
to move through fields - he has to go into User Preferences and click OK - it
lasts as long as he is logged in but on the next day, he has to repeat the
process. Has anyone else experienced this type of issue? He reports that it
is random and has happened to several users in GP. Thank you!
...Is there a way to see on what date a resource entered time?
We are on 07 through April CU.
I want to know on what dates my folks are doing the actual entering of their
hours. Is there a way to find this out?
i.e. on 11/20, Bill entered 4 hours worked on 11/16.
Microsoft Most Valuable Professional
> We are on 07 through April CU.
> I want to know on what dates my folks are doing the actual entering of their
> hours. Is there a way to find this out?
> i.e. on 11/20, Bill entered 4 ho...how to locate sum of which cells matches the number entered in a single cell?
Imagine, an excel worksheet with a really long column with numbers,
and a single cell with a number in it.
Is there a way to find out, the sum of which cells matches the
number entered in that single cell?
It's a tricky one isn't it?
| Attachment filename: example.xls |
|Download attachment: http://www.excelforum.com/attachment.php?postid=357884|
Would like the enter key to go down one line & home. Is there something I am
missing in options. T"IA
In Christ's matchless name
ted & colleen
"ted" <email@example.com> wrote in message
> Would like the enter key to go down one line & home. Is there something I
> am missing in options. T"IA
If you use the TAB key to go across the columns, when you get to the end and
hit Enter, the cursor will do that.
> Would...entering date in access records
I have this following problem. I have a access database with thousands
of records. The problem now is I want to enter the same date into all those
records, how can I do it in one shot?
Create a new query using the table that needs to be updated. From the query
grid, click QUERY in the menu and select UPDATE QUERY
In the query grid, select the date field as the field to update as the first
colum and in teh UPDATE TO row in the current column set the update value to
Since you're updating all records, no criteria is necessary. Clic...Dexterity Runtime Error When Entering Receipts
I have a user here running Great Plains version 22.214.171.124. When they
are doing Transactions > Financial > Bank Transactions > Enter
Receipts the application is locking up. I doesn't happen all of the
time but after he closes the application and goes back in again, the
error usually goes away and he is able to continue using the
The following entry is made in the Event Viewer...
Event Type: Error
Event Source: Application Hang
Event Category: (101)
Event ID: 1002
Time: 2:36:15 PM
Hanging application Dynamics....Activation Attempts Exceeded - Enter or purchase a new product key
After yet another hardware failure (leaking capictors), we had to
install a new computer (at the time we didn't know what the problem
was) with Microsoft RMS Headquarters Client. When activating, we get
Activation Attempts Exceeded - Enter or purchase a new product key.
According to our records, the number of times that this software can
be activated with this product key has been exceeded. In order to
proceed, you need to enter a different 25-character product key. You
will find the product key on the software CD case. To change the
product key, click Change Product Key.
Wha...Enter Billing notes for Project Timesheets in Business Portal
In Business Portal, it seems that you can only enter notes at the timesheet
header level. In Great Plains, you can enter notes on each timesheet line.
How can I enter billing notes for each timesheet line in Business Portal.
Here are the instructions:
To add a billing note for hours that you worked on a specific day highlight or
click in the appropriate cell and then click Add billing note.
Charles Allen, MVP
> In Business Portal, it seems that you can only enter notes at the timesheet
> header level. In Great Plains, you can enter notes on each timesh...Mny Auto Entered Transactn marked as "E" automatically
I have Money 2003 w/small business.
Everything (paychecks, regular monthly bills, etc) that is set up as "auto
entered" appears in my registered as "electronically cleared" with an "E",
when that is not actually the case. Then, when the transaction is downloaded
from my bank, it thinks the one that was auto entered was already downloaded
and it creates a duplicate.
Anyone have a suggestion on this? Class? Anyone?
Glyn Simpson, Microsoft MVP - Money
Check http://money.mvps.org/faq/default.aspx for tips and fixes for M...Entering transactions on the web
Is there a way to enter transactions on the MSN Money web site and have the
data download onto MS Money Plus?
Money used to support this but some users found it caused more problems that
it solved and many were put off by what they thought were the security
implications of it.
"Confused" <Confused@discussions.microsoft.com> wrote in message
> Is there a way to enter transactions on the MSN Money web site and have
> data download onto MS Money Plus?
...eConnect registration should allow product name to be entered
We would like our customers to be able to register the full version of
eConnect with the registration key and product name that comes with eConnect
for Scribe Adapter for Great Plains. Currently they have to open the table
ta00950 in the DYNAMICS database and manually add a record with the
TARegistrationCode and Product_Name.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open t...Entering data
I'm entering quite a large inventory list from another POS and trying to
find a faster way.
1. New item wizard does not allow creating vendor record as I enter new
items. The drop box took too many steps to get to vendor list. Is there a
2. Matrix requires entering the dimensions and attributes for each item. I
understand there is an option to establish matrix code for sizes and colors
(for apparel), but I can't seem to pull up the code in New Item wizard.
3. Is there a way to add a color or a size to a matrix after the new item
has been created. I understand ...can I design where I want the cursor to go after I enter?
I want the cursor to go from say cell A1 to E5 then to G3 in a worksheet I
designed without having to navigate throught the other cells. Anyone know if
I can do that in excel?
> I want the cursor to go from say cell A1 to E5 then to G3 in a worksheet I
> designed without having to navigate throught the other cells. Anyone know if
> I can do that in excel?
In addition to Frank's posting, you could do it with Worksheet Event code.
No sheet protection needed. No named range needed...Need VBA code that enters the F2 Key upon entering the Field
I am using Access 2000.
I understand that simply by pressing the F2 key while the cursor is in that
field, you can toggle Off and ON the highlighting for that field (textbox).
Can someone explain the necessary VBA code to perform this action without
the user's intervention?
"nytwodees" <firstname.lastname@example.org> wrote in message
>I am using Access 2000.
> I understand that simply by pressing the F2 key while the cursor is in
> field, you can toggle Off and ON th...Entering a 16 digit number
I am creating an Excel worksheet and am trying to enter credit card numbers
in one of the columns. When I enter the number, it automatically changes the
last digit to a "0". How do I format the cells to accept a 16 digit number?
Format as text or precede the entry with an apostrophe, excel has 15 digits
precision but I assume you won't do any calculations with credit card number
(No private emails please)
"Tbird" <Tbird@discussions.microsoft.com> wrote in message
>I ...Chart Title entering text VBA
Hope someone can help;
At work we import a large number of textfiles which when imported int
excel are graphed. We get the titles from the textfiles and this i
fine for all but one file. What i want to do is edit the chart title t
add text after it has imported. However the first part is variable.
So in summary i want the chart title as it is, but then to add tex
afterwards to the existing title. Is this possible?
so "Graph ????" is the title but i want to make it "Graph ????: tes
The below obviously just completely changes the title.
Sheets("Asthma Gr...ERROR check if a date set entered violates a previous date set
I am devloping an excel program that has a list of date sets, not
necessarily in sequencial order. What I want is an ERROR CHECK if a
date set violates any date set previously entered.
What I was looking for was that a discharge could not be typed in as
1/10/04 to 4/20/04
2/10/04 to 3/20/04
The second date falls within the first and should be invalid setting
off a message or an alert of an invalid entry. I am interested in
making it idiot proof so that one could not enter dates within or
covering dates already entered. This one really throws me, Please
The answer to your quest...Entering past transactions
Anyone know how to keep track of old transactions? I.e.
we are just setting up money on our system, but want to be
able to add stuff from Jan 04 to present so we have a way
to track daycare spending, etc. Can this be done?
You enter past transactions just like any other. The issue you will need to
consider is that transactions are entered in accounts and accounts have
beginning balances that have to be established somehow. For this reason,
what you want to do is **easiest** if you start with, say, your statement
from December and use its balance as the Money account beginning balance a...if value entered, then do this
I found a UDF on the web that makes a picture (from a pre defined folder
containing student pictures) pop up in a web sheet. So, in my spread sheet,
I have the following colums:StudentID,First,Last,Advisor,P1,P2,P3,P4,P5.
Then I have a colum with the formula to grab the picture: =ShowPic("c:\my
documents\my pictures\Larson07b.jpg"). But I only want the formula ran if
the user wants to see the picture. How can I do that? Doe I have to set up
another column that says something like, If the user says yes in this column,
then do =ShowPic("c:\my documents\my pictures\Larso...Display result depending on value entered
I want a quick way to enter a time in a cell.
F5 can either be 00:45 or 00:30
If the value 1 is entered into G5 then F5 will return 00:45
and if the value 2 is entered into G5 then F5 will return 00:30
what formula do I need for F5
Thank you, your help is appreciated.
"Gotroots" <Gotroots@discussions.microsoft.com> wrote in message
>I want a quick way to enter a time in a cell.
> F5 can either be 00:45 or 00:30
> If the value 1 is entered into ...Add a set number to a random entered number
I have to start a vehicle service record and am trying to add the 6000 mile
service interval to the mileage at service number.
A B C D
1 6000 12000
2 12125 18125
3 18200 24200 etc
A is the mileage at service and C is the next service due.I am trying to do
this without having a cell with a line of 6000 in it and the formula eg
=SUM(A1:B1) in the C cell.Is this possable?Hope some one can help.
HTH. Best wishes Harald
"Cyclops" <Cyclops@discussions.microsoft.com> skre...