Search results

I have a list box that allows multiple selections [Inventory]. I also have a combo box that has multiple selections [Shows]. Right now, user selects from list box and from a combo box and clicks a button. On button click, the items from the list box are associated with the PK from the combo...

I have three cascading combo boxes. How can I program a button to record the PK's from these combos into a table, but only if those values don't already exist. The 3 combos are circled in red and I want to record those values into tblJewelryInventory (circled in dark blue).

I've attached a screen shot of the relationships. In the red circled tables, I'd like to use the PK from tblJewelryType, tblCollection, tblDesignName to look up the PK from tblJewelryInventory from three combo boxes on the form. Each combination of those three PK's may have multiple...

I have three tables: 1. A table of generator information (back up power generators). This is the 'main' table. 2. A look-up table of maintenance lists that encompass the generators. Every year or two, a new maintenance list is generated by a 3rd party. This is a listing of every...

I have a search form that's slightly modified search form modeled after the one available here on this site. It's a main form with a list box. I use the listbox to narrow down the results I want from the search function. The search details are shown in a sub form that contains sub-sub forms...

I have three forms: Form1 that contains subform1 and Form2 which is totally separate. Form1 contains a listbox that I use as a search form. When a record in the listbox is clicked, it populates Subform1 with more details. If I am in Form2, I would like to be able to click a record which opens...

Created a button through button wizard that is supposed to open a form to add a new record, but all of the fields don't clear out. Only some fields clear and other fields actually populate data from another record. Snip1 shows my form with a record selected. When I click the 'New Waste'...

For the life of me, I cannot figure this out. In the attached picture has a representation of my setup. My main form has a listbox search form (taken from this site). The search results populate data in subform1. In the detail section of main form has subform1 with 3 cascading combo boxes. I...

So I'm on a contract and Access work is not in my scope of work, so it's some extra I do because it makes life a little easier. As part of my employee review with my manager (not the client), I'm including the Access work that I do and would like to include an estimate of how much money...

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

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

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?

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

A ring can be made from different metals and can also have different gemstones. Ring 1 can have different 'varieties' (Var): Var 1: ring 1, metal 1, gemstone 1, gemstone 2 Var 2: ring 1, metal 2, gemstone 1, gemstone 2 Var 3: ring 1, metal 1, no gemstone Var 4: ring 1, metal 2, no gemstone Var...

I have a report with an embedded subreport. It's set up in two columns, ordered across then down. My problem is when column 1, row 1 section is taller than column 2, row 1 section. It creates a lot of extra white space as I fill in the rest of the report. Is there a way to eliminate that...

Why is it when I rename a Module from 'Module1' to something different, the code I reference from that module no longer works?

I'm building an inventory to keep track of jewelry. 1 ring can have multiple gems and be made of multiple metals. However, this ring can also have no gems. The ring will cost different prices depending on the mixture of metals and gems (or no gems). I'm creating a report [rptLineSheet] (with...

I have a field where I'm recording the flashpoint of materials. The majority of the time, I'll have an actual number of the flashpoint (e.g. 100 or 140 or 200) but sometimes, I won't have a number or a number is not applicable. Is using a combo box the only way to integrate an "N/A" solution...