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...

Nvm I figured it out :D I used the CDbl function in a hidden textbox

Wow that worked wonderfully. Thank you very much. Now the last mission is... to convert the 100 75 50 25 0 to 100% 75% 50% 25% etc. if I do the [Text30] & "%", an error pops up. If I change it on the recordsource query, another error shows up. How can I make it so that it shows the percentage...

Thanks, that helped a lot. A problem I ran into is that since it is a continuous form, there are more instances of Text30 within the form. Is there any way for me to limit the textbox from being changed to the particular data? For example, Request was 1 for RatingID 1, hence Text30 should be...

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...

I'll give it the rest of the week, and then if I'm really stuck I'll talk to my manager about the status :p

I've been trying but nothing seems to work :(

Okay, can you tell me anything about unbound textboxes being written into tables?

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...

Ohhh.. I see. That actually makes more sense. Thank you!

I want to keep track of how many are produced daily... so at the end of the month we get a daily avg which will be useful later when doimg analysis

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...