Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Programming / February 2007

Tip: Looking for answers? Try searching our database.

Microsoft Access VBA Multi-dimensional array

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
reneedaudert@yahoo.com - 19 Feb 2007 22:21 GMT
I need to know how to create a two dimensional array in Access that
inputs data from two text boxes and displays them all in a third text
box.  Here is what I have, but it does not work:

For x = 0 To 9
  sSortArray(x, 1) = TxtName.Value
  sSortArray(x, 2) = txtGrade.Value
x = x + 1
Next x

For x = 0 To 9
sDisplayString = sSortArray(x, 1) & "'s Grade is " & sSortArray(x, 2)
_
                     & vbNewLine
Next x

txtOutPut.Value = sDisplayString
Jezebel - 19 Feb 2007 22:36 GMT
You should read help on For ... Next loops. (What on earth is the 'x = x +
1' doing in there?)

>I need to know how to create a two dimensional array in Access that
> inputs data from two text boxes and displays them all in a third text
[quoted text clipped - 13 lines]
>
> txtOutPut.Value = sDisplayString
Rob - 20 Feb 2007 16:05 GMT
> You should read help on For ... Next loops. (What on earth is the 'x = x +
> 1' doing in there?)

He probably doesn't realize that in VBA the number automatically advances.
I've coded in C a bit and you have to do that. So what's happening is the
code is only doing even numbers, I think.
Jean-Guy Marcil - 20 Feb 2007 19:43 GMT
reneedaudert@yahoo.com was telling us:
reneedaudert@yahoo.com nous racontait que :

> I need to know how to create a two dimensional array in Access that
> inputs data from two text boxes and displays them all in a third text
> box.  Here is what I have, but it does not work:

For future reference, "it does not work" is in fact nearly totally useless
to those trying to help, even for seemingly simple problems.
There are always so many different things that can go wrong; especially when
we take into consideration our own personal expectations...
Next time it would be more helpful to write about the expected result and
the actual result so that we can better help you.

Also, this is a Word group. I know that VBA libraries seem similar to all
Office applications, but in fact they are not. So it would be better to
address Access issues in an Access group.

Cheers

Signature

Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
jmarcilREMOVE@CAPSsympatico.caTHISTOO
Word MVP site: http://www.word.mvps.org

reneedaudert@yahoo.com - 21 Feb 2007 01:31 GMT
> reneedaud...@yahoo.com was telling us:
> reneedaud...@yahoo.com nous racontait que :
[quoted text clipped - 23 lines]
> jmarcilREM...@CAPSsympatico.caTHISTOO
> Word MVP site:http://www.word.mvps.org

dang, i never realized how hostile people were in these things... hey
thanks for nothing, i figured it all out on my own...
Jezebel - 21 Feb 2007 02:11 GMT
You ask for help on a page one problem, you get three versions of the
answer, and you ignore them all. No wonder you have problems. Back under
your rock!

>> reneedaud...@yahoo.com was telling us:
>> reneedaud...@yahoo.com nous racontait que :
[quoted text clipped - 28 lines]
> dang, i never realized how hostile people were in these things... hey
> thanks for nothing, i figured it all out on my own...
Jean-Guy Marcil - 21 Feb 2007 15:40 GMT
reneedaudert@yahoo.com was telling us:
reneedaudert@yahoo.com nous racontait que :

>> reneedaud...@yahoo.com was telling us:
>> reneedaud...@yahoo.com nous racontait que :
[quoted text clipped - 16 lines]
>>
>> Cheers

Hostile?

Since when signing off with "Cheers" is hostile?
Did you notice the first three words of my post: "For future reference"?
I was giving you advice, not being hostile.

If you cannot tell the difference between being hostile and being helpful, I
think you will have difficulty in these groups. Remember that all
participants do so of their own free will, nobody is being paid here... I
notice that your post may not give you the help you need. So I took it on my
own to try to help you next time you post so that all involved can be more
efficient.
Sorry for caring.

Good luck anyway.

(By the way, I DO know the difference between hostile and helpful/polite,
believe me, I was very far from being hostile.)

Signature

Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
jmarcilREMOVE@CAPSsympatico.caTHISTOO
Word MVP site: http://www.word.mvps.org

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.