Recent content by Lyconal

  1. L

    Developer packaged file

    Tried that and still get all of the warnings?
  2. 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
  3. L

    Many thanks for your help, Dave!

    Many thanks for your help, Dave!
  4. L

    Parse through a recordset, running an update query as required

    Meh - Got it working :D *Somebody* has put a 'WHERE HistoryID=[forms]![form]![HistoryID]' like a numpty. Cheers for the help guys :)
  5. L

    Parse through a recordset, running an update query as required

    I have this at the moment, but it will only work on the currently selected record within the continuous form. How do I make it work on the rest of the records, visible in the form?
  6. L

    Parse through a recordset, running an update query as required

    Doesnt want to work for a continuous form, unless you know a way? (Need to update 3 fields to the values in unbound text boxes, if the yes/no field is true) This is so that more than one record can be 'selected' to be included in a shipment, and therefore will inhert the shipment data from the...
  7. 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
  8. L

    Update multiple records at once, from a form

    Well its a continuous form based on a query, so shows all records on the form.
  9. L

    Update multiple records at once, from a form

    I have tried to same criteria, but it doesnt seem to want to work (Only for the 'selected' record) I basically want to update any of the records within the recordset, where the field "Sent" has the value "Yes", with the Tracking info from the unbound boxes above. Like I say, it works for the...
  10. L

    Update multiple records from continous form - UPDATE Query

    Iterating? Cheers
  11. L

    Forcing user to select a value from list

    You will need to reference the unbound text box from the form you wish to run the query from, to the QUERY CRITERIA for the selected search. Cheers
  12. 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
  13. L

    Update multiple records at once, from a form

    The multi-select list box works a treat :) Many thanks, P.S - Does anybody know how to select all records from a continous form for an UPDATE query? Cheers
  14. L

    Querying a Date/Time field on DATE only

    Cheers for that. Was pulling my hair out trying to use CONVERT (like I would normally in SQL2000) Cheers very much :)
  15. 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
See more
Top Bottom