Mike-
You can do that for control names.
Me("V" & x) = Something
To do it for variables, put the variables in an array.
Dim B (1 to 5) As String
B(x) = "Something"
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Lahaina, HI)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of mithomas48
Sent: Friday, January 27, 2012 6:59 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Dynamic Varialbe
Thanks Bill, but I'm trying to stay away from using a Select Case or If Else.
Isn't there a simple function or something that can dynamically change a
variable? For example...
In each pass the variable "b" would become b0, then the next pass b1 and so on.
Thanks again!
Mike
--- In MS_Access_Professionals@yahoogroups.com, "Bill Mosca" <wrmosca@...>
wrote:
>
> Mike
>
> Use a counter in the loop and a select case
>
> For x = 1 to 3
> Select Case x
> Case 1
> v1 = Something
> 'or
> Something = v1
> Case 2
> v2 = Something
> 'or
> Something = v2
> Case 3
> v3 = Something
> 'or
> Something = v3
> End Select
> Next
>
> Regards,
> Bill Mosca, Founder - MS_Access_Professionals
> http://www.thatlldoit.com
> Microsoft Office Access MVP
> https://mvp.support.microsoft.com/profile/Bill.Mosca
>
>
>
> --- In MS_Access_Professionals@yahoogroups.com, mithomas48 <no_reply@> wrote:
> >
> > How can I dynamically reset a variable within a loop - without using a
Select Case, or IF Else? For Example...
> >
> > First pass = v1
> > Second pass = v2
> > Third pass = v3
> >
> > So I need to dynamically set the last digit.
> >
> > Thanks in advance!
> > Mike
> >
>
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar