Recent content by shrndegruv

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