Search results

Tried that and still get all of the warnings?

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

Many thanks for your help, Dave!

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

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?

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...

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

Well its a continuous form based on a query, so shows all records on the 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...

Iterating? Cheers

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

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

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

Cheers for that. Was pulling my hair out trying to use CONVERT (like I would normally in SQL2000) Cheers very much :)

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

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...

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

Save the record before print - As the record will not exist to print until Saved. Add the 'Save' macro before Print in the event details.

I do have a third table, tblTransactionHistory - That tracks all movements (Balance in, Sales, Transfers between locations) - I just require the 2 instances of one field, to work independantly of each other.

I have no many-to-many relationships. I require to transfer stock from one location to another. Because I have multiple locations, and multiple items, I have created a table called warehouseitems, to break to many to many relationship. I need to be able to transfer stock from one warehouse to...