Search results for query: *

Hokkie, That's a bit of sloppy code on my part. The .Left and .Top properties of my grid are zero and don't really have an effect on the equation. Anyone, I was doing some testing yesterday, moving the app to other machines, and found that the offset is not as pronounced on other monitors...

Zemp, Thanks for sticking with it this long. I'm sure the solution is something simple that I just haven't found yet. I'll post it when I do. =) Erika

I am using the EnterCell event to place the text box. The problem occurs in the project group that the user control is part of. I have yet to try it when just using the ocx. The grid's .left and .top are at the 0,0 point of the user control. The user control contains the flexgrid, the...

The grid is within a user control, which is within a frame within a tab control. However, if I simply add or subtract the container.Left and container.Top to the equation, I end up with the same problem of some kind of offset being applied that prevents it from lining up.

Yes, the text box appearance and borderstyle are both zero. By offset I mean that the top and left of the textbox do not line up with the displayed celltop and cellleft. I'll try to draw an ascii picture of the problem. Grid: ___________ |___________|...

Zemp, Thank you for your reply. However, the code you have presented doesn't change the behavior of the box. Any suggestions as to why there might be an offset, or where the offset might be coming from? Thanks. Erika

I'm trying to build a user control that has an "editable" flexgrid. I've looked at the FAQ 222-3262, but it doesn't address my problem. I am using the following code to position the text box: With hflexgrid txtDataEntry.Text = .Text txtDataEntry.Visible = True txtDataEntry.Move _...

Thank you for the response Koala15. Here's something weird. If I run the app, break inside the mouseDown event, and view the MouseRow/Col properties by hovering I see incorrect values and it doesn't perfom the movement. However, if I run the app without break points using a debug.print...

I have a MS Hierarchical FlexGrid (MSHFlexgrid) that displays data from an ADO recordset. The grid is not bound to the recordset, I insert the data a row at a time using the AddItem method. I would like to provide users with the ability to move the columns around per the example on MSDN...

Thanks Chip. I didn't think of it that way, but you are absolutely right.

I have an XSD file that defines all of the elements that I need to output information from my application. Is there a way to read the XSD in Visual Basic 6 and then use that information to create the appropriate XML tags for the output I have to generate? The amount of data exported from this...

Thank you everyone who has responded. I've directed my boss to the open source projects and he was impressed by the fact that MS is using it in their applications. You've all helped me to bolster my case for moving to C#. I can't wait to get started on the new project and get away from VB6...

My boss has recently asked the question, "If we migrate to C# will it still be a viable language in five years?" Can anyone point to resources, articles, or relatively unbiased opinions that address that question? He comes from a C++ background and wants to make sure that whatever we move to...

Ordendelfai, Unfortunately, the two work arounds mentioned in this thread are the best solutions. Using DAO you can only modify the datatype of a field before you append it to the table. Microsoft recommends using the DDL as introduced in Jet 4.0 to modify field datatypes per Knowledge Base...

Oops, on the cmd.execute line it should read set rs = cmd.execute Thanks.

Hello. If you can help me with a link to an explicit example or a snippet of code, I would appreciate it. I have an application that needs to call an Oracle stored procedure and pass several parameters for both input and output. One of the output parameters is a recordset type (pl/sql table)...

I have done quite a bit of searching for the answer to this question, but I'm still getting errors. I have a VB 6.0 application that needs to add files to an MS Access database. I have set up the DB with a single table with two columns, a key field and an OLE Object field. I need to add...

I have been asked to produce a product that adds a button to the print preview screen of MS Access. When the user clicks the button the VB6 application will respond by collecting a snapshot of the print preview screen and transferring a bunch of data from one database to another. In the...

I have an Access report that gathers data from a set of queries. A portion of the report is in a subform. I would like to restrict the results of the subform query to a single record that keys on the value of a databound text box on the main form. Is this possible without user interaction...

HobbitK, As far as I know, when sending SQL statements to Access DBs you have to end the statement with a ; for it to process. To answer your question, you would include it after the strCoName. Mystic1112