Search results

  1. S

    Preview Report directly from form

    I have a form where information is entered into one db. I would like a button on that form that would take the information being viewed at that moment to a report in Preview mode. I have already set up the report. I have a button on the form that opens the report in Preview mode, but it allows...
  2. S

    Auto fill from cboBOX

    OK, I have been looking at other posts and using some of the suggestions there. Unfortunately, the ones that seem to answer my needs have problems, but are so old I don’t think it appropriate to contact the posters now. So here goes… I have a table called tblProducts. I then have a form called...
  3. S

    Two AfterUpdate Events Needed

    Does anyone know, can I have two AfterUpdate events happen from the same field? I have a “Distributor” field which is a combo box. This box triggers a cascading combo box effect so that once the Distributor is chosen, the “Warehouse” field, also a combo box, only allows for the choices...
  4. S

    Invalid Use of NULL

    I've got a query that I have copied from the Northwind database in an effort to understand how they have calculated their subtotals on their order form and order subform. I have changed the names of the fields (obviously) to match the names of my fields. Here is the SQL of the Query: SELECT...
  5. S

    Referential Integrity

    I am having a strange problem I cannot figure out. I have a main form for sales orders, with a subform where the products sold is entered. On the subform, there is a combo box for the products. I have created a one-to-many relationship (with enforced referential integrity checked) between the...
  6. S

    Cascading ComboBoxes

    Cascading Combo Boxes, yes another question on these. I know that there is a lot of information regarding Cascading Combo boxes, but I cannot seem to find exactly what I need, so I hope someone out there will help me out, as so many of you on this forum already have. First, you must know that...
  7. S

    Quick DLookup question

    Does anyone know if it is possible to have an After_Update of one field using DLookup, look up information for two separate fields? If so, do you know how to write it? Here is what I have that works great for the one field: Private Sub Distributor_AfterUpdate() On Error GoTo...
  8. S

    Datasheet subform not moving to next entry

    I have a main form that tracks returns from our Distributors. I have a subform on that main form that is powered by a query and linked to it’s own table for storing that info. The subform tracks three pieces of information: the product purchased, the amount of credit requested, and the reason...
  9. S

    DoCmd, or Filter for AutoFill???

    I’m not sure if this is a DoCmd or what the best way to approach this is and I am very new to VBA… My form is called frmSalesOrders (this is where our sales orders are entered). On this form is a field for entering our “bill to” customers (a combo box bound to the table tblWarehouses). I also...
  10. S

    variable auto fill options

    Many of our customers (distributors) have multiple “ship to” addresses. I would like to set up our “Orders” form so that when the data entry person picks one of our customers from the “distributors/bill to” combo box, the combo box under “warehouse/ship to” will only allow her to choose one of...
  11. S

    Linking Raidal buttons or check boxes

    I hope this is a simple one. Just to note, I'm on Access 97. Is there a way to create a two check boxes or radial buttons that are linked so that only one can be checked at a time. For example: I want the date entry person to be able to check a box that says "open" if a dispute it still open...
  12. S

    Auto Fill based on Combo Box

    I have a subform (called StoreProducts) that my data entry person enters the products that are carried by specific stores. She chooses the products from a Combo Box. Since all of the products we manufacture are already entered into a "Products" table, this is easy to do. When these products...
  13. S

    Columns from a Query in a Form

    I hope this is an easy one... I have a table that holds our Order Data, in that table I have a Query to pull specific Customer information (from that table) so that when my data entry person is in the Order Data form filling out newly processed orders, she can simply pull the customer...
  14. S

    A formula for my table

    OK, normally I would not do a calculation in a table, I prefer to keep that to queries and reports, however this is necessary. I have a table that keeps all of our sales data per order. When a distributor does not exchange a pallet at the time of pick up we charge them $7.50, but when the...
  15. S

    buttons and subforms

    I have a form that has two subforms. One is part of the regular form and works just fine, relating to the form as a subform. That is, once the information has been entered it is saved both in the form and the related table. The table for the subform automatically enters the related field...
  16. S

    subforms for multiple customers and products

    I know this type of question has been asked, but I have gone through the forum (as well as others) and have not found a workable answer yet. I have a table with all of our Customer information and a form directly bound to that. I have a table with all of our Product information and a form...
Back
Top Bottom