Recent content by thaonguyen

Hi everyone, Here is the database. It seems to be working for what I intended (80%). So after I click on "Show registers", an Appen query is ran where the data is saved into the table tblClassAttendance and Status is set to Present but the Tutor can change it. Because of the Text28, it doesn't...

The only thing that messes this thing up is the Macro that opens the form but again, there is just one action in that Macro...

Hi Ranman, I did that too and still couldn't find Text28 anywhere...:banghead:

Hi arnelgp, I already did. I looked under queries, criteria and I even attempted to delete the forms and started the 2 forms again but every time that "Log Attendance" button is clicked, the error pops up.

Hi everyone, So I am just modifying a free and existing database that I found to suit what I want because I am not super familiar with Access. I have a form called frmHome with 3 buttons. First button called "Log Attendance". On Click, another form called frmClassAttendance is opened with a...

Hi everyone, So I am making an access database to check attendance of our Accountancy classes. I have - tblClasses: with information of ClassID (PK) day of the week, morning/ afternoon, tutor, classID, level (3 or 4) - tblLearners: with information of all our learners LearnerID (PK), fullname...

Hi everyone, I am a beginner of Access and I want to build this form to help my company be more environmentally friendly. We are a training provider. So we have a database of learners with a column of the day in the week that they take lessons at our place and another column with AM or PM...

Also, is there a way to prevent copy and paste records or put a password to it? I can do with the forms but not the tables.

Thank you both. I will play with the idea and see how it goes. It's much clearer now when I'm pointed at the right directions.

That's it!. I tried the >= before but I missed out on the last part >=Nz([forms]![Search]![Combo195],"0") Thank you so much. It works like magic!

Hi Mihail, I think you might have misunderstood what I meant. I am happy with the other search criteria. What I hope to change is the "Rating" (Combo195). Right now, I have 5 options as "1 star", "2stars", "3stars", "4 stars" and "5 stars". I want to change them to "1+", "2+", "3+", "4+" so...

Yeh, I know that. I did this for my boyfriend, who is an English teacher and he prefers it this way. I did tell him. Looking into that now. Thanks a lot. You're a star!

Oops, choose 3+ for example...

Right now, on the Rating criteria it's just 1 star, 2 stars... I want to change it to 3+, 4+ so that when you choose "3 stars" for example, it includes the records that have 3 stars, 4 stars and 5 stars. For the other criteria, I'd like to keep it as it is, which is a combination of OR and AND...

Oops, sorry. I forgot. You did say it before. Here you go. Hope this works