Search the Community

Hi all, I have been passed over an Access database that needs some modifications. It is a relatively simple database, and most of the modifications I have done. However, I need to now dump some of the data out into a word document, which I can partially do, however I don't have all the code required. I was hoping there might be some Access gurus on here that might be able to lend a hand / point me in the right direction I am aiming to: The database stored 'bookings' and has multiple tables with lookup data that all are matched in the bookings table. Ie. Students table, Tutors table, Rooms table and subjects table. I need to present all the bookings for a particular tutor or student in a grid 'timetable' view. I have created the timetable template in Word and I have inserted bookmarks in each cell. I currently have some VBA code that will dump a particular field into a particular bookmark area The Issue: There are three parts that I need some assistance with. 1. I need to be able to select a tutor's name (from a listbox preferably) and it only give me the bookings for that tutor. I can try and pull data from a query, however as it stands i've only managed to get it to prompt me for manual input of a name rather than look at a listbox and set that name as the criteria. 2. Only IDs are stored in the bookings table, the data I want to pull out is the actual friendly names, which are stored in the seperate tables. 3. I need to input the bookings into the correct cell in the table based on the timeslot that is selected. Ie. If the booking is put against timeslot: "Monday A Session 1", then it needs to go into cell with bookmark 'mon1_session1_subjectname'. I can do a lost of if else statements, but it's how do I get all the data together to take from? The database is attached if you wish to have a look: LFC LSA_Lauren Monks.zip At the moment I have none of the above functionality set up, and a few bits are broken (work in progress), but more so that you can have a better understanding of the database. Thanks in advance for any assistance! I haven't done any Access work for a few years, and I'm a bit rusty!

Hi all, I've ran in to an issue where around 10 Chromebooks disconnected from our WiFi, with the error 'DHCP lookup failed', theirs now around 20 Chromebooks doing this and I fear more may occur. Another issue to side note, is our UniFi Wifi is currently running un-managed as the server that was running the UniFi controller failed a couple of weeks ago, and we are awaiting are replacement on site server. (Currently ticking over on an ancient on site server that's acting as DC for the time being). The access point's are still able to broadcast the network even though it's controller no longer exists. Any pointers on where to start would be amazing, thanks!

Problem: I am trying to create a 2-column table: child_username and parent_username, with the end result of linking parents to students on Moodle for a school of just under 1700 students and a few hundred families. For Moodle, the child_username is the student ID number (we use LDAP authentication for students and faculty) and the parent_username is the parents first and last names joined by a period and lowercase (Mark Smith -> mark.smith) background info: I have two separate spreadsheets of data exported out of two separate student management systems (we are in the middle of switching SMS's and the data was never complete to begin with) in the same excel file. One (StudentFix) contains students' first and last names (separated and concatenated, for a total of 3 columns) and their student ID numbers. It is sorted by the concatenated names and the student ID numbers are to the right of the sorted column (as required by LOOKUP() ) The other (FamilyFix) contains firstName (student), lastName(student), First and Last Name (student- A_&" "&B_), FatherFirstName, FatherLastName, parent1 username ( =LOWER(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(D2&"."&E2," ",""),"'",""),"-",""),"_",""),",",""))), MotherFirstName, MotherLastName, parent2 username ( =LOWER(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(G2&"."&H2," ",""),"'",""),"-",""),"_",""),",",""))) The result worksheet (that will eventually be saved as a tab delimited .txt to import into MySQL Moodle database) uses column D from StudentFix as child_username (no problem there), which I repeat (so each student has their studen ID number listed twice) and =LOOKUP(StudentFix!C2,FamilyFix!C:C,FamilyFix!F:F) for the first 1669 (number of students) rows and =LOOKUP(StudentFix!C2,FamilyFix!C:C,FamilyFix!I:I) for the next 1669 rows. Issue: The first 384 rows of both sets (so rows 2-385 and 1671-2054) return #N/A i the parent_username column. All of the data is formatted the same. There seems to be no difference between the two groups (those that work and those that don't). I would be happy to just go with it, but those 384 students' parents are probably going to feel left out... Any help would be appreciated. TIA.