Search results

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"

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

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

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

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

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

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

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

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

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

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

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

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