Recent content by mykil

Thanks Much.

The purpose of this code is for the user to know how many times he/she loggedIN in the Computer Laboratory every week. This code works fine before I changed the ID number Format. Dim StartDate As Date, TotalLogins As Long, LoginsThisWeek As Long StartDate = VBA.DateTime.Date Do Until...

You just saved my day. Thanks a lot. Another thing: Is there something wrong with this code: LoginsThisWeek = DCount("StudentID", "tblLogins", WhereClause)

Hi Everyone. I have a Database for Logging students every time they want to use the Computer Laboratory that works perfectly fine. I have a StudentForm where I input all the students data and a LoginForm where I add them whenever they used the Computer Laboratory that is by entering their...

:banghead::banghead::banghead: I'm creating a form which stores a grade of a student for specific subjects. What I wanted to do now is to have a textbox which will calculate the average grade of the student using VBA. For Example, The fields to be filled in are: MATH1, ENGLISH1, SCIENCE1, and...

Thanks a lot!!! You're link really helps!!!

Hello everyone!!! Do you have any code for viewing Report between two dates. So when you open the report it will ask for the starting date and ending date. Any help will be much appreciated!!! Thank you in advance!!!

calling it the

New York City

and go back

Ah. I've got your point . Thanks for the Info Mihail:)

I opened your attached db. But when I opened the form frmlogin an error message pop up: which is the StudentIsLoggedIn = false. Do this [StudentIsLoggedIn] code has something to do with something? I don't know what is it for.. Can you tell me.? And, what I did is I deleted the code and the...

Hi Mihail. I've copy the code now under the BeforeUpdate event and delete it from the command button Click Event. Also I change the control from StudentID to ID_Student. And now, it produces this error: Thanks a lot!!!

Here's how my db should: 1. Login Students (More likely 50 students per day) 2. Record the number of times a single student log in per week. 3. Limit each student to use Comlab 3 times per week only. (Prompt the user if the student exceeds) What I want to build is just a Simple logging...

Try this: relink your FE to your BE. Go to Tab menu External Data Tab and go to Linked Table Manager. That will allow you to relink your splitted db.