Search results

Thanks for quick response. For both .accdb and .accde shows correct behaviors first time but if user open subsequently with shift key, it shows all objects. Ismail

Hi Guru, To BypassShift Key, I used the code given at below link in this forum; http://www.access-programmers.co.uk/forums/showthread.php?t=51479&highlight=bypass+shift+key I created a sample .accdb (the same is attached) and followed the steps. Then I converted the db into .accde but unable...

thanks CJ. It worked.

Hi, On a form there are 4 combo boxes. Each combo box will have the multiple list of values. These list of values are uploaded while opening the form from a table. I am using the nested loop to assign the list of values. Like; Private Sub Form_Open(Cancel As Integer) Dim sqltxt As String...

Hi, One more side question. My form width is 6". It has the below properties; Auto center = Yes Auto resize = Yes Fit to Screen = Yes Moveable = Yes pop up = Yes modal = Yes Board Style =Sizable and on open event DoCmd.Maximize Issue - When the form open does not show in the center...

Thanks. I will review and update you about my progress.

Hi Experts, I created three forms which I need to give to end users. These forms are used to collect some basic information about business transactions. I wanted to restrict the users activities therefore I have to give the form in such a way that end user will not access database. In short use...

thanks. Resolved. ismail

Hello, Writing VBA and reducing repeating code by defining user defined functions is very new for me, So need help to understand the basic structure of UDF and how it should be structured In correct way. I created my codes like; Private Sub cbxEmployeeName_AfterUpdate() Dim condition As...

Thanks Bob, you are correct. I define now under module and able to get the expected output. thanks Ismail

Thanks Bob for reply. The variable results is already declare in General Section. please see the attachment. thanks Ismail

Hello, This is my first question on this forum. I got good help from time to time by reviewing others threads and issues. I have problem to manage the values from two different forms. On first form we calculated results from two textboxes and store into a public variable. On this form there...