Recent content by cjh7111

Hey all, Ive come across a problem while working on VBA in excel that pulls data in from an Access Database. It was working yesterday but for some reason im getting errors today. The VBA pastes data into the database and then runs some queries and then copies the query and pastes it back into...

How would I go about it instead?

Alright, so here is an abridged version of the SQL of the query. [Paste Table] is populated with data that users input (done via vba in excel) and then it pulls the BS%@W and BS%@C from the back tables. I need records that it doesnt find in the tables to stay blank so they know that it didnt...

Hey all, I have a query that is returning a number of duplicates because of the way that it is set up. The duplicates are the same in every field except one (BS%). For the duplicates, BS % is blank in one and has a value in the other. I want to query the original query in order to remove the...

Hi all, I'm new to Access so I'm a little lost. So I've created a query with the following SQL: SELECT Table1.[Material Key], Table1.[Material Name], Table1.[Info] FROM Table1 INNER JOIN search_MaterialKeys ON [Material Key] = search_MaterialKeys.[MaterialKeySearch]; So at the moment, users...

Thanks plog, that's helpful. I'm a little confused as to how to make a temp table. Ideally, a form would pop up that users could paste their list of mat numbers and it would populate the temp table and then run the query based on the numbers in the temp table. Is this possible?/ How would I...

Hi all, Alright so I'm new to Access and I'm a little lost. My end goal is to create a database where users can open up the front end and input "Material Numbers" and then will be provided with the related data for said material numbers. Currently, I have the query set up with the following...