I wanted to come back here and thank you for helping me with a project I was working on that I was having difficulty with. Having viewed, let's just say, a lot of your videos, this one in particular was very helpful to me.
Big help on a project I've been working on. I knew it could be done as I had mastered (*cough* but had forgotten how *cough*) appending. Updating from an Excel spreadsheet was an unknown. If all works out right there will be no more wasting 20 minutes a day had updating my entries. Instead I'll be able to spend the same 20 minutes watching yours and other videos (I so need a life.)
Fantastic video, a silly question ‘query’ I have set up access tables and import tables via excel. However, some of the data will update, is there a way to import and update without linking excel table.
Is there anything we can do if unique ID's are not provided? Iv got many records that have different names yet use the same ID. Any help is appreciated
hi i have excel table for orders ...how to convert it to access database you know in access we need tabls of customers, orders, orders detail , shipment and employee to creat the data bass i dont like to fill that table copy past what is your recmmndation ..thanks
everything is working for me except the update price. no matter what i do i cant get the prices to update. the price review works perfect. any idea on what i am doing wrong?
This is fantastic! I do have one question, I am planning to split my database before deploying it to end users. Does it matter if I set up these queries before I split it?
Calculated fields should automatically recalculate when the fields upon which they're based are updated. That's the very definition of a calculated field.
This assumes the Excel file will always have the same structure, same field names, valid data, etc. which could be too big an assumption, because Excel is basically a free-form data tool whereas Access demands structure. E.g. If the product ID has a minor mistake such as an extra space in front due to entry error, the query join won't work and the whole thing will fail. If the admin has to proof-read the Excel file every time, then it's not automated anymore, especially if a lot of data are involved. Either you need some way to ensure the Excel file always has the same valid structure and valid data, or you need a way to check for bad data, which is best done with VBA.
Yes, it's an assumption, and this solution will work just fine for most people in the majority of situations. Is this BEST done with VBA? Of course. But not everyone is skilled with VBA, so I try to show a "good enough" solution that will work for the majority of people.
On the Append side of this video when you are setting your outer limits, is it possible to have the query show stocknumber that aren't equal? I have a similar scenario as the video; however, my "price list" will constantly be adding new products that I'd need to append to my list, and it doesn't always go back to the initial product. There is no cumulative list of all product to reference, infact that cumulative list, is what I'm attempting to create.
I don't understand your question. Can you please elaborate. And you're best off submitting questions on my web site at 599cd.com/TH - I only check the comments on UA-cam MAYBE once a week.
@@599CD So i did this to a T, Access asks if I'm sure I want to update the 425 Rows, I click "yes", then run the query to see if it took, and nothing. I'm perplexed.
@@ArchitecturalLightingAlliance check the T. Instead of updating 425 rows into the query, access might've update your T with 425 rows...atleast that's what happened to me.This happened to me when i was trying to add a subform.
Hi. I am Alan. Come form HK. I had been created a local access project in Access 2010. how to convert the local project to web base project? Because my company will cange all of the application from PC base to web base as possible. Thanks.
I wanted to come back here and thank you for helping me with a project I was working on that I was having difficulty with. Having viewed, let's just say, a lot of your videos, this one in particular was very helpful to me.
all thumbs up before the class even starts. thank you so much Richard for another valuable tutorials 👍
Love this. As usual I am looking for yet another little nugget of gold from Richard - and he delivers a treasure trove of extra stuff!
Glad you enjoyed it
I learned a lot from this video. Thank you so much Rich.👍
You're welcome
Big help on a project I've been working on. I knew it could be done as I had mastered (*cough* but had forgotten how *cough*) appending. Updating from an Excel spreadsheet was an unknown. If all works out right there will be no more wasting 20 minutes a day had updating my entries. Instead I'll be able to spend the same 20 minutes watching yours and other videos (I so need a life.)
Sweeeeet :)
Great explanation, great video - thank you!
Welcome
Fantastic video, a silly question ‘query’ I have set up access tables and import tables via excel. However, some of the data will update, is there a way to import and update without linking excel table.
You could do it with direct file I/O but that will involve some VBA coding. 599cd.com/FileIO
Is there anything we can do if unique ID's are not provided? Iv got many records that have different names yet use the same ID.
Any help is appreciated
This is powerful bro. Thanks
Welcome, bro. :)
hi
i have excel table for orders ...how to convert it to access database
you know in access we need tabls of customers, orders, orders detail , shipment and employee to creat the data bass
i dont like to fill that table copy past
what is your recmmndation ..thanks
everything is working for me except the update price. no matter what i do i cant get the prices to update. the price review works perfect. any idea on what i am doing wrong?
Without seeing what you're doing, it's impossible for me to tell.
Awesome video. Thank you kindly.
Glad you enjoyed it!
This is fantastic! I do have one question, I am planning to split my database before deploying it to end users. Does it matter if I set up these queries before I split it?
Nope. Queries go in the front-end. Once the tables are linked they'll behave just as if they were local.
@@599CD Awesome Thank you
Hello Sir is it possible to update multiple calculated fields in a continuous form with one click using vba.Thank you
Calculated fields should automatically recalculate when the fields upon which they're based are updated. That's the very definition of a calculated field.
This assumes the Excel file will always have the same structure, same field names, valid data, etc. which could be too big an assumption, because Excel is basically a free-form data tool whereas Access demands structure. E.g. If the product ID has a minor mistake such as an extra space in front due to entry error, the query join won't work and the whole thing will fail. If the admin has to proof-read the Excel file every time, then it's not automated anymore, especially if a lot of data are involved. Either you need some way to ensure the Excel file always has the same valid structure and valid data, or you need a way to check for bad data, which is best done with VBA.
Yes, it's an assumption, and this solution will work just fine for most people in the majority of situations. Is this BEST done with VBA? Of course. But not everyone is skilled with VBA, so I try to show a "good enough" solution that will work for the majority of people.
Excellent
Thanks
thank you ,
Welcome 😊
On the Append side of this video when you are setting your outer limits, is it possible to have the query show stocknumber that aren't equal? I have a similar scenario as the video; however, my "price list" will constantly be adding new products that I'd need to append to my list, and it doesn't always go back to the initial product. There is no cumulative list of all product to reference, infact that cumulative list, is what I'm attempting to create.
I don't understand your question. Can you please elaborate. And you're best off submitting questions on my web site at 599cd.com/TH - I only check the comments on UA-cam MAYBE once a week.
@@599CD So i did this to a T, Access asks if I'm sure I want to update the 425 Rows, I click "yes", then run the query to see if it took, and nothing. I'm perplexed.
@@ArchitecturalLightingAlliance check the T. Instead of updating 425 rows into the query, access might've update your T with 425 rows...atleast that's what happened to me.This happened to me when i was trying to add a subform.
Hello, Please, I have a question. I want to learn how to
create Parameter in crosstab Query in Access, please help me
Feel free to submit your question here: 599cd.com/TechHelp
Hi. I am Alan. Come form HK. I had been created a local access project in Access 2010. how to convert the local project to web base project? Because my company will cange all of the application from PC base to web base as possible. Thanks.
599cd.com/AConWEB
why duplicate output destination 'Stocknum"?
I don't understand your question.
How to update Product prices without loosing the old price recorded in msaccess
Keep a history table
Amazing video! Thanks!
Glad you liked it!