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 May 3rd, 2007, 09:22 AM
Authorized User
 
Join Date: May 2007
Posts: 33
Thanks: 0
Thanked 0 Times in 0 Posts
Default VBA code for entering the same data for dates

Hi,

Is there a VBA code to enter the same data over and over for a range of dates.....For example if an employee wants to update his login and Logout time for a range of date from 12/01/2007 to 12/31/2007. The login and logout times are going to be the fields and the date is also a field....the code should allocate the same login and logout time to all the fields for the date range in question, in case there is variation there should be a seperate code to change the login and logout time....Also the 3rd part of this code should lock the user's ID for his own login and logout time and he should not be able to manipulate others records...I think creating seperate forms for all the users is not the right way...one form should have a button which will enable the user to update his records and he should not be able to manipulate the records of others....Is there a neat code for this....or can somebody help me with the programe for this kind of scenario......

 
Old May 3rd, 2007, 09:45 AM
Authorized User
 
Join Date: May 2007
Posts: 33
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I think the way to lock the users from manipuilating others data is by calling the logon Window from the code and then recognising the Employee ID. Also to add to it the employee should not have to repeat his ID, Address, Manager's Name these should automatically get picked from the code and should fill the table with which this code is connected....In short anything which is repetitive should be taken care by the code....






Similar Threads
Thread Thread Starter Forum Replies Last Post
Entering data into an SQL database jmsherry SQL Server 2000 3 July 24th, 2007 01:00 AM
Using VBA Code to Move Data Nanette Access VBA 1 November 3rd, 2006 04:16 PM
Entering data to dynamic table cells weebadbilly XSLT 0 June 30th, 2004 07:15 AM
Entering dates. mildge Beginning PHP 1 January 29th, 2004 07:24 PM
entering data Kelly Johnson Classic ASP Databases 1 August 7th, 2003 07:36 AM





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