Search results

  1. P

    Can I click on a part number in layout view of a form and have it open a new form?

    I found an answer for this question in another posting I had missed earlier. The answer can be found at: http://www.baldyweb.com/wherecondition.htm Thanks for your past and future help Paul
  2. P

    Can I click on a part number in layout view of a form and have it open a new form?

    I am using Access 2007 and have an issue I’m hoping you can help with. I have a form (frmSearchMain) with a combo box (cboSearchType) from which you choose a search type and a text box (txtSearchString) where you enter the search string and a button (btnSearch) that runs a query and opens a...
  3. P

    Dynamic Label Captions

    John thanks for your input, I’ve used your suggestion for making the fields visible or not and have that working. Your suggestion for the caption works well if I had a set number of captions for each field, however, that’s not the case here. I have a form “frmSelectCategory” with a combo box...
  4. P

    Dynamic Label Captions

    I have two tables “tblCategories” and “tblParts” that I am using with a series of forms as listed below. 1. “frmSelectCategory” – This form has a combo box with a list of part types, and a command button. A part category is chosen from the combo box and when the command button is clicked it...
  5. P

    Help with Incrementing a Custome Formatted Unique Number

    Help with Incrementing a Custom Formatted Unique Number I have a database with a table "tblCAPARMain" in which there are numerous fields some of which are: BaseNum FormatNum CAPAR# CAPARDate I also have a form "frmCAPARMain" in which I want to create a unique number for each record to be...
  6. P

    Creating Multiple Records from One Form

    dk, once again thanks for the quick reply. With a little tweeking to fit my application your solution works great and does just what I was looking for. Thanks, posterman
  7. P

    Creating Multiple Records from One Form

    Thanks for the quick reply, but I don't see the attachment.
  8. P

    Creating Multiple Records from One Form

    Hello, I am working on updating an Access 2003 database using Access 2007 and have a question about auto creating new records from a form. The current form (frmMainForm) includes the following fields and creates records in the table (tblMainTable) Inspection Date...
Back
Top Bottom