Search results

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...

Wow! So much work to do :) 1 - What do you mean f14 f15 fields? 2 - I'm not positive, probably because I was messing around deleting the private records before I sent a copy to you. I just checked on my version and a taskid IS created. 3 - Yes, these are the same. In tblUser I stored the...

Well one thing in particular came to my attention today and I'm not sure if it related but I believe it does... On a whim, I made a copy of the whole DB and ran the table analyzer on it. The table analyzer suggested that I store all of the columns from my "Tasks" table in separate tables, and...

Hey Gemma, I work for the government, and as a result our networks tend to be unquestionably slow. I'm not sure that I have the resources (mostly time, but also knowledge) to redesign the database, so I'm hoping some of the duct tape that we apply will hold this project together. In the long...

Well if nothing else I am learning a lot about sharing an ms-access database over a network. Especially after reading the last link you sent me re: file sharing over a WAN, I feel like I have a better idea of what is going on here. Our drives definitely disconnect intermittently. For example I...

Update: I made 75% of the changes listed on this site that I stumbled across while following your advice. http://www.granite.ab.ca/access/performancefaq.htm I have been testing the database this morning with one of the law clerks and she says it seems to be operating very quickly. I don't...