Search results

Thanks Ken, that looks like really useful info. The table tblConcernFormSubmissions contents are actually continually deleted and repopulated, as it works mainly to get data from the MS Form, by means of this table, into tblPlaceConcALL. It's a temp table in that respect. It gets populated by...

Ah right, thanks, this helps me to understand the logic of it, got it now.

Thanks very much George! I had a feeling i'd seen an IsNull entry on something, but I couldn't work out what to do with it. That's excellent, thanks again!!

Hi; I have created a DB that handles Student Placement Concerns. Some requests come through on an MS Form, but not all (some by email etc). I append the back end of the form to the main tblPlaceConcALL (All placement concerns) by way of the mediating table tblConcernFormSubmissions, which is...

Many thanks!!; arnelgp: those suffixes worked, so many thanks! gaP42, I'm going to keep hold of your solution, it seems a perhaps more resilient method in the long run. Just gotta get this form up and running again, then i'll try it in a test version of the DB.

Many thanks all, just got back into work. Will try today.

Hi - I am creating a database of student 'Placement Incidents', and one request was that lecturers are able to add supporting attachments to the main PlacementIncident record. I have FileCopy working to copy documents from the PC documents folder to the database’s attachment folder. It then...

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.