Recent content by reez88

Thanks a lot Linq, I have followed your instructions and the form behaves exactly the way I wanted it to. Many Thanks.

thanks for the information. I have attached a file in mdb format here..

Hi, Is there anyway to lock some columns in a subform and leave others editable? I have attached a database below. In the form 'frmAttendances' I like to keep the 'present' column editable and lock the rest out. I know if I use a continuous form and have separate controls this is possible...

Sorry to post into a very old thread. I am asking the same question as cardgunner. Has this been resolved in 2007?

I use a program called 'SSH Secure Shell Client' to download the files into my local machine. As I mentioned earlier, the remote location I connect has paths like "/folder1/folder2" (note the forward slash). I am confused...

no, I can not see it.. i tried to run \\ "server ip" and enter my ssh credentials. I was presented a blank screen with no folders on it. any ideas? Would you be able to point me to some (vba)code which can be used to download a file from ssh?

looks like I am running out of luck on this one..the machine I connect via SSH has paths starting by "/" which suggests they run non windows os.. Is there any possibility to view these folders using a file browser or add a network drive?

Wow.. I never thought it would be possible to link tables over an SSH connection. Thanks a lot for the idea. I will check on that.

Thanks both of you, We have SSH connection among the sites. Is there any way this can be used effectively?

Thanks for the reply JamesMcS, Actually I should have made myself clearer than above. Apologies for that.. But there isn't a common network drive. Current scenario is a huge excel file being emailed among the users. These users are in two different sites which do not have a common network...

Hi, I have a BE database which is only updated twice a day. The issue is I need to replicate the data to two sites which do not have a comman drive. And getting a comman drive is nearly impossible. I thought I will have two BE for the sites, but only one site will update it, then the data...

Hi, I have to design a system where FE users will only read data from a backend table through a form. They will not be updating/insering new data. All data in the backend table needs to be deleted and populated with new data thrice a day. What would be the best way to achive this? There...