Search results

Thanks Isskint. It went just like you said it would but when I tried to run the append query it didn't add the record due to key violations. Perhaps JBB has spotted my problem. I tried to switch to an Update query, but can't nominate a field in the Update To: line in design view. Do I need...

Hi all I'm a user not a programmer and can only sometimes follow VBA. I have copied some code from this forum to create a temp table using transferspreadsheet. Now I want to copy a field into its destination table. I can extract the field using dlookup in a select query (Expr1...

My database is used to manage 400+ projects. It uses a number of linked tables and queries. I need to import a spreadsheet containing information that will be attached to several different tables. My problem is in associating the imported spreadsheet to an individual project when it is imported...

Hi all. I've been lurking for a while and realise how much I have to learn, so I thought I had better say hello.