Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. carlosweiss

    Tab Key in a MSFlexGrid

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

    Regional Settings

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

    Scrollable Form / Control instead of Reporting Tools

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

    Update delayed using Jet Engine 4.0

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

    Installing an application under Windows 98

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

    Installing an application under Windows 98

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

    is there a grid control (no data) that allows editing?

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

    is there a grid control (no data) that allows editing?

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

    Installing an application under Windows 98

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

    2 OUTER JOINS

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

    2 OUTER JOINS

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

    Option Buttons in the same form

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

    Option Buttons in the same form

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

    I can't use an SQL INSERT statement

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

    Dynamic Control Matrix

    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

Part and Inventory Search

Back
Top