Query Not Working Thru A Combo On Form

Aug 4, 2006

I have document management system for 2 projects in one db. I have a login form where user has to select the project id thru a combobox. And I have all the queries based on this combobox to display results in form or report. But after login and selecting the project, login form closes and main form opens to display data pertaining to that project. But it does not work, the moment we click close to open main form again query method apears displaying the same string :[Forms]![frmLogon]![Project]. This happens for all forms, reports. I cant't figure this out. Can somebody please help me?

View Replies


ADVERTISEMENT

Queries :: Query By Form With Check Boxes / Combo Boxes Not Working

Mar 25, 2013

Attached I have a database that I've been working on which has a form called "frmCriteriaSearch". It is based off of the qryCriteriaListBoxUpdate query. I am trying to get the listbox in the second tab of the results section to work. It queries fine for the checkboxes, but I cannot get the comboboxes to affect the query (unless a checkbox has already been selected)

View 6 Replies View Related

Not Working The Combo Box From Query

Jul 4, 2007

Hi;
I'm using Access 2003 and trying to select the criteria for a query from a form that include combo box. The form that have combo box is work.

Our SQL statement is;

SELECT Names.Name
FROM [Names]
WHERE (((Names.Name)=[Formlar]![Form1]![Name]));

When I run the query the box comes but not the list.

Could you give me some advise to correct the problem.

Thank you for your help.
ibrahim

View 8 Replies View Related

Combo Boxes Stop Working After Returning To Form

Dec 1, 2005

Hello all,

I have combo boxes populated with all values in a particular field, then shunt the form onto that record (standard combo box for selecting records from a list in other words).

Problem is, these boxes seem to stop working if I leave the form for another and then return to it.

Here's the code Access puts behind:

-----------
Set SerialRS = Me.Recordset.Clone
SerialRS.FindFirst "[Serial Number] = '" & Me![Combo60] & "'"
If Not SerialRS.EOF Then Me.Bookmark = SerialRS.Bookmark
-----------

The form may be opened and closed via other processes (although never unloaded), but when I come back to it these combo boxes always stop working! Why?

View 3 Replies View Related

Forms :: Combo Box - Search Function Not Working Within Form

Jul 23, 2015

I recently created a database to be used to store incoming invoices. We have 4 suppliers which supply the same material and wanted each supplier to have its own database.

I began by making a database which included all the key tables, forms, queries and functions I would need to then save 4 copies, one for each supplier. This just meant I would not have to repeat the process for each individual supplier.

The problem is all my data is external and upon importing it into the database it has made the search function (combo box) not return results.

I believe this is because:
1) The form was created before the records existed
2) The records were imported from an external source and not created using the form.

However, the way I have designed the form is so I can see all relevant information linked with a specific invoice. This aids in gathering information quickly about an invoice but also so I can input credit note and invoice query information linked to a specific invoice on the same page.

Is there anyway to remedy this?

Or use a similar search function that returns records in my form "Main View"

The last thing I want to do is have to create the form again, although I don't think this will work either as reason 2) states.

View 14 Replies View Related

Forms :: Requery Not Working In A Form With Combo Boxes

Jan 30, 2015

New to access...just build a form, in which there are combo boxes....cascading of boxes was done.

Now the problem is I want afterupdate function to get activated when user changes the value of one combo....for which I have created a code in code builder... see the code... I think I am making a mistake in writing the code to requery...

View 5 Replies View Related

Combo Box Working On Standalone Form But Not In Datasheet In TabCtl

Dec 22, 2014

i have a form with two cascading combo's that work when the form is opened as a single form however when i place the form on Page 3 of a TabCtl it fails to cascade the correct values.

frmSiteDetails > TabCtl33 > Page3 > frm ConditionDetails subform with Combo's 1 & 2
Combo 1 = [ElementGroupName]
SELECT ElementGroupID, ElementGroupName FROM tblElementGroup; has Column Count of 2 and Bound Column 2
Combo 2 = [Element]
qrySubElements has SQL:

[code]....

View 14 Replies View Related

Duplicate Record Command Button Not Working For One Form But Is Working For Other Form

Jan 15, 2015

I have an Access 2010 database with two tables and two forms. The tables are Organizations and People. Similarly, the forms are Organizations Entry Form and PeopleEntryForm. The People are linked to the Organizations table. Several people can be linked to the same organization.On my Organizations EntryForm, I created a command button to duplicate a record using the wizard. It works fine.

I did exactly the same thing on the PeopleEntryForm, but instead of copying the record, it creates a new blank record. I don't get any error messages. Is my problem due to the fact that the People table is linked to the Organizations table?

View 13 Replies View Related

Query By Form Not Working

Oct 15, 2006

I posted a thread on here a few weeks ago about dynamic queries. I was recommended to use Query By Form. So I went to the Microsoft website, followed the instructions, but now it's not working. The query is returning ALL of the table records, no matter how many fields I fill in (or what I fill them in with). I think something may be wrong with the Query criteria, but I typed it just like the site said. If anyone has experience with this, any ideas what I'm doing wrong?

Form has 15 fields (all are related to a field in the table). 3 are combo boxes, the others are textboxes.

Here is the directions I used: http://support.microsoft.com/kb/209645/en-us

View 2 Replies View Related

Simple Query/Form Not Working...

Oct 5, 2006

I have a table filled with computer monitor information (tblMonitorManagement). I had query that uses combo boxes (cboSerialNo, cboRoom, cboDepartment) on a form for search parameters. The query is called qryMonitorManagement_Sub. The results are displayed in a subform (frmMonitorManagement_Sub). This works for both my desktop and also my laptop based forms/queries/tables.

Although this form works when using cboRoom and cboDepartment, it does not work when using cboSerialNo, so I decided to simplify it down to get to the root of the problem...here's what I did.

I created a new form, created a combo box (again called cboSerialNo), and had it look up the serial numbers in tblMonitors. Simple.

I created a query called qryMonitors_Test, added all fields from tblMonitors (not using the * option). I then set the SerialNo field criteria to the contents of the cboSerialNo on the new form. Simple. For now I'm ignoring searching on anything else.

I ran the query with no search parameters before I added the criteria, and it obviously displayed all the records in tblMonitors. Fine.

After adding the criteria (using Build...to prevent typos), I used the form to select a serial number, run the query and get no results returned.

If I copy and paste the same serial number and change the SerialNo criteria in the query to search for that it works fine. As soon as I tell it to search for the combo box contents it returns no data.

This is driving me completely bat-poo. It's nothing I've not done a squillion time before but it just refuses to work. I've got to assume it's a query issue as opposed to a form issue, but things don't get much simpler than this should be!

View 6 Replies View Related

Query A Table Using Multiple Values In Textbox On A Form - Not Working

Aug 7, 2013

I have a database in Microsoft access 2010. The database has a table that stores prospective customer records, and a form that is used to input a search criteria(s) via textboxes, which then queries prospective customers table and returns the records that contain the inputted search criteria(s).

An Example of Textboxes values on the search criteria form:
Textbox - name: bob
Textbox - address: Left blank
Textbox - category: car,boat,truck

I Have tried creating a query with the following

field: name
criteria: like “*” & name & “*”
field: address
criteria: like “*” & address & “*”
field: category
criteria: like “*” & category & “*”

SQL code:
SELECT customerName ,address,category
FROM prospectiveCustomers
WHERE customerName LIKE “*” & name & “*” AND address LIKE “*” & address& “*” AND category LIKE “*” & category& “*”;

That works, but only for one value in a textbox. Once there is more than one value in a textbox (e.g name: bob,smith), the query returns no records.

I have also tried splitting the values using the comma as a delimmter, then inserting the values into a new table. That is fine until one of the search criteria textboxes has been left blank. So the query I created will run, but returns no records.

SQL CODE:
SELECT prospectiveCustomers.name, prospectiveCustomers.address,prospectiveCustomers. category
FROM prospectiveCustomers, [SearchCriteria-name], [SearchCriteria-address],[SearchCriteria-category]
WHERE prospectiveCustomers.name Like [SearchCriteria-name].name AND prospectiveCustomers.address LIKE [SearchCriteria-address].address AND prospectiveCustomers.category LIKE [SearchCriteria-address].category;

View 2 Replies View Related

Combo Box Not Working In Subform

Mar 3, 2005

I have a main form which is linked through a [PackageID] field to a subform. i wast to use the same form for both shipments in and out. the subform has a list of serial numbers add for each [package id].

On the main form i have addresses ect and then a combo box onthe [PackageID] field which brings up all the serial numbers that came in, in that package.

This is perfect for sending a large container back out unopened, however there are times when the database will need to 'pick and choose' serial no.s from several packages. To do this i made the [SerialNo] field on the subform a combo box - looking up all the serial no.s in stock - however when a serial no is selected it doesn't update the other 15 fields in the subform.

Any sugestions? Got a feeling thats its quite an easy thing to do but its beaten me!

Many thanks

Ed

View 2 Replies View Related

Combo Boxes Not Working As They Should?

Jun 25, 2004



I have a main form with two combo boxes on which are linked if you select from the first cbo it filter the second. I also have subform that has a combo box on which is filtered by the second cbo on the main form. All works lovely when adding a new record BUT when I move to another record the cbo entries in the subform are not there, there are saving to the table are all the other data is showing just not the combo box entries - to get round this I have to reselect from the second cbo click into the subform and refresh and then they appear but this isn't how it's meant to work and I'd have to do this on every record but it then resets the previous one

I think I'm going mad!

Any help would be great

View 12 Replies View Related

Combo Box Auto Expand Not Working

Sep 22, 2005

Any ideas why combo boxes that all have their "auto expand" option set to YES are not auto expanding as I type-in text? They were working last week and I have no idea why they're not working now. Strangely, if I type in any of the entries present in the combobox list (text such as "St. Louis City") exactly as it appears in the combobox list, and then press enter, I get an error message telling me the value is invalid. Then, if I use the drop-down list to find and select "St. Louis City", it allows me to enter this value.

View 1 Replies View Related

Forms :: Dependent Combo Box Not Working

Aug 18, 2013

I have 2 combo boxes, one Categories and Products. However I have follows a tutorial and when I select the Categories, the products do not show even though the tutorial says it does. I have attached a copy of the DB.

View 4 Replies View Related

Forms :: Chart Not Working From Combo List?

Dec 5, 2013

I have a chart I am trying to create that pulls data from a table. It pulls from a list of about 7 items. The issue I have is when I do this it is showing the ID numbers in the legend and not the actual names>

How do I fix this.

View 1 Replies View Related

Forms :: Cascading Combo Boxes Not Working In Subform

Nov 28, 2014

I have a cascading combo box working fabulously in a form. However when I embed that form into another form, the cascading combo boxes quit working. After doing some searching around on the web I think my issue is either in the query that the dependent combo box references and/or in the "after update event procedure" but I just can't seem to figure out the exact changes to make to my database. Details:

Tables with data for combo boxes:LOOKUP TABLE - Veg Species - Species Type,
LOOKUP TABLE - Veg Species - Species Name.
Related together based on common field: SpeciesType

[code]...

When the form with the combo boxes is embedded as above, I can select the species type from the dropdown but when I try to select the species common name value I am asked to

"enter parameter value - Forms!SUBFORM2a - Enter Specific Veg Info!cmbSpecies_Type".

View 5 Replies View Related

Query Criteria From Combo Box On Form

Dec 21, 2005

I can't figure out what I am doing wrong... I want the query criteria to be defined by a combo box in the form. The user will select the criteria on the combo box, then click a button to run the query, however the query keeps coming up blank.

[Forms]![UserReview]![Staff] is what I have entered in the criteria for the field in the query. If I simply type in "casbds1" as the criteria, which is one of the choices in the combo box, it returns with the data I want, but I just can't get it to work with the combo box. Any ideas what I am doing wrong?

View 1 Replies View Related

Query With Combo On Form For Parameter

Dec 15, 2007

I have a report query that uses a combo box on a form to collect the parameters. I would like to be able to include an option that would be like not having any criteria at all, to show all the records. I have tried several combinations in the criteria to get it to work and haven't found a way yet.

IIf([Forms]![MyForm]![Mycbo]<0,Like"*",[Forms]![MyForm]![Mycbo])

I have tried various different versions of what you see above and none have worked. The true part and the false part both work if separated and tested. Is it possible to make this work or is there better way to do this?

View 2 Replies View Related

Combo Box Query In Form (Im Lost)

Jul 4, 2006

Hi Guys,

Hopefully a simple question here. I looking to create a form that creates a contract for a particular client we deal with (grounds maintenance). In that form I'm looking to give the end user the option of selecting an existing billing address (for a property mgmt. company for example) to to enter a new one (which would then be added to tblBillingAddresses).

What I would like to have is a dropdown menu that automatically generates all the billing addresses we have (just company name, short address) so the end user can simply select the address as opposed to having to look up the auto number attached to it.

What would be better would be to be able to use have an independent lookup that classifies each billingaddress as MgmtCompany or SingleCompany, and have the aforementioed dropdown menu only generate those BillingAddresses that are infact Mgmt Companies.

How would you reccomend I go about doing this WITHOUT having to manually enter a new mgmt company to the dropdown menu each time we enter into business with such a company (I need a real-time search query based on the above criteria, in a dropdown menu within our contract From.)

Thanks a million

BG

View 1 Replies View Related

Filter Combo Box Query From A Form Field

Feb 21, 2008

If anybody could shine some light it would be much appreciated.
I have 3 tables:
Task table---*Task ID, Task(txt), Start(date/Time), finish(date/Time)
Tasking table---*TaskingID, TaskID, EmployeeID
employee table---*EmployeeID, Name(txt)
The employee and task table are joined to the tasking table. This is so i can have a task which has many employees and an employee with many tasks. What i'm try to do is create a form which starts a task with a subform to add employees, but with combo box which filters employees with tasks which over-lap the task in focus(start and finish fields) but still showing employees which do not yet have any tasks. the start and finish fields are hh:nn dd/mm/yy.
If anybody can help i would be very grateful

Jim

View 3 Replies View Related

Query On Form. (combo Box To Give Criterea)

Mar 22, 2006

I have changed my approach for my database, and i think a query is what i needed all along. But i am not sure how to go about it.

Is it possible to have query results on a form?

more precise, i have a table full products, alot of information per product (about 30-50 fields)

The amount of actual products isn't many probably around 10, and it's likely to stay at around 10 products.

Can i have a drop down list listing all the products, so it looks these up from the product table, you select the product, that product field value becomes the criterea for the query, and all the associated form fields get filled out to do with the product selected.

To summarise, can i have this all done in a form? so it's easy for staff to simple go the to product drop down list, select a product, all the info relating to the product is then displayed on the form.

hopefully i have made sense with my post.

View 10 Replies View Related

Filter Combo Box Query From A Form Field

Feb 21, 2008

If anybody could shine some light it would be much appreciated.
I have 3 tables:
Task table---*Task ID, Task(txt), Start(date/Time), finish(date/Time)
Tasking table---*TaskingID, TaskID, EmployeeID
employee table---*EmployeeID, Name(txt)
The employee and task table are joined to the tasking table. This is so i can have a task which has many employees and an employee with many tasks. What i'm try to do is create a form which starts a task with a subform to add employees, but with combo box which filters employees with tasks which over-lap the task in focus(start and finish fields) but still showing employees which do not yet have any tasks. the start and finish fields are hh:nn dd/mm/yy.
If anybody can help i would be very grateful

Jim

View 3 Replies View Related

Forms :: Run Query From Form With Combo Boxes

Oct 23, 2013

I have a form with combo boxes that works beautifully, but I've been asked to add another feature to it. It requires adding a button that runs a query and displays the query results on the screen.The query code is:

Code:

SELECT DISTINCT Product.MSDS
FROM Product INNER JOIN tblStoreProducts ON Product.[ProductKey] = tblStoreProducts.[ProductKey]
WHERE (((tblStoreProducts.MaxUnits)<>0) AND (([Product.HazardKey])<>79))
GROUP BY Product.MSDS, tblStoreProducts.StoreKey
HAVING (((Product.MSDS) Is Not Null))
ORDER BY Product.MSDS;

One of the existing buttons on the form has this code behind it:

Code:
' btnHMIS_Click
Private Sub btnHMIS_Click()
On Error GoTo Err
If IsNull(Me.cboCompany) Then

[code]....

As you can see, the button is able to pass the parameters (which Company, and which Store within the company) to the report.

Code:
' btnMSDSSheetsPrint_Click
Private Sub btnMSDSSheetsPrint_Click()
On Error GoTo btnMSDSSheetsPrint_Click_Err

[code]...

How do I pass the StoreKey information into the query? Is it my query that's wrong?

View 2 Replies View Related

Forms :: Parameter Query Using A Combo Box In A Form

Apr 23, 2013

I have a form with a main form and a subform, main form's function is to filter the data's inside the sub form using a combo box, right now I have one combo box which filters the data according to their control no so the output if I use say CtrlNo 1 in the combo box the data that will reflect in the subform would be the data's of CtrlNo 1 but now I'm planning to add another combo box that will filter who supplied that CtrlNo.

What I did is I used the same method from my first form that filters the CtrlNo but in this form I replaced the CtrlNo combo box to Supplier Combo box it worked great but now what it made me think is it possible to put this two filters in just one form?combo box 1 is for CtrlNo combo box 2 is for Supplier.

When I tried to create this it failed, when I filtered only the CtrlNo subform doesn't reflect any data this goes the same for the Supplier combo box but when I tried to choose a filter for both combo box say CtrlNo 1 and its Supplier this works fine but what I want is to have both filters to work even if I did not use both parameters is there any way to achieve this?

View 2 Replies View Related

Forms :: Update Combo Box Query On A Form?

Sep 11, 2013

I have a simple form with a combo box linked to a field on a query and command button with vb code to open a report based on the value of combo box. The command button also includes code to requery the value of the combo box so that what was already generated in the report will not display when generating another report. Since the requery is tied to the command button, there is a delay in requery of the combo box vallue unless I click the command button twice to remove the report already generated. how to apply the requery to the combo box so that when I click my comman button, the requery process will work without me having to click the command button twice?

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved