store the content of a field variable

  • Thread starter Thread starter Frank Dulk
  • Start date Start date
F

Frank Dulk

As I do to store the content of a field of several records in a variable and
separating each record for a line
 
Hi,

? CurrentProject.Connection.Execute("SELECT OrderID FROM Orders WHERE
OrderID<=10251 ").GetString(,,",", ",", vbNullString)



Note that you will have to remove the extra ending coma, from the result.



Hoping it may help,
Vanderghast, Access MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA: How can I use a string variable as autofilter criteria? 4
".recordcount" in a control on a form? 3
How to create a bubble chart with more than 2 variables 0
Clear contents of an unbound text box on a bound form. 2
Steam games store to 'allow everything' 5
Search function on a form 3
Validate the number of checkboxes that can be true 0
The newly created record is now shown in the form 3

Back
Top