Search results

Hi Guys I havent been able to sleep and been battling with this for the last few hours, it's now 5am, but just not sure I am doing it right. please see attached screenshot, Unitname I know is wrong and will change to UnitID. Any advice would be appreciated.

Hi Yes I understand Normalisation, by trade I am a maths teacher and always look for the shortest route lol as the saying goes mathematicians tend to be lazy. I actually realise what a dumb question that was as I was making the assumption (wrongly) of creating the form from the table where in...

Ok I think I understand that and sorry for what probably is a stupid question but do I then need separate requirement tables for each course? For instance one course will require a Virtual Registration number which other courses dont need. I still need to go through the new guidelines for two...

Hi Thank you for your reply I was basically told I had to do it. They assume I know everything about databases and that could not be further from the truth, as put me next to someone like you and I am a complete beginner. I understand the concept your saying there, and I could set that up and...

Hi Folks I have been asked to design a new DB for our training department but I believe it may beyond my ability, i just cant see a way to do it. I designed the old but but it had alot of mistakes as I was only beginning to use Access then, ie personal details had to be entered for each...

Hi Guys Dont fall out over this, the solution I came up to with the help of this forum will more than cover me, it means some radical changes to how the DB operates but staff wont notice much difference. For example for simplisity when I set it up I used the switchboard manager to handle the...

Want to say a big thanks to all in this thread I have pretty much the prototype done now to show the board of directers next week.

Hi I havent really looked at that example yet as I havent had the time to try and figure how to intregrate it yet. I do like how that example also tracks deletions however. All the best

Big thanks to SOS i now have this picking up the username from the custom login solution, now just to decide should I use auditrail on form are as a seperate table. Based on the screenshot above guys what would yous recommend?

So let me see if I understand this right if I create a hidden form to store the username of the person who logged in I can then pass this value to audittrail by means of the module file? So instead of checking the environment or curruser it can be set so it checks the value on hidden form...

Hi I already know this and I presented this as a solution today, but it wont work for our office. There must be a way to pass the username from a custom login like the example I posted to the audittrail module. I am gonna check with a few developers who have helped me with my websites to see...

No they dont, we are a small firm with 8 staff, manager, 4 admin, 2 full time tutors, 1 part time tutor. Resources arent unlimited by any means so I am stuck with this. I will need to figure how to get pass the username from a custom security system to Audittrail, nothing is ever impossible...

Hi @KathyL, as a last resort I may go down this route but I always like to try things for myself first. @SOS, grabbing the network user, brings me back to the problem where staff all use the default account in Windows XP, their currently is no user accounts set up as some staff move between...

Hi All I had posted in another topic regarding this and was asked to post a new topic so here goes. I will outline my problem again, I designed a DB for my work a few years back and they had to have a technician secure it using the Set Password option in Access to satisfy the requirements set...

Hi sorry about delay in replying. Although I designed the DB I never placed the single login on it, it was one of our technicians and they just used the set password option in Access. This resulted in only one person allowing to open the DB in edit mode at any given time. The problems I...

Hi Thanks for this. I am a beginner when it comes to database deisgn and VBA code, I set up a rudamentory DB for work a few years ago to hold all participant details and training details across all our programmes. I have been since adding various reports etc at the managements discreation...