[AccessD] Amend combo to have 'Add new record' option in list

Software Design & Solutions Pty Ltd. SDSSoftware at optusnet.com.au
Thu Jun 5 03:30:08 CDT 2003


Thanks Michael - I'm playing with that now. So I have to have the same no. of columns on both sides and use null for the unwanted ones. 
THanks
Kath


----- Original Message ----- 
  From: Michael R Mattys 
  To: accessd at databaseadvisors.com 
  Sent: Thursday, June 05, 2003 3:03 PM
  Subject: Re: [AccessD] Amend combo to have 'Add new record' option in list


  Kath,

  I think this may work (or something close to it):
  For each of your fields you would select NULL
  as that field name like so ...

  ... UNION SELECT NULL AS BorrGuarID, ...
  NULL AS [ACN], '!Add New Record!' AS [NewRec]
  FROM tblClients


  Michael R. Mattys
  www.mattysconsulting.com

  ----- Original Message -----
  From: "Software Design & Solutions Pty Ltd." <SDSSoftware at optusnet.com.au>
  To: <AccessD at databaseadvisors.com>
  Sent: Wednesday, June 04, 2003 9:01 PM
  Subject: [AccessD] Amend combo to have 'Add new record' option in list


  I would like to amend several combos in my app to have the option of 'Add
  new record' at the top of the list.

  I use 'not in list' code extensively to write new records to tables and open
  user input forms, but I now have a requirement for the user to *see* 'Add
  new record' as an option. Because I have to do this for several different
  combos, there are a few different scenarios, but here is the row source
  statement for one below:

  SELECT [TblClients].[BorrGuarID], [TblClients].[BorrowerName],
  [TblClients].[AddressLine1], [TblClients].[AddressLine2],
  [TblClients].[BusPostCode], [TblClients].[ACN] FROM TblClientsORDER BY
  [TblClients].[BorrowerName];

  I have a feeling that I need a union query to pull in a value of 'add new
  record' so I have had a go at that with no luck....

  TIA

  Kath


  Kath Pelletti
  Software Design & Solutions Pty Ltd.
  Ph: 9505-6714
  Fax: 9505-6430
  SDSSoftware at Optusnet.com.au



  ----------------------------------------------------------------------------
  ----


  > _______________________________________________
  > AccessD mailing list
  > AccessD at databaseadvisors.com
  > http://databaseadvisors.com/mailman/listinfo/accessd
  > Website: http://www.databaseadvisors.com
  >

  _______________________________________________
  AccessD mailing list
  AccessD at databaseadvisors.com
  http://databaseadvisors.com/mailman/listinfo/accessd
  Website: http://www.databaseadvisors.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030605/854bd336/attachment-0001.html>


More information about the AccessD mailing list