RMS 1.2 vs 1.3, plus integrate with Great Plains
1.) I am working on an assessment for upgrading our current RMS software from
1.2 to 1.3. My assessment will take in account the benefits, broken down by
store operations (Retail) and the benefits to IT. Also, list risks and
potential problems that might be experienced. We currently have 28 stores
with 3+ registers per location with another 22 new stores on the schedule
over the next 2 years. Are their other in this group of similiar size that
have done this upgrade to the new version?
2.) If we do not upgrade the software, can we still integrate the RMS to
Great Plains? Would we...Password Protect Two Sub-contact Lists
I have a regular contact list, and within this list I have two
subcontact lists. One is personal, and the other is personal business.
How can I password protect the personal and personal business lists?
Thanks for any help!
Sorry, I just realized that there's a newsgroup dedicated to contacts.
I'll post this there.
> Hi everyone!
> I have a regular contact list, and within this list I have two
> subcontact lists. One is personal, and the other is personal business.
> How can I password protect the personal and...Problems installing Sample Database on SBS2K3,CRM 1.2
When running the sample databse wizard I get the error
message "The currently logged-on user does not have a
Microsoft CRM license. Please contact your system
administrator." I'm using the same account I used to
install CRM, the administrator account. I have no problem
bringing up MS CRM (http://mscrm) & logging in with this
account on the server, however it isn't listed under
users in Settings>Business Unit Settings>Users. Also, its
not listed in the deployment manager under user
manager>Adventure Works Cycle. I've found 1 reference to
this specifi...Passwords #5
I would like to password protect a workbook so that when
the workbook is selected to open a dialog box pops up
asking for the password and after the password is entered
correctly the workbook will then open. Thanks for the the
Todd, do a save as and look under options, depending on what version you are
using and set a password to open
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address t...Manufacturing Order Activity #2
I am doing some testing on GP 9 SP3.
I have processed a Component Transaction Entry to issue some
components and posted the issue. (Inventory Posting is set to post to
and post thru)
I can see the Inventory Transaction in the MO Order Activity Inquiry,
but I do not see the Financial Transaction. I cn see the Journal Entry
in the Journal Entry inquiry.
There are no batched in batch recovery. There are no financial batched
to be posted.
I turned on the dexsql log, but cannot see aanything that would affect
Thanks in advance.
...Please Help #2
I have created a web browser project (I have CHtmlView to browse).
After browsing to a secure area in a web page using login authorization, I
want to create another view that can browse the secured area without login
Can anyone guide me how to do this ?
...OWA GAL #2
I've read in newsgroups that you can't see the GAL through OWA. Is this
correct? The only way that you can find an e-mail address is by doing a
search on the name ?
I'm using E2K3 SP1 on W2K3 SP1. PC is up to date with all Microsoft product
Correct. Unless your GAL is pretty small, there isn't a way to display the
entire GAL. When you perform the search, you can enter in one space as the
search query, and it will display I believe the first 100 names from the
GAL, so if your GAL is under 100 people, then it would display everyone, but
that is the...concatenate more column value #2
Any function can be simply below function , No VBA? Next time, I will
try add 26 column value.
(P2)&TRIM(Q2)&TRIM(R2)&TRIM(S2)&TRIM(T2)<> "", "Y","N")
Looks like you want to return "Y" if there is a value in any of your cells
range and return "N" if only blank values in all cells... if it is what you
need try this
=IF(COUNTBLANK(H2:T2)<>13,"Y","N") '13 number of cells.
...converting to access #2
The original spreadsheet was a price list which included
product code, price, and other info. I can convert all of
the columns except for the price column which is
called "List". I tried to solve the problem by copying
the "code" and "List" columns into a new spresdsheet and
change some of the settings for the "List" column
including changing the format to general number, wider
The code column will convert when tried alone. The List
column will not.
What am I doing wrong?
I suspect that "List" is a rese...Passwords
Hi, I have a password field in a database. How do I set it so that a
user can only type in 7 characters for a password. and if they type
more an error message will appear?
> Hi, I have a password field in a database. How do I set it so that a
> user can only type in 7 characters for a password. and if they type
> more an error message will appear?
You may use the ValidationRule and ValidationText of the field in the
table design view. Setting ValidationRule to Len([YourField])>7) will
raise an error in your case.
--> stefan <--
...problem with saving #2
I hope somebody can help with the following problem. This is th
I have a java application which basically writes data (integers an
strings) to an excel spreadsheet. The spreadsheet is doing th
necessary calculations and reads back the results to the jav
application. At least he is supposed to do so.
But (as you probably guessed) it doesn't. Although in windows explore
I can see he has changed the excel-file and when I open the file I ca
see the correct data he reads back older data. More precisely the dat
that has been saved when I manually open and close the...Import 2 profiles Question
I had to reinstall a new harddrive. I backed up my outlook.pst file to an
external harddrive prior to the installation. My outlook was set up with 2
profiles (Jane and John) so I get the prompt when I click on outlook to
determine what profile to logon as. How do I import the correct files to the
correct profile. Each time I try it I only get one. For example if I enter
as Jane I get Jane and if I enter as john I get Jane's stuff. I hope this
Change the Personal Folders file that John's profile uses. Check here:
Control Panel > Mail applet > Data files
&q...Keep user passwords
We've just finished installing a new Exchange server and connecting it to a
separate DC. We used to have everything on the same server but we'd like to
be able to scale our solution better in the future - therefore the new
setup. Users are primarily connecting to Exchange by means of RPC over HTTP
from clients that are not part of our AD.
The old setup allowed users to save passwords if they configured their
clients to use NTLM authentication and followed the directions in this
This worked both for RPC...Average If #2
Sorry for reposting this...
I need a formula to figure the average in one column if for a specific
person in another. There are about 2500 entries for each sheet. I need to
know the average with time for Smith, Samsone, etc. without having to sort by
ER MD WAIT TIME TO SEE PHYSICIAN
array entered ctrl + shift & enter
> Sorry for reposting this...
> I need ...How to retrive password protected worksheet but forgot password?
I password protected an Excel spreadsheet and now can't remember the
password. Is there any way that I can gain access to my worksheet?
There are tons of FREE good Excel password 'cracking' tools. Your favorite
search engine should get about a gazillion hits on a phrase like "crack excel
password" or "excel password cracker".
A good one that many report great success with can be found at:
> I password protected an Excel spreadsheet and now can't remember the
> p...GAL Replication #2
I need to replicate the GAL between 2 exchange
organizations. Does anyone know if this is possible? If it
is, does anyone know of any articles on it?
For Exchange news, links and tips, check:
"J. Miller" <email@example.com> wrote in message
> I need to replicate the GAL between 2 exchange
> organizations. Does anyone know if this is possible? If it
> ...Spreadsheet password protection
How do you password protect a spreadsheet. I can't find anything in the help
You can prevent un authorised access by giving a password to open the
workbook itself, so that no one else can open it (Go to Tools, Options and
then Security Tab). You can do it there if you have already saved the file,
or you can go to "save as" then "Tools" and "General Options" where you can
On the other hand you can protect work sheets and ranges for different
people by using "Tools" and then "Protection" Tab
M Imran Buha...Password
I am working with publisher 2007. I finished my site last Dec. and went to
It is not letting me make changes because it does not like my password. I
can not figure out how to go in a reset everything from my provider.
I was also trying to see if I could find web publishing wizard, which
doesn't seem to exsist with 2007.
If you are saying you forgot your password then contact the ISP Tech Support
and they will reset the password to something like 1 2 3 4 or something
other that is very simple. They will also instruct you to change it to
somethin...Outlook 2007 Locks Up #2
I have a SBS 2003 R1 Prem. server with 5 workstations attached to it.
Outlook 2007 is locking up on all workstations at least once a day. This
started shortly after the Feb. 12, 2008 updates. I have seen numerous posts
via Google on this subject.
Has anyone found a solution yet?
if its bad and you didnt find a solution within the first hour you should
stop losing time and call MS
"SMC" <firstname.lastname@example.org> wrote in message
>I have a SBS 2003 R1 Prem. server with 5 workstations attached to it.
>Outlo...Named Range #2
I've named few ranges through VBA by using this code
For i = 1 To 15
' Define the name for the variables
ActiveWorkbook.Names.Add Name:=Worksheets("ST> DATA").Cells(1, i),
"=OFFSET('ST> DATA'!R1C1,'ST> DATA'!R1C214," & (i - 1) &
which is working fine, but when i try to refer it in a chart, an error
msg is popping up saying "Your formula contains an invalid external
reference to a worksheet, Verify that the path, workbook, and range
For some reason, it will not store the password. I have
checked the box that says "remember password", but, each
time I try to log in. It will ask me for it. Any ideas.
I am thinking about recreating the profile for thismailbox.
I am a consultant, and my customer doesn't know how (or
won't write down what I tell them) to do this.
...Relay Error? #2
When sending to one particular domain, I receive the following error:
You do not have permission to send to this recipient. For assistance,
contact your system administrator.
<mailservername.com #5.7.1 smtp;501 5.7.1 This system is not configured to
relay mail from <sender> to <recipient> for I.P.Address>
I can telnet port 25 of this domain from my Exchange Server, and can
successfully send mail via commands (which eliminates blacklisting), so I'm
thinking that it's a configuration issue with my Exchange Server.
I checked to ensure that Realying wan't al...RMS 2.0 Bugs
There was a post about Matrix issues in RMS 2.0. Just wondering when (or if)
MS is going to fix this? Is anybody else experiencing any problems in RMS SO
I'm getting ready to switch our production system over. Any commentary or
suggestions would be appreciated
Good morning Alex,
Thank you for posting your question about 2.0.
Microsoft is planning on releasing hotfixes to resolve issues reported in
2.0; but I have no information as to when these will be coming out.
If you are experie...Change Password Next Login, Enforce Password Policy and Expiration
I'm curious why are the Change Password Next Login, Enforce Password Policy
and Enforce Password Expiration is diabled in Greatplains 8.0 when i create a
user. my client want to know how to enable it. hope for your prompt action.
Only works for SQL 2005. If you client wants to use a beta database server...
> I'm curious why are the Change Password Next Login, Enforce Password Policy
> and Enforce Password Expiration is diabled in Greatplains 8.0 when i create a
> user. my client want to know how to enab...Update Links #2
hi. each time i open my workbook, Excel informs me that the sheet
contains links to other sources, would i like to update. is there a
way to know as to which cells are linked to external sources?
When you have formula links in an Excel Workbook (destination) to another
Excel Workbook (source) you will be asked if you wish to update links in the
Workbook (destination) each time you open it. This can be painful when you
always want, or don't want, links updated.
It isn't hard to find links without a macro. Simply use Edit|Links and
you'll usually be able to see the first ...