Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
MS ACCESS -- VBA & REPORTS?
Ok, I have a database which contains data which HAD to be manipulated using VBA (don't ask me why, just trust me, it was necessary). I've managed to populate A series of arrays with all of the data I need to display on a report (the report already exists, the code executes on the report activation).
My question is, how do display the data in my arrays in the report. I should mention that I'm good with VBA, but a COMPLETE newbie to Access, so no SQL jibberish please.
2 Answers
- 1 decade agoFavorite Answer
i wanted to ask you why you are using array but since you think it is necessary i am not asking you :)
To display your data from array on the report you can use either text box controls or label controls and set their text (caption for label) property in the report's open event. like below
textbox0.text = array(0)
textbox1.text = array(1)
...
etc. You can even dynamically create as many control (text box or label) necessary depending on your array element count. that is a little tricky though.
best regards
iLC
- Anonymous4 years ago
u have not grant an entire code yet any approaches u only examine that ur merchandise variable isn't set via the SET key-word and declare it often delecration area would this could help u bye
