Search results

I think I see where you are going with this. I will test this out and post back. Thank you for your help so far, it has been very helpful and educational too.

So I would have 2 queries - 1 for 1-day and 1 for multi-day? How would I select this option then? The user menu item is just a radio button when selected shows a drop down to select class, then another button runs the query. There is no notification that the class is a multi-day class.

I am missing something... I am getting a debug error when the db is trying to open Word. Set appWord = CreateObject("Word.Application") I did add the *.olb files located in MS Office/Office11

Thank you all. I will check out that example and see if that'll work better then just a copy of the FE.

The data is spread out through quite a few tables. here is the SQL: SELECT DISTINCT tblBaClassSchedule.ClassDescription, tblBaClassSchedule.ClassScheduleID, [FirstName] & " " & [LastName] AS StudentName, tblBaStudents.LastName, tblBaClassSchedule.StartDate, tblBaClassSchedule.EndDate...

Well it works great for 1-day classes, but not on multi-day classes.

It was listed and I unchecked by mistake. I thought I must have needed it because it was there previously.

OMG..that seems so simple [now :)]. Thank you. That is precisely what I want. I think I was over thinking this.

I'll check that, thank you. I have not been seeing any usability issues, so I may be ok either way.

No I need only the records where AM = -1 AND PM = -1 each student will have both fields and it is possible they miss either one. The query needs to pick up only records where the student showed up for both.

Question about this. For testing purposes, if the data isn't going to change, is it possible for me to just copy the FE, rename it and use this new file for testing forms, rpts and qrys?

I am on the right track with the IF STMT, but instead of a -1 or 0 I need to only show the -1. Is it possible to change this to combine [AM] and [PM] in one selection but have the criteria to be -1?

It's more complicated than that. The classes are referenced by [ClassID] and the days are set as [DateofClass]. There is another Class Table that lists all the Class ID's and class names.

That works! Thank you. My query is used to print completion certificates. I think this stmt will work great for the 1-day classes to weed out the no-shows, but I'm not sure if it'll work on the multiple day classes. I will definitely implement this tonight and check it out. Thanks again.

Is there a way to write an IF THEN expression inside a query? I have an attendance table with AM and PM checks. I want to have a result of 0, -1 if both the AM and PM checks are -1. I have this so far, but don't know if it's correct or where to put it so it works, my tests so far have all...

I read through this...does the decompile method work as well as it states? I have a 65mb FE and it can take awhile to load up.

This may help you. It refers to the I/O Error 6 and suggests the registry may be corrupted and covers steps to fix. Link

OK, that didn't work. Most likely as the listed code is for a hidden button that isn't linked to the outcome. As far as I can tell the code that generates the class listing is in a subform and here is the code:Private Sub Form_Load() Dim datCurrentDate As Date Dim strRowSource As...

I was trying to uninstall office 2007 trial manually and found a reference that said to uncheck the bindings for Office 12 in Access. I unchecked the office 11.dll by mistake in the available references and I can't find what .dll I need to recheck or reinstall. I looked and don't see Office...

That did it! Thank you both so much. I have to wait until after hours to implement and test.