Search results

I have a main table and 2 sub tables which are linked to the main table. I put all of them in 1 query. The query shows me only those record where some data are also inserted in the sub tables. That is NOT my wish. I want this query to show me all records even if there are no data's for this...

Thanks but this too is not working Jackske Belgium

It does not word Thanks for the advice, but it is not working, look the attachment Jackske, Belgium

Thanks Rich, I did exactly what you wrote me but I still get the same error message. Why? Jackske, Belgium

Thanks, but I always get an error message. It is probably something stupid but as long I do not know exactly waht, I will stay .... stupid. Please see attachment. Thanks in adavance, Jackske, Belgium

at one go How can I convert at one go all the records in a table to vbpropercase? Thanks, Jackske, Belgium

Here the correct attachmen.

I did not succeed. Look to the attachment. What is wrong? Jackske, Belgium

I want to change all names to vbpropercase via an update query. I did put the field "Names" in my query and wrote in update names:strconv(names,3). It does not work. Thanks in adavance, Jackse Belgium :o

To all, thanks it is working. Nice to have such a kind community Like you say in English "Merci beaucoup"

What do you mean with rs.edit and rs.edit? What is the code I forgot?

Thanks for your good will The message is 'Run-time error 3020' Update or CancelUpdate without AddNew or Edit

I am using Office 2000 and in my references DAO 3.6 Object Library is checked. Any way, thanks

I have a table call Members In the table, one of the records is called 'rank' I want to write some code to replace the rank with a value. For example, in the first record, rank has to be replaced with number 67 In the second record, rank has to be replaced with number 68 etc… I made a new module...

I have a table call Members In the table, one of the records is called 'rank' I want to write some code to replace the rank with a value. For example, in the first record, rank has to be replaced with number 67 In the second record, rank has to be replaced with number 68 etc… I made a new module...

I have a group of 2 tables (members & gifts), which are linked. I have an other group of 2 other tables (members2 & gifts2) with identical structure as the tables of the first group. I one to add some records from the 2 tables of group 1 to the 2 others tables in group 2. An 'append query'...

In Antwerp we say 'Dank U'.

you did omit Name=... in the criteria. Your code will not work. Any way, thanks

Thanks but with your code the 3 first have to be identical to the fother first 3. I would like to contre if "cde" appears in "abcdef" Thanks, Jacques-Belgium

About the DCount function. Dcount (“[Field]”, “Table”, “criteria”) I am calling this function from a form while I am adding a record. I use the criteria argument to compare if the ‘Name’ in my table is = ‘Name’ in my form. The syntax of the criteria is...