We are having some difficulties determinig a strategy for lookup codes.
Specfically, we are trying to determine the best way to configure lookup
codes for scalability, ease of data entry, as well ease of use at cash out.
The customization for my POS system is a clothing boutique. We have
scattered inventory, different venders from season to season, and limited
stock for the items we do carry. I really wondering if its better to simply
make lookup codes numeric, and print them out on our price tags. Is there
some better strategy or approach to handling lookup codes?
This is a multi...List of Codes and Display Names for Codes #2
seems to be working thank you .... :)
hoganc's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=14980
View this thread: http://www.excelforum.com/showthread.php?threadid=266031
...where to find mfc datagrid samples/code for vc++ 2005
Does anyone know where I can find some datagrid samples and code for MS VC++
2005 using MFC and unmanaged code? I don't want older VC++ samples (ie 6.0
or .net 2003).
you should be able to add the functionality to your project after reading
Microsoft Most Valuable Professional in Visual C++
"arch" <firstname.lastname@example.org> д���ʼ�
> Does anyone know where I can find some datagrid samples and ...VBA code go to specific location in embedded document
From Excel I'm opening an embedded OLE object (Word document). Once
the document is open, I need to be able to go to a location in the
document (preferably by keyword search). Is this possible?
Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
If Target.Range.Address = "$A$4" Then
Set Obj = Sheets("report").OLEObjects("Object 1")
...PivotTable 2003 Code is not working
I have added code to show all items in my pivottable when a bitmap is
clicked. The code needs to first show all items in the pivottable and then
go back to the scorecard sheet. THe code to show all itmes does not work at
all. The hyperlink works fine. I am hoping this code will solve another
problem. On the scorecard, I have a button to click that filters the
pivottable for a specific page item and specific row item. If they go back
to the scorecard and choose another filter choice, it does not filter
properly. So I thought if each time they go back to the score...Worksheet_Calculate
I need to use comboboxes to update several pivot tables. What event should i
use to loop thru the changes to the comboboex and update the respective
fields of the different pivot tables?
I'm trying Worksheet calculate but it will keep going even though if i turn
the diableevents to false
Thanks in advance
Isn't diableevents a typo? Maybe you meant Application.EnableEvents
„LuisE” ezt írta:
> I need to use comboboxes to update several pivot tables. What event should i
> use to loop thru the changes to the comboboex and update ...Order form
I would like to crete an order form that once you add the code of the
product all the other information will appear eg Price, description,
colour and so on...
I have seen another programme that did it but cant' find any
information on how to do it..
Thanks in advance for your help :)
mich72's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=19280
View this thread: http://www.excelforum.com/showthread.php?threadid=468455
Look in the help for the Vlookup function
If...changing email mscrm
I've the changed the email adresses in the user profile and now i dont
get any mail - not in the crm and not even in outlook, ive added a new
user with the same email definitions and didnt add the user to the crm
and with this user i got mail.
what should i do.
I guess my simple question is how to change to users email adresses?
Make sure you have changed the mail address everywhere. In the Active
Directory, in CRM (if it is not updated).
After that, re-run the CRM Exchange Routing wizard for you user.
If it still doesn't work. Remove your user from CRM and add it as...How to activate a quote in code?
How should I activate a quote in code using the sdk?
Does anyone have a code sample?
Use the SetStateQuote request to activate a quote. Sample code exists in the
sdk for changing the state of account. Modify that to suit your pupose.
Hope this helps!
Innovative solutions for your SME ERP/CRM products
"Purple" <Purple@discussions.microsoft.com> wrote in message
> How should I activate a...Search Code Problem
I have a search that I would like to have run from three tables.
'strSQL = "SELECT tblHouses.RollNumber, tblHouses.PID,
tblHouses.FirstOfHouseAddress, tblAccounts.AccountNo, tblListNos.MainListNo1,
tblListNos.MStatus, tblListNos.ProjectID, tblHouses.Strata,
tblHouses.FirstOfHouseNumber, tblHouses.FirstOfRoadName, tblHouses.LotNo,
tblHouses.Telephone1, tblHouses.Telephone2, tblListNos.MPriority,
tblListNos.MaintenanceComments, tblListNos.MainIssuedDate " _
'& "FROM (tblHouses LEFT JOIN tblListNos ON tblHouses.R...Outlook changing 'g' to 'q' when replying
When I reply to a message from a user email@example.com Outlook
changes the 'g' to a 'q' so that the reply address is
firstname.lastname@example.org. Does anyone have any idea why this might be
Thanks for your advice
Shaun <email@example.com> wrote:
> When I reply to a message from a user firstname.lastname@example.org
> Outlook changes the 'g' to a 'q' so that the reply address is
> email@example.com. Does anyone have any idea why this
> might be happening?
Since it doesn't touch the Gs in "...code 80070020
when i update KB972145 i am getting:
installation status failed
error details: Code 80070020
i have tried disabling the "Real Time" thing and still gives me problems
i am able to update everything else but KB972145 has anyone had this
problem and was able to resolve it? Does anybody have any ideas on resolving
The update is meant to address the 2 scenarios shown here:
If neither of them exist on your system, suggest you just hide the
update instead of running around in circles.
If they do exist then please, *...i-Phone pix default to Publisher, how to change?
I must have chosen the 'do this every time' box. How do I get back to the
multiple option menu and eliminate Publisher as the default?
Change your file associations.
How to change file associations in Windows XP
How do I... Change file extension associations in Windows Vista?
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"
"WSuman" <WSuman@discussions.mic...Command Button disappears from worksheet
I copied an excel workbook that had command buttons on the worksheets to a
co-worker's computer. I transferred the file on a jump drive (also tried
emailing it using Novell Groupwise). When the co-worker opened the workbook,
the buttons momentarily displayed, them disappeared. Is there some option
that needs to be set in Excel for the buttons to show.
I created the buttons using the control box toolbar. Is there a difference
between that and the controls on the Forms toolbar?
...Change mailbox name and X.400 address replication
We are using Exchange 5.5 SP4 on NT 4 SP6A.
How does X.400 addresses work when mailbox name changes?.
When A mailbox is created for a user with name "Steve
Petersson" the mailbox X.400 address gets replicated to a
central place with other mailservers so every mailserver
sees this account.
If this person change the name to "Steve Fendersson" and
the mailbox X.400 Surname are changed to the Fendersson.
Will this X.400 adress be uppdated on the central server?.
Or do I have to delete the mailbox and create a new
mailbox with new name?.
&...Integrating Pay Codes
I'm trying to set up a data conversion for a payroll client. At this point
in my testing, when I try to integrate the pay codes, I will sometimes get an
error that the code needs a SUTA state. I am pulling the SUTA state from the
source file and in some cases it does work. Any ideas as to what it is
REALLY looking for?
Debbie from Wipfli
...How do I selectively import data from another Excel worksheet?
I have a long database, that contains complete leads data with many columns.
I have another, shorter database that contains no data except one common
field between the two. I want to fill-in the info from the large database
into the smaller database. I'd sure appreciate help!
Take a look at the vLookup worksheet function.
> I have a long database, that contains complete leads data with many columns.
> I have another, shorter database that contains no data except one common...Change mortgage / loan payment frequency?
I have money 2006, how do you change a loan (mortgage) payment frequancy from
monthly to bi-weekly?
Only way I have found is to have two monthly payments called something like
"mortgage pay #1" and "mortgage pay #2".
Microsoft MVP - Money
For UK tips & fixes see
I do not respond to any emails that I have not specifically asked for.
"Jeff G" <Jeff G@discussions.microsoft.com> wrote in message
>I have m...How to Auto UPC codes?
The company I work for purchased RMS about 6 months ago and nothing has been
setup. In fact, I think I'm the 1st person to actually use the system.
The company deals in retail furniture and our problem is that a majority of
our merchandise doesn't have a UPC code. I've entered about 1,000 items with
random codes, but it's taking too long.
Is there any way to get the system to automatically make a UPC code for new
merchandise? Kind of like how the account numbers will automatically use the
next number in line?
I can set this up for you. Contact me off...BP Project Timesheet Changes
Is there a way to modify the Cost Category of project time after it has been
submitted & approved in Business Portal?
Since it is approved it cannot be updated.I hope you have not posted the
Timesheet In Dynamics GP? If it is not posted you can open the Timesheet it
in GP and modify accordingly.
Lets wait for others input on this.
> Is there a way to modify the Cost Category of project time after it has been
> submitted & approved in Business Portal?
The timesheet is approved in BP & not posted in GP.
When I tried ...Sales Module and later Service Module on the same Database
If possible to install the sales licence ... use it... and later install the
other module using the same database??
When you install CRM you can add any license (sales,
service or suite), you can also remove or add licenses as
needed. You will be using the same databases regardless
of your license type.
Thanks - Annie
>If possible to install the sales licence ... use it...
and later install the
>other module using the same database??
That is true. But when you install the server... you use a licence that it's
different between Sales...Folder List
How do you change the font size in the folder list in outlook?
you don't unless you change it in Windows, which affects all programs.
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Author, Google and Other Search Engines (Visual QuickStart Guide)
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Join OneNote Tips mailing list: http://www.onenote-tips.net/
"jch" <JCH@nospam.com> wrote in message
news:Hgsjd.50653$...error code COOD10D9
I have this error code COOD10D9 cannot detect length of file, a few files
have no info on them anymore just song title, any suggestions? also when I
click these on to play they play fine
What's the file type (extension) of these files (MP3, WMA, WAV...)?
Tim De Baets
> I have this error code COOD10D9 cannot detect length of file, a few files
> have no info on them anymore just song title, any suggestions? also when I
> click these on to play they play fine
...DBA Job Transition / Change
After working for years as a DBA for my company I would like to transition to
another position within the corporation. The company has a large IT
department, however I'm not sure what I can transition to being a DBA. I'd
like to hear from other DBA's out there that have transitioned to other jobs
within or outside their company and if they successfully made the transition.
What did you transition to? What IT jobs would a DBA qualify?
Thank you very much in advance!!
Message posted via http://www.sqlmonster.com
...How change MS mailing list address? MS login fails to recognize old--or new--address
Without signing up for Microsoft's Passport, how do I get the company to
change my email address on its mailing list?
At the bottom of the email messages I get from MS, it has a link to
When I get there and attempt to login, it does not recognize my email
address/password combination. So I entered my old email address to which MS
is still sending its list mail and requested that my password be sent to me.
It does not recognize the address after I type in the several characters the
window displays. If I type in my new email address, the same thing happens