Search results

  1. J

    Macro that asks user whether to print or printpreview

    Hey, I was wondering if it is possible to make a macro that asks the user whether they want to print or print preview a report. can this be done?
  2. J

    What is wrong with my IIF expression?

    Hey. In a subform I have a Final Price text box which I added while in design view. First I had the expression: [Quantity]*[Menu Price]. But then i remembered that every time a customer orders an item more than once the price of the item gets cut down to half the price. Obviously i need an IIF...
  3. J

    How to Count the "Nth" Number

    Hey, Whats the expression used when you want to Count all the records (e.g. Count all the number of orders a customer has made) and for every 5th record ( so when the count =5,10,15,20...etc...) the field displays Yes. In my case I have a Discount field of data type "Yes/No" and I want this...
  4. J

    What is entered in a parameter pops up in the Form

    Hey, I made a form using a field from a query that uses a parameter. When I enter this parameter, for example a date, how do I make the date appear on the form? Is this possible? Any help is much appreciated!
  5. J

    Urgent HELP!

    Hey, I set the background to a text box to "Transparent" but every time I open a form access automatically selects the first text box ( the transparent text box) which makes that text box turn white. How can i stop this from happening? When the form opens is there a way to stop access from...
  6. J

    Help! How do I...

    Hey, I want a Form which displays three different List boxes. Each list box is made up of three different queries. I don't want to display all three list boxes at a time. Instead I want each list box to only display onto the middle of the screen when an OnClick button is pressed. For example...
  7. J

    HELP! Trying to make a query where every 5 orders a customer receives a discount.

    I've made an ordering system which includes a query that counts how many orders each individual customer has made. Every 5 Orders a customer gets a discount on their order. How do I apply this? Is there a function in access that recounts values? For example, access would count all a customers...
Back
Top Bottom