Recent content by snoopy2003

Hello, At last, I understand how to do it. I saved the network path in a local table and add a module that tries to relink to this path on start up (using a code similar to your suggested code). Thank you very much for your support

Hello, When I relink the tables using the network path I get an error in the "Tdf.RefreshLink" command (because the target file does not exist) and I can not save the modified front end. Thank you for your help

Hello, Thank you for your answer. I prompt the user if he needs to update the table links but I wish to 'set' the same environment in my local pc. Thank you for your help

Hello, Thank you for your useful code. I have a code for updating tables links. I wish to define the network path in my pc. If the path was \\pcName\shareFolderName I could modify my pc name to "pcName", create shared folder named "shareFolderName" and update the access table links to...

Hello, I have a front end and a back end access files. My user save the back end on a shared network folder like: \\a.b.com\folderName$ I wish to simulate this path in my local pc in order to set the linked table links. My problem is that I can not modify my pc name to be "a.b.com". How can I...

Thank you for your help.

Hello, Thank you for your answers. Your suggestions will solve my problem. Before implementing the code - Is there any way to write a general solution that will not include controls names (because my system is constantly modified)? I mean to write a code in a form event that will go over all...

Hello, I have access tool with front end and back end parts. My user works with forms in order to add new records or edit records. I wish to "catch" the following events - if the user modify field's value (which is not NULL) I wish to display a notification message and update a comment field...

Hello, Is there any way to limit attachment field size ? I have a table with pictures and the users attach large images. I am looking for a way to prevent it. Is there any alternative to display a picture in a form by a link to folder with images ? Thank you for your help

Hello, Thank you for your help. Your suggestion solved my problem. There is no way I would be able to find the solution without your help. Thank you very much

Thank you for your help. I will try it tomorrow. Thank you

Hello, I have an access 2010 application. I have a form with tree control. In some windows 7 systems double click on tree control item does not trigger the macro event. I worked before and suddenly stopped. What can cause this behavior ? Thank you for you help

Hello, I wish to add a calendar module to my access application. I wish that it will look like outlook calendar and that I will be able to open it and add events (like in outlook). Is there any access example of this task ? Thank you for your help