Recent content by Badnapp

I read your tips on form validation, while helpful I'm still not sure what to do. 1) I went into the back end and changed all of the relevant columns to required: yes allowzls: no. This almost fixes the problem, as the user cannot save a record unless all of the comboboxes are filled out...

Oh hey again! I didn't realize I was speaking to somebody who had already helped me with this database lol. I will upload some jpegs tomorrow. Just for your own curiosity, the clerks have used it without any issues ever since I rolled it out to them. The only thing that has become an issue is...

I work for Ministry of Attorney General, in the Supreme Court of Justice. The reason that Judicial Information Technology Office has not designed this DB, is because it is not an extremely important project, so I offered to take a shot at it. It is simply a database that the law clerks in...

The user clicks a button to save the record and create a new one. Can I add code to the button that ensures all of the combo boxes on the form DO NOT have a null value before it will save the record?

I still can't quite figure this out. I'm at a point where if the user puts his cursor in a combo box, he is forced to make a selection. However, I have a button in the top right corner of the form to save the current record and create a new one, and if the user clicks this button it bypasses...

Unfortunately I'm not very high up at this company. They sort of asked the guy on the low end of the totem pole with no access experience to create a database that's used by 27 people daily, lol. But hey, that's Canadian government right? Anyways, I don't have a "maintenance period" per say. I...

I think I'm getting down to the issue. As you mentioned, they cannot just write things in my comboboxes. All 6 are populated by tables which are stored on my network drive as a separate "back end" file. The clerks have each been distributed a front end file .accde with which to enter their...

Hello everybody, I'm an access beginner, bare with me. I have a database that I've created for a number of clerks under me to use to track their daily tasks. I had the help of some other members of this forum when I was building the project 8 months ago. When clerks are entering their...

The clerk that I chose as a test subject finally got around to testing the new front end and I want to share her response with you: "I gave it a go late yesterday afternoon, but didn’t have time to enter all of my report, so hadn’t gotten back to you yet. I will say though that just from the...

Well, yes and no as far as having an operational database. The clerks are all running "ClerksDatabase v1.1" which I distributed to them BEFORE I even started this thread. As far as they are aware, nothing has been altered. On my personal C:\, I have about 15 versions right now in various...

Still waiting to hear from my clerk re: speed :(

Good question jdraw. Notes are associated with individual tasks, where many tasks can be tied to the same case. Therefore, a task can only have one note, but a case could have many tasks each with one note. The notes are only used to further differentiate tasks if the clerks work on a similar...

I wish I could give you a speed update. The clerk is too busy today so she didn't test it out. She says tomorrow she will give it a go so my fingers are crossed. I must have missed your note re: moving notes to a separate table because I did not do that. I have attached the latest copy jdraw...

Update: I changed all of the tables to *I think* normalize the data. The db also seems to be working correctly. I distributed a copy to one of the clerks to test it out. I'll report back when she gives me her results :)

Hey guys, This weekend was pretty busy for me so I didn't get to do as much as I wanted, but I did make the changes mentioned. I'm a little bit confused now, as I'm sure you expected. I made a copy of the database and tried to link the new table "tbltasks" to the forms that I have set up...