Recent content by nortonm

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....