Recent content by yaro.kobzar

Awesome thanks it worked! Here's the file name that was created: Class RosterPrehn05272011 Is there anyway to put a space between Class Roster and Prehn and a space between instructor name and the date?

Hi everyone, I'm have created a button on a report that will export the report to an excel datasheet. Here is what I have as the code... DoCmd.OutputTo acOutputReport, "Class Roster By Instructor ID", acFormatXLS, "S:\BasicSkills\BaSIS Output\ClassRoster" & Format(Date, "yyyymmdd") & ".xls"...

Ok I think i got an idea of what i want it to do... I took your advice and made it a combobox and made it much easier... Here's what i have: The Query Class Roster Master Group has two columns: Class Numbers and SumOfCountOfStudent ID. The class numbers are 1-30 for each class and the other...

all right... what do you think about this idea... I have a query that already counts the totals for each class. Would it be easier to link that query with the item number when registering so that it will lookup what the total is and if it is <30 allow the registration?

thanks spikepl. I understand now how it works... here's another thing: we have for example 4 different classes (each separated by a 4 digit number like 4000, 4001, 4002, and 4003). And each class has a different number of maximum allowed of records (registrations). Class 4000 and 4002 can have a...

"count the records using the function Count. Disable possibility to ad records, once the count reaches 30. Perhaps display a message saying so, or show current count at all times. Enable the possibility to add records if count <30. " Hmmm that's a good idea. I understand where you're going...

Hi everyone, I have a form called Student Records, which contains a subform that is linked to another query (Students and Classes Query) which can be used to edit student information and class registration. I need to create a limit on a number of records that can be registered in the query to...

Hi everyone, I'm new here and I need some help. I have been developing a registration access database and got stuck at one spot. I have: classes, instructors, and students tables class rosters, instructors-classes, and students-classes query's class roster, instructor records, and student...