[AccessD] RE: A2k2 combo boxes / rowsource hassles

Sorry to ask the obvious Tom but you have got ColumnCount set to 3 and 3
non-zero column widths haven't you?
--
Andy Lacey
http://www.minstersystems.co.uk



--------- Original Message --------
From: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
To: 'Access Developers discussion and problem solving'
<accessd at databaseadvisors.com>
Subject: [AccessD] RE: A2k2 combo boxes / rowsource hassles
Date: 27/01/05 16:26

> Hi guys
>
>
>
> I have a problem with setting the rowsource property of a combo at runtime
-
> I'm binding it to the SQL query shown below:
>
>
>
> SELECT tblAdmin_ColumnLookup.Alias, tblAdmin_ColumnLookup.FieldName,
> tblAdmin_ColumnLookup.[DataType] FROM tblAdmin_SQLData INNER JOIN
> tblAdmin_ColumnLookup ON tblAdmin_SQLData.ID = tblAdmin_ColumnLookup.SQLID
> WHERE tblAdmin_SQLData.ReportID = 5 AND
> tblAdmin_ColumnLookup.IncludeInTemplate=True
>
>
>
> The first 2 columns are there using myCombo.Columns(x), but the third...
> nowhere to be seen.  I'm tearing my hair out here!!
>
>
>
> Any help appreciated, TIA
>
> Tom
>
>
>
>
>
>
>
> Tom Bolton
>
> Systems Developer (I.T.)
>
> Donns Solicitors
>
> Tel: 0161 834 3311
>
> Fax: 0161 834 2317
>
>
>
>
>
>
>
>
>
>
>
>
> The contents of this message and any attachments are the property of Donns
Solicitors
> and are intended for the confidential use of the named recipient only. 
They may be legally
>  privileged and should not be communicated to, or relied upon, by any
other party without
> our written consent.  If you are not the addressee, please notify us
immediately so that we
> can make arrangements for its return.  You should not show this e-mail to
any person or
>  take copies as you may be committing a criminal or civil offence for
which you may be
>  liable.  The statement and opinions expressed in this e-mail message are
those of the
> writer, and do not necessarily represent that of Donns Solicitors. 
Although any files attached
>  to this e-mail will have been checked with virus protection software
prior to transmission,
> you should carry out your own virus check before opening any attachment.
> Donns Solicitors does not accept any liability for any damage or loss
which may be caused
> by software viruses...
>
>
>
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>

________________________________________________
Message sent using UebiMiau 2.7.2