Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS ACCESS






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







Return All Records If Combo Box Is Null


I have a form that using a combo box to select specific record, sometimes we need to see all records, i would like if the combo box if left empty to return all records. I typed this expression but it returns no records when combo box is empty.

IIf([Forms]![FrmReports]![LoanOfficer]="IsNull","*",[Forms]![FrmReports]![LoanOfficer])

If i use this expression i get the wrong results when a Loan Officer ID is enterd;
LIke([Forms]![FrmReports]![LoanOfficer] & *
Example of wrong results, if Loan officer Id is 1, then it returns loan officers 1,11, 111

Thanks in advance for any help


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
Combo Box To Return Records In 2nd Combo Box!
Hi All. I'm Sure this is simple enough, but i just cant seem to figure it out.

I want to use a Combo dropdown box with Codes FC000 - FC900. to return records in a second drop down box that begins with the Letters selected in the first dropdown box.

So When a Record is Selected in ComboBox1 eg: (FC0**), ComboBox2 brings up the record to match (FC000).

eg:
ComboBox1: ComboBox2:
FC0**FC000
FC010
FC020

I hope i have expressed what i want to do.

Any Help would be greatly appreciated.

View Replies !   View Related
Null Combo Box; Show All Records
Hello All,

Im using a combo box for the criteria for a saved query. Is there any way to show all the records if the combo box value is either 0 or null?

Thanks,

View Replies !   View Related
Return To Null
Hi all

i would like to know if there is a way to return a field to null

thanks in advance

View Replies !   View Related
Return To Null
Hi all

i would like to know if there is a way to return a field to null

thanks in advance

View Replies !   View Related
Null Value To Return 0
When the SSN field is null I would like this query to return : 000000000, is this possible and if so could you show me how? Thanks

SELECT
[CASEHEADS RECEIVING NON WELFARE MONEY].IVA_MEMBER_ID AS [IVA #],
[CASEHEADS RECEIVING NON WELFARE MONEY].MEM_SSN AS SSN,
Sum([CASEHEADS RECEIVING NON WELFARE MONEY].AMT_DISBURSE) AS AMT,
[CASEHEADS RECEIVING NON WELFARE MONEY].DT_DISBURSE AS [DATE] INTO [CASEHEADS RECEIVING NON WELFARE MONEY TBL2]

FROM [CASEHEADS RECEIVING NON WELFARE MONEY]

GROUP BY [CASEHEADS RECEIVING NON WELFARE MONEY].IVA_MEMBER_ID, [CASEHEADS RECEIVING NON WELFARE MONEY].MEM_SSN, [CASEHEADS RECEIVING NON WELFARE MONEY].DT_DISBURSE
ORDER BY [CASEHEADS RECEIVING NON WELFARE MONEY].IVA_MEMBER_ID;

View Replies !   View Related
Combo Criteria If Not Null Or Is Null
I am having problems with setting up a set of combo boxes.

What I am trying to do is if combo Productline is empty then in combo PartNumber would show all products but if combo Productline has a value selected then in the combo partnumber would only be able to select the partnumbers in that productline.

View Replies !   View Related
Query With Is Null Returning Not Null Records
Hello all,

A bit of a weird one, I've got a query and the criteria for showing records is that one particular field is null. However the query is showing records with the values in the field chosen for the Is Null.

Not sure why this is happening, has anyone come across this problem before?

Thanks.

View Replies !   View Related
Field Criteria: Is Null; There Are Null Values In That Field; No Records Are Returned
I think the title pretty much sums it up....

I have a query where data is first sorted by user input; first field's criteria: [fieldname], then by another field's criteria: Is Null.

I know there are records containing null values in the second field, as I have run a select query with the criteria: Like "*", to make sure they are null, and not zero-length-strings.

The query is refusing to return any results...

Any ideas?

View Replies !   View Related
Return All Matching Records
I have a database called LettersDatabase this databse holds all the letters that have been made including the path to the doc. I use SSN to ID the letters to customers on the Contacts Database.

Contacts database also uses the SSN to id the contacts



I have a form that creates new letters for customers in this form I have listbox that queries the LettersDatabase for all matching records based on the forms contact SSN to see how many letters have been made for that customer.


The problem is that my listbox only shows the first record matching that SSN but there are more records in that LettersDatabase with the same SSN that I need to have diplayed on the listbox as well.

I may be writing the query incorrectly.
Here what I have for the query on the listbox

Like[Forms]![LetterMaker]![txtSSN]

I try adding (&"*") to the end of the query but that does not help.


If anyone out there has the solution to this problem it would be greatly appreciated

Thank you

View Replies !   View Related
Queries That Return No Records
Hi All,

I am wandering if it possible to check programatically whether a query returns a NULL result?

I am writing a program(VB) that involves an IFF statement where if there are records in the query it does a specific calculation & if there are no records returned in the query it does something else. Is this possible to achieve?

Thanks in advance:D

Cheers,

Karv

View Replies !   View Related
Only Return Current And Following Records
Hi.

i.e
I have a query with the following sort of information:-

MonthAmount
08/2007100
09/2007200
10/2007 55
11/200760

As today being the 1st October, I would like the query to return the values for Oct and Nov.
The same values would be returned on the 31st Oct, but then the following day, only the Nov value would be returned...so, basically, it only returns the values of the current month and following months..

I am assuming I put something in the criteria of the query under the month? I have tried a number of things, with none working!!!

Thanks for reading....

Frank.

View Replies !   View Related
Combo Box - Null When I Want 0
I have field in my table, which is required (in access, or not allow null sql server), and have defaults of 0.

I have a form with a combo box bound (thru query) to this field - how do I let the user choose something from the list and then decide they actually didn't want to choose anything - and so clear the list.

Hear I get an error saying the field cannot accept null - how do I just force it to accept 0 - ie no choice??

Thanks

View Replies !   View Related
Query That Return No. Of Records In Run Time
Hi all,

May I know some to construct any functions or query string that can track the no. of records that mean certain criteria in the run time.

Basically I want to track the records in a subform (in datasheet view). Should the no. of records is 0, then I can disallow user from saving it onto the table for better record keeping.

Thanks !!

View Replies !   View Related
Combo Box Null Problem
Hello!

Looks like a grate forum for access topics and thats exactly what I need now! I'm new to Access and are going grazy!!

I'm trying to add some functions to an excisting database that someone else has done.

The Form creates an report from an db containing a one per day status information from water and electrical meters. Filling in start and stop dates gives a nice report over all meters and their status.

Now I want to add a combo box so the user can select one meter or leaving it empty to get all meters. I can make it work when selecting one meter in the list, but leaving it empty shows none. Or selecting any don't help all of the meters shows up anyway.

I used the search engine on this forum and found similar problem, but couldn't figure it out. Tried many combinations of the IIF statement, but didn't help.

Please help me!!

/Anttu

View Replies !   View Related
Count Function To Return Unique Records
Not sure if I worded my subject correctly. Here's my problem.. I've used query to combine 2 tables of data..

Here are my fields..

I've assignment_num field, project_num field, project_name field, emplyee_name field.

here are my data..

assignment_num field: 1001, 1002, 1003, 1004, 1005
project_num field: 20,20,15,16,15
employee_name field: tom peter, tom peter, tom peter, julie, sally

What I want is to display the employee name with 2 projects or more...

What i have done?
I've done a group by and then count project_num field.. I also added a condition whereby the countofproject_num > 1.. everything went well except that the countofproject_num display 3 instead 2..

pls help.

View Replies !   View Related
Return All Records Where An Id Field Occurs More Than 3 Times
I just can't get my head round this one and can't even think of a keyword phrase to search on!


SELECT CompID, CaseRef, ServicesID, Summary
FROM qryAllStats;

In my query I need to return all records where there are more than 3 instances of field 'ServicesID' .

For instance in the recordset ServicesID 47 occurs 5 times while ServicesID 36 occurs 4 times and all other ServicesIDs occur 3 times or fewer.

I would need to return all of the records with ID 47 and 36. Is this do-able?

View Replies !   View Related
Help Please With Multiple Outer Joins To Return All Records From Main Table
I have this query in design view and in an asp page and it works fine:

SELECT dbo_feedback.*, dbo_origin.originName, dbo_product.prodname, dbo_category.catName FROM dbo_product INNER JOIN (dbo_origin INNER JOIN ((dbo_feedback INNER JOIN (dbo_category INNER JOIN links_cat ON dbo_category.catID = links_cat.CatID) ON dbo_feedback.id = links_cat.FeedbackID) INNER JOIN links_product ON dbo_feedback.id = links_product.FeedbackID) ON dbo_origin.originID = dbo_feedback.origin) ON dbo_product.prodID = links_product.ProductID;

BUT, I want to return all feedback entries, even if they have no matching Product or Category. :confused: When I change the inner joins to outer joins I get a syntax error in the browser window. I changed the join type in the relationship diagram in Access and tried to recreate this in query designer, but Access says the statement cannot be executed because of ambiguous outer joins.

FYI, one feedback can have many products, many categories, and only one origin. I have the joins correct and enforced.

Please help, thanks!!!

View Replies !   View Related
Problems Using A Combo Box To Filter Records In Another Combo Or A Sub-form
I have seen a few articles here and there on using a combo box to filter records in a sub-form and to filter records in another combo box, but I am not getting anywhere. I hope someone can belp

Exercise 1

For this exercise, I have the following tables:

tblClients containing client names
tblProjects containing some project details

I want to set up a simple form, so that the user can select a client name from a combo box on the main form which filters the project detail records in the Projects sub-form.
Once the user enters project details, I want this info as well as the selected ClientID to be fed back to tblProjects.


Exercise 2

I have the following tables:

tblProjects as above
tblWorkstream containiig names of workstreams and some other details.

Every project has one or more workstreams

I have a form where users will enter hours worked on each workstream. They will first select Project from a combo box on the main form. This should then filter records to be displayed in the Workstream Combo box, before they can then enter hours.



Please let me know if you need me to explain any part of this better.

Thanks in advance.

ps. I am a novice, so I'm hoping to do the above using default MS stuff, not with complex programming!!!

Thanks

View Replies !   View Related

Copyright 2005-08 www.BigResource.com, All rights reserved