Search results

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. S

    Query Question

    Hi there, I am having this issue, and I can not find the way to produce the report needed. In my data table I have several columns but the most important for me now are: AuditFY Customer Sales Rep JobFY When I get the job I recorded the "AuditFY" but the customer could accept the job...
  9. S

    Retrive a Base64 text to picture

    Retrieve a Base64 text to picture Hello there. I am a Microsoft PowerAPPS user, and I have an app that save the pictures taken with my device camera into a SharePoilt list, the pictures saved are in base64 format, something like this: data:image/jpeg;base64,/9j/4AAQSkZJRgABA.......... I...
  10. S

    Sum and Count based in a Condition

    Hello, Hope someone can point me in the right direction. In my report I have several records but only some has a $$ value for the received PO. I would like to 1. Count if the POValue is greater that 1, and 2. sum if the POValue is greater that 1. Sorry is a silly question but I am stuck
  11. S

    View Reports List

    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...
  12. S

    Share Point List

    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...
  13. S

    1 Record Missed

    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...
  14. S

    Updating a Share Point Table

    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...
  15. S

    Issue with Relationships

    Hello All, I hope someone can point me in the right direction: This is my issue, we do buildings inspections, each inspection is a customer and each customer has several buildings, and in each building we check doors, windows, roof. I can't figure out how will be the relation, any help will be...
  16. S

    Text field get value from combobox

    Hello, I was wondering if somebody could point me in the right direction? I have 2 tables "customers" and "assessments" I select the customer name from a combobox in the assessment form, and I have several fields that based on the customer the information is automatically populated. the...
  17. S

    Help with a dropdown list

    Hello guys, hope someone can point me in the right direction: I have a database with assessments, each record is a building assessment an a customer could have several buildings the problem is when the database was developed I use a record for a building meaning customer will appear several...
  18. S

    Summary in a report

    Hello guys, hope someone can help me with this question: I would like to add a summary table at the end of my report, currently I have some fields like Door type, Door size, door color. And the possible choices are like follow: Door Type: Double Single Other Door Size: 3 x 7 3 x 8 3 x10 Door...
  19. S

    Consecutive Number

    Hello there, I would like to have an advice from you guys, please check the enclosed file and let me know if this is possible: As you can see I have two records and 3 orders, 2 orders for the record 1 and one order for the record two, is possible to add a field that count a new record starting...
  20. S

    Picture Control

    Good Morning All, I have this issue with pictures in reports, in my table I have my pictures stored as a OLE Object, an if i want to show those in my reports seems like the only option is to use a third party software "AccessImagine", and I have to pay for it. is there any way to see my pictures...
Top Bottom