Search results

Rich Thank a lot. It is working ok now. :)

I have tried today and it prompted 'Statments and labels invalid between Select case and first case'

Neileg Thank you for the reply. I think I would remove the msgbox from the code and make sure that nobody leaves customer combo box blank before chosing an option. Now while I am here and the code is there and you are being very helpfull as usual, I am stuck in another problem as well. I...

Her is the code Private Sub Cmdformview1_Click() viewresults acPreview End Sub Sub viewresults(PrintMode As Integer) On Error GoTo Err_Cmdformview1_Click 'This procedure used in View_Report_Click and ......Sub procedures. 'Previews report selected in the frOverallqueries option group. Dim...

Thank for the reply myInd is defined. I actually copied only a part of the full code and it left out. By 'not working' I mean that it does not display msg box. Nothing happens whne I click on command button. What I want to do is that if nothing is selected in CmbCustomer, display the msgbox...

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

Namliam You are a star. I have been fiddling with this code since this morning and couldn't get it right. There it was just a mistake of ". Because I do not have proper understanding of VB codes so I have been trying to rearrange " and , but unlucky, could not put then at right location...

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

I am sorry to be back. Thank you for your patience. Am I stupid or what? I think it would be frustrating for you as well. I have done exactly the same way as you said. I did not use other variable or dim. I used the same variable Dim myInt As String. My statement is DoCmd.OpenReport...

Namliam Its me again. Hopefully last time. A little more help can solve my problem. I am using the following code now as you advised. For Number fileds [Part No] and [Ref No], I have used 'Dim myint1 As Double' and the notation changed to "="&myint1 I have also tried ''Dim myInt As...

I am really sorry for that. I only did the mistank once in first reply and realized afterwards. I thought probaly I have got away with it but obviously not. My mind was probably stuck in VB code. I apologise for my mistake.

Namliam Thanks again for your reply. Thank you for explaining in detail. I hope I have got things straight in my mind now with your help. I really appreciate your help. Thanks :)

Namliam Thank you very much for the reply and sorry about the confusion I caused earlier on. Actually I had to add another option in the group. I am in a very early learning stage of VB codes. When I used your original code it gave message for mismatched data type, that is why I tried to use...

Namliam Thank you for your reply earlier. I have tried it and it worked but still some problems. I am using following code in a command button. Private Sub Command51_Click() Dim myInt As String If optiongroup = 1 Then myInt = InputBox("GIVE CUSTOMER", "GIVE!")...

Mailman Thank you very much for your quick reply. I will try it out and let you know but it seems to be something that I wanted. Thank you once again.

Dear All I have got following objects on a form An option group with 2 options (Option 1. Part No, Option 2. Ref No) A command button to open a report based on a query What I want? I chose an option, say option for Part No. Now when I click on command button to open the report based on a...

Dear All While exporting the data from Access to Excel. What is the difference between following two commands DoCmd.Output to …… DoCmd.transferspreadsheet……. Is it the way data is exported? What I have noticed is that using outputTo command, you cannot export to an excel file where there...

Dear All I want to export data from access to excel using following code. My question is how is it possible to export data from two different queries into one excel file which already has got some data in it. DoCmd.TransferSpreadsheet acExport, 8, "Q_Query1", "C:\New.xls", True, ""...

I am using Combo box/list box on the form.