Search results
-
I
Solved How do I jump to the next matching item when typing in a combobox?
In a combobox, if two records have the same value, is there an easy way to jump to the next one? As an example: This example's not really a problem, but it is an issue on another combobox where it's not sorted alphabetically and the identical values are miles apart. Thanks in advance. -
I
Not sure how to set relationships after splitting table
Attached: A stripped-down version of my database. In tblPlayableSims, I have several columns that I split into their own tables - if I have two Sims with the same job, I don't need to store the information separately for each. I related them like this: However, now I'm not sure exactly how I... -
I
Issues with combobox record selector and filters
In my database (attached), I have a form ('Households & Sims') with a combobox record selector to select a household. It works well until I try to add a criteria to the query. If I add [Households].HouseholdExists=True to the form's Filter or 'WHERE (((Households.HouseholdExists)=True))' to the... -
I
Subform Query: Displaying records that share same field values as current record
Yet another question about the Sim tracking database I was having trouble with earlier. Within my [Playable Sims subform], I'd like to create a datasheet subform to display all the siblings and half-siblings of the currently selected Sim. Here's what I did so far: I have a table, [Sim Births]... -
I
Limiting combobox selection in subform
I've got the problems from my previous thread entirely solved. (I ended up ditching the query and just pulled all the fields from the table itself.) Now I've got another problem that I'm a little confused on. This form is intended to be a subform for another form. The main form... -
I
Why does my form field modify the row source instead of the control?
I'm pretty much learning MS Access from scratch, so I'm probably just making some silly beginner mistake. I have two tables, Neighbourhoods and Households. I have a one-to-many relationship between the two of them. (ID > Neighbourhood). I made a form for Households and made a combobox with...