updating field based on the value of another
I could (maybe) figure this one out myself, but at best it would take hours
(for me); could I simple ask for a little assist on this:
I have several tables:
tblJob, with fields: txtItem
tblJobItemInstallNotes, with fields: txtItem, txtJobInstallNote (each
item in tblJob may have several notes)
tblItemCatalog, with fields: txtItem
tblItemCatalogInstallNotes, with fields: txtItem,
txtItemInstallNoteTitle (each catalog item in may have several notes,
referenced by their title)
tblInstallNotes, with fields: txtItemInstallNoteTitle,
- the relatio...Exchange 2K7 and ACL on GALs
I'm looking for a convenient way t set ACL on address list and GAL, seems
that we can't do it via the GUI and didn't found the parameters to do it via
So I'm left with ADSIEDIT but wonder if there isn't a better way.
Thanks for your help
...When selecting the receipient for an email from the account form all CRM contacts are displayed
Question: i'm within the account screen and select to send an email to
this account. By default, the account (and the default contact) is
entered in the receipient field. In this case, the customer wants to
select a different contact (from this account) for this email. When I
select the option to select the receipient, and choose to selection
option 'contacts' the complete list with all contacts of my CRM
database is displayed in the selection box! Sounds like an bug..i
would only like to see the contacts of this account!
Is there a simple solution for this bug?
Thanks, Sjourd (s...Displaying multi-select parameter on report?
I have a report where I use a multi-select parameter to filter the report by
the user's initials who entered the record. I typically like to print the
paramters selected for a report in the header of the report. However, when
I put this parameter.value on the report I only get the first option
selected. How can I list all the selected entries?
SQL Server 2005.
Thanks in advance,
To take care of this you can use the Join Function to deplay a
delimited list. Here is an example:
The sec...Unable to display the folder error.
I get the following message when using Outlook. If I
close Outlook then reopen it, it will work until I switch
icons (calendar to contacts).
"Unable to display the folder. Microsoft Outlook could not
access the specified folder location. An error occurred
that prevented the file M:\Outlook\cij.pst from being
saved. Close and then restart all mail-enabled
Can anyone help me with this problem?
...Images Not displayed
I am creating a sample application which scans all images in a system
and populates it in the CListCtrl with ThumbNail View
when the number of images moves beyond some 3,000 ( i dont know exact
figure when it happens i noticed at 3800 no of images) and i scroll to
look into the thumbNail view in the CListCtrl the images are not
can anyone help me in this issue
What do it mean "Images are not displayed properly"?
But seeing the number of times that you have, have you thought about using
the list control as a virtual list?
http://www.codeproject.com/l...enter value based on drop down list of another field?
I have an excel 2003 spreadsheet with 3 worksheets. In sheet 1, I created a
drop down list in column A based on values in sheet 3, column A (item
number). Thisd data comes from sheet 3, where I have column A (Item #'s),
column B (Item desc)an Column C (price)
In column B of sheet 1, I have Item Descriptions and in column C I have
price. I want this to automatically fill in based on what I enter in the
column A sheet 1 and it should get the corresponding values from sheet 3
column B and C. I can make the drop down list in sheet 1 column B and C, but
some of the descriptions need ...GAL not updating
I am running Exchange 2003 (small business server) with Exchange SP1. I
deleted some accounts from Active Directory and created some new ones with
Exchange mailboxes. None of the changes that I made show up in the GAL. The
new boxes seem to work fine but I can not open them through my Outlook (I am
Admin), it tells me that a mailbox of that name cannot be found. I tried
manually adding them to the Offline Address List (since I am using Outlook
2003 in cache mode) but it does not find them there either. There are no
errors in the Event Log to give me a clue. I have trie...Ho to make one field required based on critera of another field?
I'm creating a form and need to make the "comments" field required if the
"code" field is =>20. I appreciate suggestions! Deadline Monster is lurking!
User enters the job processing endcode value (numeric) into the "code"
field. If the endcode is =>20, comments are required.
(P.S. I don't know VB)
You would put your validation code in the Form's BeforeUpdate event.
If Me.EndCode >19 Then
If Len(Me.Comments & "") = 0 Then
MsgBox "Comments are required"
Cancel = True
...Temp Table Fields
is there any information on temp table fields that are used in reports. I
want to create a report in crystal reports and I'm trying to match a value
from "detail Tax report". I come close to the value from what I think it
should be but "close" isn't what I want. Information on how the temp table
fields are arrived at is what I am looking for. Even if someone knows the
procedure name that creates the temp table "taxHistoryPrintTable" would be
I really like the table reference that is on this site - granted you have to
sign up and ...Removing Organizer field from Appointment... DON'T!
Figured I'd share a "gotcha..." I'd been struggling to understand why my
user's Appointments suddenly stopped sync'ing between CRM and Outlook when
they were created in CRM. A few weeks ago in one of my business reviews we
were simplifying forms and was requested to remove the "Organizer" field. (I
should have just placed it on a hidden tab) Immediately after this my users
started noticing that if they created an Appointment in CRM that it was no
longer also showing on their mobile phones and Outlook Calendar. As soon as
I realize the logic behin...Pivot Tables
I have a new computer and previously I was able to use
Pivot tables as a shortcut to highlight a list of say 500
items and display the unique items in a pivot table.
However when I try to do that now it doesn't display the
items, it only show the dropdown with the unique items
checked or unchecked and therefore I cannot highlight the
unique items to create my unique items list. Does anyone
know if there is an option that is preventing me from
doing this or any other way to create a unique items list
from a larger list. Thank you very much.
If you create a pivot table with a fi...Excel to SQL ODBC link: not working when new field added
I use Excel 2007, and have some Excel files with ODBC link to tables
on a Microsoft SQL Server (2005 version).
If I change the number of records in the tables in sql and then
refresh the ODBC link, everything works fine.
However, if I add a field in SQL and then refresh in Excel, the new
field won't show up. Do you have any idea why, and how I could fix it?
Assuming that your external data is linked using MS Query, you'll need to
edit the query to add any new fields added in SQL. A select statement in MS
Query such as "Select * from table" still won...GAL
When entering a new entry in the "Journal" and selecting contacts, I
am only able to see my personal contacts. Is there a way to make the
Global Address List and option without having to copy it to my
...GAL not showing up.
I have ONE machine on my network of 130 or so that won't pull down the GAL.
It also won't show up anywhere like the Address Book properties etc... The
following is the error that we get:
10:36:58 Synchronizer Version 11.0.8000
10:36:58 Synchronizing Mailbox 'Suzanne Beals'
10:36:58 Synchronizing Hierarchy
10:36:58 Synchronizing local changes in folder 'Inbox'
10:36:58 Uploading to server 'hermes.Company.corp'
10:36:58 1 item(s) changed read-state in online folder
10:36:58 Downloading from server 'hermes.Company.corp'
10:36:...how adding the "category" field to the standard mail item ?
I have a fairly simple question, but I have already asked an exchang
specialist without any luck ... .
I want to add 2 fields to the standard mail form : a category field an
a duration field. When I click on the "new mail" button, I want t
assign every mail to a category, and I want to register the duration o
the writing of the mail. I want to use this to report on the duratio
of my activities. Some kind of time management ... .
This seems (!) very simple but I am not able to change the standar
mail form. Someone created a special form for me, with the desire
fields but this was ver...GAL? What GAL?
In the beginning, there was an user who opened his Outlook, tried to log on
to the new Exchange 2003 server, and was promptly rejected with a message
saying that his name couldn't be found in the users list.
The company called an external conslutant (me), and this is what, after lots
of struggling, I was able to understand (if it makes any sense at all).
The company was implementing a Windows 2003 domain, with its DCs/DNSs and
the clients using them.
The company's ISP sold them a firewall which, even if fully opened,
interacted really badly with Microsoft's DNS service: the...copy original sender's address into reply field OUTLOOK 2000
I get email messages forwarded to me from an information desk.
I have to reply to the original sender of the message.
Is there a way to scan the message and find the original sender's email
address and put that in the Reply: field (replacing the information desk)?
DavidOUTLOOK 2000WINDOWS 2000
how is it sent to you? As an attachment or inline? If an attachment, hit
reply to the attachment. If inline, look for the header fields in the
message unless the forwarder removed them (or doesn't use outlook).
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in...Validating a date field
I need Excel to validate that an entry in a date field is correct.
Specifically, if someone includes the day of the week in an entry
(e.g., Wed 02/16/05) I need Excel to display "You entered an incorrect
date format. Enter the date as mm/dd/yy and do not include the day of
Can anyone tell me how to do that?
kenelder's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=20020
View this thread: http://www.excelforum.com/showthread.php?t...Avoiding Updates After Displaying Menus
I have an MDI app whose MDI child windows are graphics windows that display
images. These images can be fairly complex, and redrawing them may take time.
More to the point, there are occasionally ephemeral message 'boxes' that I
display within these images that aren't drawn as part of the main imaging
code, and go away when the image is next refreshed.
Okay, so, I click on a menu item in the menu bar and the menu comes down and
I select something. I now get a WM_PAINT event in my window, causing a
redraw. This has two unfortunate effects: one is to slow things down while I
...GAL is blank
The GAL is blank for users. User running in cached mode do have a list
(probably an old list when things were working). We upgraded the Exchange
2000 STD server to Exchange 2003 STD SP2, but the problem still exists. In
Exchange manager we can preview the lists. The server has been rebooted and
the address lists are still blank for clients (using Outlook 2003 in non
cached mode). I tried running the Exchange best practise analyzer, but it
showed no errors. Any help would be great.
Have you checked permissions? Given that you can see the results in ESM
permissions seems like ...Inquiring on Extender fields
I have an extender window that's attached to the Payables Trx Entry screen.
All it is is a checkbox and my question is, once the transaction is posted
and the record moved from the PM Work table to the PM Open table, can you
still lookup that field? We need to be able to for reporting purposes.
Please shed some light... Thanks!!
You can go through the following post on the Extender Inquiries - Payables
anyone know if you can put in a formula to automatically
populate a field. I created the attributes in deployment
manager.. added the fields. but the third field I want
to be a product of the two? E.g. total or margin! Thanks
for any help.
As far as I am aware there is no support for calculated fields.
It would be possible to trigger an OnChange event, but in order to do so,
you would need to link it to a picklist (combo box) on the form. This could
then perform a calculation and assign it to the field that you want.
Pretty ordinary solution, I know... but you work with wha...Creating some another fields like notes
I would like to create some new entities on the model of the notes (a great
field in which my users can insert a lot of information). In my example, I
need for my prospector :
* A note concerning the call.
* A note concerning the project detected.
All of these notes have an historic and a 1-n relation with my account.
Moreother, the field CallNote and ProjectNote have to appear in the account
Thanks in advance.
How do you display the autonumber field in a new record in a form as aposed
to it displaying (new) and saving the autonumber in the datasheet without
having to click previous record then next record? Thanks
If you are displaying an Autonumber field, you have already made a mistake.
Autonumber fields should be used ONLY for primary keys of tables. They
should have no meaning to your data or application. A user should never see
an autonumber and they cannot be editied.
Dave Hargis, Microsoft Access MVP
> How do you display the autonumber field in a new ...