[listbox].[column]()

  • Thread starter Thread starter Miranda
  • Start date Start date
M

Miranda

hi,
i tried to use this fuction [listbox].[column](1) in a runSQL action in a
macro. However, i get an error saying that the function is undefined. should
this work?

thanks,
miranda
 
You would probably have to do Forms!YourForm.YourListbox.Column(1) ... I
don't use macros, but this is standard syntax
 
yeah, i've tried this. doesn't seem to work either


Scott McDaniel said:
You would probably have to do Forms!YourForm.YourListbox.Column(1) ... I
don't use macros, but this is standard syntax

--
Scott McDaniel
CS Computer Software
Visual Basic - Access - Sql Server - ASP
Miranda said:
hi,
i tried to use this fuction [listbox].[column](1) in a runSQL action in a
macro. However, i get an error saying that the function is undefined. should
this work?

thanks,
miranda
Click to expand...
Click to expand...
 
yeah, i've tried this. doesn't seem to work either


Scott McDaniel said:
You would probably have to do Forms!YourForm.YourListbox.Column(1) ... I
don't use macros, but this is standard syntax

--
Scott McDaniel
CS Computer Software
Visual Basic - Access - Sql Server - ASP
Miranda said:
hi,
i tried to use this fuction [listbox].[column](1) in a runSQL action in a
macro. However, i get an error saying that the function is undefined. should
this work?

thanks,
miranda
Click to expand...
Click to expand...
 
Miranda - see my reply in our original thread.

--
Ken Snell
<MS ACCESS MVP>

Miranda said:
yeah, i've tried this. doesn't seem to work either


Scott McDaniel said:
You would probably have to do Forms!YourForm.YourListbox.Column(1) ... I
don't use macros, but this is standard syntax

--
Scott McDaniel
CS Computer Software
Visual Basic - Access - Sql Server - ASP
Miranda said:
hi,
i tried to use this fuction [listbox].[column](1) in a runSQL action
Click to expand...
Click to expand...
in
a
Click to expand...
Click to expand...
 
Back
Top