Search results

I am working on a database that collects results from a survey. The survey is generated into an Excel spreadsheet and I imported the excel spreadsheet to a table. The purpose of this survey is for students to rate teachers on a number of questions on a scale from 1-5, with 1 being poor and 5...

Thanks for all your help! I never thought about going the query route like that! It's 1:23am in Chicago right now, so I will be studying the code more closely after I take a rest :) You are right - I do have a button that says "Generate Schedule based off of Teacher Requests." My original...

Thanks for the reply. I noticed in the FindNext code you had the field. Does this mean that I do not need my TeacherIDCompared and PeriodIDCompared fields at all?

Thanks. I did remove that field for now. But I don't think that is going to help my "Type mismatch" error that I am consistently receiving... Any other ideas about why this might be a type mismatch?

Thanks once again for your time and knowledge. I took your advice and compacted the database and uploaded it so others could see if they could find my error. The error is on frmGenerateMasterSchedule when you click the button that says "Generate Master Schedule off of Dynamic Classes" I spent...

I had some trouble with .LastModified right after .Update As soon as I ran my code, I got an "Invalid Use of Property" error, so I commented it out as I was trying to figure out my other error. I went back and looked at the table, and both the teacherID and PeriodID are foreign keys to...

I am coming right along. A lot of changes with the code. Provided my previous post was a valid thing to do, my next error is a type mismatch error on the same lines: Me.Recordset.FindFirst ("TeacherIDCompared = " & TestTeacher & "" And "PeriodIDCompared = " & TestPeriod & "")...

Ahhh, so close to getting it to work! As it runs, I get a compile error on the PeriodID portion of FindFirst("TeacherID = " & TestTeacher & ", "PeriodID = " & TestPeriod & ") If I take the statement so that it only compares TeacherID and write it as FindFirst ("TeacherID = " & TestTeacher &...

Thanks once again for your help. Three quick questions: a. I declared varTest at the beginning, do I need to say at somepoint that varTest = Int((8 - 1 + 1) * Rnd() + 1) like we did in the previous code? b. Can you pick out what is wrong with the following syntax...

Thanks again for some feedback. I get a different error this time: rst2.FindFirst (varTest) That line I get an error saying "Operation is not supported for this type of object" However, when I check the value that is stored in memory, it picked up the right number (whatever the periodID that...

Ok, I am still running into trouble. Hopefully you can help me again. Here is a picture of my table - after the table is populated with the data (as it is in this picture), I want my code to check the last two columns - teacherID and periodID. My ultimate goal is that I want the program to...

Thanks. I will try that and see what I come up with.

Assign Random Variables Without Duplicates I have a pretty tough VBA question, and I am hoping someone could point me in the right direction to fix my code. Right now I am attempting to create a generic scheduling program, and the setup I am using is a school scheduling program. The goal is...

Thanks for that help. I am just beginning to learn VB and I worked with that Random formula a while ago, but just couldn't get the right setup. One more question: when I use the random number formula on my query, it gives the same random number to every record in the query. Is there a way to...

Quick question, how do I have access generate a random number between 1 and 8? I want it to generate either a 1,2,3,4,5,6,7, or 8. (no zero, no nine) Expr1: Fix(Rnd(8-1)*10*Rnd()) is what I have been using, but this always generates the number 2? I do want the decimals to be rounded to the...

Hello. Can this be done? I am creating a mini scheduling program, and I have one table that handles all requests (tblRequests), then a second table is the final schedule (tblFinalSchedule). On the table for the requests, I have a field called "locked" that is of type yes/no. The purpose of...

Quick question: How can I automatically bypass the messages "You are about to run a delete query that will modify data in your table."? I don't want an end user to see that message, I just want the delete query to run. Is there a way to get rid of that message without supressing all the...

Right now I have a field named "State" in a query that is based off of a yes/no field. When I put this field in a report, I want to see a capital "Y" if the yes/no field is checked, and I want a null value returned if the yes/no field is not checked. My thought was to add another field to the...

Thanks! That's exactly what I wanted.

I am having some trouble with my forms. Everything works in my database, but the way the forms are resizing is bothering me. Right now, I have a button on a form that brings up a report in print preview mode, and the report is maximized. This is what I want to happen. However, when I close...