Search results

  1. J

    Filtering By Form

    I have a combo box that the user can select an item to filter the form to the selected value. This works fine as long as they choose an item. What if I want to display all of the items? To state it easy, I want to allow the user to select "A" , "B" or all of "A&B"
  2. J

    Main Form & Sub Form

    Thanks Pat, I looked at those databases and the way you select a product is to select it from a combo box. I need a form displaying every item in stock and let the user select whichever products he wants to ship on the order. I was hoping that when he clicks on the Yes/No, it would populate the...
  3. J

    Main Form & Sub Form

    I have a database that I’m building to ship product. I have an inventory table that list all the details of each product in stock. I have another table that is to list what carrier shipped the selected products. This table has a counter field to uniquely identify each shipment that is called...
  4. J

    Security Message Box

    I have a database with user group security. If the user tries to go into an environment that they are not authorized, the system generated message box displays "You don't have permission to run bla bla bla". Is there a way to display a custom message box instead of the system generated...
  5. J

    User Defined Table Creation

    Is there a way that a form would ask the user what information they want to track. For example: the form would ask to enter what they want to track. The user types in people. The form then ask what else. And the user types in hours worked. And on and on and on until the user has defined all...
  6. J

    Animated GIF's

    Is there a way to use animated GIF's in Access? Thanks - John
  7. J

    Selection from combobox

    I have a database with a field called classification. There are only two entries for this field, CAR or TRUCK. I have a form for selecting the criteria to print. There is a combobox with the two options of CAR or TRUCK. The user can select either of the two and the report filters the table and...
  8. J

    Page Numbering for Sub-Report

    I have a "Main Report" that has three sub-reports. In the "Main Report" page header I have the page function. The entire report shows the page numbers as expected but I want the page numbering to start back at page 1 after the fisrt sub-report is printed and start back at page 1 for the 3rd...
  9. J

    How do I call a FUNCTION

    I have a text box that contains the "Book Date" and another text box that contains the "Run Date". I want a 3rd. text box to calculate the workdays between the "Book Date" and the "Run Date". I have created a function that should calculate the workdays but I don't know where to place the...
  10. J

    Two crosstab queries in the same report!

    Anna, Create a report for crosstab1 then create another report for crosstab2. Now create a blank report and use the subform/subreport option on the toolbox menu to stick in the crosstab1 report and repeat this procedure for the crosstab2 report. This will give you a report with both reports...
  11. J

    Combo Boxes

    Let's say your table has in this order: Client Name in column one and Client type in column two. On your form, name the Client name box as [Client Name] and name the client type bos as [Client Type]. Add the following code to the control source of the [Client type]box: =[Client...
  12. J

    form/subform totals

    Give this a try Ema: =Count(Forms![Absense]![Employees Subform].Form![Days Absent]) Place a test box on your main form and place the above code in the control source. E-Mail me if this doesn't do the trick for ya...John
  13. J

    Duplicate Index error

    First of all, try to enter a record where you now with no doubt that there is no duplicated fields and ensure the record can be saved with no errors. Then enter your problem record making sure that no fields are duplicated. In your table design, if you declare a field to be primary with no...
Back
Top Bottom