Search results

  1. L

    Developer packaged file

    Just packaged my file, but everytime I try to press command buttons, it keeps asking if I really want to run update query etc. Anyway to stop this? Cheers
  2. L

    Parse through a recordset, running an update query as required

    Hi Guys, I have a continuous form that I want to parse. I want to check each record visible in the continuous form (source is a query) and if a yes/no box is checked, then run an UPDATE query for that record, then go to the next record and do the same etc. Any ideas on where to start? Cheers
  3. L

    Update multiple records from continous form - UPDATE Query

    Does anybody know how to UPDATE all records shown within the continous form, via an UPDATE query? I have got it working, but only for the selected record. Cheers
  4. L

    Querying a Date/Time field on DATE only

    Hi, Anybody know how to do this? I have tried converting the date on the fly, but to no avail. Any help is appreciated. Cheers
  5. L

    Update multiple records at once, from a form

    Hi, I need to create a form that can do the following: 1) Show multiple records per form (Like datasheet view maybe?) 2) I require to have a checkbox work 'independantly' of each record, without being a field within that table The reason for this, is that I want the following to happen: Open...
  6. L

    Adding a new record from combo box (In new form)

    Hi, I have a combo box that allows the creation of a new record, via a new form. Is there any way to get the combo box to default to the new record entered via the other form, once the other form has been closed? Cheers
  7. L

    Multiple instances of a field (Independant) on one form?

    Hi Guys, So last question I will need to ask (I think). I have a form that I want to use for stock transactions, that will require 2 instances of the same fields (Warehouse and Quantity). I also need this to create '2' records in the history, one for the FROM and one for the TOO. I think I...
  8. L

    Running an UPDATE query when closing a form?

    Hi, I need an UPDATE Query to ONLY update the one record in a table, based on the information on the CURRENT FORM only (Not the rest of the records available from this form) Anybody know how to do it? Cheers
  9. L

    Combo box - Show one column, save another?

    Hi Guys, Anybody know how to make the combo box (Linked to another table) show the Code and Description fields, but then SAVE the PK ID field? Would make my life so much easier. Cheers
  10. L

    Field based on information in another field

    Hi guys, I am working on a database for stock movements, and need the following to happen: On the TransactionHistory table, when a StockItem has been picked, the Warehouse list needs to filter based on the StockItem. The following is the setup for my dBase: StockItem Warehouse WarehouseItem...
  11. L

    Stock Transaction Table - Location A to Location B

    I have a database and want to log transactions from location A to location B, so I require 2 records inserted into the transactions table (One to remove the quantity from Location A, and one to add the quantity to Locaion B) What would be the easiest / best way of acheiving this? Cheers
  12. L

    Adding multiple locations to an existing database

    Hi guys, I have a current dBase functioning perfectly, but need to allow 'multiple' locations for stock? (Inventory management). So one item can be in one of 8 locations, and the total of the stock at all 8 locations is the total group stock. Any ideas to the easiest way? Cheers
Top Bottom