Search results

And what about these:

I am in Terrebonne.:cool:

I haven't read it all, but this seems to be what you're looking for.

DELETE * FROM mastertable WHERE Identicalfield Not In (Select Identicalfield from secondarytable);

Is your form actualy a subform? If so, and if you put the command button on the main form, the subform would have lost its focus and your code would be unable to sort the main form. Regards from Québec (pretty warm here)

You can use «Memo» instead of «Text». But you've got to know that memo fields give some problems when used in some complex queries, such as with group by.

I like that one. Will try to remember it.

AngelsGuardian, are you from the Montreal area to?

Here it is!

Just add an «AddNewRecord» button in the footer, which opens another form in which you enter the datas.

Rich is a good exemple of escapism. 21 years old... ROTFL In your dreams.

You could use the «Details_Click()» method with the textboxes «Enabled» property at «NO».

Not very good with ASP, but it seems to be a problem of opening a recordset that is already open. Look at your «MyRS.Open» and «MyRS.Close».

Here, there is a TV show where they talk about computers and new technologies. It is called: «Revenge of the nerds». I like that title a lot. When I was a kid, every one was laughing at us (nerds) because we weren't doing sports, getting out to party at discos, smoking pot and drinking beers in...

Tools menu --> Start --> uncheck the first checkbox on the right. Might as well look at the others while you're there. They give you the options to protect the database even better.

Yes 40$CAN. ~30Euros And a lot of tourists pay that price not to get on the other side, but just to get on the bridge, coming back right after. BTW, getting on the island is free. You just pay to get out of it. There is also the alternative ferry, but it is almost as expensive and it is a really...

I like to reveal my self by bits. Anyone who wants to know more about me just has to read all my posts. Almost everything is there... still some more to come.;) I don't hide behind my nickname to every one. If you've been here for long enough, you probably already know my first name, my previous...

And here is the Canadian best bridge (World's longest): http://www.confederationbridge.com/ Look at the aerial view pictures in the Photo Gallery(via the Media Gallery link)

Here it is:

It has to be that one: http://www.access-programmers.co.uk/forums/showthread.php?t=47488 It was just too funny.