Search results

Yes, that's what I want to do, except when the form loads, the subform should load to the record that was selected from the search form.

What is considered large? I'm pretty sure 'large' is considered much much larger than what I have. I have less than 3000 lines so far. Our regulatory records limit is 3 years, but we generally keep them indefinitely.

Thanks, I'll take a look at this method. I recall reading that the subform is opened and 'filtered' before the main form. I have a search form that opens the main form - so could i open the main and subform simultaneously with the subform's criteria?

Thanks for the responses. In my application (inventory management), I have a table that contains a bulk of the information and didn't know if I should just let the table grow or split it into an archive.

Out of curiosity - do you have a quick reference to opening a form that contains a subform to a specific subform record? If not, I'll start a new thread.

Ah ha! That works like a champ! That was significantly easier than I anticipated. Thanks for your help and time! You've helped me immensely.

OhhhhHHHHHHhhhh. It took me a minute to go through the sample DB. I'm going to set up a test and see if I can get it to work.

I don't quite get how I can add both sets of information. So this will let me add all the products to the ShowLink table - but I don't understand how I can associate the Shows with those records at the same time.

Three tables: Inventory InventoryPK ShowLink ShowFK InventoryFK Shows ShowPK There's an inventory of products that I might take to a show (convention). What's a good way to associate the show with the product, and store that relationship in the ShowLink table? I could make a datasheet with...

In the case of a system that keeps track of checking in and out (e.g. library books), where is the archive data stored? If a person makes 30 trips to the library, obviously one record will be the current visit - but where do you keep the 29 other visits? Do you create a separate table for...

Craaaaap. I totally didn't mean Access - I meant Outlook. I'm going to see if I can edit the title. e: Fixed title and first post.

Outlook 2007 - host distribution list on server I'm working on an governmental workstation and have no access to the back-end Outlook server. Setting up a distribution list that shows up when you are writing an email (when you click "To") is not an option. Is it possible to host a...

I'm using the Search form that's provided in the code repository; it's working fine. I am trying to transition from a listbox to a datasheet subform instead for a little more flexibility in the formatting. I see that .itemdata is for listboxes, but what is the datasheet equivalent? Tried...

So I went into my report and turned off 'snap to grid' but it doesn't look like it changed. I have my font set to 8, and if I bump it up to 9 or 10, I don't think the size of the text box is changing when I view the report. I manually set one of the text boxes to .0382" height and no change.

I shrunk down some text to 8 and 9 point, but it seems like there is a point that the text box won't get any shorter, regardless of how small the font actually is. Is that correct?

Because a ring also has a style. Like one couch can be leather, vinyl or cloth. And each of those materials also has their own designs (which may be shared between materials). You would want each combination of materials and design associated with just one couch style.

So, I think that I figured this out properly. Thanks to your help and other stuff I've read and such I think this is the correct way to build the tables. Essentially, the JewelryInventoryLink creates a subinventory of findings, metals and gems, then that is what gets associated with the main...

I have a series of nested reports and they work all the until the final report. If you open rptLineSheet2, you'll see there's only a few records with no repeats. If you open rptLineSheet, you'll see that the subform repeats itself based on how many records are contained within it. I've...

I don't think any of the jewelry will have 32 or more gemstones in it. I can't imagine there being more than 6 types (at most) of gems per each piece of jewelry. However, I don't quite understand by what you mean when you say that it's not very practical?

That's probably a different database. That's one that I maintain for work. This one (jewelry) is something I'm helping a friend from and had a brain block when setting this up.