cmbo box on subform fills fields on form when chkbx is yes
I have a multi-tabbed form that details bid data ranging from pricing to
contact info to departmental notes. Page two has a subform listing general
contractors to whom we bid. One bid may have 10-15 contractors listed. When a
purchase order is issued from one of these contractors I select a checkbox
indicating that GC. I would like the opening page on this tabbed form to show
the address and contact info for that GC when the checkbox is yes. Is this
Message posted via AccessMonster.com
On Mar 17, 3:04=A0p...No content in message field anymore
For the last two days when I open my email client I see no content in the
message field. Each email is blank with an attachment paperclip in the upper
right hand corner. When I click the paperclip I have the choice of a txt file
(which will not open up) or an htm file which will open. This is driving me
crazy and I don't want to get rid of windows mail...any suggestions on how to
Which antivirus are you running? Some of them cause problems with
Windows Mail over time.
Try running the various repair functions in the WMUtil program:
http://www.oehelp.com/...Calculated Field in form to table
Can you take a calculated field from a form and pull it in to a table??
...Changing color of a range of cells dending up on a value in anothr
I need to change the color of a range of cell, depending up on the value in
another cell. I am using Excel 2003. And it allows me to give only 3
conditions when using conditional format. But I have 7 differnt conditions.
Thanks in advance for any help.
Unless you move to XL2007, you will need to use VBA. Here are some sites
that will help
Alternatively, there is an add-in here
"Srajes&qu...Automatically filling in "full name" field
I would like to add the "fullname" field to the Contact form. Is there
someway to make this field automatically fill in with the information from
"firstname" + "middlename" + "lastname" + "suffix"?
If this can be automatically filled in, could the field later be manually
You will find that if you add the fullname field to the form, it will be
greyed out, you can't type into it. It will be populated after you create a
new contact and enter the first and last names and save the contact. And it
will change if you change the f...Field Options and Combo Lists?
Wondering if anyone knows how to make this work. I have two fields in a
form, both Combo Boxes. I want the Value List in the first box to determine
what the Value List in the second box will be. For example, if the first box
is all State Names, if you select California, the second box provides all of
the City names for that state. However, if you change the first box to Utah,
the second box provides all the City names for Utah.
In the afterupdate event of the states combobox write code to adjust the
rowsource of the city combobox. Something like:
Me.combo_STATE.RowSource = &quo...Grab a value from a label to put for critera for attached query
Let me give a little background of table/query structure.
I have a query that pulls jobs due Today-now() whose frequency is for today.
I have table with the following fields.
Job#, Location(ie.what Plant & Floor), Room(ie. mens washroom, storage room,
etc.), job Desc., Frequency, est. time, resp.. This table ties in to create
a query with another table - Cleaning(when the jobs are actually carried out)
Cleaningid, Date Done, Who did the job) and grabs the other fields from the
Here goes what I need to get:
The people on the floor will have a MAP of the floor ( Form)...Lowest value in a selection of data
What formula would I use to find the lowest value in a selection of
data i.e. B49:E52.
Gary''s Student - gsnu2007a
Jumping in here...
Is it possible to know the address of the cell containing the minimum
You can use the MATCH function to locate the (relative) position, but
if you have more than one value which are minima then it will only
find the first.
On Nov 16, 7:23 pm, John Google <JohnGoo...@hotmail.co.uk> wrote:
> Jumping in here...
> Is it possible to know the address of the cell containin...Spell check error
Every time I send a message I now get an error that
reads.. "error occurred while checking spell check". No
spell check is peformed. Outlook 2000
This behavior can occur under several circumstances.
- The Microsoft Office shared Proofing Tools are not installed.
- The spell checking features are not configured properly.
- The insertion point is not inside the body of the message when you
perform the spell check.
Please refer to the Knowledge Base article ID: 241485.KB.EN-US for more information on how to resolve this issue by copying and pasting the link below
into your ...Excluding Duplicates in One Field
I'm stuck. I have two fields, fName and fEmail. Many of the fEmail
fields have duplicates because often people in the same house use the
same e-mail address. I need to query the data so the result does not
contain the duplicate e-mail addresses. For some reason, "unique values"
still pulls up the duplicates.
I know if I exclude one of the duplicate e-mail addresses, then I also
end up exluding the name in the same record, but so long as the output
has at least one of the names, along with every record for which there is
a unique e-mail address...Multi-field primary key, no dupes
I can select multiple fields and make a primary key indexed with no
duplicates. But I just realized my criteria for "no dupes" holds only
if another field is empty (no value).
For example, if my primary key is:
then I can't enter another order for the same product on the same
That's good - unless the order's been shipped and another one is
needed. So no duplicates, but only as long as the ShipDate field for
that record is empty.
Can this be done easily? Or should I look into a different way to
...Adding Values From Different Tabs
Is there a way to add values from different tabs on the same
For example A2 from tab 1 and A2 from tab 2
Flipkid2's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=17984
View this thread: http://www.excelforum.com/showthread.php?threadid=398184
Assuming the name on Tab 1 is Sheet1 and Tab 2 is Sheet2, use thi
note the name of the sheet is followed by "!" to indicate it is a shee
------------...Change order of fields in a report to a custom arrangement
In a report, I want to list sections in a certain way that is not
alphabetical or numerical. Is there a way to do this? Curerntly, it is
alphabetical as below:
Chief of Staff
** I would like for the fields to be organized as below:
Chief of Staff
Try going to Sorting and Grouping. It is one of your buttons on the command
bar. You should be able to set it anyway you wish.
ACCES...Checking which fields changed
Is it possible to identify individual fields changed by a user during
editing on a form before or immediately after the form is saved?
On May 9, 4:25 pm, "John" <J...@nospam.infovis.co.uk> wrote:
> Is it possible to identify individual fields changed by a user during
> editing on a form before or immediately after the form is saved?
I assume you mean what data was changed when you save the record? If
so look at the OldValue property of your text boxes etc.
Take a look at what Allen Browne has at ...Display only duplicate values and delete UNIQUE Items
I have a very large list of data and on a monthly basis i need to
display only the duplicate items in a spreadsheet. I would like to do
this in VBA and then run it as a macro on the spreadsheet. Alot of
the sites that i have seen only show how to removed the duplicates.
Excel 2007 has a function which removed all duplicates but so far i
have found nothing that only displays the duplciates.... any ideas
Assuming that the field you use to determine uniqueness is column A,
you can put this formula in a helper column:
=3DIF(COUNTIF(A:A,A2)>1,"Duplicate","Unique&...Ending balance doesn't equal market value
I am using MS Money 2004. In my portfolio the Contributions ($) Market Value
amount is showing a negative amount, but Today's Balance shows a zero Ending
Balance. How do I get them to both show tha same number?
In microsoft.public.money, Eggman wrote:
>I am using MS Money 2004. In my portfolio the Contributions ($) Market Value
>amount is showing a negative amount, but Today's Balance shows a zero Ending
>Balance. How do I get them to both show tha same number?
Look for future transactions.
OWA text field is always 'grayed out' - on new messages
and replies. Small "x" button in upper left of text field
seems to have no functionality. Subject field is OK.
Bummer - do you have a question? If yes, then try asking it in an Exchange
news group as Outlook Web Access is a function of Exchange, not Outlook.
Microsoft.public.exchange.admin is a good place to start.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted w...Complex IF, more than 7 nests
I have a test that needs to run against 5 pair of data (total number of 25
combinations) using IF and AND. The TRUE result of the IF statement will
perform an array calculation.
The problem is that Excel limits the number of nested IF statements to
seven. How would you go about doing this? I'm sure there is a more
appropriate, powerful way that I'm just not aware of as an intermediate
Task phrased in plain English:
Step 1: Look at value for This Week's Incentive Bands, New Contract to
determine which array to use for "New Incentives" calculation. I'...Deleting system locked fields
Does anyone know how I can get rid of the "Is revenue system
calculated?" field on the Opportunities form? We always have
user-provided values, and therefore have no need for this field, but I
can't delete it. Anyone know how I can get around this?
You can not delete those fields.
But you can change the default value to "user provided". WIth some
javascipt you should be able to hide it for the users.
Frederic - Travi@ta
> Does anyone know how I can get rid of the "Is revenue system
> calculated?"...DTM: USB-IF test certification ID check
MSDN Document "USB-IF Test Certification ID Check" indicates the TESTID be
set to zero. When I run this test in the DTM, the log reports an error: "No
valid USB IF test ID has been entered."
I am testing with WLK 1.5. There is some buzz on the Internet that WinQual
has a method by which to generate a Test ID that works with WLK 1.5, but I
can find nothing helpful on their site.
dmm <firstname.lastname@example.org> wrote:
>MSDN Document "USB-IF Test Certification ID Check" indicates the TESTID be
>set ...How to split a field into 2 fields?
I imported a spreadsheet from Excel and would like to split one field into
Many of the records in Field1 have a note in parenthesis ( ). If a record
has anything contained in parenthesis, I would like to move that data to
What's the best way to accomplish this?
To get the word inside the parenthesis try something like
IIf(InStr([MyLeeter],"("),Left([MyLeeter],InStr([MyLeeter],&q...increment a value by 1
How do I increment, automatically, a cell by 1 if a condition is met? If one
of my cells reaches 10k I want another cell to increment by 1. Can anyone
help me if this function can be done?
Thank you, Ron
Do you want the increment only when it changes from below 10K to above 10K,
or anytime is is above 10K?
> How do I increment, automatically, a cell by 1 if a condition is met? If one
> of my cells reaches 10k I want another cell to increment by 1. Can anyone
> help me if this function can be done?
> Thank you, Ron
Increm...Exclude like values with a JOIN?
I have the following query:
FROM dbo.qry_UV_CARS_PlateX_Valued RIGHT OUTER JOIN
WHERE (dbo.qry_UV_CARS_PlateX_Valued.Yl_iD IS NULL)
And I have another secondary table containing the same field as Yl_iD.
What I want to do is have my main query exclude all the Yl_iD values that
are in my secondary table.
What JOIN and criteria will do this?
WHERE Yl_iD N...Adding Fields 02-14-06
Is there a way to add a picklist programmatically ?
If there is, a sample code would be greatly appriciated.
Thank You in advance
...VBC 'Contains' Check
Apologies gain, still trying to hack this coders VBA as a non-coder so I can
fix as he is AWOL.
Anyway part of the code was supposed to see if a cell contained specific
text but as I test it it only works on a complete match. This is the line of
ElseIf InStr(UCase(CStr(wsCert.Cells(targetCertRowNumber, 1).Value)),
UCase("TEXT")) And Len(CStr(wsCert.Cells(targetCertRowNumber, 2).Value)) = 0
Do I need to change something so it is finding "TEXT Anything" as right now
it is just finding "TEST"
Thanks in advance