Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
|
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 December 31st, 2006, 08:47 PM
Registered User
 
Join Date: Dec 2006
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default using formula in access database design

I have two questions
Question no 1
I have two columns named A and B
Column A has a number
Column B will be Blank means no value is displayed there, but when accessed it shall return a date by adding the number in column A to the current date but doesnt store any value.

Question no 2
Is it possible to fill an entire column of data in an existing table

Yes I am new and dont know much about accesss data base.

js
 
Old January 3rd, 2007, 01:44 PM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Reply:

Question No 1: Huh?!?

Question No 2: Yes. Do an Append Query. If you have a table that is already populated and you have added a new column (field) then you can populate it using an Append Query basing the update on conditions in the other fields if you want to.



mmcdonal





Similar Threads
Thread Thread Starter Forum Replies Last Post
Help for Access formula firemedic2317 Access 3 July 28th, 2008 02:06 PM
asp 3.0 classic&access *formula retrival)? saad_rashad Classic ASP Databases 3 February 18th, 2007 03:47 PM
Database Design cf2006 BOOK: Beginning Visual Basic 2005 Databases ISBN: 978-0-7645-8894-5 4 August 2nd, 2006 03:50 PM
Database Design Help malhyp BOOK: Access 2003 VBA Programmer's Reference 1 November 3rd, 2005 06:33 PM
Database design, please help! mumick SQL Server 2000 0 January 13th, 2005 02:57 PM





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