Search results

Well, I tried to use it but nothing happens:confused: I attached my database if you could take a look. Thanks,

Yes, sorry, by saying field I ment textbox :) Thanks a lot for a code I will try use it, I belevie I should enter something between "" but I'm affraid I don't know what. Could you write exactly how that should looks like or give an example? Thanks , matt

Hello, I'm looking for a code which will be checking the date of birth entered into the DOB field (i use dd/mm/yyyy format). If the person is over 18 years old the value in the 'Permission' field should change to 'No Needed' BUT if a person is under 18's the msg box should appear eg 'Please...

By using a macro I tried to make it simpler, I am doing a project for A2 Level and I’m afraid I would not be able to describe fully the code you gave me in the implementation section:eek:

I created a macro to run this code: If InStr(1,[email],"@")=0 Or InStr(1,[email],".")=0 Then MsgBox "Please enter an email in the name@domain.com format." Cancel = True End If and then set the macro in the BeforeUpdate event. But it did not work:confused: Is there anything that I...

Thanks a lot! :) But I think I will chage it just a bit :D Regards, Matt

Hello, Is that possible to set the attributes so that when I enter "Mr" to a "Title" field the "Gender" field will automatically change to "Male"? Or is that just a data duplication? Regards,

Hello, I was looking for the validation rule or input mask for an email but I could not find anything what would match what I need. Any ideas how can I validate an email or use an input mask for it? Thanks, Matt

Thanks that works :) I made stupid mistake, as the Data Type I gave Text not the Date/Time. That's why it did not work. Thanks again, Matt

What did you mean by 'format' section? The Format section under the general section of the field? If yes, then it still does not work. Regads,

Hello, I have table tblMembers where I have a field Date of Birth (DOB) i set a input mask 00/00/0000;0;_ and validation rule <Date() . But when I have entered 31/01/1985 an validation rule has blocked it. Besides when I have entered 29/01/2008 the msg has not come up! What is a problem? P.S...

Thanks! :) That works as I wanted it to works :) Now I have to just make few changes to find exactly what I want :) Many thanks again! Regards, matt

Hello, I want to ask if it is possible to total the number of rows with the same data in the specified field. Let's say that we have students A, B, C and D. There are ability levels 1, 2 and 3. The table shows: Student Ability A 1 B 1 C...

Hello The problem is because I have to create a report showing the total attendence in the chosen month and I don't really know how to start. I suppose that I will have to create a query first (or module). I have an attendance table showing students and attendance date. I have just these...

Thanks for help! :) The method you told me is really usefull however that was not a problem with the code. The data type conversion error was appearing because there was an error in the qAttendance query. This is SQL that I used first: SELECT tblStudents.LastName & ", " & tblStudents.FirstName...

thanks! that was really helpful! :) This is code that is used: Option Compare Database Private Sub cmdAddAtt_Click() On Error GoTo Err_cmdAddAtt_Click Me.txtNotice = AddAttendanceRecord(Me.lstStudents) Me.lstStudents.Requery Exit_cmdAddAtt_Click: Exit Sub Err_cmdAddAtt_Click...

Ok, no problem :) thanks for help anyway, Regards, Matt

I will try the code you suggested. The dropdown menu is not the best idea because I could not select all students at once. I tried to based my database on the example of database that I have found on this forum. I have attached this database and I would really appriciate if you could take a look...

I have used this code: Private Sub cmdAddAtt_Click() Dim db As DAO.Database Dim rs As DAO.Recordset Dim var As Variant Set db = CurrentDb Set rs = db.OpenRecordset("tblAttendance") For Each var In Me.lstStudents.ItemsSelected rs.AddNew...

can i create a macro which will run that code? I'm beginner in this programming things so i'm not really sure where should i include this code. Does that code add records just for the selected students? Thanks,