Search results

Thanks, I will have to rethink this has event occurrence cancellations have to be possible.

Hi Please see the following screenshot. Compare it with a similar for IT Suite 1 report

Hi Thanks for getting back to me, the report I just copied and renamed from the IT Suite 1 report. Removing the date does work but then it shows all bookings and not from the current week onwards. I don't know what it is about this report but even with the date removed and you cycle though...

Hey Guys Please see the attached sample database. I am trying to display upcoming events in an outlook style report, I found this formatting code somewhere on this forum. We have 5 rooms available for bookings, the report loads fine for 4 of these but for whatever reason the Board...

Out of curiosity has anyone using this audittrail ever created a moderators hub in their db? IE something like showing newly added records in the past two weeks and edited records in the past two weeks? Having a really hard time with staff here continually entering the wrong data...

I am swaying towards giving each SOW it's own table, not best practice but could prove a lot easier in the long term.

Hey Thanks for your replies, this is a technique I have used in the past and you're videos reminded me off it. I am still trying to work my head around how to incorporate this into the database though, interface and ease of use is key. I already have tables containing a list of...

Approaching 200 and will rise, some of out course have upwards of 10 units, so a different SOW for each unit is required.

Not exactly it varies depending on the course.

Hey all I am currently exploring the possibility of adding another element to our Database. Each of our courses has a scheme of work associated with it, and this is completed on a daily basis by the tutor for each student. These are currently just Word documents we print out. Example. I...

Thanks all I will look over these and use the most appropriate method for my situation.

Hey Folks After initially developing our database and giving it to staff for some time they are starting to request things to assist them in their daily routines. What I am finding is not everyone is updating to the latest version when I send a new version out. The backend sits on...

Thank you it was autofill I was needing

Hey No I am not trying to do a calculated field, just display one from another table.

Hey Guys I have a complete brain freeze this morning and cant figure this silly thing out lol See the attached example, I need to populate the Field B on the form from the associated value in SubTable for the data selected in Field A. Thanks

Hey All I hadn't originally envisioned adding this to the database so the structure may not be ideal. But to help a woman out at work I am trying to achieve this. See attached pic There are three main tables. Students, Courses and tblUnits The courses name field on the courses...

main homepage just shows the pages code.

The error the pc that cant load the modules is giving is the module name is misspelled or refers to a module that doesn't exist However that would indicate the frontend is corrupt, however the exact same file works on all the other pc's when copied to the local machine. Anyone any...

Managed to solve the freezing problem, was related to some HP security software that shipped with the PC. But still cant fathom why the other one cant load modules.

Hey No there is no wireless devices on the LAN currently. What I found with the girl who couldn't login, was there was a number of library references missing in VBA, resulting in none of the modules being available. I added the references back in but it didn't fix it (I couldn't do...