Search Results

Search found 478 results on 20 pages for 'ross johnston'.

Page 10/20 | < Previous Page | 6 7 8 9 10 11 12 13 14 15 16 17  | Next Page >

• Access: strange results with queries against MDB file

  - by Craig Johnston

  I am running the following SQL against an MDB file, a copy of which is located here: http://hotfile.com/dl/40641614/2353dfc/test.mdb.html (perfectly clean file, no macros or viruses) SELECT datediff("d", MAX(invoice.date), Now) As Date_Diff , MAX(invoice.date) AS max_invoice_date , customer.number AS customer_number FROM invoice INNER JOIN customer ON invoice.customer_number = customer.number GROUP BY customer.number If the the following was added: HAVING datediff("d", MAX(invoice.date), Now) > 365 would this simply exclude rows with Date_Diff <= 365? What should be the effect of the HAVING clause here?

  Read the article

• Can't check more than one RadioButton across multiple items in a Treeview

  - by Mike Johnston

  I’m using a TreeView control to present a list of Questions. Using the Prism.DataTemplateSelector, I'm loading a View (.xaml file) that represents a single Question into each node in the TreeView. In the View for that question is a ListBox containing RadioButtons (one for each item in a Picklist object that the ListBox is bound to). The radio buttons work as expected for the question, but when I check a RadioButton on another node/question in the TreeView, the check for the button in the Question I was editing before disappears. In other words, I'm only able to check one RadioButton in the whole list of Questions/Items bound to the containing TreeView. How do I group the RadioButtons in the ListBox to the scope of the single question instead of all the questions in the TreeView.

  Read the article

• C#: should "" be assigned to string to make it empty?

  - by Craig Johnston

  Should "" be assigned to a string to make it empty? Or should it be a left as null?

  Read the article

• What is the best and simplest http user agent in .NET?

  - by Craig Johnston

  What is the best and simplest http user agent in .NET? I simply want to put in the url have it return the page as a string.

  Read the article

• C#: what does the 'friend' modifier do?

  - by Craig Johnston

  What does the 'friend' modifier do in C#? Why is it the default modifier for GUI components in Visual Studio?

  Read the article

• vb6 app showing run-time automation error when doing something with calendar

  - by Craig Johnston

  My vb6 app is showing run-time automation error when doing something with a calendar. What is the likely cause of this?

  Read the article

• How can you speed up the display of WinForms in C#?

  - by Craig Johnston

  How can you speed up the display of WinForms in C#? I am finding that forms are being painted quite slowly, even if the window is being 'reactivated' (ie. switched to) after having been already loaded. Other languages seem to be render forms a lot quicker. Is there a way to speed things up? Using C# in VS2005.

  Read the article

• get_list_or_404 ordering in django

  - by Cato Johnston

  Hi I'm trying to order the results of the get_list_or_404 method get_list_or_404(...).order_by('name') doesn't seem to work What's the way to do this?

  Read the article

• Registration during Setup/Install packages

  - by Craig Johnston

  Is it possible to register a .NET component during the installation of a VB6 app? Is it also possible to grant security (eg. via CAPSOL) as part of an installation package?

  Read the article

• Access MDB: Is it possible to monitor and log actual queries made against an Access MDB?

  - by Craig Johnston

  Is it possible to monitor what is happening to an Access MDB (ie. what SQL queries are being executed against it), in the same way as you would use SQL Profiler for the SQL Server? I need logs of actual queries being called.

  Read the article

• What is the preferred method of refreshing a combo box when the data changes?

  - by Craig Johnston

  What is the preferred method of refreshing a combo box when the data changes? If a form is open and the combo box data is already loaded, how do you refresh the contents of the combo box without the form having to be closed and reloaded? Do you have to do something on the Click event on the combo box? This would seem to be a potential slow down for the app if there is a hit to the database every time someone clicks on a combo box.

  Read the article

• VB.NET: Can the .EXE built by VS2005 be deployed as a standalone EXE?

  - by Craig Johnston

  VB.NET: Can the .EXE built by VS2005 be deployed as a standalone EXE? When I change the mode in VS2005 to "Release" and build the solution, the bin\Release directory then contains the solution .EXE file, but also a .pdb, vshost.exe and .xml file. What are these extra files and are they necessary? I copied the .exe file to another machine and it executed properly, but there was a significant delay when it first executed - thereafter it was like any other program. What is the reason for this, and can it be helped? Is it because the other 3 files in the Release folder are not there with it?

  Read the article

• HTML: how to make a file download require a username and password

  - by Craig Johnston

  In a basic HTML web page, how do you make the user have to enter a username and password before they are allowed to download a file. What is the best way of achieving this on a website, preferably in plain HTML.

  Read the article

• Access MDB: do access MDB files have an upper size limit?

  - by Craig Johnston

  Do access .MDB files have an upper size limit? Will, for example, applications that connect to an .MDB file over 1GB have problems?

  Read the article

• JET SQL: do LEFT JOINS and RIGHT JOINS only work under JET 4.0 and above?

  - by Craig Johnston

  Does the following article apply to all uses of JET (including from within client apps via DAO or OLEDB): http://support.microsoft.com/kb/275058 Does this mean JET 4.0 or above is mandatory for anything involving an Access MDB?

  Read the article

• Why would an error get thrown inside my try-catch?

  - by George Johnston

  Why would my try-catch block still be throwing an error when it's handled? Exception Details: System.NullReferenceException: Object reference not set to an instance of an object. Try Here >> : _MemoryStream.Seek(6 * StartOffset, 0) _MemoryStream.Read(_Buffer, 0, 6) Catch ex As IOException // Handle Error End Try Edit: Cleaned the question up to remove the extraneous information.

  Read the article

• What does Error 3112 indicate when compacting an MDB file?

  - by Craig Johnston

  What does Error 3112 indicate when compacting an MDB file? The Error description is "Records can't be read; no read permission on 'xyz123.mdb'" There is a known issue with the Compact function on some versions of Access MDBs. Is the solution in this case to run the Microsoft utility JETCOMP.EXE on this file? What are the other possible causes of this error?

  Read the article

• Why is there a "Conversion Errors" tables in an MDB?

  - by Craig Johnston

  Why would there be a "Conversion Errors" table in an MDB? Does this mean there was an attempt to convert the MDB to a different (newer) version of Access?

  Read the article

• Why would an OCX or DLL file need to be unregistered then re-registered?

  - by Craig Johnston

  Why would an OCX or DLL file need to be unregistered then re-registered? Why would this happen on machine on not others?

  Read the article

• SQL Server 2005: Invalid object name exception

  - by Craig Johnston

  In VS2005, I am using a DLL which accesses a SQL Server. The DLL returns a SQLException Invalid object name 'tableXYZ' but tableXYZ is a table in the database. Should it be looking for dbo.tableXYZ instead? Is this a permissions issue with the login being used?

  Read the article

• How can I attach files to a question here?

  - by Craig Johnston

  If I want to attach files on stackoverflow for readers to download, how do I do this?

  Read the article

• VB.NET: question about "using" block

  - by Craig Johnston

  Consider the code: On Error Goto ErrorHandler Using sr As StreamReader = New StreamReader(OpenFile) str = sr.ReadToEnd sr.Close() End Using Exit Sub ErrorHandler: If there is an error inside the Using block how do you clean up the sr object? The sr object is not in scope in ErrHandler so sr.Close() cannot be called. Does the Using block cleanup any resources automatically even if there is an error?

  Read the article

• .NET: what does "throw;" by itself do?

  - by Craig Johnston

  What would be the point of just having: catch (Exception) { throw; } What does this do?

  Read the article

• C#: why have all static methods/variables in a non-static class?

  - by Craig Johnston

  I have come across a class which is non-static, but all the methods and variables are static. Eg: public class Class1 { private static string String1 = "one"; private static string String2 = "two"; public static void PrintStrings(string str1, string str2) { ... All the variables are static across all instances, so there is no point having separate instances of the class. Is there any reason to create a class such as this?

  Read the article

• Can splitting .MDB files into segments help with stability?

  - by Craig Johnston

  Is this a realistic solution to the problems associated with larger .mdb files: split the large .mdb file into smaller .mdb files have one 'central' .mdb containing links to the tables in the smaller .mdb files How easy would it be to make this change to an .mdb backed VB application? Could the changes to the database be done so that there are no changes required to the front-end application?

  Read the article

< Previous Page | 6 7 8 9 10 11 12 13 14 15 16 17  | Next Page >