Search results

  1. M

    nested dlookup 2 tables with true false

    hi June7, the above did the trick :-) it is working great now. Thanks a lot.
  2. M

    nested dlookup 2 tables with true false

    Hi June7, not all in table 1 have a match in table 2, and in table 1 could have various entries with same value. for example 20 rows in table 1 from the 7449 rows could have "01763789" Table 2 is a collection records that they keep adding that comes from another table. then table 1 is checking...
  3. M

    nested dlookup 2 tables with true false

    hi June7, almost there. I get all the results from the 7449 rows. but it gives me on all of them '-1' Looks like he does not compare the second table correct to the first one.
  4. M

    nested dlookup 2 tables with true false

    is there a way to modify that I will not get unique results? if I can get the whole 7449 rows with it, it would help a lot.
  5. M

    nested dlookup 2 tables with true false

    hi Jdraw, this is very close, I just have to show only one column with true or false. I need to add this to the query I already have. the numbers I have to compare are actually starting with a "0" as example "0432567" or "0100671" in the database they appear as text. if they are added as number...
  6. M

    nested dlookup 2 tables with true false

    Hi Plog, Now I get only 41 records, I need to have all the 7449 with the false or true. I had to take an excel workbook some one create and transform this into an access tool. there are like 30 formulas that compares data in another sheet. well, there are various sheets with data that are used...
  7. M

    nested dlookup 2 tables with true false

    Hi Plog, I get many duplications. In the real table I try to compare, there are like 7449 records, with your query I get 412606 records, in the second table there only 27521 records. All the duplicated 412606 records show as "True" the excel formula looks like this...
  8. M

    nested dlookup 2 tables with true false

    Hi Plog, I need to check data from one table with another table to see if this nr is there too. It should work like in excel with a vlookup. example would be like this: table 1, field name: IDnr: 1234 2345 table 2, field name OtherID: 4567 1234 so, if in table 1 and table 2 the number is...
  9. M

    nested dlookup 2 tables with true false

    I found this, but I have no clue how to adjust this: http://www.utteraccess.com/forum/dlookup-tables-t1935774.html
  10. M

    nested dlookup 2 tables with true false

    hi, not returning from 2 table, just to see if one exist in the other table and then set it as true. unless I understand you correct. I'm really locked on this and no clue how to build this.
  11. M

    nested dlookup 2 tables with true false

    Hi all, I'm trying to get a create a nested dlookup as I think this is what I need. not sure how it works and all examples I can find are not relevant to what I need. I need to compare 1 field from 1 table to another field from a second table, I the record is also on the second table, I should...
  12. M

    merge pdf files till 5mb size

    hi all, No help possible? Greetings.
  13. M

    merge pdf files till 5mb size

    Hi sxshech, It is more about the loop reset when reaching the 5mb size. I will use the code to get the file size before I can start looping till 5mb file size. Greetings.
  14. M

    merge pdf files till 5mb size

    Hi all, I have some code to merge pdf files that are in a folder and including the subfolder. I use Acrobat Pro and works pretty fine. What now turns out, there is a limitation on the size of the pdf files. They will be uploaded to an intranet site and the max size is 5mb. I would need to...
  15. M

    finding a particular date on a row

    Hi all, I got an excel file where the employees are and the days they are in the office. this excel file has all the dates in the columns starting from the Monday date and then next column on the same row has the next day. as example: C2 has 03/09/2019 and D2 has 04/09/2018 There will be only...
  16. M

    calculate passed days on current status

    Thanks a lot JHB :-) did miss that one out, silly me. Greetings.
  17. M

    calculate passed days on current status

    ok, now I don't get the error, but I get the number of the date :-( rst!current_status_duration = DateDiff("d", phase_initial_activities, Date)
  18. M

    calculate passed days on current status

    hi JHB, I get run-time error "2465" database can't find the filed "|1" referred to in your expression. I changed the code part to this: rst!current_status_duration = DateDiff("d", [phase_initial_activities], Date) greetings.
  19. M

    calculate passed days on current status

    hi all, I managed to get the below code, it is almost working. The only thing that I do wrong is to get the number of days passed, instead I get a date :-( Dim rst As DAO.Recordset Dim status As int Set rst = CurrentDb.OpenRecordset("SELECT phase_initial_activities, status...
  20. M

    calculate passed days on current status

    Hi all, I have a datasheet inside a form. in this datasheet, the current status is visible and the phase initial activity date. Now I need to calculate the days passed of the current selected status. There are 13 status in available to choose from. For example Status 1 till Status 13. Whit this...
Top Bottom