- Local time
- Today, 10:42
- Sep 12, 2006
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 home after that, it tested to debug.print it however that doesnt work. I tried msgbox err.description and it states the problem in the FROM Clause. and I tried to modify and modify the code at home but none worked.
I wont be asking for that question in here if I have managed to solve it myself or from the researched I have been doing googling and gooling.
genesis - i added a reply to your thread now, and THEN read this thread. [the post about the insertinto query]
I think it is highly likely that anyone reading your thread would be highly confused. - not necessarily because what yuo are trying to do is wrong - it may not be incorrect, and it may well be a simple fix - its just that the functionality you are trying to use appears somewhat esoteric (if thats the right word) - I didnt realise at all that you could directly address an external database in the way you have - as scooter just said, using linked tables is easier. Possibly very few posters would have the time to experiment, to see how your construct worked.
And therefore because the query was outside the knowledge/experience of many of the regular posters here, you probably didnt get many takers
i thought about this again (ie why would you want to do this without linking the tables), and on reflection i can perhaps understand that in a company you may have several related but distinct databases, and that information in one needs to be passed into another - without necessarily permanaently linking the tables. I cant envisage this being needed outside a work environment, and it therefore seems curious that you are asking form an internet cafe, but perhaps thats a timing thing
In my opinion this forum is the best and easiest to use, and I am sure not many posters fail to get an answer.
Hopefully you will get a solution to your problem
[edited - reading the whole of this thread again, the other post you refer to, which you bumped several times, (and which i also replied to) was again dealing with a fairly unusual code. [linking databases/tables] - it does seems that you are trying to do some things in an unusual way, or in a different way to most posters here - i am not sure where you got the code, or even exactly what you are trying to achieve - and as such you are probably less likely to get useful responses.
you also said rhetorically that you didnt think your queries were difficult - well they seemed very obscure and complicated to me - and certainly not enquiries to which I could give any more than just general information - which I tried to do
Please note this isnt meant to be controversial - just a viewpoint/explanation]