issue with row source of listbox

Hi,

I need help with the following issue.

In the form, i have a listbox whose row source made up of two different 
tables.
In one of the field i set it up as follows

Expr1: IIf(Not IsNull([Subject_Name]) Or 
[Subject_Name]<>"",[Subject_Name],[OldSubject_Name])

I was trying to get it to show up in the listbox in the view mode but to no 
avail. Is it to do with the fact that it's not one of the fields exist in the 
table?

How do i work around this?

Thank you in advance
0
Utf
2/12/2008 4:38:00 AM
access.forms 6864 articles. 2 followers. Follow

1 Replies
677 Views

Similar Articles

[PageSpeed] 37

On Mon, 11 Feb 2008 20:38:00 -0800, Associates
<Associates@discussions.microsoft.com> wrote:

>Hi,
>
>I need help with the following issue.
>
>In the form, i have a listbox whose row source made up of two different 
>tables.
>In one of the field i set it up as follows
>
>Expr1: IIf(Not IsNull([Subject_Name]) Or 
>[Subject_Name]<>"",[Subject_Name],[OldSubject_Name])
>
>I was trying to get it to show up in the listbox in the view mode but to no 
>avail. Is it to do with the fact that it's not one of the fields exist in the 
>table?

NULL is not unequal to "". It's not equal (or unequal) to anything!

Try

Iif(NZ([Subject_Name], "") <> "", [Subject_Name], [OldSubject_Name])

Better yet, don't use Allow Zero Length in your table unless you have one of
the VERY rare cases where you must do so, dragged kicking and screaming to
turn it on. That would let you just use NZ:

NZ([Subject_Name], [OldSubject_Name])


-- 
             John W. Vinson [MVP]
0
John
2/12/2008 6:14:11 AM
Reply:

Similar Artilces:

How do I refresh the selection listboxes on a pivot table?
The field-level (column) selection boxes used to select the data to be included in a pivot table include old and new values. How do I refresh these list boxes so they only include values that are present in the current source data? The list box continues to show values that are no longer in the data set. Click in the Pivot Table to bring up the Pivot Table toolbar. (If that doesn't bring it up, rt-click a toolbar and select it from the list.) Click the button with the ! icon to Refresh the Pivot Table. Hope this helps |:>) "WWW.CS" wrote: > The field-level (colu...

Issue printing newsletter that was emailed
I just completed a newsletter targeted at executives within our company. When the document is loaded and I open the Page Setup dialog box, the Layout options are: Publication type: Custom Page Size : Width: 9.5" Height: 44" Orientation: Landscape When I send the newsletter as an email, only the first page will print. Any suggestions how I might correct this problem before sending it out to our executives who will undoubtedly want to print the message. Thank you John Hart That's a really strange size for a newsletter. What size paper are you using to print it on? (I ...

Conditional hiding / unhiding of rows ?
1.) I want to know whether there exists a possibility (other than with macros) to hide or unhide with the help of a condition, as in: if(C38="blab"; unhide(rows 38:52); keep them hidden) Is that possible or is the conditional formating just limited to nice colors of certain cells if they fulfill some kind of condition regarding another cell? 2.) I want to know how I could insert in my worksheets, left to column A, two columns 1 & 2 with a little "+" in order to display, when clicking on it, the hidden rows? Does anyone understand what I mean? I am not sure if I do...

Out of Office Assiatance issues
Hi all, One of our users (UserA) is having issues receiving an Out of Office confirmation email when he emails a particular user (UserB). For test purposes I emailed this users (UserB) and received the out of office response. The UserA is able to receive other emails and there is no mailbox size restriction in place. What else can be done to investigate and resolve this issue. Version of Outlook the user is using is Microsoft Outlook 2002 ( 10.2627.2625 ) no Service Pack. "Leon" <ap76_at_email.com> wrote in message news:eRH1U3JdEHA.1764@TK2MSFTNGP10.phx.gbl... > Hi a...

Counting number of rows based on mutiple criteria
Does anyone know how to count the number of rows based on mutiple criteria on other columns? For example I want to count the number row that meet the criteria of "Yes" in Col 2 and "Yes" in Col 3. The result would be 2 in the example below. I tried different combinations of Vlookup, Countif and Sumif and could not come up with anything that worked. Col 1 Col2 Col3 A Yes No B Yes Yes C No No D No Yes E Yes Yes Your help is greatly appreciated! Hi, =SUMPRODUCT((B1:B10=&qu...

Any known issues with Symantec Endpoint protection blocking ODBC
Does anyone have tips for setting up Symantec Endpoint ver 11 on a server in a way that allows to ODBC connectivity from workstations. A few people have mentioned issues related to proactive threat protection and network protection. They suggested using its latest service pack....and disabling proactive threat protection and network protection. There is a KB article you can get from CustomerSource on how to deal with Symantec. -- Charles Allen, MVP "Ger" wrote: > Does anyone have tips for setting up Symantec Endpoint ver 11 on a server > in a way that allows to O...

Network Installation Issue
Hi everyone! I have two computers with Windows XP Home edition and Wireless Network. I want to install RMS 2.0 and use one of them to store the database and act as a register and the second one only as a register. How do I set this up? I installed RMS on both of them and SQL Express on database server. But I cannot connect to the database from the second computer. Thank you in advance for all replies. Hi, You probably need to share the drive. You will want to make sure your wireless network is secure. Do you already have the RMS 2.0? If so you might want to contact the partner from wh...

Unhide rows?
In Excel 2002, rows that were previously hidden will not "unhide." Rows that are hidden now will only unhide by using the undo command. Columns hide and unhide successfully, but rows do not. Protection is not on for either worksheet or workbook. Does anyone have an idea why this is happening and how to fix it? Nevermind. I forgot that I had a column with instructions to filter certain rows, the rows I couldn't unhide -- gee, what a coincidence. "Scot" <greatscotinla@hotmail.com> wrote in message news:9Ea4f.1079$fc7.1027@newsread3.news.pas.earthli...

Find Value; Return Row number
Goodmorning everybody! I was wondering if someone could help me with the following problem: "I wanted to make a macro which would find the first value (counting from a1) that matches the value stated in C14 of "FORM". When it gives a match I want to return the row number to "Sheet2". I tested it with dates of which I was certain it had to find a match (as I entered them myself in "Sheet1") Still it returns: "Named Argument not Found" (Runtime error 448)" I hope someon sees my mistake(s). Thanks in Advance!! Sub TestDelete() l = Sheet...

HUGE performance issue when upgraded to version 9
Just upgraded test to version 9. My laptop install and citrix are identical and logging into Dynamics is same (same DSN setup, same Dyn User ID used, same company logging into, same sql server that both workstations using, same set file, same dex.ini files, same everything): Citrix (quad processor with 2GB RAM, Win 2k SP#4,no users accessing this server): 157 seconds to completely log into company. My laptop (single processor, Windows xp, 1Gb RAM): 10 seconds to completely login This is such a huge drop that as of now, unusable to us. If sql and hardware, Dyn security etc is taken ...

report record source
Access 2003 I am trying to change the record source of my report using the below code. I get error 2191. What is the correct way to set the record source of a report? If UnitNo = 0 Then Dim strsql3 As String Dim strsql4 As String strsql3 = "SELECT t040Project.ProjectID, t041ProjectDetails.ProjectDetailsID, " & _ " FROM t040Project INNER JOIN (t041ProjectDetails INNER JOIN t000Facts " & _ " ON t041ProjectDetails.UnitID = t000Facts.UnitID) " & _ " ON t040Project.ProjectID = t041ProjectDetails.ProjectI...

Moving a row from one sheet to another wrongly leaves blank-row artifact.
Moving an entire row within a sheet in Excel XP is implemented correctly: Select the entire row, cut it, go to the target location, and Insert Copied Cells. The target row is inserted (pushing all rows below it down), and the source row is deleted (bringing all rows below it up, as it were). NOT so when the target is in another sheet in the same workbook. Excel inserts the target row correctly, but fails to delete the source row. The row still exists (only it's blanked out). You have to remeber to, tediously, return to the source and delete the blank row. Which means that if you intende...

OAB issues
Hello, My environment was migrated from EX5.5 to Ex2000 and then to EX2003. There is 2 backEnd (1 is a cluster) and 2 front-end. My OAB is not generated anymore. I had reseted Site Folder and so on.... Putting on Maximum OAL Generator I can see that error occurs while load the address templates. Any ideas ? Thanks, Diego If you use ADSIEdit (from the Windows support tools) and open the Configuration Container and then the LostAndFoundConfig, does the LostAndFoundConfig container have anything in it? If so, these may be old "lost" copies of the Address Templates and other st...

first row
Hi group Im using excel as a telephone database (cannot get my head around access). Anyway with my first row which has name, contact number etc etc, I would like to always keep visible, so as when I scroll down the list of names I can always see this first row, is this possible? or do I have use access?? TIA -- --------------------------------------------------------------------- "Are you still wasting your time with spam?... There is a solution!" Protected by GIANT Company's Spam Inspector The most powerful anti-spam software available. http://mail.spaminspector.com S...

Archiving issues #2
I have a user who uses his Win XP & Office 2003 laptop at work & away from work. He wanted his mail setup so he could access mail away fom work so i configured his Outlook to work Offline. When i set him up to work offline i archived his mail to his H:/ then imported the contents back so he had the following when he opened his Outlook. Mailbox (John Smith) Archived folders At first everything was fine. Then he started experiencing problems and when he clicked on his archived folders it said inaccessible so i tried to import the H:Archive back into the archived folder within Outloo...

Select non-consecutive rows
Hi, Is there a way to select non-consecutive rows besides Ctrl + click. If I want to insert a blank row above about 40 rows, this can become quite tedious. -- Thanks! Dee Hi only possible with VBA in this case -- Regards Frank Kabel Frankfurt, Germany "dee" <dee@discussions.microsoft.com> schrieb im Newsbeitrag news:23B3F46E-C956-4FCC-9880-08B9A200B3A2@microsoft.com... > Hi, > > Is there a way to select non-consecutive rows besides Ctrl + click. If I > want to insert a blank row above about 40 rows, this can become quite tedious. > > > -- > Tha...

Delete rows with macro code
Hi, I would like to try and find a macro code that does the following: 1. Delete rows when cells in column C3:C2000 are less than (<) 50, and; 2. Delete rows when cells in column F3:F2000 are exactly equal to (=) "0" This 'exactly' is important as I have some blank cells in column F which are greater than 50 and I need them to remain within the sheet. If anyone can give me any assistance on this, I would be grateful. Many Thanks, Greg Sub Test() Dim iLastRow As Long Dim i As Long iLastRow = Cells(Rows.Count, "C").End(xlUp).Row For i = iLastRow ...

POP3 Client connectivity issue
We have an Exchange 2003 server in a 2003 AD domain. Exchange is running SP1. We have several hundred remote users who use Outlook Express 5.x or 6.x to connect using POP3. Within the last 2 weeks, we've noticed several times that the clients are having problems downloading new mail. Outlook Express prompts for a username and password and successfully authenticates the user. Then it says "downloading message X of X" and sits there endlessly. We have restarted every service on the Exchange server including the SMTP service. This did not resolve the problem. Each time we ha...

No rows in dataset when reading in xml?
Hi, Ive had a bit of a look around for other people with this problem and cant find anything that solves it in my case, so I'm afraid im going to have to bother you all with a post of my own. Essentially, I am trying to read in an xml schema and then an xml document into a dataset using ReadXmlSchema and then ReadXml. When i do this, i end up with a table in the dataset (which i assume is created when i read the schema), but no rows representing my document. I read in a couple of places that validation failing against the schema would cause data from my xml file, so i validated my docum...

URGENT!!! Problem with row data being truncated in a copy worksheet sub #2
Dave, Thanks for responding. I tried this but I could not get it t work in conjunction with the entire module. It dies right afte copying and PasteSpecial Values It does not kill the temp file or loa the newly created sheet into an e-mail. Any Ideas -- Doctor ----------------------------------------------------------------------- DoctorV's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=514 View this thread: http://www.excelforum.com/showthread.php?threadid=26863 You may want to post your current procedure. DoctorV wrote: > > Dave, Thanks for respon...

Order By not working when record source set by vba
I had a continuous form in my database which was bound to 1 query and filtered it based on combo box values. All the fields (apart from the combos) where locked and disabled to make them view only. The form also had labels for each of the columns and if you clicked it, vba code would order the form by that column's data, click another label and it would orderby that column instead. All was fine until i decided that it would be more efficent if the form used different queries for each of the criteria instead of holding all the records in memory and filtering them. That fea...

Color Coding Multiple Rows in Combo Box
Hi - I was wondering if there was a way to color code the rows of a combo box based after the value entered. For example, If the combo box is displaying the contents of field1 (numbers) which are 1, 2, 3, 4, 1, 2 I would want all 1's to be red, 2's yellow etc. I'm able to color code a single value at a time using the "ForeColor" command but, I'm not sure if there is a way to color them all? Thanks for any help, ~ Eric This is a multi-part message in MIME format. ------=_NextPart_000_0101_01C877EB.B28A3100 Content-Type: text/plain; charset="iso-8859-1&quo...

"files based on content, not file extension" option issue
Hi, I met a strange question. When I disable "files based on content, not file extension" option in IE browser (IE -->Tools Options-->Security-->Internet zone-->Custom level --> "files based on content, not file extension" disable). When I used IE to access ftp://ftp.microsoft.com via. proxy, such as: ccproxy..etc. IE browser shows HTML source code instead of normal html webpage. Could you take a look? Always state your full Windows version (e.g., WinXP SP3; WinXP 64-bit SP2; Vista SP1; Vista 64-bit SP2; Win7; Win7 64-bit) as well...

how do I print grid lines for blank rows
I'm trying to create a log-in sheet with titles in the top row and then blank rows the rest of the page which can be manually filled in. I cannot figure out how to print the grid lines for the blank rows. Thanks for any suggestions. ...

Adding sums on the bottom of rows in Crosstab Queries
I am trying to add sums at the bottom of my reports that are generated from crosstab queries. I tried the usual =sum(Input) and it doesnt seem to work. Nevermind, my mistake, figured it out. ...