Search results

  1. M

    limit the recoed to one page

    My report alwats prints an empty page when printing, this should be trivial to you guys but it is doing my heading. any ideas?
  2. M

    Run Query from form

    Does anyone know how to run a query from form and set the query parameters to fields in the form. This is what I have a query that have a date between start date, End date, I want to be able to run it from a form and set the query paramiters from the start date field that I have on the form...
  3. M

    Undo record save

    could someone tell me how to do an undo record save? I have an order form based on a query, the problem that I have it saves data in the sub forms when I do the undo save record, using a button.
  4. M

    How to do a 2 for £5 promotion

    hi all I have a order system like the one in Northwind db, the problem that I have is need to implement 2 for £5 offer on one product, any ideas on how to do that?
  5. M

    Stock control

    Does anyone has an example of an automated stock control? please let me know
  6. M

    Rounding a number

    Does anyone know what is the function for rounding a number to the nearest integer, I tried int() but this does cutting, i.e. cuts the fraction bit. any ideas?
  7. M

    Order ID

    I have an order table that stores orders from different supplier, but how can I have a different order ID for different supplier of product that increases serialy. i.e general order id for all orders which i have. another order id for orders by a specific supplier.
  8. M

    Forward Data

    What is the best way to forward data from one form to the next and then to the next, i am currently doing it by saving the data into user defined data types, but my worry is it might not work when i go into a multi user usage. I am saving userid, amd customerid and supplier id, into variables...
  9. M

    cursor position

    Can anyone tell me how to make sure that the cursor is at the begining of the field when a field gets focuse By the way it is a text field on a form
  10. M

    Undo Record save

    Hi all I have an order form similar to the one of Nothwind sample db, the problem that i have is when data entered to the form there is not way of undoing the data since there is two subforms that store data in different linked table, any ideas? I am still waiting for an idea.
Back
Top Bottom