Search results

Thanks a lot . I really appreciate for your help. Thanks

Thanks a lot. Actually I am trying to display timetable data in a matrix format in the form and able to make changes (teacher, room, day, time) in the form. You need to open frmTimetable then qryTimetable and qryTimetable_2

I attached error msg. I really don't get crosstab queries.

Thanks a lot It worked. But I did Crosstab query with this code. But it didn't work. PARAMETERS [Forms]![frmTimetable]![sbfrmTimetable].[Form]![txtDate] Text ( 255 ); TRANSFORM First(qryTimetable_2.Booking) AS FirstOfBooking SELECT qryTimetable_2.[Booking Start Time], qryTimetable_2.[Booking...

I attached Excel File. Basically, I am trying to display data in Matrix Format. Thanks

I am novice to MS Access. I have created small database. I've got SELECT Query StudentID Name Last Name CourseName StartTime FinishTime TeacherID RoomID 1 XX YY ZZZ 10:00 11:00 5 RoomA...

Pbaldy You saved me. It worked. Thanks a lot.

Here is my code. Dim apiKey As String Dim apiSecret As String Dim receipientMobile As String Dim smsMessage As String Dim callerId As String Dim sendtime As String Dim contactList As String Dim strResult As String Dim URL_base As String Dim str_POST As String Dim XMLHttpRequest As XMLHTTP Dim...

Here is my code.Can you help how can i refer query fields? Dim apiKey As String Dim apiSecret As String Dim receipientMobile As String Dim smsMessage As String Dim callerId As String Dim sendtime As String Dim contactList As String Dim strResult As String Dim URL_base As String Dim str_POST As...

Hi Pbaldy, I read your message regarding the problem Fazerer had. I have same problem. I have been trying to apply VBA code every single row that I need to retrieve some values into my code. But it only retrieves first row not others. When I write Queries![MyTable]![MyField] , It brings Error...

Hi Pbaldy, I read your message regarding the problem Fazer

I will try to explain. If i send it the Access file, You won't be able to find what I want. (it is a bit messy) I am trying to build up a form which allows me to send SMS. My database is students database. I have got 3 mobile numbers (student, Father and Mother) They give us which phone is...

Thanks mate. To be honest, I am not that much professional and good at programming and Access. Can you please help me more on your suggestion with "Alternatively create a dynamic query from the RecordSource and Filter properties of the form" Thanks

If any of you could help me on this, I really appreciate for it. I have a form (it includes several subforms but it is not important). Using Filter in toolbar I can narrow my data set. I got a query based on the same tables with this form. I just need to link somehow form and query. I want to...

I understand it. It is really much easier. Thanks for everthing.

Yesss I did it. Private Sub UPDATETEACHER_Click() Dim strSql As String strSql = "INSERT INTO tblTeachersAttendance (CoursesTakenByTeachers_ID, AttendanceDate, AttendanceDuration, AttendanceNote)" _ & "SELECT CoursesTakenByTeachers_ID, #" & Me.AttendanceDate & "#, " & Me.AttendanceDuration & "...

I did that but it is the same. I think you've made a mistake that you typed twice AttendanceDate twice instead of AttendanceDuration. I tried yours and changed the second one AttendanceDuration but it is the same error. I read something on forums now that Forms can be corrupted. I've checked...

Thanks for your help. I attached the tables and forms. Form : frmClassAttendanceEntry In this form. At the bottom, Update Teacher Attendance button has got problem. Thanks

it is General number field

I am sorry but I don't know how to send only tables. How can I?