Recent content by k_c_morrissey

  1. K

    problem setting up relationships

    I have a table which contains a list of names and the trades that each one is qualified for and a second table for a project which requires a number of different trades to fill specific roles. How do I set up a proper relationship between the two tables. Tbl_employee. empl_ID| Empl_Name |...
  2. K

    How can I make a form always return to the form that called it?

    I have several forms that can be called from more than one other form, but I need to build my forms so that the user is returned to the form from which they started. I have looked in the help files and FAQ and I can't find what I am looking for. Please, can someone direct met to the required...
  3. K

    Runn Time error updating record -- Help ! Please...

    Run Time error updating record -- Help ! Please... I have an orders Form with a subform for products. In the subform the user selects each product by first selecting the product category from a combo box, which filters the query for the second combo where they selects the product. Once this is...
  4. K

    transfer text values to another form

    Thanks, Trying it now.... Kev.
  5. K

    How do I pass values from fields when opening other form

    I have a subform with two combo boxes. These boxes select product catagory and products. The main form sets the supplier from which to select products. If the user can not find the product they require they can double click thje product combo, which opens the product input form I need the...
  6. K

    Help !! runtime error trying to retrieve record

    Len, I'm pretty new to this DB stuff (you probably guessed!) I don't actually want to add any data at this point, I just want to look up the contract name, number and status. This info is in a table called project_info. The two combo boxes are unbound, but linked by some VB code that updates...
  7. K

    Help !! runtime error trying to retrieve record

    I have an 'add new order' form which opens with all the fields blank and focus set to a combo box. The first thing the user must do is select a contract name or number from an unbound combo box. I then want the form to update and show all the relevant information in the form fields. In the row...
  8. K

    populating a text field from a combo box selection.

    The suggested code change is the same as the first 3 lines of the comboCatagory_ID_AfterUpdate() sql. If I delete the rest of the SQL and then run it exacly as suggested) I get another debug screen with a 3058 error (see attached screen grab), which I think is telling me that I can not leave...
  9. K

    populating a text field from a combo box selection.

    Attached are 5 files which are screen grabs of the properties of the two combo boxes, the text box and the form. the 5th file is the VB for the two combos. I am ver much a novice at VB, so I am at a bit of a loss about what I can and can't remove and still make it work. I am trying to get your...
  10. K

    populating a text field from a combo box selection.

    I have a combo where the list is populated with a bit of VB code to create a two field list. When the user selects the item they want from the list it displays the item in the combo box and should populate a text box in the same row with the value from the second column. This combo is part of...
  11. K

    VB error updating text box from combobox selection

    I have a combobox selection ('product description') in my orders form which when updated must populate the product_id field. The combo box displays both fields, but once the user selects the item then the value of the combo is set to the product description and the product ID field should...
  12. K

    Locking records in order form

    Just the users of the form so that they can't accidentally change the data.
  13. K

    Locking records in order form

    I have and order entry/lookup form with a subform to view the line items on the order. Once an order has been saved and status is ‘placed’ I want the records for that order to be locked. I would also like to display a message box with a yes/no answer to confirm that they want to issue the...
Back
Top Bottom