Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: SOMSteve
  • Content: Threads
  • Order by date
  1. SOMSteve

    On Current command for a new record

    I am running MS ACCESS 2003 SP3. I have run into a (probably very easy) problem that I couldn't find an answer to when searching the posts. I am using the "On Current" event to try and detect if the item being entered is a new item. Because I don't know any other way to tell it "On new...
  2. SOMSteve

    Referencing Subform Controls from Main Form

    I am using ACCESS 2002 SP3 and running into a problem. In the main form the user selects an item type from a drop-down list. If it is equal to Equipment or Vehicle then select fields are supposed to appear in a subform embedded on the main form. The area where I'm having difficulty is trying...
  3. SOMSteve

    Open Where command button with a two field primary key

    In establishing a request to move items out of a particular office, a Disposal Request form is filled out. The table "Disposal Request" is keyed off the Office # and the Disposal Request # (Disposal Request # starts at 1 for each office, thus it can't be a standalone key). The Item Table has...
  4. SOMSteve

    Problems with a dependent combo box on a sub form

    On my Sales Form I have basic information on the sales event (who bought it, how it was shipped, shipping method, etc...). I have put as a subform the items associated with that sale. For each item included in the sale, they must select where the item they are trying to bring in came from by...
  5. SOMSteve

    Problem adding new records with an On Current event

    I am using the "On Current" and "After Update" events on a form to display select fields, depending on what type of transfer the user selects. This works fine up until I go to add a new record, at that point I get a "Run-Time Error '13' Type Mismatch" error message. I've looked into this a...
  6. SOMSteve

    Second column in a combo box to a new field

    I am trying to bind the first column to one field and the second column to a different one, by using the afterupdate event of my combo box. I know it has to be easy, but I don't know what coding to use to assign the value of my second column to another bound text box on my form within that...
  7. SOMSteve

    Update Form to perform On Current event

    In an Access form, I used the On Current Event to limit the visibility of a few different buttons and text boxes based on the values in a couple different fields on the form. While it works perfectly if you move off the record and then back on, I want it to work as soon as the user selects a...
  8. SOMSteve

    Case Statement based on combo box input

    I am attempting to use a "Select Case" statement that references a combo box on a form (not linked to a table) to open up the appropriate form for the database user. When I execute the code, I get an error: "Object required." I've seen this problem appear elsewhere in the messageboards, but...

Part and Inventory Search

Back
Top