Search results

hope that you can assist me too.

you are right there datAdrenaline. that is why I want to use Accdb format of access 2007 to utilize other features there. that is why I built my own synchronization code for accdb format. can I ask you again datAdrenaline where did you learn the other syntax for INSERT INTO that you gave me...

isnt there a thread tool in this forum such as "SOLVED" to indicate the post as Solved?

thanks for replying Dave. Using the setwarnings did do the trick. I finally finish the synchronization code for access 2007 (accdb format) that I will use in my projects.

namliam, actually it is my second option to link the table from externaldatabase if I cannot find the solution. so now I did opt for the second option. however still my append query has error message saying key violations. the error was only proper because the two tables have primary , unique...

sorry. i havent read this last night namliam because it was already 12 midnight and I have to go because the internet cafe is already close at that time. but thanks for the reply. I did try the debug.print but it didnt work so I used msgbox err.description to ge the error message and it states...

I'm sorry Col. Didnt I mentioned here that I can see whose individual online are capable but nonetheless didn't bother..

Yes, indeed that perhaps namliam had clearly answered it, do you think for me that has little knowledge about code (that is why I am asking for help) would automatically get what is the answer that namliam is pertaining to? Yes I am in the internet cafe and I cannot test it. while I got back...

again, I am using access 2007 accdb format. I have manage to create a code to programmatically synchronize between two database using the append query however, I have problem in that query because it says error key violation when there will be duplicates in records. maybe you can give me sites...

just like with my question post/right now about http://www.access-programmers.co.uk/forums/showthread.php?t=182631 is that difficult, wasn't I properly asked? didn't i tried to research it myself before I came here and ask for assistance? as you can see its not been resolved but as I can...

dont you think I can't decipher whose member in this forum are capable and those that are not? I have been in this forum for sometime now and I have seen those who are capable.

yes that is true. trying, experimenting are some ways to learn. but when you run out of tries and experiments and you have done everything already, researched through googling and still no results, you search for other ways to search for the answer and test, try , experiment on it. on the...

impatience their is not about how long it took for a reply. impatience there is a result from this situation. For example I have this question about simple code, whats lacking on the code. For 5 minutes, it didnt get answer. Then a new poster post his not easy question and after a minute or...

ok. thanks namliam. I will try it at home. but one more question. the two codes above have different syntax. the first has INSERT INTO (;DATABASE=D:\files\Database2.accdb) table1 ( ID, Fn, Mn ) the second has INSERT INTO Table1 ( ID, Fn, Mn ) IN 'D:\rommelfiles\Database2.accdb' do you...

sure it is impatience. how hard are my questions? I dont think it is. when can really see that such post was just passed by when you can really see that there are alot of capable individuals that can help but none. I dont get it. I wont bother posting this comment of mine if I can see that...

namliam, I am using Access 2007. I cannot test with debug.print now because I am in an internet cafe researching for this code. maybe you can lead me what is the proper syntax of insert into and left join so that I can properly modify the code. the first code was assisted me by datAdrenalin...

that is true

I have been using this code below in a query and it works just fine. however when I use this on module level the above code does not work. it says syntax error. so I modified it below in the module.. still syntax error on From Clause; any other way to revise the code to make it work? I need...

got to go. maybe someone will assist you. hang on.

access dont have varchar, longchar, real, datetime, longbinary.