Recent content by wtrimble

Ah, yes. I think linked table is what I need. Thanks for reminding me about that.

I have one master table with information about a unique ProjectID. There's another table that has supplemental (sp) information about the ProjectID (ProjectID's come from the master table), but only for a couple ProjectID's, not all. I created a query to combine the two tables for my co-worker...

Anybody have any suggestions?

I have two tables that are connected in a query. They both have a primary key as "ProjectID" and have a referential integrity with each other (Update). The first table (tblmaster) has all of the ProjectIDs (1000) where as the second table (tbltwo) only has about 5 records. I combined them in...

Uhh this kindof helps.. but not really. Unclear of how to use it.

I have a form in Db1(mainDB) that when a record is added in a specific form (tblsampledatainfo) it needs to be added to a table in DB2(XRFdb) in table (chemistry). My problem is this, I need to get the ID for the newly updated record in the Chemistry table in DB2 which is an Autonumber. The...

I'm using 2007

Yes I believe that is to pull a query from Access into Excel. I want to use an Update Query in Access and call upon an excel file /sheet/range... any idea?

This question is in relation to the last question I had. Can I pull data from Excel for an Update Query in Access?

How can I connect to Access from Excel. If I know that I think I write code to go line for line in excel and update my DB that way.

Anyone have an idea on how to go about doing it??

In my database I need to export a query to excel so my coworker can update it. Now I need to create a button that will create an Update Query to update any changed information back into the Access query. How can I go about doing this. I have the following from other sources but somethings not...

I have a table "tblengopp" that has a field "Oppid" which is the primary key for that table. I have another table tblprojectinfo that also has a field "Oppid" that uses the Oppid's from "tblengopp" I need to create a query that shows all of the "Oppid"s in tblengopp that don't show up in...

Yes, that works. Thanks a lot.

Ah, I'll give that a try