Search results

Restate: I have one subform I want to use at different places on my main form, applying a different filter in each of the places I display it. It seems this cannot be done.

Wayne in this case there are so many checkboxes that the report would be ridiculously long if I have to place all of them. Fortuneately, in this case it makes sense conceptually to divide this report into three reports, limiting the number of chboxes on each report. It seems like MS needs to...

Thanx for the reply -- The form is tabbed at the top level, there are no controls displayed across all tabs -- maybe that will have to change. The real problem is that hte filter property applies to the form, not to each subform control. So applying a filter ot a subform in one area affects...

Hey all simple question: is there any way to apply a different filter to a subform each time it appears on the main form? I have a subform that would be awesome on multiple tabs of a large form, and Id like to apply a different filter on each tab.... Thanx in advance! mike

Wayne thanx that makes some sense. Question: I still have to put the checkboxes on the report -- if one is not visible, is there a space where it is, or does the next visible one take its place? Does that make any sense? mike

very cute rich. But that only affect which records are selected, not which fields are displayed on the report.

Hi all I have a form that has twenty True/False items. Rather than display all of them for each record in the DB, how can I show only the ones that are True? Do I need VB for this? I hope not, but it seems that we can either put the value on the report or not, regardless of true/false...

Doc Man thanx for the long response. I basically did what you said, with the difference that I have a table each for Kitchens, bedrooms, bathrooms, LivingRooms, as they all have their own inpection points that do not overlap. I then have condition tables for each item that all the rooms have...

Im a bit unsure of what you mean. Each room has room specific info that goes in the appropriate table. For common data across the rooms, I wanted to extract that out, so I create tables like WindowCondition, PaintCondition, etc... The problem with that is when I go to make my entry form, how...

this was never the error in the first place -- it was a relationship problem...

Hi all In my VB code I need to create a row in a table that has an autonumber field as the primary key. How does one specify that in SQL. I have the following as my sql -- I dont know what should go in the [autonumber] spot "INSERT INTO [WindowCondition](ID, RoomID, UnitNumber, RoomType)" _...

SJ I dont think that will work -- I think the problem was I never told the append query to have a field Roomtype anyway, instead of using append query Ive gone to just doing SQL. Set rec = DB.OpenRecordset("WindowCondition") With rec .FindFirst "UnitNumber = " & uNumber...

can anyone offer any help?

Hi all I am creating an apartment unit inspection DB. Each unit has a number of rooms, and each room has a number of condition. So I am thinking of Table design such as: Apartment Unit <-- Kitchen ^--------- Bedroom ^--------- Bathroom...

Hi all I was wondering how I can pass parameters to an append query. I have the query set up to enter rows into a table, but I need to be able to pass it parameters. Thoe code below executes when an apartmentunit is created. Basically I am attaching a Kitchen, Bathroom, some other rooms...

Im still having trouble on this-- can either of you (or someone else) please provide a psuedocode example?

I have a query on two tables with a one to many relationship. I would like to write a query that limits the results based on fields in both tables, AND that only returns one row, regardless of how many rows are in the "many" table of the 1-many relationship. This is not an inner join or an...

thanx for the response -- kind of wierd how the Access Button wizard has a delete record option, but the code it supplies does not work. mike

In answer to the first question -- I did check the relationships tool and confirmed that the relationships are indeed 1-1. In answer to the second, this is an inpection database for an apartment building. I was handed the paper form they use and told to put in on a computer (they want easy...

hi all Im using a form to display all the units in a table with a combobox. When the user selects a unit and clicks the delete button, that unit gets deleted. The question is, how do I update the combo box after the delete? Right now a "#deleted" string takes the place of the deleted unit...