Search results

  1. Abeetan

    Is it possible to link an excel table or worksheet into an Access form?

    Can you explain a bit more, please? I am a bit confused about how can I use excel within access?
  2. Abeetan

    Is it possible to link an excel table or worksheet into an Access form?

    The The goal is to be able to create a table in excel and in the best possible way add it to access so I can print it. Basically, a form will have fields such as the date, purchase order number, project number, project name, etc all of which are saved into a table. In addition, I would like to...
  3. Abeetan

    Is it possible to link an excel table or worksheet into an Access form?

    Hello Everyone, I am trying to build a purchase order form into Access. I want to be able to integrate an excel table into the form so I perform the calculations in there then paste the table into the form. So when I print it, etc it shows on the form. Please advise. Thank you Abe
  4. Abeetan

    How to link or attach a pdf file in access database?

    I am unable to link the file, it won't open. It's just stored as text. I can't click on it and open the file. Or even worse, access says it can't find the file.
  5. Abeetan

    Solved Date Entry in access not picked by Search Form

    Thank you all so much for the input. Apparently, my search function was skipping records with empty fields and hence why I was not getting the records that I was adding new to the databases (I was adding records and skipping the fields to test whether the date format worked) and I ended up...
  6. Abeetan

    How to link or attach a pdf file in access database?

    Do you happen to have a YouTube video demonstrating an example? I have failed in the past storing a file path as a text field I am definitely missing something or doing it wrong. Does the datatype have to be a hyperlink?
  7. Abeetan

    How to link or attach a pdf file in access database?

    Hello all, I wanted to know what is the proper way of linking a pdf file that is stored on my PC in a folder to each record. For example, a pdf of a receipt for each order (a record) goes in a field. I have done something as adding a hyperlink in the field but I hear there is a better approach...
  8. Abeetan

    Hi I am Abe.

    Thank you All for the warm welcome! I am very happy I found this forum! Extremely helpful and cheerful folks on here!
  9. Abeetan

    Solved Date Entry in access not picked by Search Form

    @strive4peace Thank you so much, Crystal! I believe that the search function is working properly. Thank you! Function SearchCriteria() Dim vCriteria As Variant vCriteria = Null 'Check if Project Code Textbox is blank If Not IsNull(Me.ProjectCode) Then vCriteria = "[code] = '" &...
  10. Abeetan

    Solved Date Entry in access not picked by Search Form

    Can you please explain a little how I can integrate this check into my code?
  11. Abeetan

    Solved Date Entry in access not picked by Search Form

    Hello Crystal! Thank you for your input. I believe my problem now lies here. Apparently, when a field is empty or null it's not showing up in the results. I am going to try your code and update you.
  12. Abeetan

    Solved Date Entry in access not picked by Search Form

    Here is the issue. Actually, I should clarify that old existing data can be filtered using the search form with the provided function. The problem is when I enter new data. It is not being captured by the filter. When I played with the date settings earlier (before posing my question) it worked...
  13. Abeetan

    Solved Date Entry in access not picked by Search Form

    I am still running into the same issue. I tried all the suggestions on here. I changed my regional PC settings to match mm/dd/yy
  14. Abeetan

    Solved Date Entry in access not picked by Search Form

    I am not exactly sure what's going on, but there is an issue I am running into. My date entries don't show when I run my SQL statement on a search form. here is a post I came across that talks about the same issue I am going through Function SearchCriteria() Dim strProjectCode...
  15. Abeetan

    Search button using more than one text field Access vba

    okay, So I have two date fields and a few other short name fields. I have a form that has text fields that I use for keyword searches. For instance, I want a record with the date field such "26/07/2021" and company Name "ACEM" and the remaining fields including the other date field are empty or...
  16. Abeetan

    Search button using more than one text field Access vba

    Thank you for your reply. That did not work. I am still getting an error message.
  17. Abeetan

    Search button using more than one text field Access vba

    This is my code below. I am trying to search a database using two different dates, company name I am getting an error when one of the date fields is empty or null. How can I solve this issue or bypass if the date search field is empty to ignore it in the search or search for an empty field...
  18. Abeetan

    Hi I am Abe.

    hi I am Abe. I am new here. I am a big fan of ms access. I am currently using it to build databases at work.
Back
Top Bottom