Search results

quoting and posting here

I would like to quote and post this here:

yes I have tested it without the RI and I created query and codes and it work just fine for now for me. May I ask you Sir, you said that you also... May I ask if you have problems with RI there or how did you establish your RI? I mean did you enable your RI? Was you database working fine with...

yes Rabbie, it would be definitely easy to establish RI to become fully relational DB, however when I learned in my project that establishing RI is for the purpose of cascading updates/deletes so as not to get problems with orphaned records, I have not need of it because I have manually created...

actually not. it is just an anticipation for the years to come while I am still learning mysql. whew, it is hard for me to grasp the idea of sql now when I am stuck with a database file type. I need more time for it to learn.

I did not use the currentdb.executre strinsertinto, dbfailonerror to trap any error. I use the docmd.setwarnings false at the beginning of the code that is to be executed to trap error therein and not as part of the sql statement dfenton sir.

only when I create query that needs relationship I create relationship between tables. I do not establish Referential Integrity.

I used the code at VBA level. The SQL that you provided works but I did not used the currentdb.execute but instead I used the docmd.setwarnings.

beating is not my preferred word.

nice comment there Bob. seems like I am not the only one using the word loop, going around the bush.

I just think it is not in general sense because you posted if answers are not happening to me then I should change my post and you have given factors in posting. That is indirect remark.

the fact is I have seen worst grammar and spelling in this forum but got replies, and the helper that time took the time of analyzing the problem from that grammar by rephrasing that problem back to the poster.

if I may answer that Mike, can you tell what post have I fallen in your #1 "(1) Written in all lower case, terrible spelling and punctuation." as I have said previously, I wouldnt asked question if I have either got my solution from googling or from other forum as well.

thanks for replying still on this one Sir Brent but I used setwarnings to false to trap the error that way. i dont know if that is proper way of doing it but the works fine for me.

Oh I see. Yes I have also noticed that but I didnt know that was the purpose of RI. Yes ofcourse coding that is alot easier knowing what is the purpose of that RI. HiTechCoach, yes it is better if I just place all my tables in one DB. But I opted for using multiple DB from the beginning and...

I think we are discussing topic of this thread "How to talk to a programmer' wherein rules or guidelines where set. I think we are not talking if there is a rule that compels anyone to respond. These are some of Bobs answers. and did not I mention on my previous post on this thread...

Ignore my post? I have already taken that risk/situation when I have commented on this thread, because you cannot please everyone with what is the opinion or comment of the other person.

this topic has defrayed from How to talk to a programmer to How to setup your nickname. My main comment is that regardless how or what rules are those to be able to get the attention of the helper, it does not matter because as what Boblarson has confirmed, therefore, rules does not apply...

thanks for giving out the meaning John Big Booty. that is true Dave. that is my intention. I havent found problem on my RI as of the moment. And another site I would like to mention is that I was one program that I have downloaded from the internet using access as FE and BE, it uses multiple...

Could be? dont bother your mind thinking about such things. You will never know if that is true or false. The only fact in this forum are the individuals who "Help" and those "Need Help". Regardless, if they are Old individuals, Professional, Young Adults, Students, programming experts...