Recent content by crazdandconfusd

I think I've made the update query as stated in the response. The only thing I see happening now is it is repeating entries into the tables. I'm trying to have a unique job with amplifying information for that job in one table and then add all parts ordered with amplifying part information in...

Can anyone explain or point me to a thorough explanation on how to create an update query? I have normalized a table of data into two separate tables linked by another table with ID number fields. This created my starting point, but now as I import an updated table later, I would like to update...

I was able to perform the unmatched query, but got lost with the Event for the Continue button since I'm a novice and don't understand a lot of code. I've attached the database I have with just the table and fieldnames. The first field jmli_rqst_no is the field that is unique and won't allow...

I've researched this and couldn't find any information. I'm able to import new data from excel just fine, but I can't import updated data from excel due to duplicates not being allowed for a particular field. Is there a way to keep from importing duplicate records based on one field, but still...

First off, this website is awesome and have found some very useful information for my project in the making. I have a report that will grey out a record on a report based on any selection from a Combo Box [Hide]. I was wondering how to have a text box on a report change after all records are...