Search results

Can I bring up a related issue I've been having with this - the batch file is created to update FE but not run automatically. I believe it is related to an anti-virus software running on the machine (typically Avast). Would anyone know how to make an exception to allow batch files to run or...

Yes just integrated into my DB and it shows correct info. Only trouble is its slow to load because must sort through large dataset to find related records. Any way to avoid this?

Hi I'm revisiting some forms I started building last year (see here which I've successfully implemented thanks to @MajP !) Now my problem is that I would like to display a subform on the main form to summarise the details for each related student. I've considered the options and thought it...

Thank you! I was really looking to replace the Code column in the listbox with the concat function to reduce number of rows by having each date displayed once only.

Did you read post #13 where I explained that the studentAttendance records the students who attended sessions which were logged in sessionLog. So the date of session are in sessionLog and registerCode is in studentAttendance table.

That's great but how would I have each date on a new line?

Thanks. I understand but not sure how to apply to my situation - would like join related rows by date. I've copied relevant part of form to DB so you see how it works.

can you briefly explain how this does the same function as concatrelated and how to implement?

The SQL for the query looked up in concat is: SELECT jtblStudentAttendance.fldStudentID, jtblSessionLog.fldDate, tblRegisterCodes.fldRegisterCode FROM jtblSessionLog INNER JOIN (jtblStudentAttendance INNER JOIN tblRegisterCodes ON jtblStudentAttendance.fldRegisterCodeID =...

Each session is logged in jtblSessionLog. Students participating in that session are logged in jtblStudentAttendance. So SessionLogID is FK in jtblstudentattendance. Date of session in jtblSessionLog; registerCodeID in jtblStudentAttendance. Form is too complicated to copy over - this is just...

Hi there, I know this thread is a year old but I'm encountering a very similar issue and struggling to resolve it. I would like to produce a summary of attendance on each student's form. Something like: Date Register code 16/08/2021 /, \ 17/08/2021 O, \... See attached the relevant...

I currently use version numbering to check the user's FE is latest copy - when application opens so it would run the FE Updater at that stage when no critical functions are running so it would not be dangerous to close at that point. If you want to force an update whilst they are working, you...

Nope. Unfortunately it is still displaying the full date.

Sorry input mask is not helping to hide the date when the user clicks INTO THE FIELD. They initially add the time using a custom time selector or typing in but if they wish to modify it will display the full long date which can be confusing. Any other options here?

One more question - the format displays beautifully in the form but when I click into the field it will display the full date (I only wish to see the time). Is there any way around this?

I tried @Minty 's suggestion. Eventually found couple of out of range values. @Isaac your second suggestion worked like a dream - have no further issues with that column now! It's been a nightmare converting all the date/time columns. This is the best option by far.

You have hit the nail on the head @oleronesoftwares - I was just about to comment that my FE is running on MS Access 2016. (When I was testing I was using Office 365 so the issue wasn't occurring!) So as @bastanu advised, I have looked at the linked table in design view. The ONLY SQL data type...

Interesting! When opening the Access linked table it shows the data type as short text!

Yes it is. See attached

Please see this screenshot. I've tried every relevant data type but cannot seem to have it format to the specified type. Survey date should be short date; Between/and should be medium time. How can I go about this?