Recent content by Jalex

That sucks. I agree about the benefits, but can't do anything about it, my users were specific about not wanting copies spread on users machines. Thanks a lot Bob.

Hi bob, thanks for taking over this one. This thread is a follow up of this topic (which the forum kindly helped me with): http://www.access-programmers.co.uk/forums/showthread.php?t=234498 Addressing the question: 1) database.accdb (back end database) 2) users.accdb (front end...

Scenario: 1. sharing.xlsx is linked to database.accdb 2. sharing.xlsx refreshes on open. 3. database.accdb is open all day long (front-end, non-exclusive). 4. When opening sharing.xlsx it throws "You attempted to open a database that is already opened". How can this be solved? (we always...

Client.accdb I cannot touch. That's the whole point, they want something (sharing.accdb, sharing.xls) from which Client.accdb can "link" and work on their own. They don't want anyone touching client.accdb nor have to depend upon developers to update the link. If I create a form in...

I didn't quite get it. Here is what I did: 1. Create a Sharing.accdb with a linked table from Source.accdb 2. Publish it as Sharing.accde 3. Tried to link Sharing.accde from Client.accdb First of all the table linked from Sharing.accde is not read only and Client.accdb can't find the linked...

No I can't in fact I don't think the Client wants me to touch their Client.accdb, neither I want to have to update other clients accdb files when they want to access the data (which is most probably going to happen in the future). Thanks for the idea. I thought there could be a much simpler...

The problem with this approach is that in order to get the latest data in Client.accdb from Source.accd they should open the excel file and trigger the refresh (refresh on open). Which is not what they are looking for. :(

The problem with this approach is that nothing stops the Client from unhidding them and modifying the data. :( Through an Excel spreadsheet? OK, Ill give it a try.

Just can't figure it out. - I have a Source.accdb which is a database back-end. - One of the clients wants to link a table in Source.accdb to his Client.accdb. - The owners of Source.accdb do not want the client to be able to do anything but read the data. How can I do this? I have tried...

Yes! Such a newbie with macros. Wow, Ari, thanks a lot, saved my life completely. Owe you one. :D

After an hour of trying to make it work, I got stuck in calling the code from the Autokeys macro: "The expression you entered has a function name that .... can't find". The procedure is in a module, it is public, no spelling mistake, upcase/lowcase match, parenthesis in there. Public Sub...

Access 2010 14.0.6112.5 (32-bit)

That's a nice workaround. Thus adding it to the F5 key makes it throw an annoying "Filter not allowed" message box. I added this code though: Private Sub Report_KeyDown (KeyCode As Integer, Shift As Integer) If KeyCode = 116 Then DoCmd.RunCommand acCmdExportExcel KeyCOde = 0 End If End Sub...

Hi all! I think this should be easy, but need some guidance =/ Scenario The user wants all the non-basic functionality of the ribbon hiden. To accomplish that by doing the usual stuff: File >> Options >> Current Database >> Allow Full Menus (unchecked) Everything worked as expected...

Hi! My name is Jalex and I am a web developer that somehow got into an MS Access project. After lots of wandering through the web I found this to be the best Access resource out there, so here I am. I'll annoy you with my questions and will try to help anyone as much as my limited Access...