Search results

I think you might have found the problem. The txtApptNotes is bound to the appointment_notes field in tblAppointment. I haven't bound anything to the ID. How do I correct that?

Thanks jdraw. I'm a relative beginner with Access so it's interesting to see how you write your code. I've learnt a few things from picking it apart so thanks! HoweverI think Ranman256 has nailed the problem but I don't know how to fix it.

I suspect this comes down to a lack of understanding but I've spent a couple of hours going down rabbit holes so I think I need a bit of help before I let it ruin my evening! This is my update statement: DoCmd.RunSQL "Update tblAppointment SET tblAppointment.appointment_notes = txtApptNotes...

Works like a dream. Thank you :)

I'm trying to conditionally format a long text field in a continuous form. The form only shows the first line of text so I want to highlight the field if it consists of more than one line i.e. if it contains a vbCrLf. In code I can do this easily enough on a normal form for one record with...

See my response to MajP. Cheers

Thanks for this. It actually encouraged me to do a test DB which I attached in my reply to MajP. I'm not familiar with cross tabs in Access so it's good to see how you've put it together. I've actually built a dashboard using Access charts and the issue I have with the count is part of a problem...

Thanks this is really useful. The tblMonths makes a lot of sense. I had already built qryCountCounselorAppts in a more convoluted way so you've helped a lot to refine it. I am however now stuck on the very last bit where I couldn't get the join to work. In the world of Venn diagrams what I'm...

For the life of me I can't get this to work. I need to identify on a 12 month rolling basis by month how many counsellors didn't have any appointments. It has to take into account their start and end dates of employment. If the end date is blank they are still employed and if the counsellor is...

Sorry you're both right , over tired, I meant I'm not keeping a history of any change of counsellor attached to the appointment

Now I realise you were spot on but I'm still learning so it took me a little while to get there. Cheers

No lookups. I have a 1 to 1 relationship on counsellorID between the two tables. I've got the combo restricted so you can only select from the list. It is also set up with two columns - name and ID. However the query was wrong as you suggested, I only needed a simple query for the appointment...

Unfortunately not but it is a simple query. I have an appointment table with a counsellor Id which links to a counsellor table which holds the counsellor name. In a continuous form I display all the appointments for a client using the above query which brings in the counsellor name. Sometimes...

I completely agree about the code wadding. I don't know enough about Access yet to code efficiently all the time but I know when it doesn't feel right like my suggestions above don't. However your suggestion to revisit the design has got me thinking. I could have a text box that shows the...

Not sure that I understand. Are you suggesting that I make the counsellor name combo box unbound but populate it with the name using code then check that whenever it changes I run a SQL script to update the counsellor ID on the appointment to match the name

Thanks Pat, when I double checked the RecordSource on the form I noticed that the RecordType was Dynaset so I changed it to Dynaset (inconsistent updates) and I can now change the name so that it updates. However, instead of updating the appointment record with the counsellor ID of the new name...

Hi, I've got an appointment history continuous form populated with a query that lists all the appointments for a client and shows the counsellor name for each appointment. The counsellor name is found on the counsellor table via counsellor_ID that's stored on the appointment table. Sometimes...

Agreed it is a bit pony. Cheers

Logged on this morning and the navigation pane and Property Sheet are grey rather than the customary white background. MSACCESS.EXE appears to have been updated yesterday. I'm now on file version 16.0.15128.20178. Anyone else experiencing the same thing?