Relationships & Tables

[StarGrabber]

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 are contained in the query of the subform? I transferred this query into a separate query object named 'qrySubformNew' and changed the subform's recordsource accordingly. In this query you are mixing the wrong tables if you want to add new records. You can now select another client's name (i.e. change it) but you cannot append records. Therefore I altered the corresponding subform property (otherwise the user gets an error message when he wants to save a new record).

What do you mean with the field "CommenceDateEnd"? Sorry, but this doesn't make any sense to me.

What exactly do you want?

 

[brucey54]

Hi Starbuck,

Firstly let me thank you for your patients, I will try to be a better student! J

I understand your comments regarding corrupting the database. What I’m trying to achieve is something similar to Database_mod3.mdb.

• Under the CarerAvailability_Label I would like to add a date field i.e. labelled ‘Commence Start Date’ and ‘Commence End Date’. The idea behind this I can then flick through the form to find the appropriate week.

• I would like the subform Rota Details to include the clients address details.

• The subform to display only the client’s details entered for the carer for that précised period of time .i.e. if I create Commence start date and Commence End date for a period of one week, I only want to see the client details in the subform Rota Details for this period.

At the present moment if I select a Carer from the cboCarerID, I will see all his clients.

• I would like to switch off the Navigation buttons from the main form and the subform and add Command buttons to the main form to control both forms and also to add a new record and print the rota from the subform.

I have attached image to give you a better idea.

Brucey54

 

[StarGrabber]

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 List" (upper subform).

To the second point:
You can easily include the client's address details in subform Rota Details as you did already. But then you won't be able to add records as told in post # 21.

To the third point:
Database_mod5 offers you exactly this functionality! Regarding your statement "At the present moment if I select a Carer from the cboCarerID, I will see all his clients", I get the impression you never worked with Database_mod5.

To the last point:
At the present state of Database_mod5 you don't need those (you can hide the navigation buttons of "Rota details" by setting the corresponding subform property to "No"). But if you think you do, go ahead and learn by doing.

Maybe there are two different logics colliding here. Yours and mine. In this case I'm not the right one to help you. I'm sorry.

Anybody who wants to jump in, feel free to do so.- This would be much appreciated.