Search results

Good morning I have a glitch with a query I think. I'm a user not programmer so I'm hoping for some advice. I use transferspreadsheet to upload a report into a temp table, then a series of queries to move relevant information to appropriate tables, and a final query to empty the temp table...

Good afternoon When I click the Create MDE button I get the error message You cannot add or change a record because a related record is required in table 'MySysAccessStorage'. I am a user who has been making some improvements to our database. I have been pretty successful with the help of...

Hello I'm a user not a programmer and I'm hoping for a bit more help following up on assistance from John Big Booty a few months back. I used some code from John Big Booty to import a spreadsheet into a temp table and then run a series of queries to move the data to their final tables...

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.