Events

[Jack]

Can events only be run in a report or form, not in a query?

Thank you,
Jack

 

[Niklas Östergren]

Hi Jack!

You ar right there, query´s do not have any events only forms, controls on
forms and reports have. Why are you asking, is there something you wish to
do with a query or are you just qurious?

// Niklas

 

[Jack]

Hi Niklas!

Thank you for your quick response. I was actually creating
an array n Visual Basic and wondered if I could get away
with attaching it to a query somehow.

Thank you again,
Jack

 

[Niklas Östergren]

Jack!

I doesn´t quit follow you what you need but you can allways fill a tabel
with your data with a various ways. Using recordsets in DAO for instance.
And also manipulating the data with either query´s or DAO.Recordset
corresponding on an event in a form or a forms control or report.

But as I said, I don´t know what you are trying to do!?

Now it´s getting late here so I´m about to go to bed. But I´ll look in later
today, time´s 00:28

// Niklas

"Jack" <[email protected]> skrev i meddelandet
Hi Niklas!

Thank you for your quick response. I was actually creating
an array n Visual Basic and wondered if I could get away
with attaching it to a query somehow.

Thank you again,
Jack

 

[Jack]

Rest well and thank you very much!

Basically I'm trying to manipulate data that's being
brought in by a query. That data has to be split into two
separate fields but placeholders have to be kept. For
instance, if "01030407" comes in, then the field has to
look like this: "01 0304 07". I can write an array in
Visual Basic to handle the place holding, etc...but I was
hoping it could be linked to the query.

Thanks again,
Jack