Search results for query: *

Instead of using AddNew and Update, I would build a SQL INSERT statement and execute it on the database.

I have produced a graph within an Excel application with months "Jan-05", "Feb-05", "Mar-05", etc along the x-axis. However, a colleague requires to use this in the Netherlands where (unsurprisingly) regional settings are in Dutch. Producing this graph, the month names are translated to Dutch...

farhy, Thanks - a step forward, but I still cannot trap the error if the logon details are incorrect. Cheers, Neil

Hi all, I wish to launch Business Objects from a VB6 executable. I need to pass in the UserID & password from user input and therefore want to bypass the startup prompt. I know I can use the command line, but if the password is incorrect then I get the prompt up. I want to recognise the...

Your problem is that the .avi postscript is not assigned to any application, so the shell command does not know what application to startup to run the .avi file. Try specifying the application in which to open the avi in the Shell command ie x=vba.shell("C:\Program Files\...\xxx.exe...

The answer to this has been supplied in another thread. Basically, set your field ControlSource to =Iif(HasData,[RSFieldName],"") and if there is no data being returned then the Field will be displayed empty. Since the fields are displayed then so will the labels.

dhookom, HasData property fixed a very similar issue for me. Have a star! Cheers

You've got to open it in some application. Use internet explorer if you want to view it read only Private Sub Form_Load() Shell "C:\Program Files\Internet Explorer\Iexplore.exe f:\b.jpg" End Sub

Try For Each FrmCtl In SubFrmCtl.Form.Controls in your *** line

To ensure your numbers keep their format... =TEXT(A1,"00") & "-" & TEXT(B1,"0000")

Use the COUNTIF function in your occur column eg =COUNTIF(nrLookup,">=" & B3) - COUNTIF(nrLookup,">" & C3) where nrLookup is your lookup range B3 contains your lower range C3 contains your upper value

To keep your sanity, try arranging your data in a table (maybe in a hidden sheet) and look up the values you want. The top row allows lookup to work in both directions. For tidyness' sake, I have named the range nrTable. 0 1 2 3 0 0 85 110 0 0 0.5 0.5 500000 0 0.75 1 1000000 0.1 1 1.2 Then use...

The following should work. You need to set a reference to 'Windows Script Host Object Model' Function PathTransToUNC(sPath As String) As String Dim oWSHNet As Object, drv Dim sDriveLetter As String, sUNC As String Dim bNextOne As Boolean bNextOne = False sDriveLetter = Left(sPath, 2) If...

You can use a variable for the control's name. Use the construct strControlName = "Control1" x=Me.Controls(strControlName).Value