Search results

  1. OptimisticYid

    Replace/Update

    Just a quick problem .... I hope. I'm using SQL Server Management Express to administer my SQL database. Basically I have about 1100 products, 400 of which have a postage price of £6.00 which I need to change to £4.95, but the SQL statement I have written below doesn't seem to work. Can anyone...
  2. OptimisticYid

    Combo Box filtered by Combo Box

    I have just installed a new invoicing system and would like to add in a development. At present when you go to view an old order you can use one of two combo boxes to find a record, either by order ID or by customer name. My ideal would be to set up one combo box that details all the fields on...
  3. OptimisticYid

    Forcing sub form data

    I have a main form, lets call it orders and a subform, lets call it order activity ;) How can I force the user to enter in an activity before they exit the main form ....? Thanks in advance
  4. OptimisticYid

    Transaction log

    I have what I figure is a pretty standard format transaction log which is formed in part by three main tables - Order, Product and Transaction. Order can have many transactions, many transactions can have one product. Works well, produces a pretty invoice, feeds off into other tables as required...
  5. OptimisticYid

    ODBC Access Update

    Used to use these forums quite regularly and always found people to be of help, even started chipping in occasionally with the odd pearl myself :rolleyes: Anyhow, having forgotten my username i'm back under a different guise and have a problem that i'd like some help with. My company has a...
Back
Top Bottom