Search results

Many Thanks, there was a database made available by a 'Vlad' on the thread which helped me construct my process along similar lines

That's really kind of you, thanks very much. I am away for a few days now, but i'll be in touch as soon as i'm back onto it.

Thanks theDBGuy, i'll try and figure something out using that. I'm off for an autumn birdwatch though until Thursday, i'll leave it till then....

Thanks Gasman. I am OK doing that for individual emails, that's where i'm up to, but the problem is there are hundreds of completers, and what they want is to press one button and each recipient gets a copy of their certificate attached as a pdf. At the moment the report contains the whole...

I'll try to be succinct: I have a report mocked up as a certificate, merged to multiple course completers in a table. I want to send a certificate to each completer in the table, but all I can do with my current code is send the whole report containing everyone in the table as a separate PFD to...

Hi - apologies if I should have re-posted this as a new query, but I've just realised after coming back after covid that the cancellation works fine - except - that if someone cancels an appointment from the database that someone else entered as an appointment, then all appointments are...

I don't think the age blame thing really has legs, both old and young have poorly behaved individuals in pretty large numbers. The older people, at least UK side maintain they are much better than young people now, but who were terrorising seaside towns in the 50s and 60s meaning families had...

Superb code, many thanks.

Actually, for reference, I got the answer. I need to put the following code in: objAppointment.MeetingStatus = olMeetingCanceled objAppointment.Save objAppointment.Send objAppointment.Delete so that deletes from mine, and creates cancellation in other attendees calendars. Thanks all.

Hi - re 'The Doc Man' reply: I have confirmed that I have delete rights, I can view their calendar entry and delete the appointment from their calendar from my Outlook. With this in mind, and confirming the above code does work in deleting from my calendar, do you know if it's possible to put...

Yes, Thanks, that would also be useful; although a number of sessions are deleted, an equal or higher number are updated. I'll have to find some code for updating the main information fields instead of deleting the appointment itself.

Ah, right. Thanks, i'll have a look through. I think I have edit to their calendars, but that doesn't include delete, that would have to be full control I guess.

Hi, I have code that creates appointments in 3 tech colleagues calendars, and I need code to also remove those appointments when the particular class is cancelled. The code for adding them to the new appointment is as below: If vbYes = MsgBox("Send Calendar Appointments?", vbYesNo) Then...

Whenever I get broken/corrupt record most of the text changes to a form of Chinese characters in the database, and usually in the table that holds the new submitted records rather than any feeder tables. You could open the main table and have a quick scroll around to see if any records look like...

I agree with theDBGuy; I guess you could try and concatenate all the records in the query using the superb Allen Brown instructions Microsoft Access tips: Concatenate values from related records (allenbrowne.com) - create a query that concatenates the Record IDs from that query, add the concat...

maybe something like If DCount("*", "YourQueryName") > 0 Then MsgBox "There are unmatched queries for you to deal with.", or did you mean you want the msgbox to actually contain the record numbers?

Apologies, I couldn't get into this site for ages, it's been down. Anyway, thanks for encouraging me to take a closer look, there was a folder in the SP path not parsing properly. OK now.

Thanks, sorry, i've had to put it aside for the evening, i'll continue in the morning - many thanks.

Sorry - I didn't actually sort it out, I was just feeding back where the debug occurred - it's something about that https address that triggers the error 'Runtime error 52: Bad file name or number'. It doesn't seem to want to copy that address into the txtLink field on the form...

Thanks - righto - just checked again, and it doesn't actually go as far as populating the txtLink textbox, as it's at that point the error comes up. Just went into debug to check, and the part of the script it failed in is highlighted - it's the strFile = Dir(varitem) line - and when I hover...