Building a string

[Bob H]

I would like the end user to be able to build a string in Access (in an unbound field) on a form. I have done this by allowing the user to click on check boxes for the fields that they need to see. I then take this information and create the string, this allows the user to see the string that they created. My question is, now that I built the string in Access can I have the Pass-Through qry look at this field for the string? Could I also allow the user to set the sort by using the same method? I could some of this thru an access qry but it is very clumsy using the following steps

1. using a macro I open the qry (an access qry not a Pass-thru) in design mode
2. I copy the strin
3. I paste the string into the first grid in the qry.
4. Save the qr
5. Execute the qr
This is all done via a macro and it is quick enough where the end users doesnt see the qry in design mode. However I feel that there is a better way of doing this, and I would also like to give the user the abilty to adjust the sort. Do you think that this could be done thru VBA also it does not have to be a pass-thru qry?

 

[Rick B]

In your strin, just use something like...

[Forms]![FormNameHere]![FieldNameHere]

Rick B


I would like the end user to be able to build a string in Access (in an
unbound field) on a form. I have done this by allowing the user to click on
check boxes for the fields that they need to see. I then take this
information and create the string, this allows the user to see the string
that they created. My question is, now that I built the string in Access
can I have the Pass-Through qry look at this field for the string? Could I
also allow the user to set the sort by using the same method? I could some
of this thru an access qry but it is very clumsy using the following steps:

1. using a macro I open the qry (an access qry not a Pass-thru) in design
mode
2. I copy the string
3. I paste the string into the first grid in the qry.
4. Save the qry
5. Execute the qry
This is all done via a macro and it is quick enough where the end users
doesnt see the qry in design mode. However I feel that there is a better way
of doing this, and I would also like to give the user the abilty to adjust
the sort. Do you think that this could be done thru VBA also it does not
have to be a pass-thru qry?

 

[Rick B]

make that...

In your QUERY, just use something like...



In your strin, just use something like...

[Forms]![FormNameHere]![FieldNameHere]

Rick B


I would like the end user to be able to build a string in Access (in an
unbound field) on a form. I have done this by allowing the user to click on
check boxes for the fields that they need to see. I then take this
information and create the string, this allows the user to see the string
that they created. My question is, now that I built the string in Access
can I have the Pass-Through qry look at this field for the string? Could I
also allow the user to set the sort by using the same method? I could some
of this thru an access qry but it is very clumsy using the following steps:

1. using a macro I open the qry (an access qry not a Pass-thru) in design
mode
2. I copy the string
3. I paste the string into the first grid in the qry.
4. Save the qry
5. Execute the qry
This is all done via a macro and it is quick enough where the end users
doesnt see the qry in design mode. However I feel that there is a better way
of doing this, and I would also like to give the user the abilty to adjust
the sort. Do you think that this could be done thru VBA also it does not
have to be a pass-thru qry?