Search results

  1. S

    Lookups between two tables connected with my SPL

    Thank you very much for your patience and help. I will follow your instructions and if I get stuck I will come back. Best Regards.
  2. S

    Lookups between two tables connected with my SPL

    Would you mind to explain me like a baby steps? Sorry I am good in power apps but very limited with MS Access.
  3. S

    Lookups between two tables connected with my SPL

    Hi, thank you very much for your prompt response. Let me try to explain better all this messy scenario and please apologize for the mess. The data came from a Azure Active Directory exported as csv file. The data change frequently but for many reasons I can not get a direct connection with that...
  4. S

    Lookups between two tables connected with my SPL

    Hello community. I was wondering if this is possible to do it? I have an scenario where I get an excel file each month. Every month the file has some updates or change values in some columns. So I need a mirror file where I can keep a copy of the rows plus some information entered by the end...
  5. S

    Update Query

    Hey, thanks for your prompt response, in this case excel is the master. Share point will be a mirror file
  6. S

    Update Query

    Thank you very much for your prompt response. could you please explain a little bit this portion? Create an Update query in Access that joins the two tables on a common key column. Update the Sharepoint column(s) with the column(s) from the Excel table. Sorry, I am not good in Access
  7. S

    Update Query

    Hello community. I have a silly question and I don't know if this is possible? I have a share point list, that list is basically a copy of an excel file. I would like to make in a daily basis changes in my excel file and at the end of the day run a query that takes my excel file and copy the...
  8. S

    Access, SQL Table, Azure Pictures and Bing or Google MAps

    Sorry for the long and messy question. Here is my inquiry: I have some data in a SQL Table, which is include Latitude and Longitude of pictures taken. I also have the pictures saved in my blob storage. The question is? If I have the data linked in an Access Database is possible to create a...
  9. S

    Creating a Database

    Thank you. Easy for a master, I am a newby and I have been reading post samples etc and I can not get this.
  10. S

    Creating a Database

    I am trying to track the interest quarter by quarter, and have a report every quarter about the amount to be paid in total.
  11. S

    Creating a Database

    Thank you very much for your prompt reply. Basically the matching value is an input value, so we have for instance 100 workers and they started the program with an "X" amount, is like a saving value. that value they start at the beginning of the year and they need to finish with the same value...
  12. S

    Creating a Database

    Hi there, I hope someone can point me in the right direction, I am a beginner in access and I would like to convert an excel file into an access database. Basically I have a tab with my employees, another tab with "Interest Rate" and the 3rd tab is for the calculation. Enclosed is a copy of...
  13. S

    PDF as Template

    Thank you very much for the samples and the explanation, that is what I need I guess, I don't understand about the output and the path. I just want to be able to print in my PDF the record selected in my Access DB. That is why I was thinking in add the PDF as background but I think is the the...
  14. S

    PDF as Template

    Hi, In fact I can try to build a report for my 3 pages PDF, the PDF is a very nice form made in Adobe Livecycle Designer, that is why I was wondering is I can use that file as background and match the access fields with the empty fields in the PDF.
  15. S

    PDF as Template

    Hi, Thank you very much for your prompt reply. correct me if I am wrong. What I want to do is use the fields in my MSAccess report in the empty fields of my PDF. So you mean create again the PDF in my report?
  16. S

    PDF as Template

    Hello, I have a silly question here: I was wondering is this is possible: I have a very nice PDF form and I would like at some point have this form integrated with my data in my access database. What I would like to do is when I am checking a record I would like to be able to print that...
  17. S

    Retrieving a Value

    Hi, I can do the first part, but I don't know about this: "bring through the code as an additional column"
  18. S

    Retrieving a Value

    Hi there, silly question here: I would like to retrieve a values from another table and here is my situation: I have a subform with a combo box, that combo box is a list of the sales rep and also I have a textbox and it htat box I have: =[Sales Rep].[Colum][2] by doing this I can retrieve the...
  19. S

    Picture Hyperlink

    Hello guys, this is a silly question but I can not find a solution. In my table I have a field, that field is the URL of a PDF document, to be exact is the URL of a Safety Data Sheet. I have a report and I would like to include in that report an icon that represent the Safety Data Sheet, like...
  20. S

    Query Question

    Here is: https://1drv.ms/x/s!AknFNywdYmaVkDuIj65x6mYgoG22 seems like excel online doesn't like either Try to open the folder instead https://1drv.ms/f/s!AknFNywdYmaVkDoG-hr_thU0MosA
Top Bottom