Search results

Hi, First of all, I have a report that runs a parameter query identifying which StudentID it wants to run the report of, and what month/year. I want to leave the month/year as a parameter, but what I want to do is get the record that I selected from the listbox (IE. student 1000) and then...

Hi, So I have a grade database, and I want to make sure I don't input the student's grade twice. I only input grades once a day, since there are a fixed amount of grades that a student will have everyday. Each student has his ID, and each student has a day for whatever his grades entered...

I have a problem here that I've been wrestling with for a while. I have a table, ID, Date, and Grade. It is set up that way, and I tried SELECT tblGrades.StudentID, tblGrade.Grade, Max(tblGrade.GradeDay) FROM tblGrades GROUP BY tbGrades.StudentID, tblGrades.Grade; I figured since I'm...

Hi, I was wondering how I could run an append query from table A to table B that only appends data that is not in table B. I want the primary keys of A to be exactly the same as B, because I will use B as a blank slate (another append query to append info to another table C with all the...

Hello, I was just wondering why my vba code wouldn't work. I have a scorecard form, and what I wanted to do on a form was that if a user enters a number in a bound box (to a table), it would automatically update an unbound box. So I coded it as this. Private Sub...

Hi, I was just wondering if there is any way to transfer the data in an unbound textbox into a separate table. User enters an amount into a textbox2, and then it does some calculations that involves textbox1 and textbox2. Finally, textbox3 has the final answer. Can textbox3 overwrite...

Good afternoon. I am an intern at a manufacturing company. They asked me to migrate all of their excel spreadsheets onto MS Access. I pretty much drew out the ERD and created tables, but I had some cool ideas on how to track things, but I have no idea how to start. First of all, I was...