Wrox Programmer Forums
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old August 18th, 2016, 04:52 PM
Registered User
Join Date: Aug 2016
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Dynamically fill form fields

I want to programmatically fill fields on a form with values stored in an array. Is there a way to do this without specifying the names of the fields? The code would look something like this:

Dim i As Integer
i = 1
Do While i <= vArrayLength
Me.Word(i) = ParseWord(Me.text, i)
e(i) = TranslateText(Word(i))
V(i) = CalcTextValue(e(i), 0, 0)

i = i + 1

Word(i), e(i) and v(i) are fields (Word1, Word2, Word3, etc; e1, e2, e3, Etc.)

Thanks in advance

Similar Threads
Thread Thread Starter Forum Replies Last Post
Fill out a web form mendy VB How-To 19 March 31st, 2015 02:28 PM
Using VBScript to Fill Out a Web Form adley VBScript 11 December 8th, 2011 01:47 PM
nTier example... how to fill form il_dandi ASP.NET 3.5 Basics 10 April 3rd, 2009 10:57 AM
Fill datasheet/Continuous form with vba code only Galateo Access VBA 0 May 9th, 2008 09:39 AM
auto-fill form crmpicco HTML Code Clinic 2 April 21st, 2005 06:42 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.