Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS ACCESS & have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for

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?


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
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.


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 Replies !   View Related
Show Only Certain Related Records In Combo Box
I have a feeling this is a common and probably easy question, but I couldn't find anything on it in the forums.

I have a main customer form with multiple subforms on it to keep track of my clients insurance policies and claims. I enter their contact data in the main form, and the policy data on one of the subforms. Then when they have a claim, I enter the policy information on the claim subform as well.

How could I have the combo boxes in the claims subform (which is storing data in a claims table) only show the policy numbers (stored in a policies table) assigned to that particular person? I would assume I need to somehow filter the policies query so it only shows records for that particular person, but I'm not sure how to do that on the fly.

View Replies !   View Related
Show Filtered Form Records In A Combo Box
This sounds like a cascading combo box issue but it isn't quite.

I filter my form using 2 unbound combo boxes which can be used in any order, both of which define text strings using case select. These strings are concatenated into a filter text and applied by a routine called in the after update event of either combo. All works well.

My question: How can I show all the filtered records in a third combo box so that users can easily select the record of interest from the filtered set?

I attempted to define SQL for each combination of the 2 comboboxes but it was getting ludicrously complicated so that got the heave ho.

After that, I attempted to use a recordset clone, but I couldn't get this to work:
'Clone record set for combo box rowsource
Dim R As Recordset
Set R = Me.RecordsetClone
R.Bookmark = Me.Bookmark

'Populate combo box with recordset
With Me![cboProjectList]
.RowSource = R
End With

Reading the Access help, it seems that a combo box can only be populted via query, table or SQL. Is there any way of using a cloned recordset or the me.filter to show the filtered form records in a combo or list box?

I will be very grateful for any pointers.

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?


View Replies !   View Related
Only Show Ones Have Have Null Value On A Field
i have a querie, haves jobs information in it and one field called "Date Finished Fixing"

i want the querie to only show the ones with out dates put in so if they =nothing i don't no how to do it can someone help

View Replies !   View Related
Only Show Null In Query
I am attempting to run a query that only captures the fields that are null so that I can
run a report that shows outstanding information still required.

Essentially, each record is a provider. I have reviewers that complete an Access Form to
certify each provider. The form consists of approx. 120 checkbox criteria. If it is checked
they meet that criteria...unchecked they do not. The form is based off of 4 tables of which
I am querying from.

I'm trying to get a query to identify only those criteria that are unmet for each provider.
In other words...only show the unmet fields/checkboxes. From that I'll make the report.

Any help is greatly appreciated.

View Replies !   View Related
Show Substitue For Null On Report

I have a query that runs this code,

Like IIf((IsNull([For Which Quarter?<Enter> for all])),"*",[For Which Quarter? <ENTER> for all])

When I hit enter for all, in my control on the report is shows a 4, representing Quarter 4, when it actually pulls all records -

How do I get the report to show All instead of the 4?


Fen How

View Replies !   View Related
Changing Query To Show Null Values
This query will allow me to view payments that are made between 2 dates. I would like to know how to flip the query around so that it gives me the payments that have not been made. I think this would be described as returning the null values?

The SQL code i have at the momnet is:
SELECT download20060602.Date, download20060602.Description, download20060602.Amount, Members.FirstName, Members.[Mid Name], Members.Surname, Members.[Memb No]
FROM Members LEFT JOIN download20060602 ON Members.description = download20060602.Description
WHERE (((download20060602.Date) Between [Enter Start Date] And [Enter End Date]));

Any help or ideas would be fantastic.


View Replies !   View Related
Reports Show No Field Data If Value Is Null
I have a question about reports in Access. Is there a way for report fields to be omitted from the report if the database value is null?

For example:

Name: Joe
Last Name: Smith
Company: (Is Null)

would become.....

Name: Joe
Last Name: Smith


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
Qry Results Show Duplicate Records, Records Are Not Dup In Table.
I have built a qry that initially shows the correct information. For example.

tblContent has 289 records with a Type = Class.

I built a Query to select from tblContent Type = Class and I get 289 records. I add additional criteria of Progress <>"Not Scheduled", I then get 206 records. I then add additional criteria Last Name <>"Demo" And <>"Care" And <>"Support". This brings up 200 records, but the query appears to duplicate each record 3 times. I do not have 3 of the same types of records.

The SQL Statement is below

SELECT tblProfile.LoginName, tblProfile.FirstName, tblProfile.LastName, tblProfile.Organization, tblProfile.CostCenter, tblContent.Title, tblContent.Type, tblContent.Code, tblContent.[Date Assigned], tblContent.[Date Started], tblContent.[Last Accessed], tblContent.Progress, tblContent.[Date Completed]
FROM tblProfile INNER JOIN tblContent ON tblProfile.LoginName = tblContent.LoginName
WHERE (((tblProfile.LastName)<>"Demo" And (tblProfile.LastName)<>"Care" And (tblProfile.LastName)<>"Support") AND ((tblContent.Type)="Class") AND ((tblContent.Progress)<>"Not Scheduled"));

The qry is named qryPhysical Class. I have provided the link to view the database. Can you help me?

Thank you in advance for your assistance.

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??


View Replies !   View Related
Combo Box Null Problem

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!!


View Replies !   View Related
Combo Box Will Not Show Value.
I have the following code attached to "mouse down" on a combo box. The code works just fine. All the values are available in the list. However, when I select a value, the combo box will not show it! why?!

The code
Private Sub List_Reports_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
Dim obj As AccessObject
Dim dbs As Object

Set dbs = Application.CurrentProject
For Each obj In dbs.AllReports
If UCase(Mid(obj.Name, 1, 6)) = "REPORT" Then
List_Reports.AddItem (obj.Name)
End If
Next obj
End Sub

View Replies !   View Related
Combo To Show Only Those Not Previously Used

I apologise if this is a common question, but I didn't really know how to word the search!

I have a form with a person selector combo, and an asset selector combo. I would like the person combo to show everyone, but the asset combo to ONLY show those that havn't already been assigned to someone else.

Any ideas?

View Replies !   View Related
Combo Selection Does Not Show
I have a combo box set up to select a product and put the price into a text box. I am getting the cost showing up in the text box Therapy_Cost just fine, but the combo box itself does not display anything after I select something. If I remove the AfterUpdate, I do get the item displaying in the combo box, but, of course, don't get the price in the text box. Here are the details. Can anyone help?

Combo Box
Control Source:
Row Source:
SELECT Purchase_Items.ItemID, Purchase_Items.Item_Name, Purchase_Items.Item_Cost
FROM Purchase_Items
WHERE (((Purchase_Items.Item_Type)="2"));
Number of Columns:
4 (In this order - ID, Type, Name, Cost)
Bound Column:
Column Widths:
Private Sub Therapy_Type_AfterUpdate()
Me!Therapy_Cost = Me!Therapy_Type.Column(3)
End Sub

View Replies !   View Related
Show Only Unused Data In Combo Box

I'm wondering how to do the following:

I have two combo boxes that exist on a form record (i.e. two combo boxes for every record on the continuous form): mainCategory and subCategory.

Currently, I can choose a mainCategory and depending on the mainCategory, I have certain values available for the subCategory.

What I want to do is only show the values that have not been used for the subCategory (the mainCategory can always show its default value).

An example of what I mean is below...

The comboboxes and their row data:

mainCategory (combobox)
A (combobox rows)

subCategory (combobox)
for A: 1, 2, 3 (row for the selected mainCategory)
for B: I, II, III, IV
for C: red, blue

Sample scenario:
1. For the first record on the form, a user selects "A" from mainCategory and "1" from the subCategory for "A".
2. The user adds a new record to the form
3. For this new (2nd) record on the form, a user selects "A" from mainCategory and can only select "2" or "3" from the subCategory combobox. The "1" from the subCategory combobox is no longer available for choosing, unless the user changes the first record's "1" in subCategory to another value.

Any help would be much appreciated.


View Replies !   View Related
Show Data Alphabeticly In Combo Box
Hi Was wondering if someone can guide me in the right direction.
this is my first post.

I have a form with a combo box listing 900 pupils but the list is in no particular order. How can I sort the surnames in alphabetical order and for those changes to reflect on my form.

The problem I am having is I can sort it out in alphabetic order but the changes dont reflect onto the main form.

Does anyone have any suggestions.

Kind Regards


View Replies !   View Related
Show Field Names In Combo Box

How do you display the names of field for a table in a combo box. I know how to do it in mySQL "DESCRIBE employee_data", is there a SQL command in access to do this?



View Replies !   View Related
Have Combo Box Show First Item On List
I have made a few cascading combo-boxes that dynamically change based on the data entered into the field above them.. Example:

A SKU is entered, the combo-boxes pull the information for that sku from one or more tables (using SQL Query).

Now... I am having trouble getting these fields to show the first item in the list of possible item specifics. Everything comes in fine, however, I need to form to refresh and repopulate the fields one the SKU loses focus.

Any Ideas?

View Replies !   View Related
Combo Boxes To Filter N Show Tables
Im kinda new to Access and only been using the "Access 2003 for Dummies" for learning and making small databases. So far I can find out how to do the things I want, but recently got stuck with a combo box feature. What im trying to do is select entries in my combo box so that it will filter the table and show all its contents based on that filter. Im not sure how to link the combo boxes the right way and it seems some VB coding is needed which I dont normally use. If anyone has any idea how to do it, tell me how! Thanks. BTW im using Access 97.

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!!!


View Replies !   View Related

Copyright 2005-08, All rights reserved