Search results

Bonne fête Rak! It is sad that you have to work hard on your birthday. I hope that your evening will be better. I wish you joy, a big cake and lots of gifts.

Haven't test it but this should do... You could create another table (tblCompaniesRelations) with these fields: CustomerID SupplierID boolActive In the relation page, you show the tblCompaniesRelations twice. For the first one you link CustomerID to CompanyCode, and for the other you link...

That is very good Tay! As good as my english. Maybe some mistakes here or there, but very understandable. You learned fast! My english is not perfect yet and I been practicing since I was a little kid. Yes, I'll be back for good. I still have lot of work, and don't need much access help, but...

Comment ça va, Tay? Ton français est bon? :cool:

I'm still alive Hi everyone! I've been away for a very long time and I haven't said goodbye when I left. Please excuse me for that. I had some problems with my company: Not enough contracts:confused: So everyone left:( A few months later, lots of contract again;) But I am all alone to do all...

I'll think about you when I'll open an office in UK. Cool! Having an office in Montreal and one in UK will grant me with the «Offices worldwide» link on my website.;)

Consultant and software developer I go to companies to upgrade their way to work, adding macros or code in their Excel projects, getting them from Excel to Access or from Access to independant software as it fits best for them. I have my own company and work in partnership with friends of mine...

From a paper I read recently (free translating): «The population getting older and older, in a few decades there will be more citizens of over 60 then between 20 and 60. That means that a lot of houses and flat are going to become empty as these persons will go to retirement houses or even die...

I really don't get it. Adding «Set Warnings = False» in your macro should block these messages boxes. Maybe if you try within the VBA code that would work better. In your extract_click() method, add this line: «DoCmd.SetWarning False» If that still doesn't work, I really don't know were the...

Me.CurrentRecord

Sorry, but I don't get it. Are these messages given to you by SAP or Access? And why do you want to say «No» to these questions if you asked for those extractions? Finally, when you say: «I have turned msgboxes off» do you mean you added «Set Warnings = False»?

Sorry for being a bit out of subject since I don't have any answer to give to you. But, I have a link here that might help you to test the color you choose for colourblindness. As a colorblind myself, I know how it is appreciated when a programmer thinks about us when they are programming. Bravo!

I am not 100% sure, but I think that you should say «Public Function» instead of «Private Function».

Maybe this can help... It wasn't use as you do, but the way it takes each fields that aren't null is the same anyway. Hoping that it helps you get on the right way.

Maybe this can help...

What are the messages on these dialog boxes?

They announced +8C for wednesday, so be prepare for every weather possible. As for how to dress in cold weather, you got to forget cotton at all as it does not breath. You also have to wear multiple thin layers so you can take some away as you get warmer. Welcome to my country, my friend, and...

I always act like if I was the most hansdsome guy in the world.:cool: Though I know that there is one guy somewhere in South America that looks better than me.:D

American falls:

Sorry, but it is on the Canadian side, so it is a Canadian wonder. The falls on the American side are much smaller.:p