Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to clean an array

Status
Not open for further replies.
zrazzaq

zrazzaq

MIS
Apr 13, 2005
102
US
Hi I have an array such as ARRNYT(15)
after it has been filled and the table has been updated with the current record I need to clear the ARRNYT out, so it can start over again. How do I do that?
Thanks
Zishan
 
Sort by date Sort by votes
Looks like your array is fixed-size, so [tt]Erase[/tt] won't turn & bite. But, in the future, if you're using dynamic arrays & clear them with [tt]Erase[/tt], it also releases the allocated memory for the array itself; you'll have to do a [tt]ReDim[/tt] to reset the dimensions before you can reload it.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

ziffer68
  • Locked
  • Question
Pass Through query to create an alias for DB2 member
Replies
0
Views
286
ziffer68
ziffer68
btamsgn
  • Locked
  • Question
How to edit column chitoi into TableA
Replies
0
Views
85
btamsgn
btamsgn
Kennelbloke
  • Locked
  • Solved
Refer to Navigation Control Subform Record
Replies
8
Views
412
Kennelbloke
Kennelbloke
btamsgn
  • Locked
  • Question
How to add lines from textbox to table 1
Replies
8
Views
148
MattGreer
MattGreer
renigar
  • Locked
  • Question
Code to write file path to field always writes to 1st record 1
Replies
5
Views
246
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top