Search results for query: *

Hi Everybody. Does anyone knows how to set the item width, when the TreeView is in List mode? I would like to have a smaller width then the default, in order to show all items without the scrollbar,but i can't find a way of doing it. Any API??? Thanks in Advance, Carlos Paiva

Hi, Tkx in advance for your help. I need to do a INSERT INTO ... SELECT , but one of the destination field must be a sequencial nr, based in MAX(Field)+1 for a WHERE TypeFld=<cond> over the destination table. The question is How do I instruct SQL to the sequencial number? I did a function...

Hi all, Is there a way of formating real numbers to have leading zeros, as in VB Format function? ie: Format(123.456,&quot;000000.00&quot;) => &quot;000123.46&quot; Thanks in Advance for your time, Carlos

Hi, Does anyone know of a ImageList like control, in which we can load XP Style Icons?. I could'nt manage to insert those in the ImageList. Thanks in Advance, Carlos Paiva

Hi, Does anybody knows how to pass a parameter to an Access Report, not for filtering (DoCmd parameters do this), but just to be shown in the report (Say StationId: ...), and that is not related with report data. In Crystal reports, i'd used to pass this by using Formulas, but I can't find a...

Hi, I'm getting 'Divide By Zero' error inside this sql, Caused by having some rows with DRQNTD=0. I'd try the IIf() construction, but since it is in Group By clause, it won't let me use it. SELECT DRRUB, '' AS [Desc], Sum(DRVAL) AS Value, Sum(DRQNTD) AS Qty, Sum(DRVAL)/Sum(DRQNTD) AS UnitPrice...

Hello, all! I've the folowing question in mind: Having a given Table, Named <MyTable>, which methode is the faster: - Use of Recordset object, using Open rs,AddNew, Assign fields and Update, or - Use INSERT INTO MyTable (fields,...)VALUES (vals,...); It's just a performance question...

Hello all. I have the following problem: Having a Product table as: Id int Status varchar(50) and a Stock table as: ProdId int (Product Id in move) TrDate date (Stock move date) Is it possible to have a list of all records from Product, that do not exist in Stock since TrDate. In other...

Using .Controls.Add(&quot;VB.CommandButton&quot;, &quot;Up&quot;),is possible to create a control at runtime. The question is: Does anybody know , how to do the same but for MDI forms? The problem is that ie. CommandButton doesn't have an .Alignment property, thus the system is unable to...

Hi, guys. I'm playing around of dynamic component creation at runtime. I know how to do this, by two ways: - Add at design time, a control element with index=0 and for a new instance: Load <ctrl> - The other way, is dynamicaly create the control by adding a reference to control...

Hi, I'm creating a full featureed print preview system, and almost every thing is working fine. - I print to a PictureBox or Printer Object, using several functions to produce whatever output I want. - All this functions use mililleters as scalemode. - When the output object is Printer...

Do anyone know how to access directly LPT1, without a printer driver installed. The Idea is to control existent Hardware via LPT1 port bypassing Driver And/Or spooler. Thanks in advance Carlos Paiva

Hi, Does anyone ever done a field redefinition, using DAO, in order to change the size of a existent text field, by code, say from 10 to 20, without losing existing data in table? I'm trying to use Field.Size, but it seems to be ReadOnly, for an already appended field! Does any one know about...

Hi, everybody. Does anyone knows about any AddIn, that could view like VB6 IDE project window, but that could show visibility (Public , Private or Friend) of a sub/function/property, for each class / code module? The idea, is to visualy understand dependences, in several programs, with 30+...