Recent content by dfitz

Another idea! How do you select the records to appear in the form? If this is done using a query, can you use the query as the datasource for the INSERT query so that you don't need to refer to the form? df

In your first example, all of the conditions must be true before you will get completed. As you are testing the same field for three different values (AssessmentID), you can never have a true outcome. Try changing the And to Or in your statement and it will work. df

The problem is that you are using a continuous form that displays all records. A better way of doing this would be to select the records that you want to move, say by using a checkbox and replace the WHERE statement with WHERE mycheckbox=True. df

You're welcome Glad to help. df

I don't think that you can do what you want with a simple query. You will need to create a query to lits all items by box and use this to set up a recordset. You can then set up a loop to go through all records and identify whether all/none/some files are in archive. I would suggest that this...

That shouldn't be necessary bacause you are still running the sub programs sequentially. It may be worth setting any variables that carry over from one subprogram to another to a null value at the start of the sub program... jst to be on the safe side. Dave

Oh, and another thing... Sorry if my explanations are too basic. Not sure whether you have been using Visual Basic or not. Dave

One final try..... I assume that you are calling the query from a command button. Open the form in design view. Right Click on the field that is posing the problem and bring up the properties. Go to the event tab. The OnClick event should have [Event Procedure] alonside it and a box with ... at...

Open the query in design mode and where you have the field in question as the selection criteria type Like before the field name. Dave

Open the form in design mode. Right click on the field and select properties from the menu that appears. Select the Data tab and look for the Default Value item on the list. Just type * next to this and the job's done. Dave

If I understand the question correctly, you want one button to run all the queries. The queries are currently run from a number of buttons on different subforms. I also notice that the queries use values or update values on these subforms. I can see no reason why the code would not work if you...

Set the default property for the combobox to '*'. When the query runs, it will use this as a wildcard and the query will work. dave