Recent content by dw85745

GPGeorge: Since you were kind enough to go to all the trouble to put out those definitions, and since I'm posting on this forum, I'll do my best in any future posts to follow those definitions to keep that thread on track. Not to cause another off-topic discussion, but: In that regard here is...

---------------- The-Doc_Man ---------------- Thank YOU. -------------- Ms. Hartman: --------------- While I have a lot of respect for you, based on your posts, I respectfully disagree. An SQL can use IFs, ANDs. ORs, NOTs, and SubQueries, which IMHO is programming logic. An object does NOT...

Personally we are beyond the point of this thread and in a debate over whether one calls a "toma'to" a "to'mato". Since I am unable to post a link, hopefully putting it in quotes will work. ERRORED even as a quote. I'm deleting the internet prefix in the hopes that works. It does. This...

cheekybudda and CJ London: When I stated stored / unstored procedure, I was referring to stored/unstored ACCESS queries. IMHO they are really the same. A query is a procedure. AND unless you know otherwise, ACCESS STORED queries (procedures) require table field names in the SELECT clause...

cheekybuddha and "The_Doc_Man" In code (most OPP languages and Classice VB -- not sure about VBA but believe VBA does Not have a compiler) objects can be early bound or late bound. An early bound object is known to the compiler when compilying (e.g. oPBox As Picturebox, or oText As...

This is a test. Twice previously I've unchecked "Stay logged In" and my posts have disappeared. What I don't understand is Pat Hartman response after Nautical Gent is also missing.

my post this morning did Not take for some reason. ----------------------------------------- NauticalGent: Thanks for responding. --------------------------------------------- Not familiar with TempVars, but looked at M$ docs about them. Basically a collection of variables. AFAIK: Stored...

NauticalGent: Thanks for responding. Link: (for some reason forums will not accept a link). Will have to play with it to see if can be accessed from Code other than Access VBA.. If it can be used in stored procedure, this would greatly reduce the number of stored procedures I use. In compiled...

The_Doc_Man: So now I have a decision to make, stay with ACCESS or go with a new Db. One Hopes for that. I always try and get things to work first, then optimize for speed. ---------------------- FWIW----------------------- Data files originally started out as flat files. When "Revelation"...

Thanks to everyone for their responses ------------------------------------------------------------------ Knowing What I'm Doing, Most Likely Will Help Responses ----------------------------------------------------------------- The App is a real-time trading program, for ALL markets. It was...

Thanks to all for responding -- Happy Holidays. For some reason, posted responses got lost in my EMail client -- I didn't notice the line until today. Had pretty much determined there wasn't a solution. The_Doc_Man The link to JET SQL IN states: The way I read this is ONLY one DB open at a...

CJ_London and The_Doc_Man: Thanks for responding. CJ_London My post, previous to yours (which they had a post number to reference) and the original code post, reflects having two database objects will NOT get me anywhere, since all DB procedures are hard coded to use>>. dbDAO. {whatever}...

The Doc Man: Thank you for that excellent response. FWIW I started out on a CDC 6400 myself in 1969, While I recognize a certain amount of speculation is involved, based on my efforts to date it rings true. I now post the background of my problem (as I perceive it)., and my second question...

I have a number of question in this area. I will post them one at a time based on answers. ================ Question #1 ================ If I run the following code,, the two databases are added to the Workspace Collection. NOTE: GetPath is a function that returns the database Path...

UPDATE Working as it should. (My Error as forgot to change which DB in one of my test code line.) ORIGINAL The Source DB resides on a CD. The CD drive device is CDRW. The Destination DB is on the HD (hard Drive). What my script does is Open Each Database (CD is opened exclusive, HD is open...