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 =...

Sorry, guys The reason of the error was simply because the .mdb was read-only, apparently Windows 98 sets that attribute that way to files copied from a CD, whereas more recent Windows versions don't do that.

OK, the problem now seems to be the Access 2000 database. I ran Jet 4.0 service pack 8 (Jet40SP8_9xNT.exe) and MDAC 2.8 (MDAC_TYP.EXE) after that, but I always get the same error: "Runtime Error 3051 - The database engine Microsoft Jet cannot open file c:\xxx.mdb - It is open in exlusive mode...

Thanks, everybody. Johnwm, that's exactly what I wanted. FAQ222-3262 was very useful.

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...

I'm sorry, it is a syntax error. The error message is (translated from Spanish) Syntax error (missing operator) in the query expression 'E.MOT_INC_MENU = MI.CODE left outer join table_FC FC on E.FREC_CTRL = FC.CODE' The CUE column is in table_E only, If I use e.CUE instead of CUE I get 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...

Thanks everyobody for your suggestions, I finally did it the "craftsman" way. I put a frame beneath each of the 24 questions (I can always change the frame size so that it's the same as that of the question). That wasn't so terrible...

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