Search results

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.

Thank you Mihail. I'll post back as soon as possible..

Thanks for the reply. I did as what you have instructed. And the result I've found out that there are some codes that are not usable anymore in the database. I've also put: Option Compare Database Option Explicit in each module. But Still. Nothing Happens with the code.. I've learned...

I suggest that you would relink every front end to the back end database

Hi Mihail. Here I am again. The code greatly works above. but when I cut the code and paste it in the login button of my final db and run the database nothing happens. it only adds the record. And here's may be the cause of problem. The Data type of the StudentID field is not a Number but...

Thank you very much Mihail!!!