Looping on the data from a control on the form

  • Thread starter Thread starter thread
  • Start date Start date
T

thread

Hi all,

is there a way to loop on the data that implemented on the screen if
its a specific data from a control?
(text box for example)
 
i want to extract data from control that appears on the screen(it
bound to a query of course)
Douglas J. Steele כתב:
 
Do you mean you want to, say, extract 3 characters from a string starting at
position 8, or you want the 4 characters after the first slash, or something
like that?

Look in the Help file for functions like InStr, InStrRev, Left, Mid and
Right.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


i want to extract data from control that appears on the screen(it
bound to a query of course)
Douglas J. Steele ???:
 
no,my issue is that i want to pull data from a query via the screen
control and not direcly from a query

Douglas J. Steele כתב:
 
Sorry, I don't understand what you mean.

Can you give an example?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


no,my issue is that i want to pull data from a query via the screen
control and not direcly from a query

Douglas J. Steele ???:
 
Ok,let me maybe enter more to the details,
i need to export query direcly to an excel file,
is there an option for this?
but one of the things that import for me is that the data will be
exported to the excel file without the header row and will start from
a relevant reference of the file(row 3 for example)
do you have any tips for me?


Douglas J. Steele כתב:
 
Look at the TransferSpreadsheet method, or else consider using Automation.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Ok,let me maybe enter more to the details,
i need to export query direcly to an excel file,
is there an option for this?
but one of the things that import for me is that the data will be
exported to the excel file without the header row and will start from
a relevant reference of the file(row 3 for example)
do you have any tips for me?


Douglas J. Steele ???:
 
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

Unbinding all a Reports ControlSources 3
Excel Move or Copy Stopped Working? 0
Excel How to extract the data from Excel . 0
setting text box control sources in form on fly 2
Parameter Value error in a Subform 0
Access Form Refresh 1
LIne # on continuous subform 0
Fastest and most Efficient code? 13

Back
Top