Search results for query: *

I need to run a function on a linked table and I am not sure how to define MyTable as a linked table. I am new to Access VB and my Access help files are corrupt so i am in a bit of a bind. My code gives me an error at the "Set MyTable= . . ." I know I need to define MyTable as a...

I just had another thought. If you have a few records that you want to add to another table in another database then why don't you use an Append query to append those records into the fields that you want. It is dangerous to cut and paste records into a table but if you have to do that, then...

If you want to import a table into another database then you should use the import/export option located under the File Menu, Get external data menu option. If you have a form and want the import to be automated, here is the Access VB code to import a table automatically...

Thanks so much for your time. This is very helpful to me, but I have another couple silly questions. Do I need to enforce referential Integrity in both databses or just one? and how do I enforce referential integrity after I have linked the tables? Thanks again for your time.

I had to break a part a large DB (1 gigabite DB) into two Databases and I am running the same Access VB functions to update the same master tables because each db has a copy in two separate databases. Can I create a link to the master tables from the second database to the first one so that...

I need to pass a numeric key variable with a name selected on a cftree selection. I know there is a very easy fix, I just don't know what it is. Thanks for your help. Here is my code: <CFFORM NAME=&quot;form&quot; ACTION=&quot;treat_tactic.cfm&quot; METHOD=&quot;Post&quot;>...

I am using Access2000 and I am currently using a macro to open a different database with a command button from a form. My problem is that I need to automate openning the new DB and closing the current one and a macro continues to run. I thought that Access used to have OpenDatabase and...