Search results

I take look at the database Edgar made. Thanks everyone.

The program is using an old verison of the API that isn't functional. It stopped working in 2019 and the author said he' "wants to fix it" but never did. There's a forum link on the Skwire Empire page. I just want something to quickly check episode descriptions for a few shows without popping...

yeah, that's what I thought. Is it possible to group by series, as seen in the screenshot?

Around a decade ago, I used a little program called epCheck. (Spam filter prevents me from posting link, so look up Skwire Empire.) Looked like this: Unfortunately, it broke a few years ago and dev never got around to fixing. I'd like to try to recreate some of it in Access, mostly to see if...

I installed the FAYT and it does the job. thank you! 😁

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.

yes, that makes sense. In the Sims games, a career track is basically a set of related jobs - e.g. the Science career has 'Lab Glass Scrubber' and 'Top-Secret Researcher' as two options for the job. A Sim can only hold one job at a time. Additionally, there's actually two separate careers...

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

Thanks everyone I think I will try to reduce the ampersands for the objects - I think I can rename it for the categories without affecting the underlying object.

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

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

Sorry for the slow to respond. I think I have it working now. Thanks everyone. I'll try to change the fields to be more unique. :)

There were a few minor changes in-between that screenshot (taken a few days ago). I put the record-navigation back here (and fixed a mistake I made while preparing the database for upload). :o Steps to reproduce: 1. Open Neighbourhoods and Households. 2. Use the first comboform on the left...

Here it is. Beware that it's still a bit of a mess of half-finished forms and clumsy attempts at SQL and VBA. I'm pretty much learning this as I go. :o The relevant forms are [Neighbourhoods & Households] and [Households_subform]. EDIT: Fixed version of database in post below

I'm removing all the images from a copy of the database now in hopes that I can get the zip file under 2MB.

The subform is filtering correctly when I select an option in the mainform. It's just the combo-box that's not filtering. Unfortunately my database would exceed the 2 MB zip size unless I removed all the pictures first. :(

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

That solved it! I thought the form was pulling directly from the table, but instead it was pulling from one of my queries (which, in some brilliant stroke of genius, I had hidden so I completely forgot about it). :banghead: I changed the source of Neighbourhood in the query and it solved the...

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