Search results

  1. A

    Stored procedure only works for one user?

    Hello, I am calling a stored procedure with the code below. When i log in as my user it works great. Any other user and I get an error the execute line of the code below. I am calling @user a few times in the stored procedure but it does not make sense why any other user would make a...
  2. A

    reference only pulling one value

    I am using this snippet: Forms!PullToShipMainFRM!InvLocFRM.Form.Location <> Me.Combo11.Value to see if the values in subform1's combo11 does not have a match in subform2's location field. Subform 2 is a datasheet subform and could have either zero or multiple lines. If it has zero or one it...
  3. A

    modules and public functions in multi user environment

    Hello, I have some modules that have public functions in them that I am calling from a few different forms. Works great until there are multi users and it starts messing up. By messing up I mean sometimes it wont go through, sometimes it goes through multiple times. What I think is happening...
  4. A

    Macro runs multiple times at once

    Hello, I have a macro that is being called by multiple users. It appears that it is allowing it to start a second instance before the first one completes. This is causing errors because one of the last steps is marking records as processed but if it gets started again before done it appends...
  5. A

    Multi User environment producing unwanted multiple records appended

    Hello, I was not sure if this post should be in the queries or macros section. Basically I have a few forms that users fill out and then the data from that table is appended to a transactionTBL and then deleted from the working table. From there it goes into inventoryTBL. All of this is done...
  6. A

    Schedule tournament games randomly

    Hello, I am trying to schedule games of teams in the same league. I have four courts which play four nights a week. I do not want the same two teams to play each other more than once unless they must to fill the schedule, and in that case not the same team as the week before. I want to fill...
  7. A

    Query to compare 3 total fields and calculate total

    Hello, I have three tables that have OnOrder, OpenReqs, and OnHand. They are not totalled by the primary key which is PartCode. I need to total each of them and then make a field that will include every part code from another table, RM Description Table, and give the inventory position for...
  8. A

    Calendar control erroer loading events

    Calendar control error loading events Hello, I have an activeX calendar.10 control on my form. It works fine on my computer but when I go to any other computer there are a few errors. First, it will not set to the default date of today. It sets to the date the calendar was added. I have...
Back
Top Bottom