need an error msge when I attempt to enter a duplicate value in a
I am entering unique serial no. in col A. Can I set up a rule which will not
allow a duplicate serial no. entry into another cell?
In article <FFEF019B-E20C-4177-856A-8D8BD0F0698F@microsoft.com>,
"pg23673" <firstname.lastname@example.org> wrote:
> I am entering unique serial no. in col A. Can I set up a rule which will not
> allow a duplicate serial no. entry into another cell?
Check out the validation in the Data section.
select the area of interest (A:A)
<data><validation><Settings><C...Assigning New Value to Old Record
I am using a form and sub form to pull certain records from a table for
updating. Sometimes access will assign a new value to an old record based on
the selection criteria. For example assigning period ten to a record that
was created in period nine. All of the fileds in the form and sub fomr are
locked and protected from deleting or adding a new record . Only two fileds
are left unlocked for editing. Does anyone know why access is assigning a a
new value this way.
...Look up last value in field
I have a form to create new outlet codes. This form has a field called Store
Type, which is set to get values off a combo list. Based on the value the
user selects, a field called Store Code should be Sxxx, Gxxx, Txxx or Wxxx
where xxx is the last code + 1. Is there a way to look up what the last code
was in this table for each Store Type?
Thanking you in advance,
Several ways --
Max in a subquery
Max in a seperate query joined
Build a little, test a little.
> Hi there,
> I have a form to create new...dlookup with loop
In my fSplashForm I have a button called btnCloseApprove.
I only want it visible if ContactUserID =48 and ContactStatus =Active. How
do I add ContactStatus to the below code.
One more issue...
When the Dlookup finds the first ContactUserID it stops looking. There may
be more than one instance of the ContactUserID. How do I make it check the
whole table for
ContactUserID =48 even though it may find a ContactUserID =45 or 43
If DLookup("[ContactSubID]", "[t14Contacts]", "[ContactUserID] = '" &
Environ("username") ...changing default font size
How can i change the default font size in C++? when i use the TextOut function in MFC, the font size and colour is already a default. How can i change that?
Creat a CFont object and use the CreateFont method to create the desired font. Then use CDC::SelectObject to select the CFont object and you're done.
I'm trying to make Outlook my default mail client.
In tools, options, other, the box to check to make
Outlook the default client doesn't exist.
How do I get that box to appear and put it in play ?
It's actually easier to do this: Open Internet Explorer. Go to Tools,
Internet Options, Programs tab. Use the drop down there to set the default
mail client to Outlook.
Author, Special Edition Using Microsoft Outlook 2003
***Please post all replies to the newsgroups***
"Dan" <email@example.com...Combo box
Im an excel 2007 user and am having problems populating a combo box.
The code below runs a loop for every single row on the worksheets and adds
values from column G (Diagnosis) into the combo box where it is a text
However there are duplicates, i wish the combo box to contain UNIQUE values
Now I dont want to go off on a tangent, but I did think about using custom
views and an advanced filter to select unique values and then ALSO use goto
Special and apply the condition to look for text values ONLY (i.e. removing
the rows with BLANK values).
However the custom view...Change Default value for Date and Time Value
Is it possible to st a default value for date and time field?
For example: Task Due Time is always set to be 12.00am, we would like to
change it to 800am or 9.00am, etc.
I've looked at the attribute itself and system settings from organization,
but i couldn't locate anything there?
Is this possible in CRM
...why does my sheet not save external link values?
When I open a sheet that cointais external link values,
I see a lot of '#REF? errors. So, I need to open
the referenced files as well. This is not the default
behaviour, because Execel normaly saves a copy of the
"last seen" external values
How can I get the sheet to save external link values
> When I open a sheet that cointais external link values,
> I see a lot of '#REF? errors. So, I need to open
> the referenced files as well. This is not the default
> behaviour, because Execel normaly saves a copy of the
> "last seen" e...DLookup not working
My code is
If DLookup("Mechanic", "PartSuffixTbl", "Mechanic = " &
CLng(MechanicList.Column(0)) & "") = MechanicList.Value Then
MechanicBox.Value = ""
MessageBox = "This Mechanic cannot be modified because"
MessageBox2 = "there are Wheels assigned to it"
This is to look in the Mechanic column of PartSuffixTbl and if the
MechanicList.Value is found, the following code takes place. I have and else
also but the problem is...Changing Default form Outlook Express6 to Office 2007 Outlook
I can not seem to figure out how get rid of Outlook Express 6 no matter what
I do. When ever I try to reply or anything except using New Mail the old
Outlook Express 6 starts up instead of the using my office 2007 outlook
program. I even went into the Control Panel to uninstall it but it dose not
show up in the program list. I tried to rename the folder Oulook Express but
the computer would not let me (it said the program was in use???). I renamed
msimn.exe to oldmsimn.exe and it made no difference. I'm sure that there must
be an easy way to do it but I do not seem to be able to fig...dlookup with 3 criteria
Here is my expression:
=IIf(DLookUp("[cmps 28d]","[Laxatives]","[Client ID]=""" & [Client ID] & """
And [Ass #]=" & [Ass #] & " And [Assessment date]=" & [Assessment date])=True,
DLookUp("[28d d/w]","[Laxatives]","[Client ID]=""" & [Client ID] & """ And
[Ass #]=" & [Ass #] & " And [Assessment date]=" & [Assessment date]),0)
Client ID is text
Ass # (shor for assessment number) is number
Assessment date is date
My d...Changing font colors based on a field value
I am programming in Access 2007 but it has to be compatible with Access
2003. I have a master report that has a field called txtTribe. There are two
subreports on this report as well (and two lines, and a memo field). The
report is grouped on txtTribe.
I have the following code in the Report_Load and Report_Page events:
txtFamilyName.ForeColor = RGB(0, 0, 0)
txtTribe.ForeColor = RGB(0, 0, 0)
If txtTribe = "AAA" Then
txtFamilyName.ForeColor = RGB(0, 0, 175)
txtTribe.ForeColor = RGB(0, 0, 175)
If txtTribe = "BBB" Then
txtFamilyName.Fore...Identifying the top five values in multiple groups
I've got a spreadsheet of pay information for about eight hundred people.
Each person is on one of eight salary scales
I'd like to create a new worksheet that shows the details of just the 5
highest paid people in each scale (name, dept, salary, etc.) - and also the
five lowest. Ideally, I'd like also to be able to vary that number - eg the
top ten, the highest, etc..
Can someone help?
Suppose you have data in Sheet1 in the below format
Col A Col B Col C
Name Scale Salary
a1 1 101
a2 1 102
a3 1 103
a4 2 104
In Sheet2 cel...How to change format protection default to unlocked?
Apparently, by default, all cells in a worksheet are locked (Format > Cells
> Protection). Consequently, when I set worksheet protection (Tools >
Protection > Protect Sheet > Password), all cells are protected.
I want to protect just 4 cells. So I think I want the default for all cells
to be unlocked. Then I would lock the 4 cells and set worksheet protection.
Of course, I could manually select every cell in the worksheet (A1:IV65536)
and change the Protection format to unlock. But besides being a "pain", it
appears to increase the worksheet size &...default my attachments to MS Word
I cleaned up my computer and somehow my Word Document attachments via my
received emails has changed to a text document (doc.) Where can I go to
change the default back to MS Word when I receive email attachment documents.
File Associations, see your version of Win Help
"Legal Admin" <Legal Admin@discussions.microsoft.com> wrote in message
>I cleaned up my computer and somehow my Word Document attachments via my
> received emails has changed to a text document (doc.) Where can I go to
> change the...Choose best values in a list
How can I select the top x number of values in a range of numerical data? For
example a row contains 2,5,10,4,20,10 and I want to know the 4 highest values
(20, 10, 10 and 5 in this example).
Alternatively, is it possible to sort letters in one cell in alphabetical
order? Eg cell contains EBACDABE to be sorted as AABBCDEE...
--If you have the numbers 2,5,10,4,20,10 in cell A1:F1 try the below formula
and copy down to 4 cells to return the best values...
--You will need to write a user defined function to sort individual
characters of that cell...
...DLookup and 0
I am using DLookup on a report. If the value of DLookup is 0, how can I
display 0 on the report? Can I combine DLookup with Iif? If so, what would be
Do you m,ean Null instead of 0? If DLookUp returns a zero, you should be
able to display it just fine. If DLookUp returns Null, you will need to use
the Nz function to replace the Null with something else:
"Danu" <Danu@discussions.microsoft.com> wrote in message
>I am usi...Default Printer in GP changes in Terminal Services
We are running GP10 on a Terminal Server. Daily, as we log into GP10, we
have to check/change the Printer in Print Setup to make sure it's the right
default printer that matches the users Default Printer in their RDP session.
The default printer in RDP doesn't change; only in GP10.
We have four locations in four states and use named printers for the pick
tick & pack list to print to the right SITE ID per the order. But we want
the order page to print out at each users default printer (the user who
entered the order).
Is there a way around this without having to set...Average value only for the filtered area..
I have data in the range of cells A2:E1000. The row 1 has the headers to
which i had given filters.
The column E has a numeric value for which an average value is required at
G1 for only those cells in column E which reflect by a filter in column C.
For example, after selecting a particular name using the filter in column C,
it resulted in 10 numerical values, the formula should calculate average
value of only those 10 values and reflect in G1.
Try this in G1
When competing hypotheses are otherwise eq...Find Last Yaer's Value
I have a query having two columns.
Now I want to add one more column:
Date Sales Sales(Before 364 days)
01/01/07 xxx yyy
03/02/07 xxx yyy
How can I do this?
Perhaps by using a subquery
SELECT T.Date, T.Sales,
FROM TheTable as T2
WHERE T2.Date Between DateAdd("d",-364,T.Date) and T.Date) as OldSales
FROM TheTable as T
Or by using the DSUM function
Field: DSum("Sales","TheTableName","Date between #" &
DateAdd("d",-364,TheTableName.Dat...Default Wanted -- Plain Text
I'm using Outlook 2000. It currently displays emails as HTML when the
sender has used HTML. I subscribe to several listserves. I want to
stop receiving HTML mail frm the lists. I want to receive plain text
only. How do I do that?
Change your message reading format to plain text. You will not read any email
in html. On the Tools menu, click Options, and then click Preferences.
Click E-mail Options, and then select the Read all standard mail in plain
text check box. If you just want to change only the lists format, contact the
lists and request ...can't change default file location #2
When I click "open file", Excel always open "C:\Program
Files\Common Files\Microsoft Shared\PROOF". I have
changed the "Tools-Options-General-Default file location"
to "My Documents" but still no effect. Please help.
Did you exit Excel before trying again?
>When I click "open file", Excel always open "C:\Program
>Files\Common Files\Microsoft Shared\PROOF". I have
>changed the "Tools-Options-General-Default file location"
>to "My Documents" but still no effect. ...cant change default font
I cannot get my default font on composed messages to
change, does not matter which one I select under tools
menu always reverts back to "verdana". set to HTML, not in
plain text format.... and cannot change font under
format/font after message is composed (but not yet sent).
You don't say what version of Outlook you are using? Are you using
Have you selected "Always use my fonts" in the Tools > Options > Fonts menu?
If you are using Stationery, perhaps it's reverting back to the Stationery
Just a thought
"LB" <an...Multiple DLookUp Query
Sorry - I've had to enter this again as for some reason I can't view my
original post NOR the response (even using the hyperlink)
I am trying to 'display only' the key contacts on a tabcontrolpage by using
the code below. This works though there are some instances where there is
more than one key contact for an organisation.
Can I change this expression to display multiple contacts or is there a way
I can have another filed that extracts the 2nd contact or 3rd contact etc.?
=DLookUp("OrgContact","ContactsOrg","ContactID = " & [ContactID...