Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. robertsquestion

    missing microsoft outlook 16.0 object library

    Hi fdcusa, Issue solved! So I guess it did not work because after switching off "MISSING: Microsoft Outlook 16.0 object library" I switched on the "Microsoft Outlook 14.0 object library". But that last step is not needed anymore, I guess because I'm using Late-Binding now (after the VBA changes...
  2. robertsquestion

    missing microsoft outlook 16.0 object library

    Hi, We are using a MS Access database (.mdb with .mdw security) that is stored at a central server. The persons that work in this database either have MS Access 2010 or MS Access 2016 installed. If a user that has got MS Access 2016 installed opens the database, everything works fine. But if a...
  3. robertsquestion

    mdw security error: "cannot open a database created with a previous version of your application

    Hi Combo, Thanks for your update. The first link (http://www.access-programmers.co.uk/forums/showthread.php?t=276121) looks similar to my situation. At the end, the following is mentioned: "So I dug out an old laptop and installed office 2003 on it, and opened the mdw, which I then converted...
  4. robertsquestion

    mdw security error: "cannot open a database created with a previous version of your application

    Hi Combo, Thanks for your info. I've gone through the steps mentioned at "Join the Original Workgroup Information File Without Converting the Original Workgroup Information File". After doing that, I'm (still) able to open the secured database in Access 2010. But if I try to open the database...
  5. robertsquestion

    mdw security error: "cannot open a database created with a previous version of your application

    Hi, We are planning to move from Access 2010 to Access 2016 (using Windows 7). Our databases are in .mdb format and they are 'protected' using .mdw files. This works fine in Access 2010. But if I try to open the same database in Access 2016, I get following error message: "Cannot open a...
  6. robertsquestion

    formula to find 3 filled values in range

    Hi Skip, Thanks for your help concerning this issue. I will use the solution from Rofeu as final solution, but have also learned some new things via your answers. So thanks a lot! Regards, Robert
  7. robertsquestion

    formula to find 3 filled values in range

    Hi Rofeu, Just fantastic, works like a charm!! This is the solution I was looking for, thanks a lot for your help. Regards, Robert
  8. robertsquestion

    formula to find 3 filled values in range

    Hi Skip, I can follow your suggestions, but it takes quite some manual steps to finally get to the result. And it's not a one-time job, there will be a lot of versions of this workbook in use at different places. So it would be quite time-consuming to perform all these steps over and over...
  9. robertsquestion

    formula to find 3 filled values in range

    Hi Rofeu, I've tested your solution. I can follow the logic of the array-formula. But the outcome is unfortunately not completely correct yet. So I've pasted the array-formula to X, Y and Z. And I've pasted the 'offset' formula to AA, AB and AC. The problem is that the array-formula also...
  10. robertsquestion

    formula to find 3 filled values in range

    Hi Skip, I hope this media-fire link below is working, never used it before.. So the source columns are from columns A - U. The result-columns are in columns W - Y. Hope it's clear like this. Regards, Roberthttp://www.mediafire.com/?cfiob86ifba6aud
  11. robertsquestion

    formula to find 3 filled values in range

    Hi Skip, Sorry, just read your last reply. Maybe my last addition has answered your last questions. So: "So that means that you could have up to TEN product/qty values for the CUSTOMER, but NEVER ANY MORE. Is that correct?" Answer: There are indeed TEN possible product/qty...
  12. robertsquestion

    formula to find 3 filled values in range

    Hi Andy, So let's move the data one column, and indeed put the customername in column A. The productnames are (can be filled) in columns B, D, F, H, J, L, N, P, R, T The qty's are (can be filled) in columns C, E, G, I, K, M, O, Q ,S, U On each row, a customername is in column A. If a...
  13. robertsquestion

    formula to find 3 filled values in range

    Hi Skip, The data on row 2 could just as well be on another row, but they belong together. They represent, let's say, the sales from one customer. So each row represents the sales from one customer and each customer has bought a maximum of 3 products. So let's say row 2 is from Customer X...
  14. robertsquestion

    formula to find 3 filled values in range

    Hi Skip, Thanks for your reply. I agree that it's not a very nice table, but I have to live with it, I can't change that part. And the placement of the productnames are significant as the Quantity-column belongs to the (previous) Productname-column. So row 2 could look like this: A2 = apple B2...
  15. robertsquestion

    formula to find 3 filled values in range

    Hi Andy, Thanks for your reply, but this is not solving it. Let me explain a bit more: It could be that cells A1, G1 and K1 are filled with a Productname. Or it could be that cells C1, E1 and G1 are filled with a Productname. Or it could be that cells C1, K1 are filled with a Productname. So I...
  16. robertsquestion

    formula to find 3 filled values in range

    Hi, I'm using an Excel-2003 spreadsheet with 20 columns: A: Productname B: Quantity C: Productname D: Quantity E: Productname F: Quantity etc. untill column T. The Productname-columns contain Text and the Quantity-columns contain Numbers. On every row, a maximum of 3 Productname columns are...
  17. robertsquestion

    excel file locked for editing after using 'Import Data' script

    Hi combo, Thanks for your reply. I've changed: Mode=Share Deny Write in Mode=Share Deny None But if I run the script now and open the 'data-workbook' after that, I get the message: "Data.xls cannot be accessed. The file may be corrupted, located on a server that is not responding, or...
  18. robertsquestion

    excel file locked for editing after using 'Import Data' script

    Hi, I've used the macro-recorder in Excel 2010 to create a script that imports the data from a 'data-workbook' (data.xls) into a 'master-workbook' (master.xlsm). So I just used the standard button 'Import Data' and recorded the VBA from that button. Now the script itself is working fine, the...
  19. robertsquestion

    discount weeks in columns of report

    Hi Duane, Thanks for your solution, works great! One additional question: is there a possibility to let the user of the database decide which weeks will be visible (as columns) in the result of this query? So in other words: is it possible to make the weeks that are in the output of the query...
  20. robertsquestion

    discount weeks in columns of report

    Hi, I'm using MS Access 2003. Table 'T_discount' has got following fields: Customer Brand From_week To_week So following records are in the table: A - X - 2 - 6 A - Y - 7 - 8 B - X - 3 - 5 B - Y - 4 - 9 B - Z - 1 - 5 So in the table the discount periods per customer per brand are maintained...

Part and Inventory Search

Back
Top