Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: ywenz
  • Order by date
  1. ywenz

    subform question

    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.
  2. ywenz

    How to populate list box with user-function

    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
  3. ywenz

    Subform locks Table?

    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...
  4. ywenz

    Updating pictures based on Focus

    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...
  5. ywenz

    How to do this simple query

    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...
  6. ywenz

    Whats wrong with this query?

    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...
  7. ywenz

    Whats wrong with this query?

    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...
  8. ywenz

    What should I do?

    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...
  9. ywenz

    What should I do?

    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...
  10. ywenz

    What should I do?

    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...
  11. ywenz

    Variations in number of fields

    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...
  12. ywenz

    On the Fly Report Generation

    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
  13. ywenz

    Custom Selects using Combo Box

    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?
  14. ywenz

    Filtering fields

    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.
  15. ywenz

    Custom Selects using Combo Box

    Thanks, but I'm not quite sure what this means: SELECT BankID, BankName FROM tblBank UNION 0 as BankID, ' -None- ' as BankName FROM tblBank
  16. ywenz

    Custom Selects using Combo Box

    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 &quot;NONE&quot; 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...
  17. ywenz

    Automatic Form refresh

    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...
  18. ywenz

    Using Forms with ORDER BY Clause

    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
  19. ywenz

    Using Forms with ORDER BY Clause

    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...
  20. ywenz

    Using Forms with ORDER BY Clause

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

Part and Inventory Search

Back
Top