Recent content by Stroud1977

Thank you for taking the time to reply and thank you for the links, I'm sure they will be very helpful to me. Are you saying that it's coming up as an error because frmCalendarMain has been named or linked to incorrectly? I'm a newbie so excuse the questions, but this is confusing to me...

Hi, this is my first database, and with help from you helpful lot, I'm making good progress. My database is seemingly working fine, but when I try to Debug/Compile Database in VBA menu I get the following error 'Compile Error, method or data member not found' and it's higlighting the...

Hi Guys, thanks for all your help so far, I've almost got these tasks working now, so here's where I'm up to.. I've attached a new zipped version of my blank database, but I've put a sample booking in so you can see what's going on. On the home screen you should see a booking on the calendar...

I've been googling 'setting' variables in Where clause as recommended by Plog, but I can't find anything online...(not saying it's not out there, just nothing that I could interpret as being relevant). Does anyone know how to do this? This is hopefully the final piece of the puzzle for me...

Apologies, you must be getting sick of this, but I've got no idea what that means or how to do it. The first time I've ever encountered the 'Where/variable' command is when you posted it here in this thread and I copied it into my VBA. How do I go about 'setting' it? Do i need do something to...

'ApptIDvariable= ' It came up blank! ApptID is just the unique ID for each appt in tblappointments

Thanks again! (I owe you a beer...at least!) OK, that new code works, no errors, but it's still not working perfectly as is, the code works, but doesn't update the yes/no box on any records in tblappointments. If I remove WHERE ApptID=" & ApptIDVariable & " then it updates the yes/no on all...

Hi, and thanks again, just to be clear, I am only putting this code in my VBA. The code you've kindly supplied is unfortunately still giving me the same compile error on ApptID. (I had to hit space bar to put the WHERE part on a new row as it just stayed red if i kept it as one long line of code?)

Thanks again! I feel I'm almost there, I added the 'WHERE' clause as follows (ApptID instead of TaskID) If MsgBox(Prompt:="SMS Sent to Artist. Delete Task?", Buttons:=vbYesNo, Title:="Delete") = vbYes Then On Error Resume Next WHERE ApptID = " & ApptIDVariable"...

Thank you so much! I think I'm finally getting somewhere. I've successfully created the update statement in the query wizard, I've copied that into my VBA code and it all runs great. My only problems now is that it's updating all the appointments in my table as 'Yes' in the Yes/No box instead...

Again, a thousand thanks for your patience, but unfortunately I think this is slightly beyond me. I cannot emphasise how much of an access novice I am. I tried to create an Update Query, but I must have done it wrong and I'm not entirely sure what I'm trying to accomplish any-more and I'm just...

I totally apologise, this must be frustrating for you, but most of the above went over my head. I'm really a complete beginner when it comes to all this. I replaced the DoCmd.RunCommand line of the code with DoCmd.RunSQL and it doesn't seem to have made any difference. I'm afraid I don't really...

Thanks for the reply! Sorry about this, I've no idea why it's not opening, I can open it ok here and I shared it with another forum member a few days ago this way with no issues :banghead: Anyway, you have been very helpful, I think I'm getting somewhere thanks to your help. You're right I...

Hi Plog, thanks for the advice. My task comes up as a pop up form with only limited info which is linked to a tblappointments query. It's basically a big button saying 'Send SMS/Email'. Do i need to put a Yes/No field in the table or the query and then link to it on the form? Is there a way...