ruddj / sportsadmin Goto Github PK

I get these errors when creating a new carnival file.
https://www.screencast.com/t/pKo1Nmla

It seems to happen each time a new table is created in the database . I suspect it is just a security setting in Access that would stop it. I havent tried anything to fix it.

The problem line is in the Make_File routine.

        DoCmd.TransferDatabase acExport, "Microsoft Access", FileName, acTable, db.TableDefs(i).Name, Right$(db.TableDefs(i).Name, Len(db.TableDefs(i).Name) - 3), False

It created the file fine if I chose 'Open'. After that it worked great - no issues at all. Well done.

Hi.
I love this carnival database - thank you. I had set up my own, but yours is awesome, very user friendly, thank you.

When I generate the templates, I change them to portrait as that suits my school better. Is there a way to alter the template slightly? By changing to portrait view I get a second page for everything that I don't really need, and rather than wasting paper, I'd like to remove a section so it doesn't print.

Also, it would be great if for field events I could add more columns for 1st attempt, 2nd attempt, third attempt, rather than just best. We tend to let them have a go, measure and record - especially for long jump and high jump.

In Maintain Competitors and other long lists boxes, it would be very useful to be able to type more than the first letter when searching for a student.