Search results for query: *

Hi I am having some problems with a windows form I am developing as part of a database application. The form needs to hold an address history for a person. The main part of the form has bound text boxes etc showing the details of the current record. I have also added a datagridview which is...

I have tried running the code with the criteria and without it but it still keeps asking me to select the data source. It also says "This recordset is not updateable" in the bottom left of the screen just before asking me to select the data source. If I debug it the code seems to be failing on...

I am using Word and Access 2002. I have created the template without the criteria in the Query as you said. I have also tried running the code with the criteria missing and it is still asking me to select the data source. I am also trying it with your code now. I have posted my version below...

Thanks for that I was starting to think I would never get a reply! The problem is more to do with actually setting up the word template in the first place. I can't select the query I want to use for the merge from inside word as it doesn't appear on the list of tables and queries. If I try to...

Hi I am trying to create a template in Word which uses an Access query as its data source. The problem seems to stem from the fact the query uses form data as criteria. If the form data criteria is removed all works well, if it is put back in however, the word document is unable to see the...

Thanks guys. If the string is not "String1", "String2" or "String3" then the field is just left as it is. Can anyone recommend a good reference site for functions such as this?

Hello All I am trying to write an update query which will set a field to one of two possible values. The value to be set depends on a string contained in the same table. For example: If the string = "String1" or "String2" then the value needs to be: Value1 But if the string = "String3" then...

Thanks for the quick response everyone. They all worked great!

Hi I need to create a query to delete repeating rows in a table. I need to keep only the rows which do not have any duplicate entries. For example if I had the following entries: A A B C D D I need to be left with just: B C Can anyone offer any ideas? Thanks.