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...
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...
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...
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...
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...
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
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...
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...
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
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.