Search results

Hi there, thanks again. I have this cbo box partially working. what is funny is I am able to select the report from my report list, then even if I can not see the values in my cbo box if I select for instance the second one which is FY2019 I can see the report for the FY2019.

Thank you very much for your prompt reply. I will try. Is not clear to me. I don't need to save the file as a excel file or provide a path. I see everything happens at the double click event. but I don't see where the dates feed the report? Regards,

Hi there, just a quick question: I have several reports that as a criteria has the following state: [Forms]![Report1].[MyCategory] [Forms]![Report2].[MyCategory] [Forms]![Report3].[MyCategory] [Forms]![Report4].[MyCategory] And [MyCategory] = Combo Box with the fiscal years. so When I select...

Thanks for your patience, but I am lost in the step that I have to replace for the 7D?

OK, let me digest one by one. You mean, my list is this: https://my company/_layouts/15/ViewEdit.aspx?List=%7B056BF680-XXXX-XXXX-XXXX-A16FDE9DE97E%7D&View=%7B98269B83-557F-485D-893A-B7F7591C33B3%7D&Source=https%253A%252F%252F....... ...............................252FDatabase%252FLi...

Hi there, My list is like this: https://my...

I don't know how to capture the GUID, and also I have two connected list, should I created a view for the two list? Thanks in advance

Hi there, thanks for your reply. Yes I know how to do it. I'm excited about the next steps. Regards

Good morning, and thank you very much for your prompt reply. After reading and reading the 3 part blog, now I am going mental. LOL For me I am not an access expert, just a normal user this is very complicated. Maybe do you have any other post or video when someone can explain how to approach...

Hi there, I will try to explain my issue and I hope someone could point me in the right direction. I have my database in access, and I have created a query with all the fields that I need. that query was exported to my share point list. I have that list linked with others programs such as...

Thank you very much for your prompt reply, you turn the light, problem solved, the issue was one of the tables has a dropdown values and it was empty. Almost going mental. Thanks again. Regards

Hi there, I have been trying to figure out this issue, but I can not get a right solution. In my table, I have 574 records, I can see those in my form and in the main table. I have a query without any filter and I have 573 records, I am going mental with this record. Could someone point me in...

Good Morning and thank you very much for your reply, I never used a delete query before but I will start investigating. Thanks again!!! Regards

Hello there,thanks for your reply. Yes I have two identical tables and my users don't change data in share point, they only can see the data. So the main database and I am responsible for the daily updates is located in MS Access. I tried to export the table again to my Sp list but I get...

Hello there, and thank you very much for your prompt reply, however I think that the video is not my case. In my case the main table is located in my Access Database, with that table I've created a query, that query was exported into a Share Point list, after I imported and linked the same...

Hi there, I hope someone can point me in the right direction: I have a query in MS Access, that query was exported to a share point list, once the query was in share point list I've imported and linked the same table in my MS Access. basically that linked table feeds my share point list. my...

Thank you, we basically do inspections "building inspections, we receive a call from a customer and he wants us to visit his facility and check the building to reduce the energy consumption, so before we go to the building the customer provide all of the building(s) information like building...

I am trying to do a database since long time ago, but always got stuck at the same point, currently we have an excel file with with tabs and each tab is a building, inside each tab we have a template with all of the calculations for doors, windows, roof, etc, then at the end a summary tab with...

Thanks again for your interest with this, the enclosed diagram will help? We already have the customer information and the buildings information, the information that is collected is the number of doors, windows, roof etc.

Not sure if this is OK, I guess not I've followed your instructions but nothing :-(