Recent content by dcb

also the two tables are exactly the same?

Seeing you are doing the excel method - save me some time here and put 5 rows of data in - also one row which has the example of dont update....

How big is your db? Can you post it? Or at least you table structure so I can help you

Create a normal select query as you would in designer including only the fields you want, and criteria to meet point 2 Then turn it into a append query

We get this issue on laptops normally Try swapping your primary/secondary display As per the other post VLC Rocks (cross platform too)

PS: Point 2 You can exclude, as described, using a where clause as in any select statement

Use a insert into ........ select .......... query http://msdn.microsoft.com/en-us/library/bb208861.aspx http://www.blueclaw-db.com/accessquerysql/sql_insert_into.htm Give it a try and post back if you get stuck

Please find, attached, an exact replica of your document: Note: (No Duplicate, Indexing) Null on Parent_ID in Child_ID 1 RI

Thanks for testing: Again I cant duplicate the fault..... Please tell me which line number? Private Sub cmdS_PopUp_Click() 'DoCmd.OpenForm Dim bolSet As Boolean Dim intBorderstyle As Integer 10 DoCmd.OpenForm fCurrentForm.Name, acDesign 20 bolSet...

However you may be able to use the seek method if you specify the db as the foreign db not currentdb ....

Export to Excel http://www.btabdevelopment.com/main/CodeSnippets/SendFormsRecordsettoExcel/tabid/120/Default.aspx

You can't use the Seek method on a linked table because you can't open linked tables as table-type Recordset objects. (Source: Access 2007 Help File) FINDFIRST !!!

so you are looking to duplicate within the same table? My answer applies: Consider this query INSERT INTO YourSubTable ( Some_Field, FKID_Field ) SELECT YourSubTable.Some_Field, 2 AS FKID FROM YourSubTable WHERE (((YourSubTable.FKID_Field)=1));

The first question is why are you doing this? If its to warehouse this data (and clean your working tables) you should, IMHO, be de-normalizing your data.... Looking at your method: Append query in Table 1, lookup the last created ID1. Loop through all the linked records in Table 2. For each...

Put it before your "end if"