Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mwardle

    VB . NET EXE running over network utilizing ADO

    Well, you're missing the line ';Integrated Security=True' from your SQLConnection string. I'm not sure how to write a security-free .NET app - it's rather integral to the whole thing. Really, there's nothing unusual about your app and it should be a simple matter for the IT Support guys to...
  2. mwardle

    VB . NET EXE running over network utilizing ADO

    I think the change to SQL Server is a bit of a red herring here. Executables held on network drives acquire by default the permissions of the Intranet role. This blocks most access to the registry as well as automatic access to the local file system and security policy settings. The Access DB...
  3. mwardle

    Combobox change to update other fields

    I'm having great fun with using a combobox to update other fields. The combobox is bound to a main dataview via the SelectedValue, and the Datasource, DisplayMember and ValueMember are all set, apparently correctly. The idea is that one of the values in the combobox is a default, 'unchosen'...
  4. mwardle

    Change the Print Date from VB.NET

    I also need to do this - until this is possible using Crystal in dotNET is of limited use to us. I submitted it as a product enhancement request nearly a year ago (well prior to CRXI's release), but as yet it is not included.
  5. mwardle

    Input is constantly recognized as Null

    You could also check if you have declared a variable elsewhere called 'row'. If so, the code 'me.rows.add(row)' may be using that rather than the parameter passed to the sub.
  6. mwardle

    Graphs - Using Several Fields as One Series

    I don't think it can be done in the manner you wish. If you are using SQL Server, you can write a stored procedure that will can adapt the table into a suitable form. Eg SELECT CostType, TheYear, Period1Spend AS AmtSpent, 1 AS ThePeriod FROM tblData UNION ALL SELECT CostType, TheYear...
  7. mwardle

    Dll Version Comparison

    It contains a lot of the code, but it seems to rely on knowing the location of the Dll via a setup file, or at least the path to it. But if I always register the file from the same place then it will be easier in the future. How this will work with Citrix sessions, I don't know.
  8. mwardle

    Dll Version Comparison

    I am trying to write a little app that will check whether a dll has been registered and then, if it has, compare the version of that Dll with the latest version. If the latest Dll has not been registered, then it will be. Registering the Dll is straightforward, as is getting the version no of...
  9. mwardle

    Excel Export woos

    ...sent many emails, their replies can be summed up as 1) We can't reproduce the problem. 2) Oh, actually we can. Here's an old knackered dll that *works*. Your problem has been passed to our development team. 3) Here is a link on how to display the euro symbol (grr) 4) And more recently...
  10. mwardle

    Slower Restored Database

    Auto Update Statistics is on. I just tried DBCC ReIndex on the main index used by the sp, and it seems to be back to speed, indeed slightly faster than the original. Cheers.
  11. mwardle

    Slower Restored Database

    After restoring a database under a different name to use for testing, it seems to run considerably slower than the original. A number of stored procedures that analyse the data contained therein run take between 2 to 10 times longer in the restored database than they do in the current database...
  12. mwardle

    Datatype problem with stored proc

    How the stored procedures interpret dates parameters depends on the Language of the login. An sp with code such as TheDate BETWEEN '12/06/02' AND '19/06/02' will work fine for a British English login, but not for an English (US) login.
  13. mwardle

    Every Other Row in a DataGrid Gray

    Using the standard ado-bound datagrid, no. By using other grids like TrueDBGrid, yes. But if alternating colours is all you want I'd abandon the idea becuase the third party grids are quite expensive. The datagrid that comes with .NET allows for alternating row colours, but I have not yet had...
  14. mwardle

    Playing movies in VB6

    You can play AVIs using either a form or a picturebox as the screen. Code for this can be found at http://www.andreavb.com/tip090006.html The code is for a picturebox but can be adapted for an entire form. I don't know if you can do other movie types though, and the code doesn't allow for the...
  15. mwardle

    Playing movies in VB6

    You can play AVIs using either a form or a picturebox as the screen. Code for this can be found at http://www.andreavb.com/tip090006.html
  16. mwardle

    Automating Export to Excel from VB code

    The option you want is ExportOptions.ExcelAreaType. This has options like Details and Page Header to base your column widths on
  17. mwardle

    Loading a .RPT file at Runtime with VB6/CR8.5

    First of all, what kind of database are you connecting to? In Crystal, make sure that Reprompt User When Connecting is not ticked. Secondly, have you tried using the RecordSelectionFormula property instead of the SQLQueryString? According to Crystal Decisions, when using the SQLQueryString in...
  18. mwardle

    Loading a .RPT file at Runtime with VB6/CR8.5

    The method below works fine on CR 8.5 and probably on CR 8.0 dim cappAny as New CRAXDDRT.Application dim crptAny as CRAXDDRT.Report Set crptAny = cappAny.OpenReport(path of report) Now you can play around with it to your heart's content.
  19. mwardle

    time stored procedure

    You don't need to mess around with Declares for this kind of thing. Update t_timeoff Set accrual_rate=4.69 WHERE user_id IN (SELECT DISTINCT id FROM t_user WHERE hire_date = DATEADD(yy, -5, GETDATE()) AND YEAR(hire_date)>1996) AND type='vacation'
  20. mwardle

    Date Time Picker Control, Checkbox Value

    If you set the value of the DatePicker to a date, any date, the checkbox is automatically ticked. If you set it to Null, the checkbox is unticked and the date faded out. When unticked, the value visible will be the last value. So if you want the DatePicker to show today with the checkbox...

Part and Inventory Search

Back
Top