Hi,
I'm having a real problem with something a though would be fairly simple!
I have a time in the format "hh:mm:ss" and I want to convert this into seconds but I just can't work out how to do it.
For example I may have 01:02:04 and I need to convert this into seconds (I thinks its 3724 for...
Hi I need to write a query that will show a list of retailers and a count of all of there orders.
I came up with this;
SELECT Retailers.NA_ID, Count(Orders.NA_ID) As countOfOrders
FROM Retailers
Left Outer Join
Orders
ON Retailers.NA_ID = Orders.NA_ID
WHERE (Orders.JointOR_ID <> '' OR...
We appear to have a performance issue with one of our systems, after some analysis I belive that the bottleneck appears to be Access, it just cant read and right the volume of data fast enough, however the company we have purchased this software from insist this isn't the problem. I'm almost...
I don't know if this is the right forum or if I should post on the Crystal one. I have a crystal report that's datasource is a stored procedure on an sql server database. One of the field in the procedure is a path to a bmp. I would like my report to show the image the path points to however I...
I have a win form app that I would like my users to access through a URL and no touch deployment. However the big problem I am having is that my app needs to use some DTS .dlls and resource files. When i try to acces my app from the url I get an error that the dlls its looking for aren't...
Hi,
I have a database of about 12,000,000 rows and on one particular field I have a need to remove all spaces from the left, right and middle of the string. I've used LTrim and RTrim to complete the first bit however i'm having trouble removing the spaces from the middle of the string, I can...
I'm looking to write a program that displays a digital countdown in hous:minutes:seconds and possibly milliseconds to a particular date and time either set in the code or by the user. I started this with the idea that it must be fairly simple but so far i'm stumped, I have no idea how to go...
I have a list view on a windows form that is populated from an SQL server database. There is a timer on the form on the tick of which the list view 'refreshes' and the data contained in the list view is updated.
What I would like to happen is, when the list view is updated, the vertical scroll...
Hi, I have a vb.net Parent form which contains a child form, on the click of a button on the child Microsoft Excel is opened and, using some API calls and the handle of Excel and the vb.net Parent Form, Excel is then set as a child of the vb.net Parent.
The problem I am having is that when you...
Hi, I have a vb.net Parent form which contains a child form, on the click of a button on the child Microsoft Excel is opened and, using some API calls and the handle of Excel and the vb.net Parent Form, Excel is then set as a child of the vb.net Parent.
The problem I am having is that when you...
Hi, I have an MDI Parent form which contains a child form, on the click of a button on the child Microsoft Excel is opened and, using some API calls and the handle of Excel and my MDI Parent, Excel is then set as a child of the MDI Parent.
The problem I am having is that when you minimize my...
I have a form Form1 that opens up Form2 as a modal type form on the click of a button. What I now need to do is update the value of a textbox on Form1 with a value that is entered into a textbox in Form2, again on the click of a button, it should then close Form2.
This used to be fairly...
We have about 40 computers that we switch on every morning using Wake-On-Lan what we would also like to do is then run something that would send ctrl-alt-del to this computers and log them in, they all have the same username and password.
Is it possible to use something (possible sendkeys) to...
I have a VB .Net application that, using Windows API, pulls Microsoft Mappoint in to it as a child window. What I now need to be able to do is change the border style of the Mappoint window so that it is no longer sizable.
Here is what I have so far
MpOpen = FindWindowNullClassName(0, "Map -...
Can anyone tell me if it is possible to set up a new SQL Sever DB either from an Access adp or from a vb .net project.
Also could anyone tell me how I can run a .sql file on this new database programaticaly
I have a Database which contains records that need to have the unique ID
NE00000001
NE00000002
NE00000003
Etc.
I am unsure of how to create this unique ID field so that it is automatically entered on every insert. I dont really want to have to run some code for every insert as myself and a...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.