Formula for multiple conditions
The formula i have entered does not work for all conditions. Here is the
formula i have entered and works for 2 conditions but not all 4.
A12, R12, S12 contain dates and Column T is a status column. If no date is
in column A then i want column T to be blank. And if column S date is blank,
then i want column T to be white (on target for due date, column R), or
yellow (3 days before due date). If column S is >...Multiple Domain with Multiple Email Address
For all you Exchange Expert here my question.
I have 2 forest and they is currently a trust between both domains. My
question is can I have one Exchange 2003 Server on ABC.com and one Exchange
2003 Server on 123.com. At the same time I can share mailbox resource
between both domain. Meaning that if I want to host both domains on ABC.com
for both ABC.COM and 123.COM can it be done. I understand that I am limited
to 1 Storage group with the Standard Edition while the Enterpise Edition I
can host up to 20 different Storage groups. Would I be able to setup
accounts for either domains...Options Group and Query Criteria, revisited
I recently posted a question about option groups passing info to a
query for a Yes/No field, and received some great advice. However,
I've tried to apply that advice in a similar way to a Date field, to
no avail. In the query, I want the user to be able to display (1) only
records with dates present or (2) only records without dates present
or (3) all records.
I changed the query criterion that worked for the checkbox as follows,
and placed it under the Date field which I want to select by (this
statement yields no records):
IIF([forms].[fmQryByClinicSurveys].[emailOptions]=1...How can i insert multiple pictures in a word doc, simultaneously?
I need to put in multiple photos from a file in my reports, and i would like
them to be sized to fit 6-10 per page. Is there any way to do that in one
It depends on your definition of simple. In order to control the layout of
the images you need to insert them in a table of fixed cell width. The
images will then adapt to the width of the cell. How many will fit of a page
is determined by whether the images are portrait mode or landscape mode - or
The following macro will insert a two column table at the cursor and proceed
to en...multiple vendors or buying groups
I have a PO that may eventually be charged, by percentage to more that one
vendor. So, they are buying a product that is say 25% to one vendor and 75%
to the other. How can we do this? Any suggestions? Additional software?
VB? Please let me know.
Asyma Systems Inc.
...Multiple Table Query
OK, its been awhile since I've posted but this group is the best..
Here's my problem:
I am using data validation that is connected to the 2 categories below
Widows Benefits with Survivors
Each category will be connected to 2 tables for a total of 4 tables. I
have used VLOOKUP for a similar problem. I named the tables included
the names in the formula..everything worked great.. but with these
tables the return values are in more that 1 column.. Here's what I
Based on the age of the widow & year since death and the table will
return a value( I have the...Multiple Conditions
I am trying to populate a field on a form if certain conditions are met such
If checkbox1 is true then display x
If checkbox 2 is true then display y
If both are true then display z
If both are false then display w
Any help will be greatly appreciated!
Use Switch(), Choose() or nested IIf() expressions.
See the help in Access for details an examples.
If you actually have lots more checkboxes than the 2 in your example, you
might get better results by redesigning the table:
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for ...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") ...Running check with VBA on multiple fields before updating
I'm trying to run a check on two fields so I can ascertain if the third field
should be updated or if a new line should be added. I'm using the index and
seek method to try and handle this. The problem is that the first match it
comes across the field gets changed.
This is my code.
Dim db As Database
Dim rec As Recordset
Dim strSQL As String
strSQL = "tblpos"
Set db = CurrentDb()
Set rec = db.OpenRecordset(strSQL)
'Do Until rec.EOF
rec.Index = "emp"
rec.Seek "=", Me!Combo257
If rec.NoMatch = False Then
'Do Unti...Printing multiple copies
I have a workbook that keeps printing 7 copies. I've changed the amount in
the print dialog box to 1 and saved the workbook but when I open it again it
defaults to print 7 copies. How can I get it to only print 1.
Have you checked you printer peferences, advanced, paper output, quanity
> I have a workbook that keeps printing 7 copies. I've changed the amount in
> the print dialog box to 1 and saved the workbook but when I open it again it
> defaults to print 7 copies. How can I get it to only print 1.
...using MATCH for multiple matches
Is it possible to use the MATCH function to list all matches in a column
rather than just the first one, or is there another way of doing this?
Not sure what you want to extract, but the easiest way is to autofilter your
list: Data | Filter | Autofilter....
MS Excel MVP
"Mat" <buffaloesinc@DELETE2REPLYhotmail.com> wrote in message
> Is it possible to use the MATCH function to list all matches in a column
> rather than just the first one, or is there another way o...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...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...Generic Criteria
Is there a criteria I can enter in a query field that will return
records based on a selection from a combo box if it is made, or will
return all records if there is no selection made?
I was trying to keep it generic because it would apply to many queries
in my database. I am trying to create it in design view because I am
not very good with SQL. I can try SQL if that is easier, though.
Below is an example of one of my queries. I have 4 of these that
filter the information for 4 different fields. Trying to get it all
SELECT ExpensesMain.[Date of Expense...Pulling data from multiple workbooks
I have at any one time a set of approx 200 workbooks that contain data in the
I would like to quickly identify the worksheets that contain a date in
either / or both of two cells. Same cells in each workbook.
Does anyone know if this is possible and is so how you do it? Looking to
have either the workbook highlighted or a frontend spreadsheet that tells me
which workbook to look at. This could be either by providing the workbook
name or information contained within a third cell of the original workbooks.
Pulling my hair out, so all help appreciated.
Mike, in the workbooks...VLookup Function over Multiple Worksheets
I am trying to use the VLOOKUP function over multiple worksheets, can this be
done on Excel 2003?
I am trying to automatically retrieve data that is dependent on previously
entered fields in drop down lists that I have created.
A semi-exoctic formula from Peo S a few years ago, this looks up across
eight sheets. It is an array-entered formula... CTRL+SHIFT+ENTER
If you wnt to tackle this I will help you, I don't completely understand the
formula but I believe I can guide you through it to lookup over many
worksheets. (formula is all one one line in both cases...Multiple Lanes
I am planning on having 2 lanes in my store. I currently have a single lane
dongle but ordered another. Will this work for 2 lanes with each lane having
a single lane dongle?
Nope, only one dongle per database. You need to send your original in and get
a 2 lane dongle.
> I am planning on having 2 lanes in my store. I currently have a single lane
> dongle but ordered another. Will this work for 2 lanes with each lane having
> a single lane dongle?
Would I send them to Microsoft to exchange my two 1 lane dongles for a 2 l...Remove Multiple items from a Site
Is there a way to remove multiple items from a site all at once? I have been
using the Item Quantities Matenence window, but can only do one item at a
time. I have several hundred items to remove.
I've done it with a macro, but I agree it should be part of the
software...if you can add by ranges, why not delete?
-Go to Tools/Macro/Record
-give the macro a name
-record yourself deleting one (including pressing the next arrow at the
bottom, if they're in sequence)
-go to Tools/Macro/Stop Record
You can either then run it via Tools/Macro/Play (or Ctrl-F8)...How do I edit a worksheet and copy to multiple files?
I need to change a few cells in one worksheet and apply these changes to all
files in the folder. All workbooks have the same worksheets and formats.
...Query Criteria 02-22-10
I have a table "Trans" with fields [DT], [Acnt], [Amt]
I want a query to return records with dates in [DT] that are greater than or
equal to the date inserted in the [FilterForm]![FFrom] and less than or equal
to the date inserted in the [FilterForm]![FTo].
However, if [FilterForm]![FFrom] & [FilterForm]![FFrom] BOTH are NULL I want
ALL the records to be returned.
What would be the correct SQL syntax?
Thanx in advance & Best Regards,
IF DT ALWAYS has a value you can use the following.
WHERE Dt Between Nz(Forms![FilterForm]![FFrom],#1900-01-01#)...Multiple Values
My next problem is I need to extract only certain information from a
worksheet as sample-
Worksheet A Worksheet B
Column A Column A Column B
SP001 SP001 PL001
Worksheet B is my Bill of Material...Select multiple adjacent cells of multiple cells without selecting
Select multiple adjacent cells of multiple cells without selecting adjacent
cells one by one. those cells looks like;
|Column A1 |Column A2|
|random characters | A |
|sjsjsjsjskkskskskk | B |
|wtwuwuwuuusisis | A |
|wuuuuusiwuwuwiu| A |
|euuuuuuuuuuuuuuu| B |
I am trying to select A1 cells that's adjacent of A2 cells without selecting
cells one by one.
Thank you for your help.
I am trying to select A1 cells that's adjacent of "B" cells without selecting
A1 cells one by one
> I...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...Accessing multiple .pst files
I have a backup .pst file on an external hard drive from an Office 2003
My home computer is running Office 2007.
Can I access and operate on emails on the external hard drive (2003) using
my Outlook 2007 home computer without corrupting my normal home .pst file?
You can open the .pst file as an additional data file in both versions of
Outlook, but you can only use one Outlook version at a time with both .pst
Optionally, you can create a second mail profile and connect the other
unused .pst to that profile to keep the data separate.
Milly Stapl...Multiple e-mail accounts in outlook #3
I want to create at least two e-mail accounts in my outlook. My
problem is that I want two seperate inboxes. I know I can just use
filter. The problem with that is that it gets frustrating when e-mail
comes in from mailing lists and doesnt fit the filter. Any ideas are
"Ari Winokur" <email@example.com> wrote in message
> I want to create at least two e-mail accounts in my outlook. My
> problem is that I want two seperate inboxes. I know I can just use
> filter. The problem...