Search results

  1. M

    Unknown Function 'Environ'

    This error seems to be showing itself on a handful of pc's that use the database. The problem seems to be pc specific, not user specific, but I have been unable to find a fix. I had one of the users that is getting the error go into the vb script editor of the database in question and type in...
  2. M

    Write Conflict - 3197

    I have a form linked to a table in a FE/BE database with multiple users. The problem I'm having is that multiple users will be accessing the same record at the same time, and the write conflict error shows up. I have changed the form to update the controls from commands entered in an...
  3. M

    Major Form Problem

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

    Appending to a memo field in form textbox

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

    Error 3071 - Expression too complex?

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

    Users unable to open database

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

    Form Freezing Problem

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

    Only one user able to access form

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

    Updating a table from two subforms?

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

    Locked out of Access

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

    Macro issues

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

    Bound controls

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

    Dropdown combo box problem

    New Access user here, so be kind: I've created a form that includes a dropdown combo box for Name and a text box for Employee Number, with the control source being a query. In a subform from another query, I have other fields that are linked to the employee# field of the form. The form is...
Back
Top Bottom