Search results

the senior developers should assist the newbies instead of pointing out posts which will lead to nothing. There are many comments about the post and my comment on other form but not a single comment regarding my question. As mentioned in my intro post i mentioned few names that are always...

I have created a database and want to distribute the database over network. Is there something that i want to do so that there will be not data loss of duplication as the same database will be used by two or three users means they will be entering data in the same table. kindly guide.

what changes are required now ? the code is working fine for me. If i missed something let me know :)

did what you said but the old macro is still not working. i have written a vb code from google search and its working. Private Sub Command47_Click() If IsNull(Me.clasS) Then MsgBox "Please select a server." Me.clasS.SetFocus Else DoCmd.OpenReport "AttendanceLog", _ acViewPreview, _...

what will be easiest solution ? cant chagne and relink the whole db. kindly tell the easiest soulution accordint to the current situation i have on db. thanks

i have attached the db.

the first part of the macro is running fine if i enter it seperately. [atdate]=[Forms]![student_attendance]![dates] the part after the AND is creating blank report/result [stclass]=[Forms]![student_attendance]![class] and ultimately if i combine both of these via AND clause the report opens...

not working i have attached the screenshots after updating the macro code. also let me know what should be the record source of report? the actual table where i am saving attendance log or the query which is selecting the records?:confused:

="atdate = #" & [Forms]![Student_Attendance]![dateS] & "# And somefield = '" & [Forms]![Student_Attendance]![clasS] & "'" i have ammended my code as per your code given above and here is my code after adding the value ="atdate = #" & [Forms]![Student_Attendance]![dateS] & "# And stclass = '"...

I am trying to open an access report based on two criteria on my form. here is the macro i am using. ="atdate = '" & [Forms]![Student_Attendance]![dateS] & "'" for a single criteria it is working fine. but i am unable to add multple criteria for report. Here is the code i wrote for multiple...

the error i posted is the result of same steps you are mentioning

am i doing it right ? Private Sub Report_Load() Report.OrderBy = "[termttl]*0.4 + [stmttl]*0.6 Desc" End Sub

dnd't got your point :confused:

i have a calculated field in access report and when i sort report on that field it gives me this error. Operation is not supported for this type of object the field is from a table where it is calculating average of 3 other fields.

i am using switch statement on report to define a criteria. Here is the switch statemtn code i am using...

will give it a try and let you konw

Finally i have completed most of my form design and code and now i want the form to be loaded without any menu or ribbon of access. Also i want to disable message when entering a data into table via query. So what type of code or action/s i need to achieve the task?

[SOLVED]: Attendance Sheet Format finally i figured it out. here is the code that worked for me. Private Sub present_Click() DoCmd.SetWarnings False DoCmd.RunSQL "UPDATE dbo_adm SET dbo_adm.attype = 'Present'" DoCmd.SetWarnings True Me.Requery...

i need a button that can chage the comboBox value to Present before the user can mark the attendance

I am attaching two images of my form and also written some requirements on those images. The mark all button on the form is marking all the stuent present and saving in Attendance log tble. But my requirement is still the same that i want a button on the form that can change the status of all...