Search results

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

I had already checked it. The field is there in record source of report. The full set up of report is as follows Report is based on a crosstab query. Cross tab query is based on a select query. In corsstab query ANALYSIS DATE field is set as column heading in 'mmm-yyyy' format.

Its Monday again and I am back. Thank you very much for your replies. Just a little problme (I think) is left. I have now put following code but still it prompts to enter parameter values for ANALYSIS DATE and Parts type. DoCmd.OpenReport "R_Fuel parts summary monthwise", acViewPreview, ...

Thanks a lot for your reply. I will try in on Monday now. Its been enough for today here. I want to go home now. Thanks

you are right. Mistakenly I posted it in the wrong forum earlier on. May be that is why I did not get any response.

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

Thank you for your reply and the link. Unfortunately I could not open it on my PC. I do not want to use macro. Regarding using combo box reference in query cirteria, I was avaoiding to do it because I may be using the same query for other reports. But if that is the only option I can do that...

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

I have tried and it worked perfectly. I have used it in BeforeUpdate event of Optiongroup. It has made my life easy, at least for today. Thanks ;)

Mile-O-Phile Thanks. That was very quick.

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

Thank you very much for your reply. Sorry for being late in response. I was caught up in some other problems. I have managed to solve the problem. First of all I put[date from] and [to] txtboxes on the form whic I did not have before. Secondly to make things easier I have copies them on a...

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

Thanks again for your reply. I am sorry for not been able to explain my question properly. I try here again. On a form I have got following objects A combo box (CmbCustomer) An option group with 4 options, Reject date, Analysis date, Rej code, Liabcat On Reject date and Analysis date options...

Namliam Thanks for being there again for me. I had put the same question in full detail earlier on but did not receive any reply. I have explained the logic behind it. There might be some better solution which I am not aware of. The link of my other question is as follows...

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

GumbyD Thank you very much for your reply. This works exactly the way I wanted. Thanks for your help. :) :) :)

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