[listbox].[column]()

[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

 

[Scott McDaniel]

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

 

[Miranda]

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

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

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

 

[Miranda]

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

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

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

 

[Ken Snell]

Miranda - see my reply in our original thread.

--
Ken Snell
<MS ACCESS MVP>

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

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

hi,
i tried to use this fuction [listbox].[column](1) in a runSQL action

in

a