Search results

Many thanks for your replies. I didn't manage to get the array to be added to the query design grid successfully, so for now I've had to resort to combo box and single values in the query. I'll try and pick up the thread when I have more time, i'll update if I sort it. Many Thanks.

Apologies - I've had a bad week - (been dumped!) - i'll feed back as soon as I can.

Hi - I have a list on a form that you can select multiple values, and when btn pressed it copies them to a text field. Then the other button should open the query with the contents of that text field in the criteria. But when you run the query it won't read directly from the form, and it brings...

Ah, brilliant - thanks very much!

Hi All - I am currently needing to code a button that will create a linked table to an excel spreadsheet that sits in the OneDrive for each person who uses the database. The database handles tutorial bookings for academics in our school - they enter availability slots in the DB, then export as...

Ah, it must have been a dodgy text box, I deleted it, added a new one, and it worked this time, I must have done something to it when changing the values. Many thanks for confirming the code for me, i'd have been messing about all day checking it!

Thanks -I will, i'll just do a spot of tidying up lol....

Thanks - thought so - well it appears that the code seems right, and the way to call it too, so i'll have to try and figure out what is stopping it from running. Cheers again.

No it gave same error - sorry the error is #Name? (not #error)

Thanks DBGuy - I'm pretty sure I did, but as you've ID'd that i'll have a go again restarting the db first. There's no need to put tblBookings_ALL in the module code is there?...just trying again....

Hi, I'm trying to run a relink routine depending on what the current link path is for a table called 'tblBookings_ALL', so basically it would be along the lines of: "If link path for tblBookings_ALL = txtLinkedFilePath (which would be...

Many Thanks all, I managed to find a solution from a thread provided by gasman, but all the suggestions helped me to understand what I needed to make happen, and will be used to perhaps cut a corner or two off what i'm currently doing.

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.