Making a shopping list
This was posted by a friend in another forum.
Please can someone format a a table in excel for me. I need a tabl
that displays a list of items that i can enter a number in a colum nex
to an item, this would then generate another table that i could the
print showing only the items i have have selected and the qauntity. i
like a shopping list from a supermarket .
It's really anniying me that I can't work it out, as it seems very ver
simple to do
EARTHWALKER's Profile: http://www.excelforum.com/...Anyway to start the "Messenger" service only when connected to AD?
I use quite a lot of "send net" to broadcast important messages to the whole
domain. But the "messenger" service has to be started in order to receive
messages. However, more than half of the computers are portables that the
owners could bring back home. And when they're home, they're connected to
Internet with every mean available to them. And it's better that the
Messenger service is stopped to avoid spam messages from Internet or other
So, is there a way to start this service when these portables are connected
to the AD. And when they'...how i can make checkbox on Ms. Excel? #2
how i can make or use checkbox on ms. excel?
Open up the forms Toolbar and select the checkbox.
Draw the checkbox on the screen wherever you want it to reside.
Right Click on it to edit or format the Box.
> how i can make or use checkbox on ms. excel?
...Sum only if corresponding field is not empty
I have a table which includes the date, Expected expenditures and
Date Expected Actual
1 10 10
2 10 11
3 10 9
4 10 8
5 10 12
At the end of the date, I enter the actual expenditures for that day.
Now, for example, say it is the end of the 5th day of the month. I have
a sum function at the bottom of actual which is sum(above). How can I
get a sum of the expected only up to that current date for which i have
entered data into the ...SSRS Advance Services and passing parameters via <form>
I'm new to SSRS. I'm using SQL Server Express with Advanced Services,
and I have a report working. The report has a Parameter defined as
"ReportDate". In the report design, I have a subheading expression
that goes like this:
="For " & Parameters!ReportDate.Value
I'm trying to invoke the report from an ASP.net MVC app like this:
<form id="frmReader" action="
method="post" target="_blank&qu...Slight problem making electronic payments
I am using Microsoft Money Premium 2007. I use this program to
instruct my bank to send payments from my checking account. My bank
actually mails a paper check to whomever I specify, and draws the
funds from my checking account.
This has been working well for monthes. Recently, I upgraded my web
browser to Internet Explorer 7. At about the same time, Microsoft
Money upgraded itself to version #.
Now, after I instruct Microsoft Money to send out checks, I always see
a web browser screen that says "Navigation to the webpage was
canceled. The web browser screen has a URL field that reads r...Create new field
Access 2007 - I have to label each claim with a claimtype based on a
combination of fields and I'm not sure how to do this. In AS400 query, I
used conditional calculations, but would really prefer to find a solution
that is easier to update and manage. Hopefully, the table below gives an
idea of the combination of fields that I am working with. Each claim has all
of these fields. However, all claims with Aslob 052 should be labeled
"Casualty". All claims with Aslob 230 and FieldB=EPG are labeled "Surety,
but those with Aslob 230 and FieldA=EIC01 should be ...Package File Service Pack Inclusion
After applying SP3 to GP 10, is there any way to create a package file that
includes the service pack or do you have to install the package file and
immediately apply the service pack?
You can create Installation package file for your V10. Then, Install the GP
in Clients using the Installation package and then Apply Service Pack on
their machines. For Service pack, You can use GP Automated Client Updates
that will be helpful.
"Rich Wheeler" wrote:
> After applying SP3 to GP 10, is there any way to c...Extender Fields not removed from Smartlist
I had created a Inventory Add On Window using extender and added on a
field called as Manufacturer. I then, proceed to linking the field to
Once saved, I can not see the field I created via Extender in
Smartlist inventory. Unfortunately, I then found out that GP standard
already have a field name called as Manufacturer. So, I go back to
Extender and change the name from Manufacturer to TagID.
But, when I launch SmartList > Inventory > Item, I can still see the
Manufacturer extender field I had created and I can never find TagID.
I had made sure that...Address Fields Displaying incorrectly
I've imported a series of address from a CSV file and mapped all the fields
correctly (I think) and i have 2 questions
The problem I have is that in business card view the addresses don't display
correctly. They seem to be ok if you open the contact but don't initially
display how I want them (or like the others already in the contacts folder).
To illustrate the problem I've attached an incorrect and correct view of how
I want the address information to be displayed.
The email address comes in ok but I want the display name to be "FirstName
Last...to Make Labels with different photo and name
I probably will want the size of an 8 label page but they will have a
different photo and name on each.
Is this possible in Publisher 2002 SP3?
I've been all over the net looking for some info to no avail.
I did make one label in Publisher and I like the looks of it but for the
life of me I cannot find out how to get different ones on one sheet to
print. Why can't it be as easy as dragging them? I'll make them
individually instead of a mail merge. lol
Thanks for any input.
> I did make one label i...How do I make "No Header Row" the default in 'Sort Ascending'
I opften sort a range of cells using the Sort Ascending arrow. The
majority of the time the first row dose not sort, and when I got to
Data, sort The "Hesre Row" is ticked.
How do I make the default 'No Header Row' and avoid using Data, Sort
I don't think you can set the default for an alternative see the
macros at http://www.mvps.org/dmcritchie/excel/sorting.htm#icons
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritch...Auto populate fields
I have a form that asks for Name, Job Title, Employee ID number, etc. I can
create a drop down list using Validate no problem. However, I want to be able
to automatically populate the fields when a person's name is selected.
For example, if I select Billy from the Name drop down list, the Job Title,
ID Number, etc. gets automatically filled.
If you had a table with the other information that relates to Billy (and other
names), you could use =vlookup() to return that info.
For more info about =vlookup()...
You could look at Debra Dalgleish's site:
http://www.contextures.com/xlFun...Calculating profit fields in PA01304?
I have a quick query, I hope you can help...
I am currently writing an integration between our resource management
software and GreatPlains ProjectAccounting... I am updating the time-phased
data in the PA01304 table with data derived from our database, OK so far...
The problem comes when I ripple through the calculated fields that are based
on the PABQuantity or PAFQuantity fields that I have updated.
I have the GPPA SDK installed and the documentation explains all the
formulae for the calculations, but it fails to explain where the values used
come from... For example
When the Profi...Problem Setting-up Bank of America's online services in Money 2006
I migrated from Money 2005 to Money 2006 and I'm having problems with the
automatic updates in my Bank of America (BOFA). Money 2006 doesn't recognize
the previous online setup information and every time that I try to set up the
online services for my BOFA account Money 2006 creates a new account and
download last transactions.
Is there a way to associate my existing BOFA account with the online set-up
information? My BOFA account is not CA, WA, etc.
Can someone help me?
I just installed the MS Money 2006 and was unable to add the BoA a/c
successfully. Although I was a...how can i make the fields in my contact table match the ...
how can i make the fields in my CONTACTS table match the design view of my
CONTACT DETAILS form? need to know asap. thanks so much for the help!
i will be okay once i accomplish this. :-)
On Sat, 27 Feb 2010 11:58:02 -0800, mercedesb_girl
>how can i make the fields in my CONTACTS table match the design view of my
>CONTACT DETAILS form? need to know asap. thanks so much for the help!
>i will be okay once i accomplish this. :-)
You can see your database.
What are your tables...missing fields when importing contacts from excel 2003 to outlook
Hi folks. I have a list of contacts that I wish to import into outlook 2007.
I have saved it as an excel 2003 document but when I go to import it, I only
see 10 out of 12 column headers. The result of which is that the email
address and notes do not get imported. I looked through this list to see if
I could see any answers and have looked at my named range to ensure it
encompasses all my columns and it does, so can anyone shed any light on this?
What happens if you export some of your existing contacts to Excel and
compare the output to your Excel list?
...Can I Use AutoNumber Field In Multi-Table Link?
Is there any problem using the AutoNumber field as the primary key, and then
using this field to define a 1-M relationship between two tables?
I recall being warned against this. At the time, I was using another db app
(Paradox). Would this warning also apply to Access?
David Portwood wrote:
> Is there any problem using the AutoNumber field as the primary key,
> and then using this field to define a 1-M relationship between two
> I recall being warned against this. At the time, I was using another
> db app (Paradox). Would this warning also apply to Access?
No....Two field entry questions
I don't know if VBA will be involved, but... I have a Word
document with some tables and some of the cells of that
table should have text entered. What I'd really like to have
those cells which require entry to initially be yellow in color,
but whenever text is entered (either when the cursor has left
the table cell, or also acceptable when any text appears
in the table cell) the background color should go away.
My second question is that there are some places in my
document where I have entered spaces with an underline
to indicate that it should be filled out. However, wh...Macro for Company field in CRM Outlook Client
I feel like I'm beating a dead horse but I have to make this work for
this implementation; getting the company field in outlook to populate
with the Parent Customer information from CRM. This is discussed in
detail in this older post:
I can't use the suggested custom field addition because it doesn't
link to Palms. With several guys out on the field, the macro seems
like the only viable option. So the macro I...Saving Calculation Fields Value
im having a hard time making a database system using only full access..
im not allowed to use any VBA codes.. now im having difficulty on calculation
fields in a form.. it is said that calculation fields are not stored in a
table.. my question is how can i get the value of that field if ever i have
to create another form where i need its existing value.. it would be if easy
i can find it in a table but like i said it only exist in the form.
please help me with this.. thanks....
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/2007...calculated fields in outlook 2003 email
Hi I am trying to make a automated email for holiday bookings at our
Is there a way of calculating dates and using outlook custom fields within
the email. I can not find it if there is.
A regular email message can't do calculations and custom fields. An =
Outlook custom form can, but it would not be an appropriate solution =
except inside an organization, and it's not clear that's the scenario =
you're working with. (For starters, only people using Outlook can =
see/use Outlook custom forms.)=20
Sue Mosher, Outlook MVP
Author of Configurin...How can I show Fields from the Contract Form on the Case Form ?
I want to show the schemafield contractnumber on the case form.
I tried to add a field in the case customization.
I also mapped the field in the Deployment Manager from the schema contracts
to the schema Incidient.
The Result is a new Field on the Case Form without a value.
Does anybody know how to map Schemafields from the schema contracts to the
Thanks, Sebastian Evers
This is not possible out of box.
Your options right now is use SDK if you want to link in a field from
Contract into Case. Or wait for v2.0
http://www....displaying extra fields in org chart after running org chart wiZard
hi iread these instructions in the meaasge board:
"After you run the wizard, expand the "Organization Chart"
menu and click
Then click on the "Set Display Fields..." button and add
the fields you want
displayed in the shapes.
Can you do this in visio 2000, i am having trouble
...requery on timer? does this make sense?
I have a pie-chart on my main menu; the main menu cannot close, it only
becomes invisible. How do I requery the pie-chart to show new data when a new
workorder is added to the system? Should this be done using a timer or is
there a better way?
I've tried to requery on the got focus event, but that didn't seem to work.
If you have any ideas, I'd be grateful.