Information générale
Catégorie:
Codage, syntaxe et commandes
Thanks for your help, but Ian suggestion of blanking the RecordSource prior to the SELECT and resetting it afterward works very well.
>When you rebuild your cursor with another SQL the Grid loses it's .RecordSource. Consequently, everything below that is lost as well. I've never tried this suggestion before (the lightbulb came on while reading your post) so if you try this let me know how it works.
>
>1. Create a temporary table based on the cursor returned from your SQL-SELECT
>2. Base Grid.RecordSource on this table
>3. Run the SQL and APPEND all records to table.
>
>When you need to update info:
>
>1. ZAP table
>2. Run SQL
>3. Append to table
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement