Search results

Thank you for your quick reply. I'm working in Access 2003, but the file format is 2000. In Options, the default record locking is set to No Locks, and the box is checked for Record Level Locking. This is true of both the front and back ends. Any info would be appreciated - Thanks again...

I have a database that will be used when our system is down to receive requests from customers and to dispatch out those requests. If anyone will take a look at the "Dispatch Panel" form and find what is causing this not to work, I'd be forever in your debt. A record is taken on the receiver...

I figured it out. I had to check if [Receiver Comments]<>"" instead of checking if not null. Thanks anyway.

I have a form with a comments textbox that links to a memo filed in a table. I have an unbound textbox for the users input, and afterupdate, I concatenate the input to what was in the comments textbox. It is working the way I want it to, except it carriage returns even on the first entry. I...

I know this is an old thread, but I thought I'd post a reply for anyone having the same problem: You need to set the text box back style to transparent, then change the back color on gotfocus/lostfocus.

I have a strange problem I can't figure out. I have a massive query that runs off of about 10 other queries. I use [forms]![Authority].[Emp#] in the query conditions, using the supervisor's employee# to only show them the members on their team on the form. My problem is that the query/form...

OK, I just moved the back end of one of the databases into a shared folder that everyone has authorization to access and re-linked all the tables. My users are still unable to access it, getting the same message that someone either has it open exclusively or they don't have authorization to...

I'm now being told that if the back end is in a folder that the user doesn't have authorization to access, they won't be able to access the data from the front end. I can understand that, however for months, the back end has been in this protected folder, and users without access to that folder...

I have two databases that have been split, and both back ends are in a shared folder on the server that only a few people have authorization to access. One of the front ends is accessed off another shared folder, and the other is saved to each person's desktop. They have been up and running...

I kicked out my users and compacted and repaired the backend. It went from 333mb to 194mb, and it seems to have fixed the problem, although it is still a little slow. Thank you very much for the advice. Mike

Now that I think of it, I have compacted and repaired the front end where the form is, but I have not compacted and repaired the back end. Do you think that could be the problem? Thank You, Mike

I have compacted and repaired the database. I'm finding out that it's only freezing if I go directly into design mode on the form. If I run the form and then go into design mode, it doesn't freeze. The form is designed from a query that only shows the employees of the person logged into...

I have a form running off of one large query that is running fine, although it takes about 12 seconds for it to load. My problem is that this last week, I've been having a problem with it freezing when I try to save changes to it. At first, I thought it was a problem with my pc, but it's...

Thank you very much for the reply Bob. My users are accessing a single fe on the server, but I plan on sending individual front ends out in the next week. The Record Locks were set to All Records. I changed it to No Locks, and it's working fine. Thanks again! Mike

I have a form in a split database that is linked to a table. The problem I'm having is that only one person can access this form at any one time. If a second user tries to open it, it just does nothing. There are other forms that have subforms linked to tables that multiple users can access...

I have a form that contains two separate subforms. One has six records that automatically update from a table (one record per employee) when a name is selected from a dropdown on the main form. The other is linked to another table (many records per employee), but I haven't figured out how to...

I copied Odun's post below to describe my problem. I'm having the same problem. I can't even creat a new blank database without being prompted for my user name and password, which aren't working. Any suggestions would be very much appreciated. Thanks, Mike...

I have a form that has two controls for name and employee#. The user picks the name from the dropdown box, which fills in the employee# and other information in the subform (address, ph#'s, work schedule). The user then needs to pick from another dropdown box in the subform, and if they pick...

The controls in my subform update automatically when I select from a dropdown box in the main form. I'd like to be able to change the information in those controls if need be. Is that possible?

Is it possible to have a form with controls that are bound to a query and be able to overwrite or update those fields/controls? I don't want the table the query uses to be changed, just the control on the form. Thanks.