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 September 24th, 2005, 09:52 AM
Registered User
 
Join Date: Jul 2005
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default access textbox controlsource

HI,
I am using a function to add items on each row on a subform. This function is called from the controlsource of a textbox. I would like to add the value of the textbox to a field so I can use it in reports. Is there a way to bind form textbox values to a table when the controlsource is already in use?
Thanks


 
Old September 26th, 2005, 06:12 PM
Friend of Wrox
 
Join Date: Jul 2005
Posts: 150
Thanks: 0
Thanked 0 Times in 0 Posts
Default

You really do not want to save the calculation. You can use the exact same calculation methid on your repoort.

Boyd
"Hi Tech Coach"
Access Based Accounting/Business Solutions developer.
http://www.officeprogramming.com
 
Old September 27th, 2005, 09:30 PM
Registered User
 
Join Date: Jul 2005
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
quote:Originally posted by AccessMaster
 You really do not want to save the calculation. You can use the exact same calculation method on your report.

Boyd
"Hi Tech Coach"
Access Based Accounting/Business Solutions developer.
http://www.officeprogramming.com
 
Old September 27th, 2005, 09:34 PM
Registered User
 
Join Date: Jul 2005
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
quote:Originally posted by spareparts
 
Quote:
quote:Originally posted by AccessMaster
Quote:
 You really do not want to save the calculation. You can use the exact same calculation method on your report.

Boyd
"Hi Tech Coach"
Access Based Accounting/Business Solutions developer.
http://www.officeprogramming.com
Hi,
Thanks for the reply. I was hoping to be able to output the report in word and I need a sql string for that. But I see what you are saying and I should look to vba to fill the table. I just don't know how to do that.
Currently the table is filled through a loop that inputs fields via a sql string.





Similar Threads
Thread Thread Starter Forum Replies Last Post
Saving textbox data into Access iostream212 VB Databases Basics 0 July 20th, 2008 09:58 AM
Connect textbox to Access field aya_hbkenshin04 Classic ASP Databases 0 May 3rd, 2006 12:52 PM
how to access label or textbox in crystalreport howru_sweety Crystal Reports 0 February 27th, 2006 02:44 AM
Access 2003 - Adding Textbox at runtime? ashish_kamdar BOOK: Access 2003 VBA Programmer's Reference 5 February 17th, 2006 01:18 PM
controlsource binding on text boxes eng Pro VB 6 0 October 10th, 2005 04:27 AM





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