Search results for query: *

No, that did not work. Anymore ideas?

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...

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...

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...

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...

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...

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...

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...

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...

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...