Thank you June7.
Sorry, how can I change aryNums source to a table instead of Text box? If account numbers are getting through a table (tblNewAcc[Accounts]) instead of text box.
Steve,
Thank you for the file. Will check it out.
Thank you June7.
Sorry, how can I change aryNums source to a table instead of Text box? If account numbers are getting through a table (tblNewAcc[Accounts]) instead of text box.
Steve,
Thank you for the file. Will check it out.
How does the data get into the table? I thought you are copy/pasting into an unbound textbox?
The array code won't go away if the data is still a multi-line string.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Initially they will copy & paste account numbers in Text box, then after will open tblTemp form for further filling information. When click on a button from this form, need to check above conditions. This is a regular table NO multi line in a row.
So, i like to revise aryNum source form Text1 to tblTemp[Accounts]
If i simply set
aryNums = tblTemp[Accounts]
For i = 0 To Unbound(aryNums)
will this work?
Thank you June7 for your continuous support.
No. Now the code will loop through records of the form or a recordset object and the array goes away.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
June7, how can I revise that VBA?
Here is information about working with recordset objects.
http://www.everythingaccess.com/tuto...ith-Recordsets
http://allenbrowne.com/ser-29.html
http://msdn.microsoft.com/en-us/libr.../ff820966.aspx
Also, RecoredsetClone can be quite useful.
http://msdn.microsoft.com/en-us/libr...ffice.11).aspx
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Thank you June7