Search results

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...

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...

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...

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

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...

Dear All I am using following code to open a form on OnClick event of a command button. myInt = InputBox("GIVE PIC NO", "GIVE!") stWhere = "[PIC NO] = '" & myInt & "'" DoCmd.OpenForm (frmName), acNormal, , stWhere When I click on command button, it prompts to enter PIC NO, opens form but...

Here is the statement. Please can you see where I am doing wrong. DoCmd.OpenReport "R_Fuel parts summary monthwise", acViewPreview, , "[ANALYSIS DATE] = > #12/31/1999# " Or "[ANALYSIS DATE]Is Null" And [Parts type] = " #Fuel# " OrderBy ([ANALYSIS DATE]) [ANALYSIS DATE] is a date field...

Here is the statement. Please can you correct it for me. DoCmd.OpenReport "R_Fuel parts summary monthwise", acViewPreview, , "[ANALYSIS DATE] = > #12/31/1999# " Or "[ANALYSIS DATE]Is Null" And [Warranty parts type] = " #Fuel# " OrderBy ([ANALYSIS DATE]) [ANALYSIS DATE] is a date field...

Dear All On a form I have a command button that on click opens a report, based on the selection made in a combo box on the same form. I have used following code. It does open the report but does not show any data. Can somebody advice please. Private Sub CmdVin_Click() Dim stDocName As String...

Dear All I have got an option group with three options. Each option is linked to a combo box. I mean combo boxes have been enabled with each option. So you select an option and then select values from combo box. My question is that how is it possible that when an option is selected the other...

I want to show photos on a form and a report.. My present setup is as follows I have been saving the photos in a separate folder on network. The main table in my database contain a column named photos which is set as hyperlink. On the form user enters a text in this field and then by right...

Dear All Can somebody tell me wheather the following statemnt is correct or not in stWhere string Dim myInd As String myInd = Forms![Form2]!CmbCustomer Select Case Me!frmHVAC Case 1 stWhere = ("[REJECT DATE]Between [date from] And [to]") And (" [CUSTOMER]= '" & myInd & "'") Or...

Dear All On my form I have an option group, a combo box and 3 command buttons to open reports depending on what is selected in combo box and in optios. What I want to do is Reports can be viewed based on selection in combo box alone Reports can be viewed based on selection in combo box and an...

Can sombody tell me where I am doing wrong in the following code. Private Sub viewresults2(rptPrint As String) Dim stWhere As String Dim myInt As String Dim myInd As String myInd = CbCustomer Select Case Me!frmRelativequeries1 Case 1 myInt = Forms![New form Sample]!Cbpartno stWhere =...

Dear All I have got a little query about option group and VB codes. I explain my problem here I have got set up an option group with 4 options and 7 command buttons each opens a different report based on the selected option. Now the problem is do I have to write separate VB codes on each...

Dear All Can somebody tell me what is wrong with the following statement. It is not working. Case 1 myInt = Forms![New form Sample]!Cbpartno If IsNull(Forms![New form Sample]!CbCustomer) Then MsgBox ("Please select Customer first") Else DoCmd.OpenForm...

Dear All (Message for Namliam if he reads this mail, thank you very much for your help yesterday on a similar issue of option groups. I did finally managed to do the way I wanted it to be. Thanks) I want to filter the records using two parameters. I want one parameter to be selected from a...