Recent content by dcumming

No - i didn't quite understand the formatting of the code to enter

AND THIS IS THE ANSWER!!!!!! "I just want to be able to click a button and update a number of fields in an individual record, rather than having to fill them in manually" thankyou @LarryE for reading my request :)

Yes! "@CJ_London if so the code behind the button click event might be something like txtSource=“ebay” txtcountry=“USA” Etc" Something like this yes i was hoping there would be an onclick command 'For this record' UpdateField eBayCountry = "United States" UpdateField eBayGenre = "Soundtrack"

"How are you meant to know which is which?" - not sure what you mean I just want to press a button and make those changes to the record that is currently on screen - there will always be some manual entry from me, the name of the artist for example. i want to update the record that is...

Hi Gemma et al - seems I've rushed the explanation of what I'm trying to do. I just want to be able to click a button and update a number of fields in an individual record, rather than having to fill them in manually No fields dependent on others - they are dependent on the vinyl or CD i have...

Hiya, I've a form that I update manually when I buy stock - and I'd like to be able to automate it a bit. For example, if I get a soundtrack on vinyl, i want to be able to update a number of the fields, rather than changing them individually. In this example, I would update ebayRecordSize...

They definitely wont change their outputs, but not the end of the world as i've got most of the macros to transform them

So, With my PM head on, I spent some time writing down what i believed would be the benefits of doing this, and whilst I wont go into those, I wanted to think about whether it really made sense or I should just spend time unpicking the current database. It does stack up in my mind, as much as...

Thanks Doc - it will likely be just me, however my son is doing some admin work for me in terms of stock, so next step would be to look at using the db

Good point. The issue i had was with the unique id for an ever changing set of stock, and often it's available from different suppliers at different prices. Cat numbers and barcodes appear not to always be unique, so i had to create a reference field that combined the three bits of data there...

it's pretty big, and will need some time to remove sensitive data - think i've found a simple way round it just by thinking around the problem

Hmm - doesnt seem to like running it across 50k records. Just hangs - cant see the line progressing, so i'll leave it for 10 mins Might have to reconsider approach - i've got a relatively high spec desktop, i7 32gb ram

@theDBguy looks like that has worked thank you very much

Hi, @Pat - just trying to simplify the question - there's a dozen different xls in different formats, columns etc. In short, it's too time consuming for me to unpick the 18 update queries i run against it once all the data is in, hence this route. @Doc man I can do the unmatched query, but i...

I run a records business and have all my stock, and suppliers' stock in an Access 2016 database I have externally linked tables to Excel spreadsheets that i get from the suppliers (tblSupplierData), these are updated daily. I need to have a main central table (tblAllData) where each individual...