Recent content by DannyLondon

That was the trick. You are a genius, thank you! Is this where Access and VB diverge? I have never known such a thing in VB. Thanks again, I don't think I would ever have got to that solution. Danny [rockband] [wiggle][wiggle][wiggle]

I will give that a go. Thanks for your help. [rockband] [wiggle][wiggle][wiggle]

I am trying to use the TabStrip control, as I do not want pages or control containers. I have started a new mdb file with a new form, placing only the Microsoft Forms 2.0 Tabstrip control, and a command button. With the following code, I still get the error. Private Sub Command5_Click()...

Hi MajP Thanks for your reply. The code you have entered is exactly what I was expecting to be able to use. I am using the Forms.TabStrip.1 control. In my form load, I have the simple code: Me.tabAdjustment.value = 0 Unfortunately I get the error: Run-time error 2101: The setting you...

Hi Folks This seems like it should be a simple issue, but I am struggling to find a solution for it. I have added a tabstrip control to one of my Access forms. Note that this is the tab control with just the tabs, not with pages. I can't work out how to select a tab using code (eg, to make...

Hi Folks I am really, really perplexed here. I have an Access database with is secured by an mdw file. I use a shortcut to open the file, and automatically execute code within it. The shortcut contains the user, password and command line argument, eg: /user UserID /pwd Password /cmd Auto...

Hello all Does anyone know how to limit the VB ImageCombo control to items in the list (ie not allowing free text)? I expect the behaviour which is achieved in the standard combo box by setting the style property to 2 - Dropdown List. Thanks Danny [rockband] [wiggle][wiggle][wiggle]

Hi Moben I am pleased it has worked for you. Unfortunately I have not read any books on VB.Net, so can't give you any pointers. Danny [rockband] [wiggle][wiggle][wiggle]

No, assuming your parameter in Crystal is called UserName, then: frmMain_Menu.CryRep.ParameterFields(2) = "UserName;" & gb_user_name & ";True" Danny [rockband] [wiggle][wiggle][wiggle]

Hi Moben Sorry, it seems that the format for the OCX control is different from the RDC environment (the newer way of accessing report objects). The format for the OCX is CrystalReport1.ReportFileName = "C:\My report.rpt" CrystalReport1.ParameterFields(1)...

Hi Moben You could use parameters to pass the user name and sales date to Crystal. Regardless of what records are returned, you will be able to print these parameters in the report. Furthermore, you can use the SalesDate parameter in your record selection criteria, doing away with the system...

How are you calling the report? Do you have a front end? If so, pass these details to the report as parameters. Danny... [rockband] [wiggle][wiggle][wiggle]

Hi SurfingGecko Thanks for your note. I was searching for a way to use the integration of the RDC without needing to embed the rpt reports into the exe. It seems the Application object also needs to be declared, resulting in the following code: Dim rptReport As New CRAXDRT.Report Dim...

The Gods must be smiling. I came into the forum for just this issue, and there it was, second from the top of the list. Thanks for your help Madawc. Danny [rockband] [wiggle][wiggle][wiggle]