Search results

Thanks DBguy, you have been really helpful! I am going to try that, if I come to a solution going to come back later to tell you!

Gonna look up the solution for one then, hope to find something that I can apply. For two the only problem is the promt box that appears to make sure that you want to update the table, I was thinking to add a button to a form that closes the DB and at the same time runs the query. The problem...

Ok, got the update query to work perfectly, so now I got to do only two things to have my sharepoint list always up to date: 1- Open the excel file to recalculate any possible change 2- Execute the Update query and click the 1203123 boxes saying "Yes I want to update". Any suggestion to improve...

Yes, I could do it manually, but the idea was to dedicate the least amount of work possible. Any suggestion to achieve that?

Oh, it would be great to update sharepoint from Excel, that would simplify a lot my work. And programming on vba could be possible, it should check a lot of conditions on each project then fill a field on the table but that also could work perfectly. (To be clear, it has 22 possible stats for...

Maybe I have to start from scratch: I made a DB for my sector, part of the data that I collected there allows me, through an Excel Formula on a Table to see the progress of projects. Because the forms on access are on daily use and I open the Excel sheet everyday, the Status its up to date. That...

Mmm... I don't know if that is what I want. I was looking forward having that list updated so later I could make a reference to each item on a QR code. Well I guess I'm gonna have to think another way to have linked data on sharepoint or something like that. Thanks for your help DBguy!

Hi again, well to keep you updated with this I did the following: Now I have an Excel Table that Is linked to my access db because the excel has some formulas to make it a dynamic Status tracker. So now, I want to upload this Excel linked table to Sharepoint Online, that is fine. But I'd like to...

No, it should never go that far, I don't think its going to be more than 500, maybe 1000 so I'm going to give it a try. Thanks for everything!

The list I want to upload it's not that complex, only has a linked field through a foreign key, if that works I'm happy.

Hi DBguy, thanks for the help. To clarify a little: you are saying that I should upload the tables too?

Hi, I think this is my first post here so greetings everyone! I was looking for some help with the following, I never used Access with Sharepoint before and I'm trying to implement some ideas for my organization, one of those ideas would be to have access to a query from a link on a QR Code, but...