Hi Ove,
Post it at groups.yahoo.com: log in there and go to the ms_access
group. On the left, you'll see a "Files" link, where you can upload
a sample to illustrate your problem.
Peter
--- In ms_access@yahoogroups.com, "Ove Billing" <[EMAIL PROTECTED]> wrote:
>
> Hi Peter,
> Your advice to use semicolon was successful for the criteria, that
was
> now accepted. However, the main problem remains. Now, though,
nothing
> is displayed in the second combobox.
> Many thanks for your invitation to send you data. However, I do not
> know how to furnish you with data and what you need for helping me.
My
> test.mdb is only 244 kb so it is easy to send but to what address?
> Attachments seem not to be allowed here.
> Best regards
> Ove
>
> --- In ms_access@yahoogroups.com, "phoogenb" <phoogenb@> wrote:
> >
> > Hi Ove,
> >
> > I think it may be because formula arguments need to be separated
> > with semicolons (;) for locales with a decimal comma (like most
of
> > the non-English-speaking world, including Sweden).
> >
> > So instead of IIf(Arg1, Arg2, Arg3) use IIf(Arg1; Arg2; Arg3).
> >
> > I'm not very well familiar with the Northwind examples. If that
> > doesn't work, try posting the SQL here. I will have a look at it
> > (if someone else doesn't get to it before I do).
> >
> > Good luck,
> >
> > Peter
> >
> > --- In ms_access@yahoogroups.com, "Ove Billing" <oy@> wrote:
> > >
> > > Thanks Peter for your suggestions.
> > > I have tested the method given in kb 209576 but have failed.
Your
> > first mentioned method and the one given by Jackie Home are too
> > general for me but the kb being more detailed was easier.
> > > After having typed everything correct in my Swedish edition of
> > Northwind and Acc2000 and thus no error messages appeard any more
> > the result was that all Rooms appeared in the the second cbo
> > irrespective of the setting in cboHouse. I tested both with my
own
> > tables and with those in Northwind with equal result.
> > > Under 3. in the kb a Criteria is given that seems to be
incorrect.
> > With both bases I get an error message that tells me that the
comma
> > at the end of the first line is not correct (when trying to save
the
> > query the message comes and the comma is marked. On the other
hand
> > the criteria is, I guess, not essential for the end result, only
a
> > way to take care of the situation when nothing is selected in
cbo1.
> > > Do you have any comments on this or could you possibly suggest
> > another method in some detail, being possible for me use?
> > > Best regards
> > > Ove
> > >
> > > ----- Original Message -----
> > > From: phoogenb
> > > To: ms_access@yahoogroups.com
> > > Sent: Wednesday, April 11, 2007 4:45 PM
> > > Subject: [ms_access] Re: Form design with choosen records
> > >
> > >
> > > Hi Ove,
> > >
> > > One possible solution: A form displaying tblHouse records,
and
> > > containing a subform showing tblRoom records. If you set it
up
> > > properly, Access will handle the filtering of the subform
> > automatically.
> > >
> > > Something else that might be of use: A pair of combo boxes,
> > where the
> > > user selects a house in the first one, and then the second
one
> > shows
> > > only those rooms that belong to the chosen house. There's a
> > > description of how to do this in the MS Knowledge base ("How
to
> > Create
> > > Synchronized Combo Boxes"):
> > >
> > > http://support.microsoft.com/default.aspx?scid=kb;en-us;209576
> > >
> > > Good luck,
> > >
> > > Peter Hoogenboom
> > >
> > > --- In ms_access@yahoogroups.com, "Ove Billing" <oy@> wrote:
> > > >
> > > > I am not very skilled at Access but try anyway to help a
small
> > local
> > > > museum to erect a base with their objects.
> > > > One problem to handle (with simplified examples): I think
of
> > having a
> > > > tblHouse with 4 records (H1, H2, H3 and H4) and a tblRoom
with
> > many
> > > > rooms (R1, R2 ...), some in H1, others in H2 etc. How do I
> > construct a
> > > > form where only rooms in H1 are visible or choosable when
first
> > > > choosing H1 etc. ? Is this possible? Other ways?
> > > >
> > >
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
>
