Go Back   Access World Forums > Microsoft Access Discussion > Modules & VBA

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 04-15-2004, 10:30 AM   #16
sloaner14
Registered User
 
Join Date: Apr 2002
Location: lawton, ok, us
Posts: 32
Thanks: 0
Thanked 0 Times in 0 Posts
sloaner14
I understand the issues with size, but this what the client wants. What you have done is perfect, I just need the other information in the attendance table. If I try to explain the maddness, it may drive you insane. Like I said your stuff is perfect, I also need the other info. Please don't try to understand. lol

sloaner14 is offline   Reply With Quote
Old 04-15-2004, 09:05 PM   #17
RichO
Registered Yoozer
 
RichO's Avatar
 
Join Date: Jan 2004
Location: Wisconsin, USA
Posts: 1,036
Thanks: 14
Thanked 2 Times in 2 Posts
RichO is on a distinguished road
OK I think this is what you want...

The SQL statement in VBA just needed to be set up to pull all the rest of the fields off the form and store them in the table along with the dates. If that's what the client wants, so be it.

I also locked the continuous subform fields because they appear to be just there to display the class schedule and you don't want a user trying to enter data in them because that will mess up the table.
Attached Files
File Type: zip TSchedule.zip (36.4 KB, 106 views)

__________________
Access 2010, Windows 7
RichO is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump




All times are GMT -8. The time now is 10:30 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World