Search results for query: *

Hi, Is there any way to know which key is the last that has been pressed, independently of the event of a control? The KeyPress or KeyDown events of a command button or text box are not useful for me in this case, because I'm using a MSFlexGrid control, and the LostFocus event (triggered when I...

Hi I have a grid that has numeric values in its cells. When I try to evaluate them (using the val function) the value is truncated because the regional settings in my computer are set so that the decimal point is the comma. Is there a way to evaluate these values without that problem? Thanks...

Hi, Does anybody know of a way to make a MDI Child form scrollable? That is, putting some text in a position that exceeds the dimension of the form but still be able to see it if I move with the scroll bars. I just want to put some arranged text into the canvas, to display some results. We are...

I'm using Access 2000 and Microsoft Jet Engine 4.0 and I'm using these kind of sentences to make updates to the DB: Dim Aconn As New ADODB.Connection Aconn.Open "Provider='Microsoft.JET.OLEDB.4.0';Data _ Source='c\myDB.mdb'" Aconn.BeginTrans strSQL = "update customers set name =...

Hi, Is there a grid control that allows to edit the cells in the grid? Datagrid binds the grid to a data source and I don't want it, I just want to put arbitrary data into it, and then read from it. MSFlexGrid or the Microsoft Grid control (from grid32.ocx) don't allow to edit the cells. I...

Hi, I have generated an install package, using the "packaging and distribution assistant" in Visual Studio 6.0. My computer runs under Win XP SP2 and uses ADO DB connections. I tried to install the application using this install package in a computer that has Win 98. In the middle of the...

Hi, Does anybody know the SQL Syntax for having outer joins to 2 tables within the same select statement? This query returns an error: select E.CTRL_DIRECT, MI.DESC as MI_DESC, FC.DESC as FC_DESC from table_E e left outer join table_MI MI on E.MOT_INC_MENU = MI.CODE left outer join...

Hi, Is there any possibility to have different groups of option buttons within the same form? That is, several questions each with a Yes/No possible answer. I have a form with a lot of such questions (more than 20) and after I designed the form layout and put all the controls in there I...

Hi, I'm also new to VB and I'm used to working with SQL statements. From a previous thread I read that the way to use an Insert SQL looks like this: Dim dbUsers As Database Call Initialize_Form Dim rsUSER_INFO As Recordset Set dbUsers = OpenDatabase("c:\PESCE\PESCE.mdb") sqlaction...

Hi, I want to add a matrix of controls at runtime. If I write: Set ctrls(i) = Me.Controls.Add("VB.Label", myCtrl(i)) I get an error. Any ideas on this? should I declare it first? how? Thanks, Carlos