On my Access form have 2 fields. Code and Code Description. The code field
does a look up on a table and allows the user to select the code they want.
The table contains the code and code description fields only.
What I'd like to be able to do, is if a user selects code A1 (for example)
the code description field automatically populates with the code
description. How can I achieve this?
Is the control for the code field a combo box? If so, you can change the row
source to include the description in an additional column as long as you can
construct the query pr...Must buy new computer...Ideas?
Hello to all! Finally my over 10-1/2 year old Dell desktop's extreme
slowness has seriously gotten on my nerves and I'm now looking for a new
one. (Surprisingly, it's working pretty well otherwise...)
Maybe this isn't the right forum? But beside the usual things like RAM and
HD GBs, are there things I should be sure to have...or be careful NOT to
have on a desktop? After n ot looking into computers for over a decade I
feel like a Martian in the Earth. lol!
Also, is it possible to transfer to the new one ALL my stuff, including
programs, etc.? Do you thin...Dynamics CRM-Accounting Pro 2007
Why is there not a connector for CRM to Account Pro 2007? Especially since
there is one from CRM to business contact manager?! I thought microsofts big
plan was to integrate everything, yet these two softwares, which would seem
like a perfect fit to me, do not even talk to each other.
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 the suggestion in the Microsoft Web-based Ne...Default properties for new folders
How does one set the default properties applied when
creating new email folders? Currently, when I create a
new folder, it is created with the AutoPreview turned on
by default. I'd like to change that do that it is left
off by default. It's something of a pain to create a new
folder and then go in to customize it's properties.
You can do this by editing the Messages view; View-> Arrange By-> Current
View-> Define Views...
You might want to define a new view yourself and apply that view on first
use of that folder.
Robert Sparnaaij [MVP-Outlook]
www.howto-o...New Email Messages
I just installed Outlook 2007 on my new PC and for some reason the new
messages I received can only be received when I press the SEND/RECEIVE
BUTTON. My Outlook at work receives these new mail messages as they are
received. So how can I configure the system to make that happen?
The Trail Hiker!!
There are two settings within the accounts
1) Send on starting
2) Auto send/receive every xx minutes - set this for 10 minutes
"hiker0531" <firstname.lastname@example.org> wrote in message
>I just installed Outlook 2007 on my n...Microsoft Word and Excel (all products) will NOT open or run.
When trying to open a new document or a saved document in any of the Microsoft products it will not open and an error message comes up saying: <br>
"The application Word quit unexpectedly. Mac OS X and other applications are not affected." <br><br>When opening word it will open and then after a couple seconds close and not give a reason as to why.
The most likely causes are lack of updates (both OS X & Office) and need of
repairing disk permissions. Tend to those matters & see if the problem
persists after a restart of your Mac....Unable to open "New" window to write email.
I am using Microsoft Outlook in Office 2003. It has been working great until
When I click "New" to write a new email I get an error window :
The messaging interface has returned an unknown error. If the problem
persist, Restart Outlook.
I have tried this several times, even restarted the computer to no avail.
Anyone have a solution????
...Prevent new comments on old posts in sharepoint blogs
How do I stop comments on certain posts in a SharePoint blog?
I have removed permissions to the specific post to the lowest possible
access and people can STILL post a comment. If I uncheck one more item in the
list of permissions, the users can no longer see the post.
...A Short Video on Adding/Editing New Customers
If capturing customers at the POS is important to you, take a couple of
minutes and watch this video. This application also allows for edit of
Global customer information in HQ installations.
Contact us for detailed info and demo.
It would be nice if you could encode the videos with a more common codec,
and not in wmv format. This requires the GTM3 codec (GoToMeeting). Windows
Media Player 11 doesn't automatically download the codec, and I'm not going
through the trouble to download and in...New Location/New setup
Currently I'm downsizing our office, and moving to a new location. I'm
running MS Server2003 as well as Exchange 2003. Once moved, I will no longer
require the server (since I am setting up a home office).
Are there currently any steps or procedures available to correctly shutdown
one office...and basically setup a home office with no exchange server.
Also I will be removing the current pc's from the Domain, and setting up a
few in a workgroup.
I would like to receive emails from the other employees for time being until
I completely cancel this email account. I already have a...Looking for Microsoft Office Binary File Format or File Signature data
I have an application which obtains numerous "unidentifiable" files
with no file extension, via FTP, and would like to run some sort of
binary filter on it to identify PPT, DOC, XLS file formats.
I did fine this: http://www.garykessler.net/library/file_sigs.html
But it seems a messy way of accomplishing this, and is incomplete. Any
clues as to finding the binary record format and/or file signatures of
Office documents (Office 2000 and greater).
...Microsoft Outlook NightMare
Here is the error message I keep getting while I am at home using my la
top: microsoft error message 0x8000ccc0e.
When I go to my corporate office to work I can send/receive mai
without a problem. No error message at all. What gives?
I am secured my network - tried the MS Outlook Support site - use
there suggestions and nothing works. Please Help!
A very sad Bookkeeper...
Bookkeeper's Profile: http://www.officehelp.in/member.php?userid=504
View this thread: http://www.officehelp.in/showthread....How do I activate the new mail button
When I start Outlook, the "New", "forward", "reply" and "reply to all"
buttons are not active which means I can not send mail. I have no problems
receiving mail. Also, on web pages with email links, when I click on them,
the Outlook application is not launched which is almost certainly related to
this. I think I'm missing something very simple here!
Are you in a mail enabled folder? Do you have an active email account
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert...changing the SQL query on CRdc / CMSFlexGrid...example anywhere?
I have an application that connects to my remote database.
I want to use the same window with CMSFlexGrid class to display
the resukts from a query.
Unfortunately, with my current setup the flex grid only displays
the query results from the pre-runtime SQL property setting.
Changing the SQL property in the connected CRdc
and refreshing both remote data and CMSFlexGrid doesn't
update to the new query.
//change to the new SQL query
((CRdc *)GetDlgItem(IDC_REMOTEDATACTL1))->SetSql("SELECT * FROM data");
((CRdc *)GetDlgItem(I...Style available all sheets new or old
I need a custom style that is available in all
spreadsheets, new or old. I can set style and save it in
book.xlt in xlstart, but that only works for new
workbooks, and doesn't work with old spreadsheets when I
call them up. I want to be able to select a group of
cells, or column or row and apply a setting for negative
numbers to have brackets. I am using Excel 2000.
I even tried saving the style in personal.xls, but that
doesn't work as it is hidden.
Do I have to use a macro? And if so what would it be?
Public Sub MergeStyles()
ActiveWorkbook....Sub Form Assigning New Values to Old Records
I am using a subform within a form to have users update certain fields in the
record where the rest remiain locked. On the Main form when the list box
(which is bound to a query) is used to select the record set to display in
the subform it sometimes takes an old record and assigns a new value to the
record. For example it changes the Period field from 9 to 10. Taking a
record created in period 9 and assigning a period ten to it which is the
selection I make in the list box. Addtionally, it looks like it is taking
the first record in the related table to assign this new value to. ...Re: Re: Product key needed for Microsoft Office v.X
Operating System: Mac OS X 10.5 (Leopard)
I do not have the product key and the v.X CD I have is a copied version not the original. As far as I can tell by checking all the files, everything was copied over to my new mac. If no one can supply me with a product key I will have to purchase another version.
> I do not have the product key and the v.X CD I have is a copied version not the original. As far as I can tell by checking all the files, everything was copied over to my new mac. If no one can supply me with a product key I will have to purchase another ve...Word 2003 Forms (JUMP TO Fields)
I am creating a word 2003 form and was wondering if it is possible to skip
fields depending on the selection in a drop down menu.
ie. QUESTION: Is there a requirement for a COSHH Assessment ? DROP DOWN
If yes just go to the next field box if NO then Jump this section to another
section/Field further down the form?
It is possible, but only with a macro.
The basic idea of changing which form field is "next" is discussed at
http://www.word.mvps.org/FAQs/TblsFldsFms/SetTabOrder.htm. The macros
in that article can b...Which table will refresh by adding new Account / Contact
I am new to CRM and trying to update CRM Accounts and Contacts from our
Sales Management system. I am using Micorosft Bulk Import utility. I am in
preparation of CVS files but not sure what columns do I need in CVS file to
complete one Account/Contact record. Could anybody please help. I am .NET
expert developer, please let me guide If I could develop CRM by using .NET
Microsoft do provide CRM SDK for CRM enhancment using .net. You can download
from following url
http://www.microsoft.com/downloads/details.aspx?familyid=9C178B68-3A06-4898-BC83-BD14B74308C5...Adding new pages
Any thing I do on new pages happens simultaneously on any previous page. Can someone help me please?
Can you be more specific? What stencils are you using and what are you
John... Visio MVP
Need stencils or ideas? http://www.mvps.org/visio/3rdparty.htm
Need VBA examples? http://www.mvps.org/visio/VBA.htm
Common Visio Questions http://www.mvps.org/visio/common_questions.htm
"Joanie" <email@example.com> wrote in message
> Any thing I do on new pages happens simultaneously on any previ...About the microsoft fix for INSufficient Buffer for print
microsoft specified something to fix the print error. I couldn't find what
they try to say. they specified one file. If change that file in our system
is it resolves my problem. They specify the file version and size. but i
couldn't find any file similar to net. where can i found that. they
specified the file
Date Time Version Size File name
10-Jun-2003 15:54 5.0.2195.6753 1,757,712 Win32k.sys
Can any one send this fil...Front End Services Question
I was going through one of my books and came across advise that Exchange
Management, MTA Stack, and Routing Engine should be set to disabled on then
front end server. I had never heard of this. Has anyone else?
"FredT2" <Fredt2@mail.com> wrote in message
>I was going through one of m...Automaticaly put in the / in a date field
I want my users to input a date in the format dd/mm/yy
I know some of them will mis out the separators and enter for example
140301 for the 14th March 2001, but Excel changes the date to something
How can I create a mask (like in Access) so the separators are already
displayed in the cell? For example the cell would look like / / and
when the date is input it automatically jumps over the separator.
You could use a worksheet event that changes the entry to a date. Chip Pearson
has some code at:
> ...New trend, new business, new year a new beginning
New trend, at start of new year.
"If you want things to work different, you must try a different...whatever..." Does that seem obvious?
Brighten up with this "reading" and attack the money issue with
I am finishing my year 2005 with some regrets and some joy.
For some the year passed has not been "tip top" in their view.
But I believe it has just been very well as the page I shall bring you
that has this statement which I believe wholeheartedly:
"THINGS ARE UNFOLDING AS IT SHOULD" (paraphrased) I invite you to read the whole "poem&quo...New messages comes up in Deleted folder
Sometimes when I receive new messages the go to the
Deleted folder instead of the Inbox. The messages are
from random people...not just one sender. What is the
Check your message rules/filters. "key word" in new mail
subject line of body is probably being tagged and
filtered to deleted items folder.
>Sometimes when I receive new messages the go to the
>Deleted folder instead of the Inbox. The messages are
>from random people...not just one sender. What is the