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 derfloh 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: *

  1. homless

    How to keep Access Form Header and Detail Section Together

    No, that did not work. Anymore ideas?
  2. homless

    How to keep Access Form Header and Detail Section Together

    Is there a way to fuse or rather stop the Detail part of the Access form from moving when vertical navigation bars are active? I have a form that is a little big for my screen so I had to keep the vertical navigation bars on. But when I try to scroll up or down using the navigation bar, the...
  3. homless

    Check box Option Group

    Left out the quotation(") marks at the end of the queries on the last thread. Case 1 Me.Text2.RowSource = "SELECT qryInStock.ProductName" FROM qryInStock Case 2 Me.Text2.RowSource = "SELECT qryOutOfStock.ProductName FROM qryOutOfStock" Case 3 Me.Text2.RowSource = "SELECT...
  4. homless

    Check box Option Group

    Thank you [2thumbsup] This is what I did and it appears to be working. Is there something else that I should add? Can I add Me.Requery after each case statement? What do you think? I want to be able to see new records that are added to the product table. Private Sub grpBox_Click() Select Case...
  5. homless

    Check box Option Group

    I have an Access form that has 4 check boxes. I have 4 queries for each check box and a combo drop down list that displays products that are in my table tblproduct. The check boxes are named as follows: InStockQ OutOfStockQ DiscontinuedItemsQ All Products The frame name for the grouped...
  6. homless

    Update Checkbox

    Actually, I figured out the problem. There was some bad data in the table and after I deleted the bad data, I was not getting the problem with Access duplicating columns anymore. And for the discontinued products check box, i just added the code in the After Update Event: me.dirty = false So...
  7. homless

    Update Checkbox

    I am sorry, I only have one table, product and I have 3 check boxes, InStock, outOfStock and discontinuedItems. I have a query to filter discontinued items but my problem is that Access is putting duplicate rows into the columns when I check on a discontinued item. Example of product Items...
  8. homless

    Update Checkbox

    Please tell me what I should do? I created another check box on my product table for discontinued items. But it is not doing what I want it to do. What I would like it to do is to be able save selected discontinued products on the table by putting an X on the corresponding field. I don’t want to...
  9. homless

    Update Checkbox

    Thank you very much dhookom [thumbsup2]. I put the code below in the After Update for the check boxes and it appears to do what I was looking for. I can select or dis-select a product and the report shows the changes without me closing the form. If Me.Dirty = True Then Me.Dirty = False End If...
  10. homless

    Update Checkbox

    Thank you in advance for your help. I am clueless here. I have an Access form with two check boxes for Instock and OutOfStock products. There is a drop down list for the products. I want to be able to print products that I have selected the checkbox for. If the checkbox is not selected, then...

Part and Inventory Search

Back
Top