list box row source

Access 2003

On my form called f018ContrPerfEmissGua (PK GuaID SK ProjectID) I have a 
list box called UnitType.
I need help with the row source

If UnitNo=0, listbox shows all UnitType where ProjectID = 
mef018ContrPerfEmissGua.ProjectID

else listbox shows UnitType where UnitID = mef018ContrPerfEmissGua.UnitD

How can I make this work for rowsource in a listbox or combobox?

Thanks,




-- 
deb
0
Utf
4/22/2010 3:01:01 PM
access.queries 6343 articles. 1 followers. Follow

1 Replies
804 Views

Similar Articles

[PageSpeed] 13

Could you make the rowsource a query with an IIF statement to select that for 
you?
-- 
Milton Purdy
ACCESS 
State of Arkansas


"deb" wrote:

> Access 2003
> 
> On my form called f018ContrPerfEmissGua (PK GuaID SK ProjectID) I have a 
> list box called UnitType.
> I need help with the row source
> 
> If UnitNo=0, listbox shows all UnitType where ProjectID = 
> mef018ContrPerfEmissGua.ProjectID
> 
> else listbox shows UnitType where UnitID = mef018ContrPerfEmissGua.UnitD
> 
> How can I make this work for rowsource in a listbox or combobox?
> 
> Thanks,
> 
> 
> 
> 
> -- 
> deb
0
Utf
4/22/2010 3:56:03 PM
Reply:

Similar Artilces:

Customizing Activities\History LIst
Is there a way to add a date to Activities' History list? It would be nice to know when each activity happened. Thanks, Troy Troy, no way currently, although Microsoft has mentioned it might be an option in version 2.0 (nothing is guaranteed!) A few ISVs have custom products that do it... www.salentica.com www.c360.com Dave "Troy" <anonymous@discussions.microsoft.com> wrote in message news:af6b01c436bd$ce671f00$a001280a@phx.gbl... > Is there a way to add a date to Activities' History > list? It would be nice to know when each activity > happened. >...

Better to "nest" or use multi-level list?
I'm in the process of creating/defining a style(s) for a list that will be numbered in "level 1" and have indented bullets in "level 2." For such a list is it better to define a multi-level list style and linked paragraph styles? Or use one's already defined numbered list and use one of the Word's pre-defined bullet lists when needed for the second level? As part of this question, is is preferable not to have a style "nested" within another style or doesn't it matter? Thank you. -- Norm Hi Norm: I'm not sure why yo...

Distribution List Changes
Hi All, I have a mail enabled distribution list with four users. Only those users plus the Administrator have rights on this group. Yet a seperate user is able to add / edit or remove users to this group even though they do not belong to this group. The user does not even have admin rights and is able to make changes. Let me know of any options I can try. Thanks Waynear wrote: > Hi All, > > I have a mail enabled distribution list with four users. Only those > users plus the Administrator have rights on this group. > > Yet a seperate user is able to add / edit or remov...

Shared file links not updated when rows inserted in subfiles
We have one shared file which receives data from 20 subfiles via links with a relative reference. User A will open subfile 1 with the shared file. User B will open subfile 2 with shared file. User A inserts a row in subfile 1. User A saves subfile 1 and shared file. User B saves subfile 2 and shared file. Either user opens shared file. Link in shared file does not recognize the inserted row from subfile 1. Help! ...

Sound shows on custom Annimation list yet no sound heard
When the PP Presentation is saved as a show,some slides have sound and some do not. All sound came from the same folder. Also, when playing the slides while in PPPresentation, swome have sound and some do not despite all being indicated on custom annimation lisy and all startin "after previous." Thanks! Often when one sound plays but another doesn't, it's an issue of the length of the file path. What's the file path to your music? Is it really long? If so, the longer-named songs might just be hitting the length limit. -- Echo [MS PPT MVP] http://www.ec...

Data Sort with header row
How can I set the default so that the "with header row" indicator is flagged as opposed to the "without header row"? Hi Ian, Don't think you can. You can help Excel make a guess by making the formatting of the header row differ from the data below it, by making the header Text, and Bold; which helps but is far from being reliable. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Ian" <ian@ckf....

Drop Down List and Check Box
Hi...I was search for this topic but don`t found the solve...Anyway I have a drop down list like this [image: http://www.geocities.com/augurtrade/excel_checkbox.txt] and this [image: http://www.geocities.com/augurtrade/excel_checkbox2.txt] ok my questions is what is (Blanks) and (NonBlanks)...? Is it possible for me to see only all the check box that was checked or vice versa...??? How to make a total below the checkbox i mean when someone check the check box, a total number appear below the last check box [image: http://www.geocities.com/augurtrade/excel_checkbox3.txt] [image: http://www.g...

Transposing a column to several rows
I have a large file with many rows; let's say it looks like this: start data1 data2 data3 data4 start data1 data2 start data1 data2 data3 .... What I want to do is transpose the column to a row, and then each time the word START appears, start a new row. So the above would look like this: start data1 data2 data3 data4 start data1 data2 start data1 data2 data3 .... Any ideas? Thanks in advance, Scott Make sure you make a backup copy of your data before using the code I just posted "walkersc@gmail.com" wrote: > I have a large file with many rows; let's say i...

how reliable is the "Who has you in their contact list" list?
Because someone who I think has recently (within the last week) deleted me is still on this list (I don't think she blocked me), but when I check who deleted me on blockstatus.com, he shows up. could it be it's not updated? which of the two would be more reliable? -- maykk Greetings, Do not use these websites, they will steal your identity and sell it. You should change your password immediately. That said, in general, the "who has..." list within Messenger is accurate. There have been instances over the last six-months or so where the list (and m...

Selecting from contacts list
I have all my contacts in the Contacts List and I want to delete all those with a common extension i.e. all those who have email addresses @hotmail. I am using Outlook 2007 Can you do a search or advanced search which will show the contact you want to delete? You should be able to highlight & delete them from the results. "GrahamC" <GrahamC@discussions.microsoft.com> wrote in message news:6AC1880D-9632-4ED9-BAE2-7083690B9FA7@microsoft.com... > I have all my contacts in the Contacts List and I want to delete all those > with a common extension i.e. all t...

Check Box to display records with completed status only
Hi, I have a query whereby a record is lablelled complete if the "Completed date" field has a date in it, otherwise it is blank. I want to check box on a form when ticked, to display a report with completed records only. Can anyone help? Thanks, B/ On your form, you have a command button to open the report, and a check box named (say) chkCompleteOnly. If the check box is checked, you want to open the report to show only the records that have a date in the [Completed date] field. The event procedure for the command button's Click event would look like this: Priv...

protect a single row of formulas
how do I protect a single row or group of rows (or columns) without protecting the entire sheet. I have tried everything that I can think of but nothing works. I have a spreadsheet that tracks labor hours. I have several rows and columns I need protected, leaving areas for data entry. Hi basically, you need to "unlock" the bits you want people to get to (format / cell / protection and untick the locked check box) and then protect the sheet (tools / protection / protect sheet). -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anywa...

How to line up the last cell in each row?
I have some data for which I am only interested in the final column from each row. The problem is that each row is a different length, so that row 1 may be 10 columns wide, row 2 15 columns, etc. How can I get the last element from each row to line up in the same column so that I can sort, sum, etc.? Here is one solution: Insert a new column at A1 so you now have shifted all of your data to the right. Assuming that Row 1 has headers your first data record will be in row 2. Type this formula into A2 =OFFSET(B2:IV2,0,COUNTA(B2:IV2)-1,1,1) Drag copy down to the end of your data. Column ...

Script to list access right
Hi I am trying to find any script which would generate list of login users with certain access level (select, write etc.) at one particular database. Is there something like that? Thanks. Justin ...

Smart List export to Excel #2
Hi, We are using Dynamics 9.0 and Office 2003. When we try to do a Smart List export to Excel, we keep getting an "Exception_Class_Object_Exception" that references varying object errors, such as 'Cells' or 'Value'; the object errors will change each time we try an export. As a workaround, I've found that closing Excel before doing the export allows the export to complete successfully. However, that solution isn't acceptable, as our Dynamics users would like to be able to work in Excel, doing other tasks, while the export is processing. Does anyone...

a list of lists
currently i use CArray to keep track of a list of objects, but I don't know MFC classes well enough to keep track of a list of lists. I'd appreciate some suggestions "wanwan" <ericwan78@yahoo.com> ha scritto nel messaggio news:1187535523.924671.143350@j4g2000prf.googlegroups.com... > currently i use CArray to keep track of a list of objects, but I don't > know MFC classes well enough to keep track of a list of lists. I'd > appreciate some suggestions You might want to embedd your list based on CArray into a class (e.g. CListOfSomething), and then ...

Counting rows that fit within a range
I've got what seems to be a simple problem to do by hand (if it weren't for the fact that the table in question isn't exactly small). So I was hoping I could do it (somehow) in an Excel spreadsheet. What I have, is a column of numbers (to one decimal point), assumed to be sorted in descending order. I want to have another column (calculated by Excel) that will count how many rows have a larger value (in the first column) than it, but only up to a certain range (by adding a constant to the value of that row). For example, here's some data, with the first column supplied by ...

List of different values in data area
Hi excel specialists, How Can I automatically get the list of different values from the dat area and to find out their frequence? INDIVIDUALLY MEASURED VALUES: 3,5 4 3,5 4 3 3,5 4 4 3 3,5 4 3 3,5 3 3 3,5 4 4 Thanks for your help in advance. Balcovja -- balcovj ----------------------------------------------------------------------- balcovja's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2623 View this thread: http://www.excelforum.com/showthread.php?threadid=39572 Take a look at FREQUENCY in Hep -- HTH RP (remove nothere from the email address if m...

Can data in one text box automatically appear in another?
I am trying to design a form in Publisher, and would like to link text boxes so that data entered in one will automatically appear in another on the same page. Is this feasible? How will this form be used? "G.O.G." <G.O.G.@discussions.microsoft.com> wrote in message = news:E4C951DF-7D4F-4FC1-8F6B-2C0B4EB8882A@microsoft.com... > I am trying to design a form in Publisher, and would like to link text = boxes=20 > so that data entered in one will automatically appear in another on = the same=20 > page. Is this feasible? Maybe with some programming... -- Mary Saue...

Global Address List and Handhelds
We use Ipaqs throughout the company, and I was wondering if there is anyway to have exchange add the GAL to the outlook contacts on the workstation, so that when they sync up, they will retrieve the Global Address List? In news:%23TkYtT0$GHA.3560@TK2MSFTNGP04.phx.gbl, Flip <phil.atkinson@beltek.com> typed: > We use Ipaqs throughout the company, and I was wondering if there is > anyway to have exchange add the GAL to the outlook contacts on the > workstation, so that when they sync up, they will retrieve the Global > Address List? No (and this wouldn't really be an ...

Newbie: Copying row of values to a column
I have a row of cells with brand names. I want to copy the contents of the row of cells to a column on another sheet. How can I achieve this so that whenever I change a cell value on the row I also modify the value of the cells in the column in question? I was shown how to do this once, a long time ago, but I have forgotten. I think it involved the Vlookup function but I am not positive about it. Thanks...Carlos In EXCEL 2007 take the following action:- 1. Enter the following information in cells G9 to G12 (of Sheet1):- Persil Tesco Woolworths Coca Cola These are the bran...

Fields in items list-- add/delete
Hai, I am using RMS version 1.2. In Stores Operations Manager it displays list of items when click on Database-->Items. It displays only five columns. Now i need to add / delete some fields in this list. Is it possible to add or delete the fields? if yes how can i add the fields? Thanks in advance, Nagendra On Wed, 27 Apr 2005 01:22:02 -0700, "Nagendra" <Nagendra@discussions.microsoft.com> wrote: >Is it possible to add or delete the fields? if yes how can i add the fields? I don't think so antonio ...

Copy Formula Down until last row
How would I copy a formula down a column until the last row. I have data being output to a workbook and the number of rows change each time I run the report. In cell M2 I wish to enter the formula =sum(L2-K2) and then copy this down to the end cell in column M, so M3 = =sum(L3-K3), M4 = =sum(L4-K4) and so on Hi Mick Try this for size. Should do what you want. take care Marcus Sub CopytoLast() Dim lw As Long lw = Range("L" & Rows.Count).End(xlUp).Row Range("M2").Value = "=L2-K2" Range("M2:M" & lw).Fi...

remove small list from large list
I have two mail lists on excel. The first has 16,000 names, the second has about 6,000. I need to remove the 6,000 from the 16,000 as they all appear in the big list as well. How do I extract those 6,000 entries from the larger list? My expected result is a mailing list with 10,000 names. Chip Pearson has some techniques at: http://www.cpearson.com/excel/duplicat.htm Howie J. wrote: > > I have two mail lists on excel. The first has 16,000 names, the second has > about 6,000. I need to remove the 6,000 from the 16,000 as they all appear > in the big list as well. How do ...

Jpeg's appearing as black boxes...
Version: 2008 I am new to using Word for Mac - having recently transferred from a PC. I am finding that some (not all) some documents are displaying the jpeg's on them as black boxes. Instead of the image the entire are is just black and prints this way also. The image displays correctly in the finder, but once the document is full size, the image is a black box. <br> Help please! How do I get my images back? <br><br>Thanks <br><br>Amber Hi Britamy: Chances are they are CMYK JPEGs. Word (or any other Microsoft Office application) can't handle CM...