Can I use a subform to display a table and have buttons on the main forum execute queries to update the table the suform is displaying? When I try to do this now, I get an error msg saying that table is currently in use.
Hi, I want to populate a list box from a column from a table in my DB. Additionally, I want to add an "ALL" row to the listbox to signify that the user wants to select all from the list box. So how do I add more rows after populating the box with data from a table? Thanks
I have a subform that displays the content of a table. In my main form, I have code that repopulates the table. But when attempting to run the code, a 3211 run-time error comes up saying that table is already in use by another person or process. Is there no way to have the subform display...
Hi, I have a form that displays images. The Image control acquires the path of the image from a subform that displays the content of a table. The table is displayed using Textboxes so I'd like the picture to update based on the Focus Event(when the user clicks on the text box that displays the...
Hi, I have two tables A and B, B's primary key is a foreign key in A. I want to do a query that returns all records in A where its foreign key value doesn't match up to any of B's primary keys' values. In other words, A has a corrupted or erroneous record. I've used NOT IN but it doesn't seem to...
So now I'm running this query:
SELECT *
FROM ImageProps, VehicleDetails, Environment, DayOrNight, Motion, Weather, SSPos
WHERE ImageProps.OccupantID=9999 OR (ImageProps.VehicleID NOT IN(SELECT ID FROM VehicleDetails.ID)) OR ImageProps.EnvironmentID NOT IN(SELECT ID FROM Environment) OR...
SELECT *
FROM ImageProperties, OccupantDetails
WHERE ImageProperties.OccupantID <> OccupantDetails.ID;
ImageProperties keeps information about what type of occupant is shown in the image. OccupantID is a foreign key and OccupantID.ID is the primary key in the OccupantDetails table. This query...
Yes, the category will never change, it's set by a national safety agency. So I'm thinking to just have age and weight IDs in the main table and have an age and weight table to map the IDs to their respective categories. So when querings for individual images, two joins of the IDs would give me...
We're not storing birthdays because we dont' really care about the exact age of the person, we only care about what age bracket he/she fall under, because of privacy issue some ppl might only give us a bracket they belong to. So with that in mind, would you say this is the only way to do it? My...
Say I've got a main table with bunch of records of images in my DB. Each image is a picture of a person, two of the attributes are age category, and weight(ideal or not). Would it be better to put the age and weight combinations into another table and generate IDs for each possible combination...
Hi I was wondering if there's a way to automatically generate a report from a table based on the number of fields in that table? I have a table where the result of an action query is stored into. Then I would like to have a report generated based on the content of that table. But The table's...
Hi, I'm designing a form where the user can select which fields he would like on the final report. It seems to me that the fields in a report HAS to be predetermined at the design stage. Is there a way for ACCESS to generate a report based on the fields the user has selected?? Thanks
Maybe I haven't explain clearly what I need to do. I don't need to specify criteria in the WHERE clause. I need to specify the fields to return in the SELECT clause. Maybe there's a way where I can concatenate all the fields the user selects from the form and put that string into the SELECT clause?
Is there a way to filter specific fields rather than the values in each field? basically it's like a customized SELECT clause, but it'll make it easier by first doing a SELECT * and then just filter the datase horizontally and vertically. I hope I've explained it clearly.
Hi, I need to create a form where one combo box exists for each field in my database. The user can then choose the criteria of each field, or "NONE" to exclude that field from the query. Then hitting the command button will bring up a report of the query result. I've done some...
Hi, I have a form that executes 8 complex queries and put the results in different text boxes. Sometimes when the server runs slow, it takes a very long time to complete all 8 queries and Access won't update the text boxes until all 8 are finished or if a mouse click is detected, it will update...
But the field I want to order by is going to vary, based on what the user selects in the Combo Box, so is that were I would put [forms]![Form1]![Combo1] ?? So it'd be like
SELECT * FROM Table1
ORDER BY [forms]![Form1]![Combo1];
Thanks
Hi, I tried what you said but I doesn't work. I think you might have skipped over a couple of steps. So the Row Source Type for my Combo box should be a query right? But would I be selecting in my query? I already have a query that I want to use. I just need the forum so the user can pick which...
Hi, I want to design a forum where the user can select a field they want to order the search result by. So far, I've tried doing:
ORDER BY [forms]![Form1]![Combo1];
Where Combo1 is a drop down list of bunch of valid field names. However, this doesn't seem to do anything. The query gets...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.