Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-access > #9955

Re: Display User Data in Form

Newsgroups comp.databases.ms-access
Date 2014-10-02 06:42 -0700
References <5690c1fc-93f7-435b-b811-ab2de24afd70@googlegroups.com> <aabe5a35-beda-48d2-b62b-e47b567f3125@googlegroups.com> <53b19be5-ca7c-4797-a13d-fde071e8c62c@googlegroups.com> <26c0032b-170f-4401-bed7-2bc5257c506c@googlegroups.com> <fe78c927-302f-41f9-8864-a2c780bbff62@googlegroups.com>
Message-ID <8ec35446-b0ad-4cd2-bd3f-fb4ff29a2fdd@googlegroups.com> (permalink)
Subject Re: Display User Data in Form
From Jim Devenish <internet.shopping@foobox.com>

Show all headers | View raw

James

There is no need for the .value

I have explored TempVars further and find that it acts completely like an array.

Public Sub testTempVars()
    TempVars.Add "theEntry", "today is Thursday"
' use the value
    Debug.Print TempVars("theEntry")
    
' change the value
    TempVars("theEntry") = "tomorrow"
    Debug.Print TempVars("theEntry")
    
' add another entry without using the .Add method
    TempVars("newEntry") = "Saturday"
    Debug.Print TempVars("newEntry")
End Sub

This produces output:
today is Thursday
tomorrow
Saturday

A very effective concept

Jim

Back to comp.databases.ms-access | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Display User Data in Form Anita Arnold <honolulalu@yahoo.com> - 2014-09-22 10:42 -0700
  Re: Display User Data in Form Patrick Finucane <patrickfinucanetx@gmail.com> - 2014-09-22 12:18 -0700
    Re: Display User Data in Form Anita Arnold <honolulalu@yahoo.com> - 2014-09-22 12:22 -0700
    Re: Display User Data in Form Patrick Finucane <patrickfinucanetx@gmail.com> - 2014-09-22 12:22 -0700
      Re: Display User Data in Form Anita Arnold <honolulalu@yahoo.com> - 2014-09-22 12:25 -0700
        Re: Display User Data in Form Patrick Finucane <patrickfinucanetx@gmail.com> - 2014-09-22 14:32 -0700
          Re: Display User Data in Form Anita Arnold <honolulalu@yahoo.com> - 2014-09-23 03:53 -0700
            Re: Display User Data in Form Patrick Finucane <patrickfinucanetx@gmail.com> - 2014-09-23 06:52 -0700
  Re: Display User Data in Form Anita Arnold <honolulalu@yahoo.com> - 2014-09-25 04:34 -0700
    Re: Display User Data in Form Anita Arnold <honolulalu@yahoo.com> - 2014-09-25 04:49 -0700
      Re: Display User Data in Form Patrick Finucane <patrickfinucanetx@gmail.com> - 2014-09-25 11:02 -0700
        Re: Display User Data in Form Anita Arnold <honolulalu@yahoo.com> - 2014-09-25 12:13 -0700
          Re: Display User Data in Form Patrick Finucane <patrickfinucanetx@gmail.com> - 2014-09-26 06:07 -0700
    Re: Display User Data in Form Patrick Finucane <patrickfinucanetx@gmail.com> - 2014-09-25 10:58 -0700
      Re: Display User Data in Form Jim Devenish <internet.shopping@foobox.com> - 2014-09-28 06:46 -0700
        Re: Display User Data in Form CDMAPoster@fortunejames.com - 2014-10-01 11:48 -0700
          Re: Display User Data in Form Jim Devenish <internet.shopping@foobox.com> - 2014-10-02 06:42 -0700
            Re: Display User Data in Form CDMAPoster <CDMAPoster@fortunejames.com> - 2014-10-02 09:35 -0700

csiph-web