Search results

Bang on target ;) Thank you very much Koci and also thanks to maxmangion for the link to a very useful thread :) :) :)

Dear All It may be a very dump question but I can't get my head around it. I have a MainForm and then a subform Form1 on it. There is a command button cmd1 on subform Form1. Now I want to access cmd1 through another command button cmd2 on a different form Form2. How would I design the...

Thank you for your reply. I had already this but somebody has suggested me followings sum([Text50])+sum([Text23])+sum([Text69]) which I hope would solve my problem Thanks again

I am trying this simple calculation for last 2 hours but still not successful. A group footer in a report has a text box Text100 with control source e.g =[Text50]+[Text23]+[Text69] Now on the same Report footer I want to calculate the sum of all the values for all groups I used a text box...

Dear All I have a customer based database. Customers are visited at regular intervals and visit dates are recorded. On a form user selects a customer from a combo box and it filters the data and shows records for that customer. I want to show the history of that customer in a subform over...

Dear All I want to filter records at the click of a button on my form based on the selection I make in an unbound combo box placed on same form. I am using following codes. Can someone please let me know where I am doing wrong. Private Sub Command22_Click() 'Filter data for CustomerID Dim...

Just to let you know that I have managed to solve the problem. I have changed the statements in Private sub formview to following and it is working just fine. If you have got any better suggestion please let me know? Private Sub formview(frmName As String) myInt = GetData("Give WR...

Thank you very much for your reply. It is working ok now except for one problem. When Input Box appears and you click on Cancel, it still opens the form. How can I change it so that by clicking on Cancel, it would stop there? Thanks in advance.

Dear All Here is a full code that I am using and I am sure I have messed it up a lot since this morning. The way I want it to work is that on click of a button, it asks user to input data and then filter the records for this data and opens in form view. In this condition it does open the...

Dear All I am using the following objects on the form to display images; One text box that holds image paths (txtimagepath) An unbound object frame (myimagebox1) Following is the code being used: Private Sub Form_Current() On Error Resume Next If Not IsNull(Me![txtimagepath]) Then...

For some very strange reason, when I opened the form today it was working fine and fast. I did compacted and reapair the database yesterday but even after doing it, it wasn't any better . Could it be some network problem which affected a part of the database?

Form contains 4 tab controls and three of them have option groups on it. But the same form was working perfectly ok just a couple of days ago. I cannot remember changing anything.

Thank you for replying Actually the form contains tab controls. Form itself is not bound to any data source.

Dear All In my database one of the forms is very slow to open now. It was ok about couple of days ago and now it takes about a minute to open. Other forms are ok. Can anybody suggest where should I look at to rectify the problem? Thank you

quote include your suggested full code. My mistake in pasting

Thank you for reply. As you would have seen in the code above, each combo box is set to a null value before update. If I use this code for each combo box then if I select one option, other combo boxex will still be having null value. Wouldn't it still give msgbox to enter value in other...

Dear All On my form there is an option group named specialreports. Then there are combo boxes linked to each option. Private Sub OptSpecialreports_BeforeUpdate(Cancel As Integer) Me.CmbCustomer1 = Null Me.CombPallno = Null Me.Cmbmodel = Null Me.txtDatefrom = Null Me.txtTo = Null...

Update Here is an update on the above issue. At last today I have managed to solve the problem with the help of someone. Here is the solution stWhere = "[PIC NO] Like '*" & [myInt] & "*'"

Good morning Tried the way you suggested. Following error comes up Run time error 2501 The open form action was canceled

Thank for your reply. honestly I do not have a clue. Bit more help please