Search results for query: *

You can also install the MSDE (Microsoft Desktop Engine) on a desktop/laptop running XP / 2000 pro. This is nice 'cause its license free and can download it for free from microsoft.com. No GUI though, but you can use enterprise manager/query analyzer with it. I think you also have a 2GB...

Hi, You can specify a SQL Query in the Source of the transformation task. Just select the "SQL Query" radio button on the source tab instead of selecting the "Table/View". Then type the sql query in the window For example: SELECT * FROM [YOURTABLE] WHERE BALANCE > 5000 This will then only...

Does anybody know of any websites where I can get the standard windows avi clips such as displayed in a filemove, file delete windows dialog? I would like to include these in a VB application I have written. Thanks

I'd use the following syntax: Try execute sql statement catch msgbox ex.message exit sub end try The ex.message will return any SQL errors within the sql statement. Hope this helps!

Hello, I need to know how to call a SQL SP asynchronously in VB.NET (ADO.NET), so my program doesn’t freeze whilst waiting . In VB6 I used to do the following: Dim cmd as adodb.command Dim rs as adodb.recordset Set cmd = new adodb.command cmd.activeconnection = cn cmd.commandtext =...

Hello! Could anyone advise me on how to display the time in a textbox like a clock. I can manage to get the time but can not get it to continually update itself. thanks!!

Thanks for the tips!

Hi! Can anyone help! On exit of a form, does anyone know if I can remove all data from a table? Thanks.

I am trying to stock control system which links to the point of sale. I have a form for products and would like to be able to choose a no. of products to sell. I would also like the sale to effect the stock control. Does anyone have working examples or any ideas?? Many thanks.

Thanks Uncle Jack, I'll give that a shot!

Hi! I Need some help!! I have 2 tables. a ProductsTbl and a TempTbl On entry into a form I need to copy the contents of the ProductsTbl to the TempTbl. Does any know how to copy the contents of one table to another. The tables have exactly the same structure. Any solutions would be greatly...

Hi, Can anyone help! I am trying to delete a row out of a listbox when you select the row then click the a button. The Listbox is unbound and has values in it selected from a combo box. Any help would be much appreciated! Thanks

Hi, I have tried the suggestions given but they don't seem to work. Does anyone have any other solutions?? Any help would be greatly appreciated. Thanks

Hi! I want to be able to pass value(s) from a combo box to a list box in order to create a list of items. Is this possible? Does anyone have a solution to this? Any help would be greatly appreciated. Thanks

Hi! I want to be able to pass value(s) from a combo box to a list box in order to create a list of items. Is this possible? Any help would be greatly appreciated. Thanks

I'm trying to create a car stock control system. I want to be able to choose a car to buy and then once the car has been chosen I would like to subtract by 1 the amount of cars that I have in stock. Any help would be very appreciated!!

I have a form displaying records from a table called Stylist1. The current way of displaying these records is using "continuous forms" with only one text box displayed in the design view, this is bound to "Stylist1". I would like to be able to display these records on a...