Recent content by nortonm

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