Search results

I created a personal household inventory database for homeowner's insurance purposes. Each record contains data related to a household item such as a TV, table, etc. Each item has two associated .jpg files which show a photo of the item and related documents. These .jpg files are in the same...

From what I have been reading my problem stems from having only one table so a re-design is in order. Thanks for replying, David.

I have a single table database that I created for my own personal use to store computer related information. I categorize this data by Topic, Primary Sub Topic, and Secondary Sub Topic which appear as combo boxes (cboTopic, cboPrimarySubtopic, and cboSecondarySubTopic) on my form. Each one has...

Thank you, speakers 86, your union query suggestion worked perfectly, just what I was needing.

I have a single table database that includes the following fields: Supplier1, Supplier2, Supplier3. On my form I placed three combo boxes, cboSupplier1, cboSupplier2, cboSupplier3, each bound to one of these fields. When I drop down the list for any of these combo boxes I want to see all of the...

Thank you, David. This is an interesting approach; I'll try it.

I created a database which contains the names of scanned magazine articles saved as PDF files. I give each PDF a descriptive name which I store in the Subject field. I placed a text box on my form to display the Subject text which is named txtSubject. What I want to do is place a command button...

Thank you, nIGHT mAYOR for your response to my post. You solution worked like a charm. My list box now displays only the records I am filtering for when I use Filter by Form and click Apply Filter.

I have a form containing a wizard generated list box that displays the "Subject" field for all of the records in my database and allows me to select any record for display. When I use Filter by Form or Filter by Selection I want the list box to refresh and display only those records in the...

Thank You, Missinglinq. I did not realize that Data Sheet View was actually considered a form. I thought it was merely the table data displayed in a spreadsheet like format. Thanks for pointing that out and I will take the approach you suggested.

I am experiencing an error message in an Address Book application I am working on. This application stores names, addresses, phone numbers etc. It also stores URL's to websites. On my form I have arranged my text boxes columnar style allowing me to tab down the page in a logical order to enter...

I am creating an application that prints label inserts for CD jewel cases. I have several different text layout styles that I use. For example, Style A, Style B, Style C, etc. Each style differs from others in its text box placement and graphical elements such as dividing lines. In my table I...