Search results

I have a "Location" combo box with a list of location. Each location has a boolean "Exist" field. I'm trying to get it so when I select the location, the "Exists" check box is checked if the location table shows record that something Exists in that Location, and not checked if the opposite is...

This should be a simple SQL statement; I've done it before but just can't figure it out now. I have a LabSample table. The lab sample has couple fields that are foreign keys TechID (from Technician table) and ProjectID (from Project table). Not all records in the LabSample table contain a...

How do you run a Access query with VBA OnClick function? Instead of using a macro, I want to have VB code run the query. (This is an alternative to my previous problem with the error message.) Thanks

Please help!!! I've been struggling with this for a LONG time and my head about to explode! I'm trying to run this dynamic query by form (the form consists of combo boxes) but it will only work under certain conditions. The function of the form: when a freezer is selected, then display all...

In a multi-column ComboBox, how do I call other columns (not the first one) in SQL. This code works for calling the information from the first column: [Forms]![frmLocation]![cboLocation] I want to use a retrieve a value that is in the third column, so I try this...

I found out what it was - they have a little error in there sample code. it should read DoCmd.OpenQuery "Dynamic_Query" - they forgot the little dot. How careless of them.

I am trying to create a form that functions as a dynamic query based on information provided by the user in the form consisting of a list box, some combo boxes and text boxes. I found this link that displays a how-to example with the VBA code for the Northwind sample database...

The instructions still do not work? Am I doing something wrong? I went over it many times, and I even did what the instructions said to do on the Northwind sample database. The dependent combo box still does not filter anything. Please help!

This is exactly the solution I'm looking for. I tried this and also tried what they suggested for the older version of Access (using a macro instead of VBA code). I am working with a list box and a combo box. Select from the list box to filter the combo box. The concepts should be the same...

I am trying to create a database to track freezer inventory. I have a form to Search for inventory based on the location provided. The more information is provided on location, the more narrow the search result of items. The tree structure goes like this (each its own entity with PKey) -...

I found a solution to my own problem Ok this is what I did SELECT DISTINCTROW Col1 & Col2 & Col3, * FROM Table; This gave me an Expression field that is unique to each column. I turned that into a table and ran a SELECT DISTINCT on the new field. If you know of a much simpler alternative...

This sounds like a simple one, but I can't get it to work. I'm trying to figure out how to modify a table with repeating rows, so there are none. I tried to create a SQL Query that looks like this SELECT DISTINCTROW * FROM Table; The resulting has no apparent filter effect on the table...