Search results

Hey Jdraw thanks again for all of your continued assistance, here we go... Screenshot: Woops forgot to attach it, I have added to this post. WAN Issues: I have been looking into the DAO Opendatabase method of enforcing a persistent connection and I thought I had done everything correctly but...

I'm beginning to think that despite the downfalls of my database design, the major issue is related to network performance. I have some clerks who work with in the city with me who are experiencing little or no lag, but I also have clerks in adjacent smaller cities who say it takes them minutes...

1. What is production mode? The back end is saved as a .accdb file stored on a shared drive. The front end is a .accde file distributed to the 26 clerks. I built the file using Access 2010 Professional. 2. 26 Clerks depend on the database to enter their daily tasks. One manager uses a copy of...

Re: Comments: . I can remove spaces from all names if you think this would speed it up, but I think it's a different issue. . I have no clue how to build relationships lol. I know that sounds ridiculous, but this is the first Access DB I made and I kind of fumbled through it. I'm assuming you...

Attached is a copy of the database in .zip format *before* I split it. The two tables that are linked are "Tasks" and "Judges" and the slowest combo box is based on the "Judges" query.

Another difference between his second example and my database is that he is using a table as the location recordsource that has all of the possible values, where my subcategories are stored in 5 separate tables and the afterupdate event in my cboDivision box references one of those tables...

Yes, the second one is very similar to what I did. I remember coming across that tutorial while researching cascading comboboxes. However I didn't understand it at that time and I am using Access 2010 and got sketched out because he's using an older version, so I chose to use VBA code to build...

I'm pretty terrible with VBA code, but as I understand it.... cboDivision is a combobox with rowsource "Division of Law" which is a table The table is simply six categories: civil, criminal, divisional court, family, admin, CJO office All of these categories have their own corresponding table...

My apologies, now I believe I am following you. The comboboxes I'm referring to are comboboxes on a form used to create a record of a task. ex. User logs in --> Access opens Task List form which shows all tasks done by that user User needs to create a new task entry --> Clicks "New Task"...

CJ_London: 1 - Yes, the front end is quick 'enough' for all users, with the exception of the cascading combo boxes. These lock up the users machine for a couple of minutes. 2 - All users are hardwired to the network. The back end is stored on the J:\ drive of this network and all users have...

Good morning, I have created a small database for law clerks that I manage to input and track their weekly tasks. On the advice of others, I split the database into a front and back end, storing the back end on a shared server that we wall have access to, and distributing copies of the front...

Thanks everybody for your feedback. I am of the opinion that it has something to do with the permissions/rights on the network. I can't have the excel file open simultaneously through two different users even though it is a shared file, and that seems odd to me. However... The excel...

That's the funny thing Kevlray, I saved the excel file so that it is a shared file, and thus it should be able to be opened simultaneously by multiple users. Still I am encountering this issue. I am starting to think it might be too much trouble to leave this particular table linked. We only...

I think I left out some information that might be important. All of the clerks are spread out across the province in different offices. We all have access to the same shared drive (labelled J:\). The back end of the database is stored in this J:\ drive. A copy of the front end has been...

Yes, each user has a copy of the front end stored on the C:\ drive of their machine.

Good morning, I have a simple access database that 26 clerks in my office use to enter their weekly tasks. The database is split into a front end and back end, with the back end stored on a shared drive that we all have access to. We have been testing the database for 3 weeks with 5 clerks and...

Maybe if I word this more simply... I have a combo box on a form, it is based on a query. There are 4 fields in this query - Case Name, Division, Subcategory, Assigned By. When a selection is made, all column widths are zero except for Column 0 - "Case Name" which is what I want the combo box...

Good morning everybody, I am working on a database where law clerks input the tasks that they accomplish each day. They use a form called "TaskDetails" to input all of the information related to their daily tasks via combo boxes. The problem I have is: often times the clerks work on the same...

Thanks for your help :) I was able to get it to work by using this query: SELECT tblUser.FullName, tblUser.Region, tblUser.UserID FROM tblUser WHERE (((tblUser.FullName)=[Forms]![frmLogin]![cboUser])); ... and then basing combo boxes off of the query. The login window minimizes when they put...

This worked perfectly for me. Thank you for your assistance. If I could trouble you for one more minor thing. What can I add to the query or SQL lines in order to automatically select the available option. IE. Now that I based my comboboxes on that query they will only populate with who is...