Search results for query: *

Hello People Do you kknow whether is it possible to make a CR preview modal?. In other words, if I click elsewhere when a preview is open, it immediately disappears and goes on background. I would like this could be impossible before I close the preview itself. Can you suggest me the way to do...

Hello People. I cannot find a way to solve this apparently very simple question in making a formula: In practice: if I have a number (say 45) and i want it to transform into: 000045 what kind of CR function shall I use? Very obliged for yr help. Regards TdP

Hello people. Suppose you have a Clients Table ID Name 01 Smith 02 Johnson 03 Brown And two Tables: Orders1 and Orders2 like: ORDERS1 ID ID_Client Description 01 01 Beer 02 01 Wine 03 02 Whisky 04 03 Brandy ORDERS2 ID ID_Client Description 01 02 Beer 02 02...

Good Morning(Evening) to everyone I am trying to understand the actual usage of the Function CallByName. Reading the guide, it is a function used to manipulate objects by either executing a method or setting the value of a property Usage: CallByName(object, procedure, calltype, args) For...

Hello everyone. I have created two Tables (CUSTOMERS and ORDERS) using DAO. CUSTOMERS ORDERS ID ID NAME ID_CUSTOMER ADDRESS On CUSTOMERS I have created ID As Primary Key by the following: db.Execute "CREATE UNIQUE INDEX...

Hello I am looking for Dijkstra Algoritm written in VB6. Can anyone post me an example or indicate where to find one. I only found written in C++ or Java. Very grateful for yr help. Bye TdP

Good Morning Say you have a Table like This: EMPLOYEES Name text 50 chars Surname text 50 chars Photo ole I would like to use the listview to show a list of the employees as follows: Photo Surname Name I have coded as: Dim db As Database Dim rs...

Good Morning. Pls kindly suggest me where to post this kind of question if this is not the proper forum. Simply I would need to know if it is possible to upload an image from a VB6 application to a C/R. The aim is to apply the proper company logo on every report printed. Thanks for yr kind...

Good morning. Do you know if there is a 3rd party control which enables to draw detailed maps (towns, ports, depots, etc...). The only I know is The HotSpotImage where you can draw lines onto a existing picture or drawing, so that each of the parts created are event sensitive in VB code. But...

Good Morning to everyone. I simply want to create a new record in a SQL Server DB Table (protocol ADO). I have written, for example, this code: .... rsADO.Open "TABLE", cnADO, adOpenStatic, adLockOptimistic rsADO.AddNew .... Well I note that if the Table contains a great number of records, a...

Good Morning to everyone. In a simple form I have two controls: one textBox and one comboBox. If I set the Appearace property of the textBox to 0=Flat then it actually appears flat with a thin border around, but if I do the same for comboBOX, nothing happens and the control remains sunken. Do...

Good Morning I have created a Graph by Mschart and I want to print it out. Therefore I have written this code: Clipboard.Clear MSChart1.EditCopy Printer.PaintPicture Clipboard.GetData, 0, 0 Printer.EndDoc All works correctly, the print comes out, the graph is correctly printed with all the...

Hello everyone. I am trying to use the property AutoWrap in a VSFlexGrid. Let's say I have a grid with three columns and many rows. I want the text contained in the cells of the first column to wrap within the cell (upsizing consequently the row height) if it is longer than the cell. I have...

Hello to everyone! Suppose you have a simple one column Table (TABLE_01) like this: Mark ABC 003 ABC003 DSA 234 FDR332 ..... I would like to create a query which returns: ABC 003 ABC003 when I search for 'ABC003' For Example: SELECT some_Function_here(MARK) FROM TABLE_01 WHERE MARK = 'ABC003'...

Hello People I have made a VB application where I want to delete a certain numbers of records from a .Mdb Table and then to insert some others. In practice I have two sequential transactions: (let's suppose an ADO Connection) cnADO.execute “DELETE FROM TBL1 WHERE FLD_1 = ‘X’” cnADO.execute...

Dear all I have a problem which I cannot understand clearly. Say you have a number (984,4) stored in a Table Field (declared as Double) of a Database. In my VB program I do as follows: Dim A as double A = rs!Field If I see the contents of A after the assignment, it is 984,40024411.... Is it an...

Hello to everyone! Suppose you have a simple one column Table (TABLE_01) like this: Mark AA_003 AA 003 AA003 AB_055 ..... I would like to create a query which returns: AA_003 AA 003 AA003 when I search 'AA003' For Example: SELECT some_Function_here(MARK) FROM TABLE_01 WHERE MARK = 'AA003' Is...

Hello Sometimes (in a VB project) I create a temporary mdb table on which I load the data coming from a certain process. Then I read that table by a Query for other purposes (for example a print) and eventually I delete that table. Do you know if it is possible to create that table directly...

Good day to evryone. I have found out the following problem using SQL Enterprise Manager: When I double click on a Table of a database, and the Table Properties appears, the number of rows, which is indicated under the filegroup, in is one lower than the actual. Infact I have a table with 50...

Good Day to everyone. When I write a record in a Table (where there is a numeric field with identity (counter)), how is possible to know the value that will be written in that field before or after the updating? For Example my Table has three fields: ID(with identity), Field1 and Field2 If I do...