Adding Contacts #3
After saving my contacts, I can not find them when I search for them. I
know it is there because when I sync with my Blackberry it appears
A few questions:
- are you looking at a filtered view of your contacts?
- do you have multiple contact-type folders?
"ljg" <email@example.com> wrote in message
> After saving my contacts, I can not find them when I search for them. I
> know it is there because when I sync with my Blackberry it appears
> Please help
Vince Averello;315832 Wrote:
&...Cannot copy/paste in tables
I have been using publisher for years, and have used this
same version (Publisher 2000) for three years. I work
with a lot of tables and I have been able to highlight an
entire cell (or several cells) and copy and paste them
somewhere else in the table.
Suddenly (perhaps after one of the many "upgrades" from
Microsoft), I am unable to do this. I have a monthly
project where I have to copy/move information from one
cell to another continually, so to suddenly not be able to
do this is very frustrating. Anyone know of a reason, or
better yet, a solution to this problem? ...fill color toolbar buttons for specific colors
Is there a way to have multiple toolbar buttons that fill different
colors? For example, one toolbar button for fill blue, another to fill
red, another to fill yellow.
Currently, to work with several colors, I need to click to get to the
fill palette, then select the color. Quite tedious and slow.
One way would be to have a macro for each assigned to a custom button on a
Microsoft MVP Excel
"bucky3" <firstname.lastname@example.org> wrote in message
news:email@example.com.....Combo Box Drop-down list is based on specific data
I have a table (ASSIGNEES), which has four columns (ID, ASSIGN-NAMES,
EMAILADDRESS, DEPARTMENT). I need to set up a combo box that only shows the
names associated with a specific department when I click on the drop-down
arrow. For example, anyone with a department of MGT will not show in the
drop-down selection and anyone with a department of ENG will show up.
Thank you in advance for your help.
You put the criteria in the query that you create in the record source. So
in the query, reference the control on the form that has the department you
want (or don't want) to s...VPN tunnel between AD and offsite backup?
We have a small (residential) business which runs an AD with three or so
users, and a single Server 2008 R2 Exchange 2010 / AD server (say,
192.168.0.2/255.255.255.0, public IP 18.104.22.168/255.255.255.248) running
onsite. We're often away from the office (sometimes we're all abroad at the
same time with nobody at the address) so, in the interests of redundancy and
always being able to access email, we have bought a second server hosted in a
datacenter nearby (say, 22.214.171.124/255.255.255.0) which will also be an
AD and Exchange server, (both CAS and maibox servers...Going Live with GP
I plan to start using GP Sept 1. We have not transferred any historical
transaction from the old accounting system.
All of our Vendors, Customers, Inv Items etc. are entered and we have tested
all functions of AP AR GL.
Does anyone have a checklist of things to do when starting with a new GP
I understand the basics things such as
Enter open invoices in AP and AR
Enter open POs
Enter begining GL account balances fromt the old accounting system
Begining bank balances and so on.
I just want to make sure that I'm not overlooking something so a check list
from someone ...Migrating data from GP to GP
I have a GP7.5 installation when all data is, and a new GP8 installation on
a different server.
I need to migrate inventory data from the GP7.5 to GP8.
I know that i should use the integration manager. But using it means that i
should know the data source structure which is GP, and this is very complex
because i need to migrate all inventory module, not a few data.
PS: i don't what to make an upgrade because other modules are different in
the 2 installations.
Does anyone have any idea on this issue?
Have tried just using DTS within SQL Server choosing your 7.5 s...GP concurrent user and SQL 2005 CAL
assuming a 10 con-current licenses being installed on 15 workstation, with 15
users in GP.
How many SQL 2005 CAL is needed ?
Server plus user client access license (CAL) licensing requires a separate
Server license for each server on which the software is installed, plus a
user CAL for each user accessing the server.
The user CAL model will likely be more cost effective than device CALs if
there are multiple devices per user (for example, a user has a laptop and
handheld computer accessing SQL Server).
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business...adding yes/no field
How do I add a check box field to my query field name to be "Active"
I Tried Active:=yes/no,checkbox DIDN't WORK can you fix for me or is it
not able to do this THANKS MARSMAN
You would add the check box (binary) field to the table the query is based on
then it will show in the field list of your query. Name it "active" in the
State of Arkansas
> How do I add a check box field to my query field name to be "Active"
> I Tried Active:=yes/no,checkbox DIDN't WORK ...RE: Managing specific folders in all users mailboxes
I have followed those instructions and have set up a Recipient Policy that
takes care of just the one particular folder (Spam).
To test it I am using my personal mailbox here at work and am asking it to
delete any mail that is over 1 day old and more than 1KB. I picked my name
out of the Exchange Recipients, directed the policy to the specific mail
store and told it to find a specific alias (me). I moved some old sent
emails into the folder that were at least 30 days old.
I also setup a rule that says to run the policy every morning between 3 - 5
AM. I ran it manually yester...Questions about GP Client upgrade configuration
I'm getting ready to install a Service pack for GP7.5 and my ultimate goal
is to get ready to upgrade to GP8.0. However right now upgrades are very
tedious and below is the whole story.
All the users/clients are identical!
Let me describe what we have done in the past to upgrade and what I want in
In the past we sat down at each client machine performed the install. Then
we logged in as an administrator (Ethoseries required this I think) so the
product can finish loading what it needs. Again we do both steps on every
In the future what I would like to do is in...ALTER TABLE and ANSI_WARNINGS
We are running SQL Server 2008 enterprise.
I am attempting to change the data type on a column from int to bigint using
the following command:
ALTER TABLE dbo.jkAudit ALTER COLUMN jkAudit_UID bigint
When the above command is executed I get the following error:
Msg 1934, Level 16, State 1, Line 1
ALTER TABLE failed because the following SET options have incorrect settings:
'ANSI_WARNINGS'. Verify that SET options are correct for use with indexed
views and/or indexes on computed columns and/or filtered indexes and/or query
notifications and/or XML data type methods and/or ...update another table afterinsert
Hi, relative newbie question:
I've got a datasheet form which I'm using for stock in/out recording
which adds a record for each stock transaction in a stock table (number
of stock in and out etc.) , I also have a total stock level field on the
products table - I want to add\subtract from the stock total in the
products table when I add a record to this stock transactions table in
the datasheet - what is the best method to do this? I was thinking do a
sql update in code on the Form_AfterInsert event - am I doing the right
------------------------------...Stuck on Simple Query and Form from 2 Tables
I know I should know how to do this and have probably done it before, but
can't seem to get it right:
Tables: Households (Many) Committees (One)
Fields: (Standard Contact Info Fields) (Chair & 12 # fields for Members)
Many to One Join on Committees.ID to Households.Committees_ID
I want to be able to build a Committes query and form that 1) in the form
selects a name from a Households.Head dropdown list in each Member (1, 2, 3,
etc) field; 2) after selection, displays Phone and Email info beside each
Committe.Member's name; 3) stores relation...Pivot Table xl2007 Q
I currently have a PT in xl2007 with dates in my Column Data (From 1/01/2010
to 5/31/2010); I've currently filtered to show only 2/05/2010 to 2/25/2010
(the only actual February dates). How can I extract the Lowest current date
(2/05) and the Max Current date (2/25) out to cells D1 and D2 so when I
print the report these
dates are visible to the reader?
...Adding non-domain emails to distro list
Is there a way to add a external POP3 Address to a
Create a custom recipient (in Exchange 5.5) or if your running Exchange
2000 create a contact in Active Directory, then you'll be able to add the
contact to the distribution list.
Hope this helps,
"James Panegasser" <firstname.lastname@example.org> wrote in message
> Is there a way to add a external POP3 Address to a
> distribution list?
...Fabrication and GP
I need to know how to process a transaction in GP. We are a sales -
distribution center. We do some light fabrication. We need to find a way in
GP to take one part or more parts, do fabrication work with them, then put
them back into the system as a new part. For example, we take drum rollers
and send them to a local fabricator who drills holes in them, inserts
"brushes", then sends them back to us as a brush roller. They charge us for
labor and the additional material and we have a new part.
Currently, we either treat it as a parts sale / purchase. That part is
clean, but a...Pivot tables #2
Does anyone know a good place to find information about pivot tables and how to use them?
where one link leads here
"alex" <email@example.com> wrote in message
> Does anyone know a good place to find information about pivot tables and
how to use them?
Also see PivotTable I, II, and III at MS site.
http://office.microsoft...Pivot Table Count Issue
I'm using Excel 2003. I'm a high school guidance secretary. The
administrators are constantly asking for data relating to course failures.
From our school's student management program, I've exported a listing of all
course grades for the year and used the data to create a pivot table.
Right now, I'm only using row fields: StuName, GradeLVL, TermID, StoreCode,
I've filtered the data to only show records with a TermID of '1901' &
'1900'. (Semester 1 Final or Year Long). I've also filtered the StoreCode to
only...adding 2 columns where
Column B I have types of payments, google, amazon, paypal etc.
column C contains $$ amounts.
I want to add the money in column C where column B = paypal.
what is the statement??
See your other post
Microsoft Excel MVP
"Tammy" <Tammy@discussions.microsoft.com> wrote in message
> Column B I have types of payments, google, amazon, paypal etc.
> column C contains $$ amounts.
> I want to add the money in column C where column B = paypal.
> what is the statement??
> t...GP 9 Upgrade and SQL Server 2000 sp4
per microsoft's documentation sql server sp4 must be installed before
upgrading to GP 9. does anyone know if the sql server sp 4 install is
necessary for the GP 9 upgrade? microsoft's documentation indicated that all
service packs for GP 8 must be installed before upgrading to GP 9, but after
speaking with support, they said the GP 8 service packs aren't necessary.
bottom line: i'd like to avoid the sql sp4 install if necessary as i had to
rebuild my test server after installing sp4 last week.
Since the database requirements for GP 9.0 list SQL 2000 SP 4 a...delete row contains specific word in an macro
Hi, Im trying to delete row that contains specific expression like:
In row 444 column b contents (ESSO PRODUITS) i want to delete that row but i
have more then one row to find and delete.
Try this on a spare copy:
Do a Data > Filter > Autofilter on col B
Select from the droplist: ESSO PRODUITS
Select all the filtered rows (select the "blue" row headers)
Right-click > Delete Row
GMT+8, 1� 22' N 103� 45' E
Jean-Francois <JeanFrancois@discussions.microsoft.com> wrote in mes...Adding Pasted Links
I need to add two values together and paste the results in a different
worksheet. I have a table with many of these operations. Short of typing the
full links, is there a short cut way to do this?
If you've got a formula like =Sheet1!B1+Sheet1!C1, you can copy the formula
as far down the column as you like, and the references will change the
appropriare row as you copy down.
"Champskipper" <firstname.lastname@example.org> wrote in message
>I...Upgrading from GP 9 to GP 10
While trying to upgrade from GP 9 to GP 10, I get an error when selecting
the instance of the already installed GP 9: "Index was outside the bounds of
the array". Any ideas?
...Payroll GP 10.0
Got this from a client and not sure what they are doing, but never heard of
this any help would be great.
As I am reviewing the Payroll Deduction Journal from the payroll I just ran
yesterday, I have identified 5 employees whose deductions & benefits did not
calculate. I happen to be one of the 5. There is $$$$$ that did not come
off my pay as deductions; including my 401K. The common denominator seems to
be when employee changes are made, deductions & benefits are made inactive;
even though those benefits & deductions have no part in the changes being
made. Pardon me, ...