Recent content by JST

Hi Arnel, The link you gave has Trojan2 virus. http://orlando.mvps.org/DBtoEXEMore....oad1#Download1 The file contains virus even after being quarantined. Any suggestions. regards

Thanks Arnel, it's been a lot of learning

Arnel, I have been using this since ACCESS 2007 times. Just wanted to try something different by opening the form thru VB code. If you could help pl.

and one more small help. I want to open the form through a module. I have used the following code in module Private Sub Form_Open() DoCmd.OpenForm "Form-dt" End Sub I want the form to be loaded through module upon opening the database. rgds

thanks Arnel.

Hi Arnel: Many thanks. There is a problem while executing. When I type a text in the text-box, it searches the column, but the cursor goes to 1st column of 1st row and I have to click back in the text-box for typing the second letter. say for example, if I type 'A' of your Arnel, then the...

Hi, I am using a form (Form_cus) to display records of a table (Table_cus) through a query (qry_cus). I want to filter the records based on field (cus_nm) value typed in a text box on the form. What should be the VB code in the "on change" event so that it displays the records based on cus_nm...

Many thanks Arnel. The exe has really worked. I am able to protect my entire database. regards.

thanks Arnel. The idea appears to be wonderful. The DBtoEXE coverter app is not working in my office laptop. Will give it a try at home with my personal laptop. regards

very true. And my problem remains a problem....... thanks anyways for sharing your thoughts.

Yes Gina. I mean to have the front end form in a separate database. I succeeded somewhat by having 2 .accdb files A & B, where file B is the main database file. I set the reference of file B in A. Write a module in B to open form (to be used as front end). Now you can access this module in...

If what you mean to say is an executable file (.accde), I have tried that also. You can still access all the objects.

Thanks Gina. Will try this and revert. Alternately, is there a way out to keep the main Form in a seperate database. Regards

Hi Gina, Primarily 2 reasons I want to have full control and 2. The staff is novice to Access and keep on fiddling with queries/ reports creating problems for me. I was working in FoxPro earlier and was very comfortable with .exe file. Wonder if Microsoft strengthens MSACCESS in a similar way...

Hi Rabbie, I have some 50 queries, 20 reports and 30 macros all related to 2 Tables. This MSACCESS-2010 database is being used by several users installed in 3 systems. I want that nobody should be able to see my Queries, Reports and Macros. I have set all objects as hidden. I have also hidden...