Search results

If you want me to test your application you have to upload it complete, but with sample data naturally!

My suggestion was your continuous form is bound to a table or query and displays at least one record. I tested the code before posting successfully so I'm sorry for the error MsgBox. Maybe the command rs.MoveFirst before starting the loop helps. But... tell me, why do you use the control values...

Use the record source of the form as follows: Private Sub btnAddAppointmentItems_Click() On Error GoTo ErrHandler Dim rs As DAO.Recordset Set rs = Me.RecordsetClone If rs.RecordCount = 0 Then Exit Sub End If Dim olApp As Object Dim olAppt As Object If...

Open "Database_mod5" once more. To the first point: There is no need to add the date fields ‘Commence Start Date’ and ‘Commence End Date’ in order to flick through the form, because you have this functionality already - including precisely these two fields. Select the desired week in "Rotas...

Hello MBKN2013, welcome to the forum! I'm not sure if I understand your intention right. Do you want to save pictures in a table or only load them to be displayed in a form?

Hi David, in attached file you'll find my solution for your task. Please note the tables are empty. I didn't want to upload bitmaps. ;) For further details refer to the contained module.

Yes, that's possible. An example how to implement password functionality you'll find here: http://www.access-programmers.co.uk/forums/showthread.php?t=226927

Assuming 'QuoteNeeded' is a checkbox and 'CusomerActive' a textbox you can use the following code: Private Sub QuoteNeeded_AfterUpdate() If QuoteNeeded.Value = -1 Then CustomerActive.Value = "active" QuoteNeeded.Locked = True End If End Sub That's all? Or... am I...

With my statement "Change whatever you want..." I didn't say "corrupt your database". But this is what you've certainly done. As a consequence "nothing seems to work any more"! Why do you put the textboxes 'CommenceDateStart' and 'CommenceDateEnd' on the mainform although their control sources...

Hi meq, welcome to the forum. You're "looking forward to learn some cool stuff here"? Well, we will see if that stuff is really cool... Assuming you use the ParentID as a foreign key in the student table you should delete the field NumOfStudents. For the count you better use a query like...

Change whatever you want as convenient.

Hi Tom, please find attached a different solution for your project.

And here is a slightly improved version. Finally the DLookup function worked (so the code module of 'sfrRotaDetails' contains only one procedure now). Beyond that it is now possible to start a new shift at the same minute the previous one ends. :)

With VBA nearly everything is possible, but this is not a good idea. Far too complicated. It would mean the carers are restricted to only one shift a day. But in post #12 you ask for a validation logic that refers to more than one shift a day. You'll find a solution for this case attached...

Replace "Formulare" by "Forms" in the criteria field of 'qryRotaDetailsPerCarer'. I apologize for the detail I've missed.

Hi jchar, see my solution in attached file.

Alright then - good luck with your project!

At this point I think you should have a look at the attached file.

Symply by adding some more parameters: "SELECT SpeciesTB.Species FROM tblSpecies WHERE SpeciesTB.Species IN (" & strCriteria & ") AND Year(yourDateField)=" & yourYearCriterion & " AND SpeciesTB.yourAreaZoneField=" & yourZoneCriterion & ";"

Maybe I can show you, but what do you exactly want the code to do? In the lines I gave you, you can see how the selection of species is passed to your query (--> recordset).