Search results

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

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

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

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

Hi, I'm a little unsure of which direction to go with this. I'm not sure it's possible, I've looked all over but can't find a clear replacement for the code below to work with a SharePoint doc library. (I've been using it for years just fine with standard network folders) What I'm trying to...

Hi, - I'm a bit flummoxed as I edit table data in query based forms all the time, but I just seem to have hit a brick wall. I'm guessing the way ive got the tables set up is not really very good, but I've done much worse and been able to edit table data through a form based query. I included a...

Hi, I'm struggling to concoct some vba to rename some files in a folder. The problem came about because a web portfolio system at work exports files for students with a SQL UUID - meaningless string - instead of the Title. So they have a folder full of files they don't recognise without opening...

Hi - Is there a way of forcing a value in a listbox or combox to the bottom of the list, even though though the rest of the list is sorted a-z? It's a two box conditional combox thing, the list in Cat2 is selected from the Cat2 table depending on what was selected in Cat1 cbobox, so I can't...

Hi - I think the answer to this will mean much leaner databases for me in future.... In a nutshell, I have a form that looks at an attendance table, and all data can be amended on the form if needs be except the User, as it has a foreign key in the attendance table, but I need to reselect by the...

Hi to all. I've been using access for about 5 years now, but I learnt from books and hence have loads of bad habits, yawning gaps, naïve code etc, but I am able to get stuff doing stuff for people! I'm trying to improve my skills, and become more professional with the code I use. I guess I'm...