Search results

  1. S

    Solved Prevent Duplicate Entry with Multiple DLook Up's

    So I'm attempting to adopt some code that I came across in an effort to prevent people from double entering invoices. I think I understand the basic premise which is to use the DLookup to compare what has been entered to values already existing in the table and if it matches, then prevent the...
  2. S

    Solved VBA to Define Range for Upload

    I need help with this code. I have an excel worksheet that I will import into an access table. The range to be imported will change with each sheet. I'm 90% of the way there, I just need help getting across the finish line. My problem is this: the code below is supposed to find the last row with...
  3. S

    VBA to Check for Duplicates and add Nonduplicate

    So I'm attempting to do something I'm not really sure how to accomplish. Essentially I'm adding file names from a folder to a table using the code found here: http://www.allenbrowne.com/ser-59alt.html In this code, I need it to check against the table for duplicates before adding records and...
  4. S

    export report with subreports to individual PDF's

    Hi All. I need some help with my report and their subsequent subreports. Currently I am generating a report with 3 separate sub reports and all the reports are based on a series of parameters specified on a form (ie. Start Date, End Date, ID, etc...). Each sub report is based off it's own query...
  5. S

    On Click button Code

    So here's my issue... I have a database of properties. Each of these properties has several pdf documents that are associated with each property. In one table I have all the properties and information. In the second table I have all the hyperlinks to the documents. What I would like to do is...
Top Bottom